This KB article contains fixes for the following issues.
- Multiple SEP policy cubes fail to process.
- Error when processing the SEP Agent Security Events
- Failure to add a SEP database connection to IT Analytics.
The following errors correspond with the issues stated above:
Multiple SEP policy cubes fail to process with the following error:
System error: Invalid procedure call or argument error in the back-end database access module. OLE DB was unable to convert to the data type requested for the 5-column value.
Errors in the OLAP storage engine: An error occurred while processing the 'computer' partition of the 'computer' measure group for the 'Sep Antivirus Policies' cube from the IT Analytics database.
- Error when processing the
Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Invalid length parameter passed to the LEFT or SUBSTRING function.. Errors in the OLAP storage engine: An error occurred while the 'IPS Detection Event - Name' attribute of the 'EP IPS Detection Event Name' dimension from the 'IT Analytics' database was being processed
Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Invalid length parameter passed to the LEFT or SUBSTRING function.. Errors in the OLAP storage engine: An error occurred while the 'IPS Detection Event - Name' attribute of the 'EP IPS Detection Event Name' dimension from the 'TRW IT Analytics' database was being processed
- The following error is returned in the event viewer when attempting to add a SEP database connection to IT Analytics.
Exception: Statement(s) could not be prepared. Invalid object name ‘SEM_SVA’. OLE DB provider “SQLNCLI10” for linked server “<linked server name>” returned message “Deferred prepare could not be completed”