Cryptic TM1 Messages Decoded

Ideas and tips for enhancing your TM1 application
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Cryptic TM1 Messages Decoded

Post by iansdigby »

On running any TI process that, inter alia, populates a cube:

TM1speak (in message log) : "Cell type is real"

Human speak: "You specified that a data variable was of type Numeric but the cube cell you are sending it to is a string cell".

(or vice versa?)
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Alan Kirk »

iansdigby wrote:On running any TI process that, inter alia, populates a cube:

TM1speak (in message log) : "Cell type is real"

Human speak: "You specified that a data variable was of type Numeric but the cube cell you are sending it to is a string cell".

(or vice versa?)
Real = Numeric. You'll sometimes come across an error like "cannot convert {whatever} to real" (can't recall the exact syntax of it); it means that whatever is trying to be input to a cell or otherwise manipulated cannot be converted to and/or is not numeric.

Edit: I expected that this would be referred to somewhere in the documentation, but the only place I can find it is in the API manual which is a place that most of those who don't wish to look programming death in the face and laugh at it will avoid. Page 10 of the 10.1 manual:

Code: Select all

Value                  Description
TM1_REAL          A double precision IEEE floating point number.
TM1_STRING       A character string whose length does not exceed 64K bytes.
TM1_INDEX          A 32 bit unsigned integer.
TM1_BOOL          A logical value stored as 1 to indicate TRUE, 0 to indicate false.
TM1_OBJECT       A structure used to refer to objects managed by the API. Typically an object contains information about the server in which the object resides, and an index to locate the object within the server.
TM1_ERROR        A structure containing typically an error code and an error message string.
TM1_ARRAY        An array of values.
Items 1 and 2 are the only ones that apply to values stored in a cube, though.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Wim Gielis »

Another one:
Data spread failed.
You are a read-only user - as set in the }ClientProperties control cube - and you try to edit a numeric cell.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
GWT
Posts: 2
Joined: Thu Jul 24, 2014 9:36 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Cryptic TM1 Messages Decoded

Post by GWT »

"failed to create empty document" when double-clicking on a SUBNM in Excel.

Try deleting the .tbd files in %appdata%\Applix\TM1
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Cryptic TM1 Messages Decoded

Post by gtonkin »

Process "xxx": Invalid parameter array size: Could not initialize process

You also get a failure on opening the error log and the log$ file remains.

The cause of this error is due to a drill process being created against cube A but the drill Assignment belongs to cube B i.e. the cubename in the parameters of your process is not the same as the one being drilled from.
lotsaram
MVP
Posts: 3648
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Cryptic TM1 Messages Decoded

Post by lotsaram »

gtonkin wrote: Fri Nov 29, 2019 8:00 am Process "xxx": Invalid parameter array size: Could not initialize process

You also get a failure on opening the error log and the log$ file remains.

The cause of this error is due to a drill process being created against cube A but the drill Assignment belongs to cube B i.e. the cubename in the parameters of your process is not the same as the one being drilled from.
Yes it's a right PITA that TM1 doesn't let you have truly generic drill processes. The closest you can come is to replicate a generic drill process per cube with count of N dimensions.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Cryptic TM1 Messages Decoded

Post by iansdigby »

A couple of favourites from older versions:

On cancelling a text output operation:
'Stop Now?'

On logging off an instance through the Explorer:
'Disconnect self?'
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Cryptic TM1 Messages Decoded

Post by gtonkin »

A new one to me.

Using TM1ELLIST in Planning Analytics for Excel to show Members in a dimension.
When I refreshed the sheet I got the #SPILL! message as the element list would have over-written values further down in the column i.e. spilled over I guess.

This is an Excel error, not TM1/Planning Analytics for Excel - See Excel Help, Dynamic arrays and spilled array behavior
Formula overlap - Array formulas can't be input if there is anything blocking the output range. and if this happens, Excel will return a #SPILL! error indicating that there is a blockage.
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Wim Gielis »

gtonkin wrote: Sat Jan 18, 2020 2:43 pm A new one to me.

Using TM1ELLIST in Planning Analytics for Excel to show Members in a dimension.
When I refreshed the sheet I got the #SPILL! message as the element list would have over-written values further down in the column i.e. spilled over I guess.

This is an Excel error, not TM1/Planning Analytics for Excel - See Excel Help, Dynamic arrays and spilled array behavior
Formula overlap - Array formulas can't be input if there is anything blocking the output range. and if this happens, Excel will return a #SPILL! error indicating that there is a blockage.
Microsoft has (finally !) launched a number of new functions in Excel to the general public. These functions are truly a game changer if you ask me!
Read here with Jon Acampora: https://www.excelcampus.com/functions/d ... ill-ranges
Or here: https://support.office.com/en-us/articl ... 88f5502fa2
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Cryptic TM1 Messages Decoded

Post by EvgenyT »

This is really cool, along side TM1ELLIST function. No more weirdly wrapped formulas lol
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cryptic TM1 Messages Decoded

Post by Wim Gielis »

Indeed. A good number of really ugly and longwinded array formulas (confirmed with Ctrl-Shift-Enter) are hopefully gone now.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Steve Rowe
Site Admin
Posts: 2407
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Cryptic TM1 Messages Decoded

Post by Steve Rowe »

TI data export error

......,Data Source line (1) Error: Data procedure line (57): Invalid real number "nullptr"
Error: Data procedure line (57): error repeats 1 times

triggered by using CellGetN versus a cell with a rule error #N/A being returned.

Fix your rule to make the error go away!
Technical Director
www.infocat.co.uk
Post Reply