Direct edit dimension collection has not been cleared before commit

Post Reply
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Direct edit dimension collection has not been cleared before commit

Post by lotsaram »

Has anyone ever seen the following ERROR status log message in the tm1server.log and know what it means?

ERROR TM1.Commit Direct edit dimension collection has not been cleared before commit.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Direct edit dimension collection has not been cleared before commit

Post by qml »

What version did you see it in?

I have started seeing this message after upgrading our on-premise 10.2.2 from build 10.2.20300.98 to build 10.2.20700.43. It happens at the end of any process that makes use of the Direct metadata functions, but seems to have no impact on the completion status of the process or its outcomes. However, I have seen it coincide with a rollback/restart of a process on one occasion - but I don't have enough evidence to conclude that it was caused by this error.

In any case this looks like a defect to me.
Kamil Arendt
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Direct edit dimension collection has not been cleared before commit

Post by lotsaram »

Thanks for the response. This is on 10.2.2 FP7 and we didn't see it on FP5 which was the previous version on this site.

Got a somewhat dubious response from support which didn't clarify at all whether this is an actual error or overenthusiastic logging.

Although there is is odd (very rare) use of DimensionElementInsertDirect in the system with the error the odder thing is that this error crops up at random after commits of dimensions and not always necessarily the ones where TI is using the direct update functions.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Gabor
MVP
Posts: 170
Joined: Fri Dec 10, 2010 4:07 pm
OLAP Product: TM1
Version: [2.x ...] 11.x / PAL 2.0.9
Excel Version: Excel 2013-2016
Location: Germany

Re: Direct edit dimension collection has not been cleared before commit

Post by Gabor »

I've seen that error after moving to 10.2.2 FP7, but could get rid of the message by adding "DimensionUpdateDirect(DimName)" at the end of the Epilog of each process handling with direct dim updates.
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Direct edit dimension collection has not been cleared before commit

Post by qml »

Gabor wrote:I've seen that error after moving to 10.2.2 FP7, but could get rid of the message by adding "DimensionUpdateDirect(DimName)" at the end of the Epilog of each process handling with direct dim updates.
Weird. I always do the DImensionUpdateDirect in Epilog after any Direct inserts, mostly because without that rules don't get attached to elements added in that way (one to look out for). Despite that I still see the same error as Lotsa.
Kamil Arendt
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Direct edit dimension collection has not been cleared before commit

Post by lotsaram »

From own testing and confirmed from IBM support adding DimensionUpdateDirect to the Epilog does not make this error message go away.

What I still don't know is whether the error actually is an "error" or just something g that should be ignored.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Direct edit dimension collection has not been cleared before commit

Post by lotsaram »

By way of update support opened a collab with development on this error and it seems that IBM development believe the error message is caused by an empty subset or UDC at the time the dimension is updated. Thus can be filed into the category of "not really an error".
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Direct edit dimension collection has not been cleared before commit

Post by Steve Vincent »

Except that if you happen to be rebuilding a dimension then the 1st element to be added causes this error, and subsequent tasks on the dim fail. I'm currently getting errors on adding attribute values because of this; TM1 doesn't think my elements have been added, and on completion the dim is missing them.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Direct edit dimension collection has not been cleared before commit

Post by John Hammond »

Agreed, both elements and attributes can go missing.

Ignore this error message at you peril!
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: Direct edit dimension collection has not been cleared before commit

Post by Wim Gielis »

https://www-01.ibm.com/support/docview. ... wg1PI83033

IBM say to upgrade to 2.0.6 but in 2.0.8 I still get this error/no error, so I'm confused here.
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: Direct edit dimension collection has not been cleared before commit

Post by Wim Gielis »

I still see this message at the customer (not sure what version).

But I noticed an update by IBM: https://www.ibm.com/support/pages/apar/PH23571
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
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Direct edit dimension collection has not been cleared before commit

Post by lotsaram »

Wim Gielis wrote: Tue May 11, 2021 1:14 pm I still see this message at the customer (not sure what version).

But I noticed an update by IBM: https://www.ibm.com/support/pages/apar/PH23571
I also recall seeing this message ALL_THE_BLOODY_TIME
However, have been on 2.0.9.6 now for quite a while and I don't recall seeing it in this version.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply