Error with Web client in 8.12/8.96 setup

[kiran g]

Hi All,

We are in a process of setting up two installations of JDE EnterpriseOne 8.12 with 8.96 toolset against MS SQL Server and Oracle as backend database in our test lab. Setup is on Win2K3 machines with WAS 6.0 used for web client.

In both the installations, we are facing the issue with accessing applications through web client. We are getting Unknown JAS error while signing into JDE.

In jasdebug.log following error is getting logged for setup with SQL server:

------------------------------------------------------
04 Aug 2009 18:37:18,166 [Line ?] [WebContainer : 5] [DEBUG ] - [JDBJ] Connecting to null with URL : jdbc:microsoft:sqlserver://PS6511:1433 DBUser :
04 Aug 2009 18:37:18,557 [Line ?] [WebContainer : 5] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
04 Aug 2009 18:37:18,557 [Line ?] [WebContainer : 5] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.
04 Aug 2009 18:37:18,557 [Line ?] [WebContainer : 5] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.) com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)
04 Aug 2009 18:37:18,557 [Line ?] [WebContainer : 5] [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.) com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)
04 Aug 2009 18:37:18,573 [Line ?] [WebContainer : 5] [SEVERE] - [JAS] Exception occured in the JDESignon.jdeSignon() :BuildUserSession Failed. com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

------------------------------------------------------

During both the installations we didn't face any issue except while populating production database with test data load in Create PSDEMO step through R98403E. The pdf generated was indicating Table Missing in Data source error.

I have verified the JDBC driver name entries in jdbj.ini and also put the jdbc driver libraries at required locations.

The issue seems to be with user name needed to establish jdbc connection with DB server. From log it seems that web client tries to connect to DB server with null user name.
----------------------------------------------------------
Connecting to null with URL : jdbc:microsoft:sqlserver://PS6511:1433 DBUser :
----------------------------------------------------------
(PS6511 is the name of machine hosting Enterprise server and MSSQL server database server)

Does anyone faced this issue earlier? Any pointer on this will be of great help.

Thanks in advance,
Kiran

 

[klwong]

First, you have posted in the Applications section, so it is not likely that you will get much of an answer here.

That said, I can think of 2 possibilities for your error:

1) You have not populated the user and password lines in the JAS.INI file.
2) You have not configured security services yet, or not associated a "system user" with your E1 user ID.