Obiee 11g Error Message From Bi Security Service
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: nqserror 12002 socket communication error ] Authentication Failure. Odbc driver returned an error (SQLDriverConnectW). State: 08004. bi security access denied - web service credentials are invalid Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused. [nQSError: 43113] Message returned
Could Not Connect To The Authentication Web Service (taking Obis Offline)
from OBIS. [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[ Also connecting to the metadata repository (RPD) in online mode fails with similar error. Looking through the BI server
[nqserror: 43126] Authentication Failed: Invalid User/password.
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 nqserror 12010 obiee 11g 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://
the following sections Section C.1, "Resolving User Login Authentication Failure Issues" Section C.2, "Resolving Inconsistencies with the Identity Store" Section C.3, "Resolving Inconsistencies
Odbc Driver Returned An Error Sqldriverconnectw Obiee 11g
with the Policy Store" Section C.4, "Resolving SSL Communication Problems" Section [nqserror: 12010] communication error connecting to remote end point C.5, "Resolving Issues with BI System User Credentials" Section C.6, "Resolving Custom SSO Environment Issues" Section C.7, obi sec 00111 failedauthentication bi security access denied web service credentials are invalid "Resolving RSS Feed Authentication When Using SSO" C.1 Resolving User Login Authentication Failure Issues This section helps you resolve some of the most common user login authentication https://blogs.oracle.com/mandalika/entry/obiee_11g_resolving_presentation_services failure issues encountered while using Oracle Business Intelligence Enterprise Edition 11g. It is not intended to be a comprehensive list of every possible scenario, and contains the following topics: Section C.1.1, "Authentication Concepts" This section describes the basic concepts of authentication in Oracle Business Intelligence Enterprise Edition. You must understand the concepts used throughout this https://docs.oracle.com/cd/E28280_01/bi.1111/e10543/troubleshoot.htm guide as a prerequisite for using this section. Section C.1.2, "Using the Oracle BI Security Diagnostics Helper to Automatically Identify Security Issues" This section describes how to deploy and use an Oracle BI security diagnostics helper application, enabling you to automatically identify some common security issues. Section C.1.3, "Identifying Causes of User Login Authentication Failure" This section provides a cause-and-effect diagram to use as a checklist for identifying authentication failure causes. Section C.1.4, "Resolving User Login Authentication Failures" This section provides reasons and solutions for login authentication failure. C.1.1 Authentication Concepts This section describes authentication concepts, helps you to resolve login issues, and contains the following topics: Section C.1.1.1, "Authentication Defaults on Install" Section C.1.1.2, "Using Oracle WebLogic Server Administration Console and Fusion Middleware Control to Configure Oracle Business Intelligence" Section C.1.1.3, "WebLogic Domain and Log Locations" Section C.1.1.4, "Oracle Business Intelligence Key Login User Accounts" Section C.1.1.5, "Oracle Business Intelligence Login Overview" C.1.1.1 Authentication Defaults on Install Immediately after install, Oracle Business In
naveen@bipracticals.comWatsapp : +65-82830121Training will be real time and more hands on.Number of slots available : 2/5 Wednesday, July http://pagelock.blogspot.com/2012_07_04_archive.html 4, 2012 Authentication failed issue in OBIEE11G ISSUE: Starting Presentation Services fail with the error: [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl. getbisystemconnection] [ecid: ] [tid: ] Authentication http://www.askjohnobiee.com/2012/08/how-to-oracle-internet-directory.html 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 obiee 11g returned from OBIS. [nQSError: 43126] Authentication failed: invalid user/password. (08004)[[ Also connecting 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] [] [] [ecid: 0001J1LfUetFCC3LVml3ic0000pp000000] [tid: 1] [13026] Error bi security access 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://
the scenario where you're configuring a proof of concept 11g implementation using Oracle Internet Directory as the authentication provider. Oracle's Fusion Middleware Security Guide for 11g certainly provides you with a bird's eye view of how to configure OBIEE 11g to integrate with web logic's OID LDAP authentication provider but in this how-to I will digress slightly and present a detailed, step by step guide on how to configure your OBIEE 11.1.1.6 system to use OID LDAP authentication for users. This how-to is a culmination of the countless posts on Oracle Technical Networkrequesting additional help with implementation and will provide the user answers to the most common OBI and OVD (Oracle Virtual Directory) errors that you typically encounter in this proces, including: OVD-40666, OBI-SEC-00022, OBI-SEC-00015, and LDAP error code 32. At the end of this how-to, any user within OID will be able to log into OBIEE 11g Answers. Note that if you're using OID as the authentication provider but storing groups in an external database table, this also serves as a suitable 'step 1' prior to implementing the groups authentication model (to be covered at a later date) Prequisities: Your Oracle Internet Directory must have the following users: BISystemUser BIAuthor BIConsumer BIAdministrator These are out-of-the-box weblogic users that weblogic uses in its defaultauthenticator for users, groups, and application roles. If you are using Oracle Internet Directory to store groups, then it must include the following weblogic out of the box groups: BIAdministrators BISystemUsers BIAuthors BIConsumers Step 1: Add Oracle Internet Directory as an Authentication Provider in Weblogic Administration Console 1.a) Navigate to Security Realm -> myRealm -> Providers -> Authentication -> New to add an OID Authentication Provider * Note that at this point, you will not see myOIDDirecotory in your Authenticat