UIM 9.0.2 data_engine errors for MSSQL 2008 R2 database

Document ID : KB000118815
Last Modified Date : 02/11/2018
Show Technical Document Details
Issue:
After upgrading to UIM 9.0.2 in an environment where the backend database server is Microsoft MSSQL 2008r2, data_engine may experience failures even though the upgrade appears successful.

The following log message will be seen in the data_engine.log:

Oct 31 17:33:30:007 [1864] 0 de: ExecuteNoRecords - Query: exec spn_bas_SetVersion 'initialize', 'NIS_QOS_DATA',9.0200,5; 
go 
begin 
update qos_data 
set checksum = CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024), 
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2) 
FROM S_QOS_DATA qos_data 
INNER JOIN S_QOS_DATA T on qos_data.table_id = T.table_id 
and T.checksum!=CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024), 
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2); 
end; 
exec spn_bas_SetVersion 'finalize', 'NIS_QOS_DATA', null, 5; 
Oct 31 17:33:30:007 [1864] 0 de: [main] ExecuteNoRecords - 2 errors 
Oct 31 17:33:30:007 [1864] 0 de: (1) ExecuteNoRecords [Microsoft OLE DB Provider for SQL Server] Incorrect syntax near 'go'. 
Oct 31 17:33:30:007 [1864] 0 de: (2) ExecuteNoRecords [Microsoft OLE DB Provider for SQL Server] 'CONCAT' is not a recognized built-in function name. 
Oct 31 17:33:30:007 [1864] 0 de: COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Incorrect syntax near 'go'. 
Environment:
UIM 8.x upgraded to UIM 9.0.2
Windows Primary Hub
MSSQL 2008r2 backend database

 
Resolution:
A hotfix (data_engine 9.02HF1) has been released and is available at the UIM Hotfix Index website:

https://support.ca.com/us/product-content/recommended-reading/technical-document-index/ca-unified-infrastructure-management-hotfix-index.html