TM1IPA.DLL is not found ?

[hardstep]

Hi Folks
Anyone seen this error message : XQE-GEN-0010 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: "tm1ipa.dll is not found".

I get this when trying to report against a TM1 cube with DQM ON, but not when DQM OFF.
Have tried various fixpacks incl. and upto TM1 10.2.2 FP3

Anyone seen this before or know how to fix ?.
Kind Regards
Nick

[MFGF]

Hi Folks
Anyone seen this error message : XQE-GEN-0010 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: "tm1ipa.dll is not found".

I get this when trying to report against a TM1 cube with DQM ON, but not when DQM OFF.
Have tried various fixpacks incl. and upto TM1 10.2.2 FP3

Anyone seen this before or know how to fix ?.
Kind Regards
Nick

Hi,

Have you verified that tm1ipa.dll actually exists? It should be under tm1_64\bin64.

Cheers!

MF.

[hardstep]

Hi MF
Yep it certainly is there sitting in tm1_64\bin... the file exists !.
Nick

[MFGF]

Hi MF
Yep it certainly is there sitting in tm1_64\bin... the file exists !.
Nick

Ok - time to log it with IBM I'd say :)

MF.

[cognos810]

Hello hardstep,
I had seen this error in my environment BUT I was not using DQM. I landed on an IBM KB document, which I am not able to get to now(will keep looking), but it had suggested to install the TM1APIs on all report servers(dispatchers) in the location "parallel to" your cognos install. I am not sure how significant it is to install the TM1APIs exactly at the root location of the cognos install but it worked for me and the error went away.
For example: My install location for Cognos BI dispatcher on all servers was "C:\Program Files\ibm\Cognos10_64"
I went ahead and as suggested by the KB, installed the TM1APIs at "C:\Program Files\ibm\tm1_64".

That resolved my issue. Worth a try?

-Cognos810