Message Log WARN

Post Reply
MarenC
Regular Participant
Posts: 346
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: 3105
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: 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
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: 346
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: 3105
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: 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
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: 3105
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: 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
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