I am geting the following error, while configuring the Peoplesoft EnterpriseOne Adapter 6.0.1 adapter
“Oracle TNSNames Entry Not Found”
has anyone faced such a issue before with the latest Peoplesoft EnterpriseOne Adapter 6.0.1.
Your inputs in resolving this issue would of great help.
Thanks
Amit J
We’ve installed the adapter on wm61 on HPUX host running Oracle Names (as opposed to tnsnames). We are running an adapter run time on the Unix box which connects via the broker to a windows install of IS/Broker 6.1. We have installed Peoplesoft E1 8.9 on HPUX11i.
I’ve seen this message a lot of times along with a lot of other errors - yes you will need a tnsnames.ora file - probably the best place to start is to show you our configuration file then append the tnsnames.ora. Note that you may get a bunch of other problems once you get the connection happening - we currently have a number of service requests relating to this adapter. Once you get this connection enabled the other one (the event connection) should be fairly straightforward.
Parameter Value
Connection Type PeopleSoft EnterpriseOne Connection
Package Name PSFT_E1_Adapter
Transaction Type for Connections LOCAL_TRANSACTION
Unique name for this ERP connection EnterpriseOneAdapter
ERP Username JDE
ERP Password ******
ERP Role for Username *ALL
ERP Environment Name DV9
ERP Enterprise Server Host Name melsys31
ERP Enterprise Server Port 6011
ERP Security Server Host Name melsys31
User Session Timeout 0
Maximum time, in milliseconds, to keep specs cached 30000000
Timeout value, in milliseconds, for a request to the enterprise server 90000
Number of milliseconds before a manual transaction expires 600000
Size of JDENET socket connection pool 30
Enable OCM for BSFN execution location False
Location to place log files. A relative path from the working directory must start with “./”. ./logs/EnterpriseOneAdapter
JAS log file name jas.log
JAS logging level. ERROR=error’s only; DEBUG=all ERROR
Append to JAS log file. TRUE=Append to existing log files. FALSE=Replace existing files TRUE
JDE log file name jderoot.log
JDE logging level. ERROR=errors only; DEBUG=all ERROR
Append to JDE log file. TRUE=Append to existing log files. FALSE=Replace existing files TRUE
JDEDebug log file name jasdebug.log
JDEDebug logging level. ERROR=errors only; DEBUG=all ERROR
Append to JDEDebug log file. TRUE=Append to existing log files. FALSE=Replace existing files TRUE
BootStrap Data Source Username JDE
BootStrap Data Source Password ******
JDBj BootStrap Data Source Name System - B9
BootStrap Data Source Database Type. O=Oracle;S=SQLServer;W=UDB;I=AS/400 O
BootStrap Data Source Database Name. Required for Oracle and UDB database types CUBDSYS
BootStrap Data Source Database Server Host Name
BootStrap Data Source Database Server Port
BootStrap Data Source Physical Database
BootStrap Data Source Database Owner SY9
Spec Data Source Username
Spec Data Source Password ******
JDBj Spec Data Source Name
Spec Data Source Database Type. O=Oracle;S=SQLServer;W=UDB;I=AS/400 O
Spec Data Source Database Name. Required for Oracle and UDB database types
Spec Data Source Database Server Host Name
Spec Data Source Database Server Port
Spec Data Source Physical Database
Spec Data Source Database Owner
Full path to Oracle’s ‘tnsnames’ file (include file name) /u3104/webMethods/wm61/IntegrationServer/bin/tnsnames.ora
JDBj JDBC Driver Class for Oracle oracle.jdbc.driver.OracleDriver
JDBj JDBC Driver Class for AS400
JDBj JDBC Driver Class for SQL Server
JDBj JDBC Driver Class for UDB
Allow JDBC connection pooling FALSE
Minimum number of physical connections in the pool 5
Maximum number of physical connections in the pool 30
Initial number of connections on startup 1
Pool increment size 1 1
Timeout value, in milliseconds, for a connection to be made 1800000
Interval time for connection pool cleaning 600000
Consistency Check for spec full
optional - directory of dynamic connector jar files
optional - jdeinterop.ini file path. If left blank the file(s) will be created based on the above configuration
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 5
Maximum Pool Size 10
Pool Increment Size 5
Block Timeout (msec) 20000
Expire Timeout (msec) 20000
Startup Retry Count 2
Startup Backoff Timeout (sec) 30
s.ora
cubdev =
(
DESCRIPTION=
(SOURCE_ROUTE=OFF)
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=)
(PORT=)
)
)
(CONNECT_DATA=
(SID=CUBDEV)
(SRVR=DEDICATED)
)
)
cubdsys =
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=CUBDSYS)(SRVR=DEDICATED)))
cubtst =
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=CUBTST)(SRVR=DEDICATED)))
cubcrp =
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=CUBCRP)(SRVR=DEDICATED)))
cubjde =
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=)))(CONNECT_DATA=(SID=CUBJDE)(SRVR=DEDICATED)))
I hope this helps.
Brett.