Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limit on deleting members from workspace

AdellaApr 9 2013 — edited Apr 18 2013
Hello,

I wanted to know if there is a limit on how many members that can be deleted at once from a dimension in a classic planning application. I know that there is a parameter in the outline load utility that would delete the entire dimension and would load the members from scratch from the metadata file you specify. But is there was a better way of deleting the required members apart from using the outline load utility parameter and deleting from the workspace?

We are trying to cleanup our metadata and also trying to delete some members from a dimension but it looks like it is taking ~ 40 mins for deleting ~ 3000 records. Does this sound reasonable?

Also, I am seeing some strange and unexpected behavior while performing these operations. When I am selecting a parent member (that has ~ 3000 child members) and hitting delete, it would show like it's doing something in the status bar on the browser but after a while it would disappear and the page doesnt refresh. It is neither showing the success message nor is it showing any error which is confusing as it's not telling me if it did the delete or if it didn't do the delete. So, when this happened I went and checked the dimension and the parent level member was still in there without getting deleted. Then I tried deleting a different parent member and then encountered an error after a while saying -

An error occured while processing the page. Please check the logs for details.* (Can someone please let me know what's the name of the log file that I need to look and where?)

Another time it threw an error -

You are trying to change data that has been changed by a user on another server. Wait a few seconds and try again. If you continue to see this error message please contact your administrator.*

So basically I am seeing all sorts of different things happening and the deletion process is not going smoothly.

Please share your thoughts on this.

Thanks.
~ Adella
This post has been answered by JohnGoodwin on Apr 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2013
Added on Apr 9 2013
8 comments
340 views