tag:blogger.com,1999:blog-6413551094595469687.post8601875286767531862..comments2024-03-13T13:07:08.079+05:30Comments on Something More....: Unexpected Essbase error 1007083Navan Mehrahttp://www.blogger.com/profile/15380717475082956833noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-6413551094595469687.post-57574459471460231502022-03-11T22:01:52.981+05:302022-03-11T22:01:52.981+05:30I have been experiencing 1007083 on an ASO app I&#...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.Billhttps://www.blogger.com/profile/17570690057828826521noreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-60934449612722242812019-04-24T20:37:36.570+05:302019-04-24T20:37:36.570+05:30The problem happens because in the data file or SQ...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:<br /><br />\\Outline verification errors:<br /><br />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.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-60067460934391128912014-09-27T02:55:51.360+05:302014-09-27T02:55:51.360+05:30This is very helpful. I changed the sourece file ...This is very helpful. I changed the sourece file to ANSI file type and it worked!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-59749940759011608682014-07-07T22:43:05.866+05:302014-07-07T22:43:05.866+05:30Thank you so much... Excellent work... It worked f...Thank you so much... Excellent work... It worked for meAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-37060515708499374172014-05-28T16:15:05.598+05:302014-05-28T16:15:05.598+05:30Awesome !! Worked out for me .. Thanks Awesome !! Worked out for me .. Thanks Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-7157845668416076862013-11-28T16:54:46.030+05:302013-11-28T16:54:46.030+05:30Outline is opened in edit mode and we didn't u...Outline is opened in edit mode and we didn't unlock also we will be getting object is locked by user.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-51713534852439139152013-09-03T00:47:31.704+05:302013-09-03T00:47:31.704+05:30Helpful, saved some valuable time...Helpful, saved some valuable time...Unknownhttps://www.blogger.com/profile/17278700858771956021noreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-49951275694270493552013-09-03T00:47:00.343+05:302013-09-03T00:47:00.343+05:30Helpful, saved some valuable time...Helpful, saved some valuable time...Unknownhttps://www.blogger.com/profile/17278700858771956021noreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-78067840070875383872013-07-18T01:54:48.813+05:302013-07-18T01:54:48.813+05:30I found that, the encoding format of the files mat...I found that, the encoding format of the files matters. If the files are encoded as ANSIC this error does not appear anymore... :)<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-73110084953236347782013-04-09T03:26:19.342+05:302013-04-09T03:26:19.342+05:30I found that making text files with MS SQL Server ...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.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6413551094595469687.post-74200525734888543352013-02-28T19:25:00.587+05:302013-02-28T19:25:00.587+05:30Hi Navan,
Thanks it really worth ... :-) Hi Navan,<br /><br />Thanks it really worth ... :-) S Sudhakarhttps://www.blogger.com/profile/09107279699330853412noreply@blogger.com