IBM Support

All reports failing to run against TM1 data source

Troubleshooting


Problem

After upgrading both Cognos Business Intelligence to 10.2.2 and TM1 to 10.2.2 fix pack 2 all reports including new ones are failing to run against TM1

Symptom

Found an internal error: 'XQERuntimeException':
XTM-ERR-0003 The MDX query submitted to TM1 server failed during
execution. The TM1 error code is: InvalidMDXExpression. The TM1 error
message is: "Wrong version of mddstm1ng component. Expected tm1ipa
interface version: 10.2.100".

Cause

TM1 was referencing older version of library files first when reading left to right.

Environment

Cognos Business Intelligence 10.2.2 on single server AIX 7.1
TM1 10.2.2 Fixpack 2 on a second AIX 7.1 server

Resolving The Problem

On the Cognos Business Intelligence server ensure the TM1_PATH environment variable is pointing to the bin64 directory of the correct install.
On the TM1 application server ensure the LIBPATH is pointing to the bin64 directory of the correct install.
In this case the issue was resolved by removing the reference in the LIBPATH that was pointing to older version of TM1.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21696855