Unable to run sample Cognos 10.1.1 report on SQL Server

Technote (troubleshooting)


Problem(Abstract)

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).

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Cognos

Software version:

7.5

Operating system(s):

AIX, Linux, Windows

Reference #:

1613082

Modified date:

2014-02-27

Translate my page

Machine Translation

Content navigation