KB44761: Statistics fail to log in MicroStrategy Intelligence Server 9.x and 10.x against Teradata

• Strategy

MicroStrategy Intelligence Server 9.x -10.x fails to log statistics in newly created statistics tables against a Teradata 13.x or 14.x database.

SYMPTOM
Strategy Intelligence Server 9.x -10.x fails to log statistics in newly created statistics tables against a Teradata 13.x or 14.x database.

Entries similar to the following are seen in the DSSErrors from the time of Strategy Intelligence Server startup.


2014-12-05 14:39:04.993-05:00 [HOST:YGU-941GADVD][PID:4952][THR:4428][Database Classes][Error] Catalog Get Columns failed. 
Error type: Odbc error. Odbc operation attempted: SQLColumns. [HY000:-3668: on SQLHANDLE] [Teradata][ODBC Teradata Driver][Teradata Database] A table listed in the Dictionary is not present. Connection String: DSN=YGU14_TD14;UID=YGU14;.
2014-12-05 14:39:04.993-05:00 [HOST:YGU-941GADVD][PID:4952][THR:4428][Kernel][Error] MsiStatisticsMgr::Unable to execute columns.
2014-12-05 14:39:04.993-05:00 [HOST:YGU-941GADVD][PID:4952][THR:4428][Kernel][Error] Init() : Failed to add statistics tables. Return code = -2147467259

A connection can be successfully established to the Statistics database from the Strategy Intelligence Server machine using Strategy DB Query tool.

CAUSE
The reason for this issue is unknown and has been seen against certain Teradata configurations.

ACTION
This issue has been resolved by making a change on the ODBC driver options. Edit the DSN connection to the Teradata database and enable the “Ignore Search patterns” option as shown below:

The Strategy internal reference number for the issue discussed in this document is 770844.

Comment

0 comments

Details

Knowledge Article

Published:

June 3, 2017

Last Updated:

June 3, 2017