Direct edit dimension collection has not been cleared before commit
-
- MVP
- Posts: 3667
- 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
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.
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.
- qml
- MVP
- Posts: 1095
- 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
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.
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
-
- MVP
- Posts: 3667
- 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
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.
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.
-
- 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
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.
- qml
- MVP
- Posts: 1095
- 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
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.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.
Kamil Arendt
-
- MVP
- Posts: 3667
- 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
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.
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.
-
- MVP
- Posts: 3667
- 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
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.
- 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
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- 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
Agreed, both elements and attributes can go missing.
Ignore this error message at you peril!
Ignore this error message at you peril!
-
- MVP
- Posts: 3128
- 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
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.
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
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
-
- MVP
- Posts: 3128
- 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
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
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
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
-
- MVP
- Posts: 3667
- 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
I also recall seeing this message ALL_THE_BLOODY_TIMEWim 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
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.