COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: hardstep on 27 May 2015 06:29:06 AM

Title: TM1IPA.DLL is not found ?
Post by: hardstep on 27 May 2015 06:29:06 AM
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
Title: Re: TM1IPA.DLL is not found ?
Post by: MFGF on 02 Jun 2015 09:20:39 AM
Quote from: hardstep on 27 May 2015 06:29:06 AM
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.
Title: Re: TM1IPA.DLL is not found ?
Post by: hardstep on 04 Jun 2015 04:28:37 AM
Hi MF
Yep it certainly is there sitting in tm1_64\bin... the file exists !.
Nick
Title: Re: TM1IPA.DLL is not found ?
Post by: MFGF on 04 Jun 2015 06:15:48 AM
Quote from: hardstep on 04 Jun 2015 04:28:37 AM
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.
Title: Re: TM1IPA.DLL is not found ?
Post by: CognosAnalytics on 04 Jun 2015 03:50:40 PM
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