| Asset ID: |
1-72-1568422.1 |
| Update Date: | 2013-07-11 |
| Keywords: | |
Solution Type
Problem Resolution Sure
Solution
1568422.1
:
Unable to connect to Times Ten database on Exalytics server
| Related Items |
- Oracle TimesTen In-Memory Database
- Oracle Exalytics Software
- Exalytics In-Memory Machine X3-4
|
| Related Categories |
- PLA-Support>Eng Systems>Exalytics>Oracle Exalytics>DB: Exalytics_EST
|
In this Document
Created from <SR 3-7361945111>
Applies to:
TimesTen Data Server - Version 11.2.2.5.0 and later
Exalytics In-Memory Machine X3-4 - Version All Versions and later
Oracle Exalytics Software - Version 1.0.0.2.0 and later
Information in this document applies to any platform.
Symptoms
Unable to connect to TimesTen database on Exalytics server. The below error is the encountered:
Error:
Error Message-Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 14080] One of the unavailable physical database schemas (DPS_PROD, DSR_PROD) may have been required to answer this query.
[nQSError: 14020] None of the fact tables are compatible with the query request VGPRD_AP_INV_DTL_ALL_F_V.Accounting Event ID
Cause
The opmn.xml file has to be configured properly for OBIEE to connect to TimesTen. Specifically, the TIMESTEN_DDL variable has to be added, and the LD_LIBRARY_PATH variable has to be appended with the TimesTen LIB path.
Solution
Edit file <MW_HOME>/instances/instance1/config/OPMN/opmn/opmn.xml
Insert the following child element under <ias-component id="coreapplication_
obis1" inherit-environment="true"><environment>
<variable id="TIMESTEN_DLL" value="<TimesTen_Install_Dir>/lib/libttclient.so"/>
Append the TimesTen LIB path to the value of variable LD_LIBRARY_PATH, under element <ias-component id="coreapplication_obis1" inherit-environment="true"><environment>
<variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib:<TimesTen_Install_Dir>/lib" append="true"/>
In a future version a rules check has been added to the Exachk utility. Exachk will likely be released in the near future and it will do the following check relative to this setting:
Check opmn.xml for TimesTen Client DDL variable and LD_LIBRARY_PATH
Attachments
This solution has no attachment
