E1: ESU: Installing EnterpriseOne Planner ESU To Pathcode Returns "TNSNAMES File Not Loaded" Error

(Doc ID 861414.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information 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)


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)

Changes

Installing a Planner ESU patch to a pathcode.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms