Pages

Tuesday, September 11, 2012

Unexpected Essbase error 1007083

I came across this issue and thought of sharing one of the possible solutions for it. The solution of mine may not apply in all situations but you never know it may help. Before going ahead, I would just like to give a small background of the situation.

I have an ASO application with 10 dimensions in Essbase version 11.1.2.0. I had a task to clean up some metadata to get rid of unwanted members and thus developed few load rules. All load rules ran well except for one which gave this error



Object [outline name] is locked by user [user name]
Dimension build failed. Error code [1090040]. Check the server log file and the dimension build error file for possible additional info.
Unexpected Essbase error 1007083
Object [outline name] unlocked by user [user name]

The log files do not provide any information about the error. Initial search on web, oracle forums, support says a lot many things. From all those sources I could get information that this error may occur due to any one of the following reasons:



  • Essbase server running out of memory. This usually happens if we have 32 bit OS/Essbase server and try to load big hierarchies
    • I checked my system and found only 50% of memory was consumed. The source file had just 500 members and one of the load rule with 8000 members ran well. Thus this reason did not apply in my case
  • Check the directory path for source data files, error logs and make sure it does not have special characters
    • My source file were stored on Desktop on Win XP and it had spaces in its path. Also it had spaces in the path of directory where error logs were written. So I changed the locations and stored everything on C:\ . It didn't actually helped and error continued.
  • Validate the load rule which loads metadata and make sure it is stored at correct location on server or file system and is correctly used in MAXL
    • I recreated the rule file from start and validated it. Then manually loaded the source file but it gave the same error
Since I could not find much help online, I followed the below approach to identify cause.
  1. I tried adding a member manually to the outline and restructure completed successfully on save
    • This implies server is not running out of memory due to restructure
  2. Created a new application with blank outline. Tried loading the members using the fresh load rule. It failed with same error.
    • This implies my original application do not have any issues as the same error occurs in new application too
  3. Created a new data source file manually with few records as in original source file. I did not copy-paste the records but typed in all information.
    • The members loaded successfully with the original load rule as well as with new load rule in both the applications - old as well as new. This concludes my data source file was the culprit
  4. I have access to Unix system and recreated the file using vi editor. Everything worked great after the source file was corrected.
I hope this helps other developers in overcoming such error.

11 comments:

  1. Hi Navan,

    Thanks it really worth ... :-)

    ReplyDelete
  2. I found that making text files with MS SQL Server 2008 R2 brings me this error, but if I open and resave the file with a text editor it works w/ no problem.

    ReplyDelete
  3. I found that, the encoding format of the files matters. If the files are encoded as ANSIC this error does not appear anymore... :)

    ReplyDelete
  4. Helpful, saved some valuable time...

    ReplyDelete
  5. Helpful, saved some valuable time...

    ReplyDelete
  6. Outline is opened in edit mode and we didn't unlock also we will be getting object is locked by user.

    ReplyDelete
  7. Awesome !! Worked out for me .. Thanks

    ReplyDelete
  8. Thank you so much... Excellent work... It worked for me

    ReplyDelete
  9. This is very helpful. I changed the sourece file to ANSI file type and it worked!

    ReplyDelete
  10. The problem happens because in the data file or SQL table are some characteres that not are in ANSI Format, by example: '\x85', '\x91' those charactes make an extra colum, so when the data file is load, the properties in the outline are not property correct, then there are errors like:

    \\Outline verification errors:

    Solution, check the data source in order not to have such characters and correct the format of the data source maibe some rows will have the problem.

    ReplyDelete
  11. I have been experiencing 1007083 on an ASO app I'm supporting. The load would fail. The issue seemed to have to do with ASO multiple hierarchy handling during the dimbuild. The dimension in question was marked for multiple hierarchies. The BSO source cube that fed the dimension members had some new hierarchies added to it that I wasn't aware of. So, since my process did not add the new hierarchies to the dimension AND mark them Dynamic, the dimbuild would fail (because the hierarchies added as Stored would violate other ASO Essbase laws). To fix this for the future, I marked the entire dimension Dynamic (instead of Multiple Hierarchies) so that when new hierarchies are added in the future, they will flow into this ASO cube successfully. While this means nobody can pre-aggregate any member in this dimension going forward, it cost is worth the reward, in my opinion.

    ReplyDelete