search cancel

Software Component - Version generates binding to small error when cubes are processed.

book

Article ID: 162285

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When processing the Application Metering, Installed Files, or Installed Software cubes in the CMS 7.6 Report Pack for IT Analytics a binding error is generated on the Software Component - Version dimension.

Errors in the OLAP storage engine: An error occurred while the 'Software Component - Version' attribute of the 'Software Component' dimension from the 'IT Analytics' database was being processed.
Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.

Cause

The Software Component's version field was increased to a size of 128 characters with the release of ITMS 7.6. However this field wasn't increased from the previous size of 50 characters in the report pack for CMS.

Resolution

Attached to this article you will find updates versions of the Application Metering, Installed Files, & Installed Software cubes. Along with an updated definition for the Software Component dimension.

These changes get applied to the IT Analytics database on your Analysis Server. Please note that if you have changed the name of analytics database from the default 'IT Analytics' you will need to modify the below line in each of the four updated definition files to match your database name.

Change
<DatabaseID>IT Analytics</DatabaseID>

To
<DatabaseID>your database name</DatabaseID>

 

Attachments

Updated Software Component Version.zip get_app