Authentication Error. Details Odbc Driver Returned An Error Sqldriverconnectw
Contents |
Services Startup Failure By Giri Mandalika-Oracle on May 08, 2012 ISSUE: Starting Presentation Services fail with the error: [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] Authentication Failure. Odbc driver returned an nqserror 10018 in obiee error (SQLDriverConnectW). State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for
Nqserror: 13057
the requested connection is refused. [nQSError: 43113] Message returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[ Also connecting could not connect to the authentication web service (taking obis offline) to the metadata repository (RPD) in online mode fails with similar error. Looking through the BI server log, nqserver.log, you may find an error message similar to the following: [OracleBIServerComponent] [ERROR:1] [] []
Nqserror: 10058
[ecid: 0001J1LfUetFCC3LVml3ic0000pp000000] [tid: 1] [13026] Error in getting roles from BI Security Service: 'Error Message From BI Security Service: [nQSError: 46164] HTTP Server returned 404 (Not Found) for URL .' ^M RESOLUTION: Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in 'Active' state. If any of the components is in 'Prepared' state, select that application and then click on nqserror 37001 "start servicing all requests" Restart BI Server and Presentation Services In some cases, the following additional step might be needed to resolve the issue. Access the Enterprise Manager Fusion Middleware control: http://
standing, the major things to look out for include: The Presentation Server going downThe Presentation Server being up, but the BI Server has gone downThe Scheduler is down or hasn't actually been configured properlyThe J2EE Application Server is down whilst
Nqserror 10092
the OBIEE components are upThe Java Host server is down (and what does this affect?)All of
Nqserror 43119
the OBIEE components are up including the J2EE server, but the source database is downAll of the above, but this time Essbase is nqserror 26012 downIf you're an administrator, what is the impact of these parts of the system failing (we'll ignore clustering for now), and if they are down how can you find out what's wrong? Starting with the Presentation Server, in theory https://blogs.oracle.com/mandalika/entry/obiee_11g_resolving_presentation_services it shouldn't crash by itself but I've seen this happen when, for example, there is a bug in the Presentation Server code that caused a segfault when a pivot table contained too many cells. In general though, problems with the Presentation Server are generally because the process isn't actually running, and when running with WebLogic as the J2EE Application Server users will get a message like the one below if they try and connect when the Presentation Server service http://www.rittmanmead.com/blog/2009/05/troubleshooting-obiee-connectivity-and-server-issues/ isn't running: This error is caused by the J2EE Presentation Services plug-in not being able to communicate with the Presentation Services itself. If Presentation Services is running on a Windows box, a quick check in the Windows Services applet will show if the service is running OK, and as we can see in the screenshot below it's actually down. So why has it gone down? The best places to check are the log file at
$ORACLEBIDATA/web/log/sawlog0.logif the Presentation Server was up at one point but then crashed or closed down for some reason, or the Windows Event Viewer (System Log) if the service won't actually start in the first place. Unfortunately the messages in the System Log don't really tell you what the problem is (the error above was actually caused by a developer making changes in the instanceconfig.xml file but entering the details incorrectly, which stops the Presentation Server service from actually starting) but at least if you try and restart the service and find that it won't actually start, you can probably assume it's due to a change in one of the config files and the next step is to find out who's introduced the changes. In conclusion then, if users can connect to the J2EE application server but not to the Presentation Server, check that the service is up, check the sawlog0.log file to see if there's been an abAndroid Hadoop Python Ruby on Rails Visual http://ssssupport.blogspot.com/2013/05/obiee-11g-resolving-presentation.html studio.Net Data Ware House BI APPS ODI BIAPPS 11.1.1.10 Installation https://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/ in Linux OBIEE INFORMATICA ODI TABLEAU QLIKVIEW PHP SAP HYPERION CONTACT US Wednesday, May 22, 2013 [OBIEE 11g] Resolving Presentation Services Startup OBIEE 11g: Resolving Presentation Services Startup Starting Presentation Services fail with the error: [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] authentication error. [ecid: ] [tid: ] Authentication Failure. Odbc driver returned an error (SQLDriverConnectW). State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused. [nQSError: 43113] Message returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[ Also connecting to the metadata repository (RPD) in authentication error. details online mode fails with similar error. Looking through the BI server log, nqserver.log, you may find an error message similar to the following: [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0001J1LfUetFCC3LVml3ic0000pp000000] [tid: 1] [13026] Error in getting roles from BI Security Service: 'Error Message From BI Security Service: [nQSError: 46164] HTTP Server returned 404 (Not Found) for URL .' ^M RESOLUTION: Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in 'Active' state. If any of the components is in 'Prepared' state, select that application and then click on "start servicing all requests" Restart BI Server and Presentation Services In some cases, the following additional step might be needed to resolve the issue. Access the Enterprise Manager Fusion Middleware control: http://
Hyperion Business Rules Hyperion DIM Hyperion Essbase Hyperion Financial Reporting Hyperion Shared Services Hyperion Web Analysis Hyperion Workspace Informatica Mapviewer OBI EE Plus OLAP Oracle 11g Oracle Data Integrator Oracle EPMA OWB Web Center Suite Top Posts Customizing OBI EE - SOAP API Customizing OBI EE – GO URL Parameters Oracle BI EE 10.1.3.3/2 - Between Prompts for Date Columns - Using Presentation Variables Hyperion Essbase 11.1.1.0 - Partitioning and its use cases - Transparent, Replicated and Linked partitions - Introduction Oracle BI EE 10.1.3.3/2 - Bins and Groups Oracle Enterprise Performance Management Architect (EPMA) - Administering Essbase, Planning and HFM - Setup Oracle 11g - BLOB and BFile support for SQL Plus Hyperion Financial Reporting - Getting Started Hyperion Essbase 11.1.1.0 - Using Java APIs - Part 1 - Viewing Outline Members Oracle Olap 11g - First Impressions Pages About Me Contact Me Workshop Series Your Questions September 2007 M T W T F S S « Aug Oct » 12 3456789 10111213141516 17181920212223 24252627282930 Archives June 2009 May 2009 April 2009 March 2009 February 2009 January 2009 December 2008 October 2008 September 2008 August 2008 July 2008 June 2008 May 2008 April 2008 March 2008 February 2008 January 2008 December 2007 November 2007 October 2007 September 2007 August 2007 July 2007 Bookmark About Me I am Venkatakrishnan J, a Business Intelligence enthusiast working with Rittman Mead Consulting who likes blogging about acquisitions in the BI space, technical workings of the BI tools in general and Oracle Business Intelligence tools in particular. All the views expressed here are my own and does not reflect the views of Rittman Mead Consulting or Oracle. Going forward, i would be blogging at http://rittmanmead.com/blog. Blogroll Abhinav Agarwal Adrian Ward Alex Andriy Yakushyn Antonio Romero Asktom Borkur Steingrimsson Christian Berg David Aldridge Dimitri Gielis Doug Burns Eddie Awad Frank Buytendijk Howard Rogers John Goodwin