JAS login issues on AS/400

I'm running ERP 8.0 SP21_G1 on an AS/400 enterprise server running V5R2 and I have a JAS server (WAS4.0) running IIS. Currently I'm having issues logging into OneWorld on the JAS server. I can launch the snoop servlet and I can get to the jde/owhtml page and I can load SAW but I can't login to any environment on the JAS server. From a FAT client (installed locally on JAS server) I can login to the regular and 'J' environments and submit reports to the Enterprise server so I think my environments are setup correctly.

I've followed the guides in the SP21 JAS install guide but all it has for
the configuring JDBC for the iSeries is to obtain the IBM toolbox and to
copy the jt400.jar to <WAS_HOME>\lib\app. In the stdout.log I get a 'No F0092 OCM' error and in the jde.log I get the following:

2003-04-11 14:21:11.062 [ORB.thread.pool:2] LIB : ***** File [D:\Program
Files\JDEdwards\JAS\EA_JDEdwards_1.ear\webclient.war\logs\jas.log] opened
2003-04-11 14:21:11.078 [ORB.thread.pool:2] LIB : SysInfo: Windows 2000
5.0 x86 JavaInfo: IBM Corporation 1.3.1 (J2RE 1.3.1 IBM Windows 32 build
cn131w-20020403 ORB130 (JIT enabled: jitc))
2003-04-11 14:21:11.094 [ORB.thread.pool:2] JAS : OneWorld JAS startup
initiated
2003-04-11 14:21:11.250 [ORB.thread.pool:2] JAS : JDBC Driver
<COM.ibm.db2.jdbc.app.DB2Driver> is registered. Major Version <7> Minor
Version <1>
2003-04-11 14:21:11.391 [ORB.thread.pool:2] JAS : JDBC Driver
<com.ibm.as400.access.AS400JDBCDriver> is registered. Major Version <5>
Minor Version <0>
2003-04-11 14:21:11.391 [ORB.thread.pool:2] JAS : Could not register
<com.microsoft.jdbc.sqlserver.SQLServerDriver>, ClassNotFoundException.
2003-04-11 14:21:11.406 [ORB.thread.pool:2] JAS : Could not register
<oracle.jdbc.driver.OracleDriver>, ClassNotFoundException.
2003-04-11 14:21:11.953 [ORB.thread.pool:2] JAS : OneWorld JAS startup
complete
2003-04-11 14:21:38.328 [Servlet.Engine.Transports:10] JAS : trying
DriverManager.getConnection/new OWConnection to Datasource : OMDATP: DV7334,
OMSRVR: null, OMDATB: System - B7334, OMOOWN: SYS7334, OMLL: null, OMLIB:
SYS7334, OMOMUI: null, OMOMTO: Y, OMOMDS: Y, OMOMJD: Y, OMOMCC: null,
OMDSTP: I, OMOCMB: null, dbUser: null
java.sql.SQLException: The application requester cannot establish the
connection.(null)

I also get an error when I run the egenerator stating that 'DBDRIVERS
component: jt400.jar could not be found. Does anyone know where the
egenerator needs this file?

Thanks

Colin

Colin,

Did you use the egenerator that came with SP 21 it will be in the system folder under B7. The .jar file needs to be at a path similar to this for AS/400

set DBDRIVERS=
"D:\ProgramFiles\JDEdwards\JAS\webclient\servlets\jt400.jar

Hope this helps

Does andone have a CLASSPATH they could send me from a WIn2K JAS server
running WAS40 with an AS/400 enterprise server (SP21 or SP20).?

Thanks





Colin Dawes, Sr. Technical Consultant
Syntax.net
B733.1 to ERP 8.0
Oracle 8i/9i/SQL Server 2K, DB2

Thanks for the replies. My error was that I actually tried to follow the JDE
documentation which was not totally correct for the AS/400. The issue is
that in the jas.ini [DB SYSTEM SETTINGS] section it states the following:
[DB SYSTEM SETTINGS]
# This option should be set only for SQL*Server or Oracle.
# It should be left blank for DB2.
#
Object Owner=SYS7334
Server=
#

This is actually wrong. The server name has to be filled out regardless of
platform. This setting is actually supposed to be input during the initial
install as the 'OCM Server' but the documentation for JAS_SP21
says.........well just assume it's confusing at best.

Colin



Colin Dawes, Sr. Technical Consultant
Syntax.net
B733.1 to ERP 8.0
Oracle 8i/9i/SQL Server 2K, DB2