Oracle Business Intelligence Application Errors and Solutions

Error:
In results tab following error start occuring:

Error
	View Display Error
	Error getting drill information: SELECT "Requisition Details"."Destination Type" saw_0 FROM "Procurement and Spend - Purchase Requisitions"   Error Details Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads Odbc driver returned an error (SQLSetStmtAttrW). State: 08004. Code: 10092. [NQODBC] [SQL_STATE: 08004] [nQSError: 10092] The Oracle BI Server is not currently running. [nQSError: 12008] Unable to connect to port 9703 on machine testbi.fatima-group.com. (08004) SQL Issued: {call NQSGetLevelDrillability('SELECT "Requisition Details"."Destination Type" saw_0 FROM "Procurement and Spend - Purchase Requisitions"')}

Refresh

Solution:

---------------------------------------------------------------------------------------------------------

Error:
Source Extract and Load Error

Return Code

20942

Message

ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_ITEMCOSTGENERAL (5405500) fails with return code 20942. ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s). ODI-1232: Procedure Diagnostics Raise Exception execution fails. ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84) at java.lang.Thread.run(Thread.java:662)

Solution:


-----------------------------------------------------------------------------------------

Error:
While login to analytics Oracle Business Intelligence 11.1.1.x from a url like
http://<hostname>:9704/analytics

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error


The server encountered an unexpected condition which prevented it from fulfilling the request.

Solution:

Start OPMN Services 

1. export ORACLE_INSTANCE=/opt/OBI_Home/Middleware/instances/instance1 
2. cd /opt/OBI_Home/Middleware/Oracle_BI1/opmn/bin 
3. ./opmnctl stopall 

4. ./opmnctl startall

if still issue did not resolve follow the document.

Doc ID 1921886.1

-----------------------------------------------------------------------------------------


Error:
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_BOMITEMFACT_EXPLOSION (3326500) fails with return code 6576. 
ODI-1226: Step TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 fails after 1 attempt(s). 
ODI-1232: Procedure TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 execution fails. 
ODI-1228: Task TRUNCATE OPI.OPI_OBIA_W_BOM_HEADER_DS - EBS11R10 (Procedure) fails on the target ORACLE connection TEST. 
Caused By: java.sql.SQLException: ORA-06576: not a valid function or procedure name 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) 

Solution:

Please apply the patch Doc ID 1923841.1 based on source EBS version.  -------------------------------------------------------------------------------------------------------------------------


Error:
While executing Domain Load Plan in Oracle Business Intelligence OBIA 11.1.1.10.1

ODI-1519: Serial step "Start Load Plan (InternalID:8910500)" failed because child step "Global Variable Refresh (InternalID:8911500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:8911500)" failed because child step "1 Domain (InternalID:8918500)" is in error.
ODI-1519: Serial step "1 Domain (InternalID:8918500)" failed because child step "2 Domain SDE (InternalID:8995500)" is in error.
ODI-1519: Serial step "2 Domain SDE (InternalID:8995500)" failed because child step "Serial (InternalID:8996500)" is in error.
ODI-1519: Serial step "Serial (InternalID:8996500)" failed because child step "3 SDE General Domain (InternalID:9035500)" is in error.
ODI-1519: Serial step "3 SDE General Domain (InternalID:9035500)" failed because child step "Load Target Table (InternalID:9036500)" is in error.
ODI-1519: Serial step "Load Target Table (InternalID:9036500)" failed because child step "EBS_12_2 - DSN 1 (InternalID:9037500)" is in error.
ODI-1519: Serial step "EBS_12_2 - DSN 1 (InternalID:9037500)" failed because child step "DOMAIN (InternalID:9038500)" is in error.
ODI-1519: Serial step "DOMAIN (InternalID:9038500)" failed because child step "Parallel (InternalID:9039500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:9039500)" failed; 12 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step.  Failed child steps: SERVICE (InternalID:9291500), MFG (InternalID:9309500), FINANCIALS (InternalID:9173500), SOURCING (InternalID:9241500), EAM (InternalID:9329500), ORDER_MANAGEMENT (InternalID:9252500), PROJECTS (InternalID:9199500), COMMON (InternalID:9040500), COST (InternalID:9263500), HUMAN_RES (InternalID:9082500), PROC (InternalID:9221500), SUPP_CHAIN (InternalID:9286500)
ODI-1518: Parallel step "SERVICE (InternalID:9291500)" failed; 11 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step.  Failed child steps: SDE_ORA_DOMAINGENERAL_ACTIVITY_PRIORITY (InternalID:9295500), SDE_ORA_DOMAINGENERAL_ACTIVITY_STATUS (InternalID:9296500), SDE_ORA_DOMAINGENERAL_ACTIVITY_CATEGORY (InternalID:9297500), SDE_ORA_DOMAINGENERAL_AGREEMENTTYPE (InternalID:9294500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_BILLINGTYPE (InternalID:9303500), SDE_ORA_DOMAINGENERAL_FND_LOOKUPS AGREEITEM_BILLING_TYPE (InternalID:9307500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_AREA (InternalID:9302500), SDE_ORA_DOMAINGENERAL_AGREEITEMTYPE (InternalID:9293500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_STATUS (InternalID:9304500), SDE_ORA_DOMAINGENERAL_FND_LOOKUPS_ASSET_ACCOUNTING_MTHD (InternalID:9308500), SDE_ORA_DOMAINGENERAL_SERVICEREQUEST_SEVERITY (InternalID:9305500)
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_DOMAINGENERAL_ACTIVITY_PRIORITY (472500) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942:
ORA-06512: at line 49

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:514)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1074)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:133)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:84)

