Message Log WARN

Post Reply
MarenC
Posts: 144
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 » Mon Oct 21, 2019 8:59 am

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: 2713
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Message Log WARN

Post by Wim Gielis » Mon Oct 21, 2019 9:13 am

MarenC wrote:
Mon Oct 21, 2019 8:59 am
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?
Yes. Trying to insert an element into a dimension where the element is blank.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

MarenC
Posts: 144
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 » Mon Oct 21, 2019 9:26 am

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: 2713
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Message Log WARN

Post by Wim Gielis » Mon Oct 21, 2019 9:50 am

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

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

Re: Message Log WARN

Post by Wim Gielis » Sat Jun 05, 2021 12:34 pm

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

Post Reply