Troubleshooting
Problem
We are trying to setup a connection to AS400 DB2 V5R4M0 using JDBC v65 Fix16 and JTOpen v4.8 with IS v65 SP1. WmART Fix 7 was also applied. This connection is returning the following message:
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection
resource DBConnections:DB2DBAdapter_CBLDW_Target.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection
DBConnections:DB2DBAdapter_CBLDW_Target: after 1 attempt(s).
[ART.118.5036] Adapter Runtime (Connection): Unable to configure
connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class
"com.ibm.as400.access.AS400JDBCDataSource".
The application requester cannot establish the connection. (Connection
refused)
There are also instances of following error
Error Message: 'com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Adapters.DB2DBAdapter_DD_Target.empzzzxpenseDatazzz:zzzzinsert4WeeklyzzzzEmpData.
[ADA.1.316] Cannot execute the SQL statement "INSERT INTO zzzzz.DW_4WEEKLY_EMPLOYEE(BUDGETCODE, GRADE, FILECODE, EMPLOYEECATG, FIRSTNAME, LASTNAME, HEALTHCARECODE, ALLOWANCE, TIME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)". "
(08001/-4499) [jcc][t4][2030][11211][3.50.152] A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: T4Agent.sendRequest(). Message: Broken pipe. ERRORCODE=-4499, SQLSTATE=08001"
Document Location
Worldwide
Log InLog in to view more of this document
Historical Number
Product Build 6.5.
Was this topic helpful?
Document Information
Modified date:
20 March 2025
UID
ibm17205100