at java.lang.Thread.run(Thread.java:662)

Solution:

Check your Source Connection Details again

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Error:
java.io.FileNotFoundException: /opt/OBI_Home/BIAPPS/Oracle_BI1/oui/bin/oneclick.properties (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:146)
at java.io.FileInputStream.<init>(FileInputStream.java:101)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.loadProperties(OiocOneClickInstaller.java:514)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.init(OiocOneClickInstaller.java:379)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createFrameElements(OiocOneClickInstaller.java:365)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2171)
Exception in thread "main" java.lang.NullPointerException
at oracle.sysman.oio.oioc.OiocOneClickInstaller.setListProps(OiocOneClickInstaller.java:574)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.loadProperties(OiocOneClickInstaller.java:538)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.init(OiocOneClickInstaller.java:379)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createFrameElements(OiocOneClickInstaller.java:365)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2171)

Solution:

There is no need to execute config.sh as you have installed OBIEE through Enterprise install mode or config.sh has already been executed.
-----------------------------------------------------------------------------------------------------------------------------------------------------------

Error:

The JDK wasn’t found in the directory

Please edit this script so that the JAVA_HOME variable points to the location of your JRE”

Solution:

1) In a seperate window Locate the file CommEnv.cmd in $MIDDLEWARE_HOME\wlserver_10.3\common\bin\

2) Make a copy of the CommEnv.cmd file for backup purposes

3) Edit the CommEnv.cmd file to include the JAVA_HOME

For example:

@rem Reset JAVA Home
set  JAVA_HOME=D:\Oracle\Middleware\Oracle_BI1\jdk
FOR %%i IN ("%JAVA_HOME%") DO SET JAVA_HOME=%%~fsi

4) Save the file

5) Restart the nodemanager and continue with your config

-------------------------------------------------------------------------------------------------------------------

Error:
***************************************************************************
The WebLogic Server encountered a critical failure
Reason: Assertion violated
***************************************************************************
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class weblogic.protocol.ServerIdentityManager$Initializer
        at weblogic.protocol.ServerIdentityManager.findServerIdentity(ServerIdentityManager.java:65)
        at weblogic.protocol.URLManager.findAdministrationURL(URLManager.java:173)
        at weblogic.server.ServerLifeCycleRuntime.getLifeCycleOperationsRemote(ServerLifeCycleRuntime.java:1203)
        at weblogic.server.ServerLifeCycleRuntime.getLifeCycleOperationsRemote(ServerLifeCycleRuntime.java:1232)
        at weblogic.t3.srvr.ServerRuntime.sendStateToAdminServer(ServerRuntime.java:421)
        at weblogic.t3.srvr.ServerRuntime.updateRunState(ServerRuntime.java:407)
        at weblogic.t3.srvr.T3Srvr.setState(T3Srvr.java:209)
        at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:505)

        at weblogic.Server.main(Server.java:71)

Solution

-------------------------------------------------------------------------------------------------

Error:
ORA-14400: inserted partition key does not map to any partition .

Soluion:

Execute below statement and recheck:
 ALTER TABLE OBI_DW.W_AR_XACT_F SET INTERVAL(1);