E1: ESU: Installing EnterpriseOne Planner ESU To Pathcode Returns "TNSNAMES File Not Loaded" Error
(Doc ID 861414.1)
Last updated on JANUARY 16, 2020
Applies to:
JD Edwards EnterpriseOne Tools - Version 8.98 and laterInformation in this document applies to any platform.
Symptoms
In this scenario here, customer is applying the latest EnterpriseOne 9.0 Planner ESU to a pathcode after completing a new install (as the Special Instructions instruct) fails with the following errors in the jde.log:
3288/2156 WRK:Starting jdeCallObject Tue Jun 09 10:22:25.656000 JdeJvm.cpp2051
JdeJvm::CheckForExceptions() - Java Exception encountered : java.lang.Exception: A JDBException occured.
3288/2156 WRK:Starting jdeCallObject Tue Jun 09 10:22:25.656001 JdeJvm.cpp2051
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: A JDBException occured.
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.initColumnInfo(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.<init>(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [ORACLE_TNSNAMES_NOT_LOADED] Oracle TNSNames file not loaded.
at com.jdedwards.database.impl.oracle.OracleTNS.getTNS(Unknown Source)
at com.jdedwards.database.impl.oracle.OracleConnectionParams.getConnectString(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.jdb.JDBStandaloneConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.jdb.JDBStandaloneConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
...
Caused by: java.io.IOException: Unable to find the configure file tnsnames.ora
at com.jdedwards.base.util.IniFileLoader.getAbsoluteFileName(Unknown Source)
at com.jdedwards.database.impl.oracle.OracleTNS.loadTNS(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.<clinit>(Unknown Source)
at com.jdedwards.database.jdb.JDBStandalone.<clinit>(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.getConnection(Unknown Source)
JdeJvm::CheckForExceptions() - Java Exception encountered : java.lang.Exception: A JDBException occured.
3288/2156 WRK:Starting jdeCallObject Tue Jun 09 10:22:25.656001 JdeJvm.cpp2051
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: A JDBException occured.
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.initColumnInfo(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.<init>(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [ORACLE_TNSNAMES_NOT_LOADED] Oracle TNSNames file not loaded.
at com.jdedwards.database.impl.oracle.OracleTNS.getTNS(Unknown Source)
at com.jdedwards.database.impl.oracle.OracleConnectionParams.getConnectString(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.jdb.JDBStandaloneConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.jdb.JDBStandaloneConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.select(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
...
Caused by: java.io.IOException: Unable to find the configure file tnsnames.ora
at com.jdedwards.base.util.IniFileLoader.getAbsoluteFileName(Unknown Source)
at com.jdedwards.database.impl.oracle.OracleTNS.loadTNS(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.<clinit>(Unknown Source)
at com.jdedwards.database.jdb.JDBStandalone.<clinit>(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.getConnection(Unknown Source)
A similar error seen by users with a local OEE database may be received instead:
2848/524 WRK:Starting jdeCallObject Fri Jul 10 11:32:59.859001 JdeJvm.cpp2051
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: A JDBException occured.
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.initColumnInfo(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.<init>(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [ORACLE_TNSNAMES_ENTRY_NOT_FOUND] Entry not found for database JDE900 in Oracle TNSNAMES file.
at com.jdedwards.database.impl.oracle.OracleTNS.getTNS(Unknown Source)
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: A JDBException occured.
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.initColumnInfo(Unknown Source)
at oracle.e1.database.copytablexml.StandAloneCopyTableXML.<init>(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [ORACLE_TNSNAMES_ENTRY_NOT_FOUND] Entry not found for database JDE900 in Oracle TNSNAMES file.
at com.jdedwards.database.impl.oracle.OracleTNS.getTNS(Unknown Source)
Changes
Installing a Planner ESU patch to a pathcode.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |