TM1 Forum

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

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.

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.

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) ;

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

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.

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

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.

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...

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.

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.

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

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.

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.

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

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

Newsspeak:

Unknown process return status. Please contact Applix Support

English

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

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.

OMG!!!

tm1 string in quotes too large

KEWL!!!

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

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.