Cryptic TM1 Messages Decoded

Ideas and tips for enhancing your TM1 application
John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Cryptic TM1 Messages Decoded

Post by John Hammond » Thu Jan 07, 2010 6:37 pm

My idea for a thread is to list cryptic TM1 messages and decode them once you find what really is going on. Apologies if this has been done before. If not please add your own insights into the secret world of TM1 error messages.

Cryptic Error:

4388 ERROR 2010-01-07 18:31:05.775 TM1.Process Process "jphTempo": : Could not initialize process

Real Error

Parameter list supplied in TIExecute call from jphTempo does not match required list of parameters

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Sat Jan 09, 2010 12:13 pm

Cryptic Error

This Process is not complete and cannot be run

Real Error

You had an error that you fixed but you didn't change the code. Type a blank space in the prolog to amend the code without really amending it and this will go away.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Sat Jan 16, 2010 2:58 pm

Cryptic Error

Error: Prolog procedure line (8): Cell is not writeable

You are doing a viewzeroout in the prolog. The view has calcs and consolidations removed.

Real Error

This error occurs where you have n level values which have been overridden by a calculation. Only when the cube is next saved to disk will the n level values will be lost. This confuses TM1.

Solution

Unload and reload the cube.

(Sorry gave wrong soln before below)

1. Turn calcs off by renaming the .rux file. Unload the cube and then reload with calcs back on to find the n level values unwittingly retained.
2. Recreate the cube from the unload which has conflicting n level data removed.
Last edited by John Hammond on Tue Jun 21, 2011 8:25 am, edited 1 time in total.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Sat Jan 23, 2010 6:15 pm

Cryptic Error

Syntax error on or before <code fragment> logical expression

Possible Reason

You need to '@' prefix any comparator for alphanumeric operations with a string

eg
Change

SubOrganisation = IF( P3 = '%', 'AllMDX',JobName) ;

To

SubOrganisation = IF( P3 @= '%', 'AllMDX',JobName) ;

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Sun Jan 24, 2010 12:21 pm

Cryptic Error

Within the TI process message box this flashes up:

Could not write Dimension Definition to disk storage

Reason

The disk is full on the server

Postscript

Thought this was the reason but see

http://forums.olapforums.com/viewtopic.php?f=3&t=2092

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Wed Apr 07, 2010 6:04 pm

Cryptic

Error registering object

Real

You have sufficient access to read an object and go into the editor but insufficient access to update that object.

User avatar
Steve Rowe
Site Admin
Posts: 1965
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Cryptic TM1 Messages Decoded

Post by Steve Rowe » Thu Apr 08, 2010 9:44 am

You also get that error if you try and save a TI with the same name of a (different)TI that already exists.

ItsPat
Posts: 7
Joined: Sat Sep 05, 2009 9:50 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Cryptic TM1 Messages Decoded

Post by ItsPat » Thu Apr 08, 2010 4:36 pm

Cryptic

2516 ERROR 2010-04-08 00:01:58.561 TM1.Rule TM1RuleImpl::LineGet - String overflow error, length = 526

Real Error

When doing a CellGetS and passing in a NULL or '' as a dimension, it will give give the error above.

Solution

Add an if statement to verify the dimension is not a non null or blank value.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Tue Apr 20, 2010 12:48 pm

Thanks Steve and itsPat for your contributions.

Cryptic:

tm1xl: An invalid argument was encountered

Cause:

You pressed an action button when the active cell in Excel begins with an IF formula.

Starter for 10 if anyone can come up with the why...

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Wed Apr 28, 2010 6:27 pm

Cryptic:

TM1 No data showing in Transaction log and logging is ON for the cube

Real reason

Transaction log uses GMT / Universal Time and not local time.

Marc
Posts: 6
Joined: Thu May 27, 2010 1:17 am
OLAP Product: TM1, Infor PM Olap
Version: TM1 9.4 + Infor PM Olap 3-10.x
Excel Version: all
Location: Singapore

Re: Cryptic TM1 Messages Decoded

Post by Marc » Thu May 27, 2010 10:12 am

Hi John,
I am struggling with that exact same problem at the moment and haven't got a handle on it yet, unfortunately I am not sure if I understand the solution steps you propose. Would you explain a little more in detail please?

thanks!
Marc
John Hammond wrote:Cryptic Error

Error: Prolog procedure line (8): Cell is not writeable

You are doing a viewzeroout in the prolog. The view has calcs and consolidations removed.

Real Error

This error occurs where you have n level values which have been overridden by a calculation. You would think that when the cube is next saved to disk the n level values will be lost, but they are not. This confuses TM1.

Solution

1. Turn calcs off by renaming the .rux file. Unload the cube and then reload with calcs back on to find the n level values unwittingly retained.
2. Recreate the cube from the unload which has conflicting n level data removed.

User avatar
Martin Ryan
Site Admin
Posts: 1957
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Martin Ryan » Thu May 27, 2010 10:00 pm

Hi Marc,

The answers John suggests here are usually just one possible cause rather than the definitive reason for any given error. Please post a detailed description of your problem in the main forum, preferably including the code that's causing the problem.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer

Wim Gielis
MVP
Posts: 2277
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Wim Gielis » Tue Aug 31, 2010 2:12 pm

Steve Rowe wrote:You also get that error if you try and save a TI with the same name of a (different)TI that already exists.
And you also get that error whenever the Rules editor for the cube }ProcessSecurity contains errors like unexisting process names. For no matter what process. You cannot create a new process.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Fri Apr 01, 2011 10:55 am

Cryptic:

2011/04/01 10:26:08:Process "_big_string": System stack overflow, process terminated

In English:

You've probably exceeded the maximum string size in TM1. This is only 255 bytes in rel 90 and practically unlimited 94 onwards I think.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Tue May 24, 2011 1:54 pm

tm1 cell type is consolidated divide by zero

George got here before but still spent 45 mins sticking in debugging messages

TM1 DOES NOT EXCEPTION ON DIVIDE BY 0 BUT LOADS INFINITY WHICH IS NOT A REAL NUMBER WHICH CAUSES CELLPUTN TO FAIL!

http://www.tm1forum.com/viewtopic.php?f=3&t=325

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Fri May 27, 2011 5:46 pm

Message Faux

TM1 Invalid Number

Verite

You typed a dot which you couldn't see due to the excellent choice of fonts in the TI editor

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Sun Jun 19, 2011 12:01 pm

Newsspeak:

Unknown process return status. Please contact Applix Support

English

You called a proc that has an Itemskip in the prolog.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Tue Jun 21, 2011 8:22 am

Psychobabble:

Tm1 viewzeroout Wrong Number of Dimension Elements

Mr Spock

It is spurious, Captain. TM1 is most illogical. Unload the cube and you will stop the error occurring. This is particularly where the cube has a view that references an MDX based subset.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Wed Jun 22, 2011 3:33 pm

OMG!!!

tm1 string in quotes too large

KEWL!!!

You coded a triple quote ''' which your aging peepers could not make out.

John Hammond
Community Contributor
Posts: 262
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: TM1/PM/Cafe/Persp PAX 2.0.45
Version: 10.2 Dev PA 2.0
Excel Version: 2010 and 2013
Location: City of London

Re: Cryptic TM1 Messages Decoded

Post by John Hammond » Thu Jun 23, 2011 6:13 pm

tm1 error opening the logfile cube drill

Unbelievably this appears on a drill. What actually has occured is that the dimensionality of the cube has changed and you are no longer passing the right number of arguments to the drill proc.

Post Reply