Tuesday, September 4, 2012

All About ORACLE BI & OBIEE

Error Message on OBIEE Analytics reports
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

Solution: 1. Your TNS Client is not setup correctly. set the client and $TNS_ADMIN to refer the client location.
2. execute the SQL client env file to set classpath and ORACLE_HOME.
Restart..saw server and presentation server.

3. check the particular DB user configured on repository has proper access on database objects being used in particular report. if not, grant the access to user.

Enable logs for BI Publisher XDO
$ORACLE_HOME/jdk/jre/lib
create a file xdodebug.cfg with below entry
LogLevel=STATEMENT
LogDir=/applications/xmlplogs
Restart the OAS.


For integration with Oracle BI Presentation Services, you must disable SSO for Web services between the BI Presentation Services server and the BI Publisher server. http://dwh.one.gob.do:9704/xmlpserver/help/en_US/htmfiles/B25951_01/T421739T475591.htm - process
http://docs.oracle.com/cd/E10091_01/doc/bip.1013/e05000/toc.htm#iss_tb
http://docs.oracle.com/cd/E12844_01/doc/bip.1013/e14667/bip_101341.htm#CBAIFACF - imp


  require valid-user
     AuthType Basic
     Allow from All
     Satisfy any



LDAP authontication user/password config for BIP.
/u01/app/oracle/product/10.1.3/OracleBI/xmlp/XMLP/Admin/Configuration/xmlp-server-config.xml
"property name="LDAP_PROVIDER_ADMIN_USERNAME" value="BIADMIN"/>"
and bipuser (BIPUSER) is database user to query from BI Publisher thourgh datasource

No comments:

Post a Comment

Post a Comment