× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. May 2004

The application requester cannot establish the connection. (Not able to pass connection to server job. Unknown or unrecoverable error occured.)

We just installed a new iSeries 810 at v5r2, and I'm having a terrible time 
getting a database or signon(AS400 object) connection.

We have several web applications that reside on a pc Linux server running 
Tomcat that use the toolbox to connect to the iSeries. After we got the 810 up 
and running, I restarted the tomcat server and couldn't not connect. My first 
thought was some of the required services were not running on the iSeries. So, 
I did a STRHOSTSVR *ALL and STRTCPSVR *ALL and I still can't connect through 
jdbc or the AS400 object.

Out of frustration I assumed it was something with my applications so I 
attempted to setup a db server in WDSC for iSeries and it will not connect or 
allow me to signon through the remote system explorer.

After all this I wrote a couple of simple test classes with a trace that would 
try to pull data back through jdbc and rla. The trace is listed below.

As a work around I setup a tomcat instance natively on the new iSeries, and I 
can get a jdbc connection to the database; however, none of my business classes 
that use the AS400 object can connect. 

Any ideas would be appreciated as I'm the only iSeries Java developer in house.


The trace output:
Toolbox for Java - Open Source Software, JTOpen 4.3, codebase 5722-JC1 V5R3M0.1
Thu May 27 10:42:31 EDT 2004  as400: Properties  (13799530) : access = "all".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : block size = "32".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : block criteria = 
"2".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : date format = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : date separator = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : decimal separator 
= "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : errors = "basic".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : extended dynamic 
= "false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : libraries = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : naming = "sql".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package add = 
"true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package cache = 
"false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package clear = 
"false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package error = 
"warning".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package library = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : password = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : prefetch = "true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : prompt = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : remarks = 
"system".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort = "job".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort language = 
"ENU".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort table = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : sort weight = 
"shared".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : time format = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : time separator = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : trace = "false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : transaction 
isolation = "read uncommitted".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : translate binary 
= "false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : user = 
"webappstst".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package criteria 
= "default".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : lob threshold = 
"32768".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : secure = "false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : data truncation = 
"true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : proxy server = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : secondary URL = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : data compression 
= "true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : big decimal = 
"true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : thread used = 
"true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : cursor hold = 
"true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : lazy close = 
"false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : driver = 
"toolbox".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi string type 
= "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : key ring name = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : key ring password 
= "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : full open = 
"false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : server trace = 
"0x00".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : database name = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : extended metadata 
= "false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : cursor 
sensitivity = "asensitive".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : behavior override 
= "0x00".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : package ccsid = 
"13488".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : minimum divide 
scale = "0".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : maximum precision 
= "31".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : maximum scale = 
"31".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : translate hex = 
"character".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : toolbox trace = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : qaqqinilib = "".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : login timeout = 
"".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : true autocommit = 
"false".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi implicit 
reordering = "true".
Thu May 27 10:42:32 EDT 2004  as400: Properties  (13799530) : bidi numeric 
ordering = "false".
Thu May 27 10:42:32 EDT 2004  as400: Driver AS/400 Toolbox for Java JDBC Driver 
(10053659) : Using IBM Toolbox for Java JDBC driver implementation.
Thu May 27 10:42:32 EDT 2004  Getting system property: 
'com.ibm.as400.access.AS400.proxyServer'
Thu May 27 10:42:32 EDT 2004  Value found in system properties:  'null'
Thu May 27 10:42:32 EDT 2004  Value found in jt400.properties file: 'null'
Thu May 27 10:42:32 EDT 2004  Value not found.
Thu May 27 10:42:32 EDT 2004  Detected os.name: Windows XP
Thu May 27 10:42:32 EDT 2004  Constructing AS400 object, system name: 
'XXX.XXX.XX.XXX' user ID: 'webappstst'
Thu May 27 10:42:32 EDT 2004  Getting system property: 
'com.ibm.as400.access.AS400.proxyServer'
Thu May 27 10:42:32 EDT 2004  Value found in system properties:  'null'
Thu May 27 10:42:32 EDT 2004  Value found in jt400.properties file: 'null'
Thu May 27 10:42:32 EDT 2004  Value not found.
Thu May 27 10:42:32 EDT 2004  Connecting service:  4
Thu May 27 10:42:32 EDT 2004  Setting up AS400 implementation object:
Thu May 27 10:42:32 EDT 2004    Enable SSL connections: null
Thu May 27 10:42:32 EDT 2004    Native optimizations allowed:  false
Thu May 27 10:42:32 EDT 2004    Use threaded communications:  true
Thu May 27 10:42:32 EDT 2004    User specified CCSID:  0
Thu May 27 10:42:32 EDT 2004    Locale: en_US
Thu May 27 10:42:32 EDT 2004    Socket properties: 
com.ibm.as400.access.SocketProperties@1d80e6d
Thu May 27 10:42:32 EDT 2004    DDM RDB: null
Thu May 27 10:42:32 EDT 2004  User ID: 'WEBAPPSTST'
Thu May 27 10:42:32 EDT 2004  Signing-on with prompting turned on.
Thu May 27 10:42:32 EDT 2004  Validate security...
Thu May 27 10:42:32 EDT 2004  Signing-on without prompting...
Thu May 27 10:42:32 EDT 2004  Opening a socket to verify security...
Thu May 27 10:42:32 EDT 2004  Connecting to port mapper...
Thu May 27 10:42:32 EDT 2004  Sending port mapper request...
Thu May 27 10:42:32 EDT 2004  Data stream sent...
61 73 2D 73 69 67 6E 6F 6E 
Thu May 27 10:42:32 EDT 2004  Receiving port mapper reply...
Thu May 27 10:42:33 EDT 2004  Data stream data received...
2B 00 00 21 1C 
Thu May 27 10:42:33 EDT 2004  Adding entry to Service Port table: system 
XXX.XXX.XX.XXX, service as-signon, port 8476
Thu May 27 10:42:33 EDT 2004  Opening socket to server...
Thu May 27 10:42:33 EDT 2004  Setting socket options...
Thu May 27 10:42:33 EDT 2004  Socket properties:
Thu May 27 10:42:33 EDT 2004      Remote address: /XXX.XXX.XX.XXX
Thu May 27 10:42:33 EDT 2004      Remote port:  8476
Thu May 27 10:42:33 EDT 2004      Local address: /XXX.XXX.XX.XXX
Thu May 27 10:42:33 EDT 2004      Local port:  2030
Thu May 27 10:42:33 EDT 2004      Keep alive:  false
Thu May 27 10:42:33 EDT 2004      Receive buffer size:  8192
Thu May 27 10:42:33 EDT 2004      Send buffer size:  8192
Thu May 27 10:42:33 EDT 2004      So linger:  -1
Thu May 27 10:42:33 EDT 2004      So timeout:  0
Thu May 27 10:42:33 EDT 2004      TCP no delay:  false
Thu May 27 10:42:33 EDT 2004  Starting an inet socket to as-signon
Thu May 27 10:42:33 EDT 2004  Sending signon server exchange client/server 
attributes request...
Thu May 27 10:42:33 EDT 2004  Data stream sent...
00 00 00 34 00 00 E0 09 00 00 00 00 00 00 00 00 
00 00 70 03 00 00 00 0A 11 01 00 00 00 01 00 00 
00 08 11 02 00 02 00 00 00 0E 11 03 00 00 00 FC 
C6 E9 8B E0 
Thu May 27 10:42:33 EDT 2004  Receiving signon server exchange client/server 
attributes reply...
Thu May 27 10:42:33 EDT 2004  Data stream data received...
00 00 00 18 00 00 00 00 00 00 00 00 00 00 00 00 
00 04 00 00 
Thu May 27 10:42:33 EDT 2004  Data stream data received...
00 04 00 08 
Thu May 27 10:42:33 EDT 2004  Signon server exchange client/server attributes 
failed, return code:
00 04 00 08 
java.lang.Throwable
 at com.ibm.as400.access.Trace.log(Trace.java:944)
 at com.ibm.as400.access.Trace.log(Trace.java:869)
 at 
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1913)
 at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
 at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
 at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
 at com.ibm.as400.access.AS400.signon(AS400.java:3339)
 at com.ibm.as400.access.AS400.connectService(AS400.java:805)
 at 
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2672)
 at 
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:911)
 at 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:802)
 at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)
 at TestDB.main(TestDB.java:39)
Thu May 27 10:42:33 EDT 2004  Signon server exchange client/server attributes 
failed:
com.ibm.as400.access.ServerStartupException: Not able to pass connection to 
server job.  Unknown or unrecoverable error occured.
 at 
com.ibm.as400.access.AS400ImplRemote.returnSecurityException(AS400ImplRemote.java:1596)
 at 
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1914)
 at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
 at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
 at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
 at com.ibm.as400.access.AS400.signon(AS400.java:3339)
 at com.ibm.as400.access.AS400.connectService(AS400.java:805)
 at 
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2672)
 at 
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:911)
 at 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:802)
 at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)
 at TestDB.main(TestDB.java:39)
Thu May 27 10:42:33 EDT 2004  as400: Connection null (26440236) : Throwing 
exception. Original exception: .com.ibm.as400.access.ServerStartupException: 
Not able to pass connection to server job.  Unknown or unrecoverable error 
occured.
 at 
com.ibm.as400.access.AS400ImplRemote.returnSecurityException(AS400ImplRemote.java:1596)
 at 
com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:1914)
 at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:1794)
 at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:2603)
 at com.ibm.as400.access.AS400.promptSignon(AS400.java:2049)
 at com.ibm.as400.access.AS400.signon(AS400.java:3339)
 at com.ibm.as400.access.AS400.connectService(AS400.java:805)
 at 
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2672)
 at 
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:911)
 at 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:802)
 at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)
 at TestDB.main(TestDB.java:39)

Thu May 27 10:42:33 EDT 2004  as400: Connection null (26440236) : Throwing 
exception.  Actual exception: The application requester cannot establish the 
connection. (Not able to pass connection to server job.  Unknown or 
unrecoverable error occured.) sqlState: 08001 vendor code 
-99999.java.sql.SQLException: The application requester cannot establish the 
connection. (Not able to pass connection to server job.  Unknown or 
unrecoverable error occured.)
 at com.ibm.as400.access.JDError.throwSQLException(JDError.java:521)
 at 
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2680)
 at 
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:911)
 at 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:802)
 at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171)
 at TestDB.main(TestDB.java:39)

dumping sqle
java.sql.SQLException: The application requester cannot establish the 
connection. (Not able to pass connection to server job.  Unknown or 
unrecoverable error occured.)
 at com.ibm.as400.access.JDError.throwSQLException(JDError.java:521)
 at 
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2680)
 at 
com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:911)
 at 
com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:802)
 at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:171) The error was 
The application requester cannot establish the connection. (Not able to pass 
connection to server job.  Unknown or unrecoverable error occured.)

 at TestDB.main(TestDB.java:39)

Thanks,


Tony Richardson
AS/400 Developer
JAS Forwarding (USA), Inc.
One Ravinia Drive, Suite 650
Atlanta GA, 30346
Tel: (770) 688-1260
Fax: (770) 688-1229
Web: www.jasusa.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.