Message Log WARN

Post Reply
MarenC
Regular Participant
Posts: 436
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Message Log WARN

Post by MarenC »

Hi,

I am seeing some WARN messages in the message log, the message reads:

TM1.Dimension Object Name is Blank

It appears this error is against a process which ODBC's to a sql database

Does anyone have any ideas what could trigger this error?

Maren
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Message Log WARN

Post by Wim Gielis »

MarenC wrote: Mon Oct 21, 2019 8:59 amI am seeing some WARN messages in the message log, the message reads:

TM1.Dimension Object Name is Blank

It appears this error is against a process which ODBC's to a sql database

Does anyone have any ideas what could trigger this error?
Yes. Trying to insert an element into a dimension where the element is blank.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
MarenC
Regular Participant
Posts: 436
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Message Log WARN

Post by MarenC »

Hi Wim,

Does this only appear when the source is ODBC?

I tried testing with a csv data source, had 3 rows in the source, made the middle row blank and did dimensionelementinsert and when I ran the process it just inserted the 2 populated rows and ignored the blank one?

Maren
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Message Log WARN

Post by Wim Gielis »

I encountered this with ODBC data sources only, so that seems to be the case.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Message Log WARN

Post by Wim Gielis »

This can happen in regular dimension updates as well. I see it in the Prolog tab where the function "DimensionElementComponentAddDirect" is used.
If the parent for instance is empty, you get this one.
Best regards,

Wim Gielis

IBM Champion 2024-2025
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
Post Reply