46008 Internal Error
June 18, 2009 OBIEE Architect Leave a comment Direct Database Request in OBIEE using Essbase causes [nQSError: 46008] Internal error: File .\Src\SQXDGEssbaseCAPI.cpp, line 1003. (HY000) Applies to: Business Intelligence Answers Option - Version: 10.1.3.2.1 to 10.1.3.4.1 [1900] - Release: 10g to 10g Symptoms When running a query in Direct Database Request in OBIEE against Essbase, the following error occurs: ERROR --------------- State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. [nQSError: 46008] Internal error: File .\Src\SQXDGEssbaseCAPI.cpp, line 1003. (HY000) The query works in Answers screen but not in Direct Database Request screen. STEPS --------------- By following these steps the issue can be reproduced using Essbase as data source: 1. Create a report in Answers 2. Verify that the query returns results 3. Now copy the physical SQL of the above query from the query log (section ‘…sending query to database…') 5. Copy it into the Direct Database Request SQL statement field 6. Verify that the columns in SELECT statement are displayed in the Results Column section 7. Run the results and the above error is generated Cause This issue has been caused by Bug 6869282 "DIRECT DATABASE REQUEST THROWS ERROR WHEN RUNNING AGAINST ESSBASE". There is an issue with the code that checks for FROM clause in the SQL. The parsing code expects a space before and after the FROM clause. Solution The behavior is reproducible in the latest version of OBIEE, 10.1.3.4.1. The recommended workaround is in the MDX query to enter space before the "FROM" clause in the physical SQL and execute the query. A single space before the FROM clause resulted in the following error (the er
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Richard JoeTorre bracke Ramnath.Awate DukeGanote http://obiee-blog.info/bugs-and-issues/direct-database-request-in-obiee-using-essbase-causes-nqserror-46008-internal-error/ Locutus Nikki Klein Dennis Stevenson AbhaiTripathi Craig Borysowich Clinton Jones bluesguyAZ59 iudithm mircea_luca Adrian_Grigoriu blrvenkat COMPANIES CloudLock Trend Micro Incorporated Citrix Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Siebel Groups Ask a New Question Siebel Analytics For discussion on Siebel Analytics , please visit the Oracle BI http://siebel.ittoolbox.com/groups/technical-functional/siebel-analytics-l/obiee-rpd-errordatatypesukeycomparecpp-3933392 group. More Siebel Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. OBIEE - rpd error...\DataType\SUKeyCompare.cpp,? jsoutlaw asked Dec 15, 2010 | Replies (2) Hi all Has anyone seen this error before.... State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46008] Internal error: File .\DataType\SUKeyCompare.cpp, line 823. (HY000) I've brought a new calendar view into the RPD with a new week field in the correct format to join to another table
this content in your HTML Search confirm cancel Report adult content: click to rate: Account: (login) More Channels Showcase http://obiee80.rssing.com/chan-6968903/all_p1.html RSS Channel Showcase 9659344 RSS Channel Showcase 7242217 RSS Channel Showcase 9991680 RSS Channel Showcase 3804884 Channel Catalog Subsection Catalog Articles on this Page (showing articles 1 to 10 of 10) 11/08/10--11:50: _[nQSError: 46008] I... 11/26/10--08:48: _nQSError: 59012 12/17/10--08:00: _OBIEE 11g Transacti... 01/14/11--01:51: _OBIEE 11g ‘No Log F... 03/03/11--09:35: _nQSError 15019? Che... 05/09/11--05:19: _OBIEE 11g Strange 46008 internal O... 06/16/11--01:29: _OBIEE Admin Tool Gi... 09/05/11--21:00: _OBIEE 11g Transacti... 09/06/11--09:00: _OCM Error when usin... 09/30/11--14:34: _nQSError 77005 When... (showing articles 1 to 10 of 10) Browse the Latest Snapshot Browsing All Articles (10 Articles) Live Browser 0 0 11/08/10--11:50: [nQSError: 46008] Internal error: File .\DataType\SUKeyCompare.cpp, line xyz. (HY000) Contact us about this article There seems 46008 internal error to be a number of causes for this error but in my experience it is most often encountered in a federated data model bringing data from different fact tables – joined by conformed dimensions – in which you have multiple sources for logical tables in the Business Model and Mapping layer. If you [...] 0 0 11/26/10--08:48: nQSError: 59012 Contact us about this article I came across a strange problem today when trying to use the Ago time series function. I made a simple formula to show the change in a measure between current month and last month. Easy you would think: Folder.Measure – Ago(Folder.Measure, DateFolder.Month, 1) However, this resulted in: [nQSError: 59012] UnderFlow occurred during the execution of [...] 0 0 12/17/10--08:00: OBIEE 11g Transactional Update Failed [nQSError:37005] Contact us about this article If you often edit an OBIEE repository in online mode then chances are you will have come across this error at some point. As far as I understand it, this refers