Troubleshooting
Problem
Trying to run the sample Cognos 10.1.1 report, "Overdue Work Orders By Location" on SQL Server, the following error occurs: The operation "_add_days" is invalid for the following combination of data types: "nvarchar" and "integer".
Cause
Using the incorrect MS SQL Server ODBC Driver.
Resolving The Problem
When creating your Data Source in Cognos Administration, make sure you specify the correct driver.
MS SQL Server ODBC driver has two versions. When creating the DSN, you should pick "SQL Server Native Client xx.xx" ( SQLNCLIxx.DLL ), not SQL Server (SQLSRV32.DLL).
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21613082