msouterblight1
VIP Member
All,
We are having an issue with our WebDev clients, they can't connect to the local DB! When the developers select EnterpriseOne Menu to bring up the local HTML Client, the web page appears, but there is no menu, only the fast path. If they try to fastpath to any application there is a critical error pop up. After reviewing the logs, I found the following:
25 Jul 2007 12:36:27,259 [SEVERE] - [JDBJ] The administrator must manually regererate the serialized object database for deployed packages to take effect.
25 Jul 2007 12:36:27,400 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
25 Jul 2007 12:36:27,400 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
25 Jul 2007 12:36:27,556 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [BASE] com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [BASE] com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C. com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.
25 Jul 2007 12:36:27,571 [SEVERE] - [JAS] SpecException occured in the JDEOWDirect.getSpec(): | User Name : JDE, Environment : DV812, Role : *ALL, Language : null com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
...
om.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
OneWortld Local - DV812 is the local location defined in the jdbj.ini file so that the web client is hitting the local tables instead of the Serialized Object tables used by the web server.
Here is the definition from the jdbj.ini file:
[JDBj-SPEC DATA SOURCE]
name=OneWorld Local - DV812
databaseType=M
server=localhost
serverPort=3372
database=JDELocal_DV812
physicalDatabase=JDELocal_DV812
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=sa
password=
Any ideas???
We are having an issue with our WebDev clients, they can't connect to the local DB! When the developers select EnterpriseOne Menu to bring up the local HTML Client, the web page appears, but there is no menu, only the fast path. If they try to fastpath to any application there is a critical error pop up. After reviewing the logs, I found the following:
25 Jul 2007 12:36:27,259 [SEVERE] - [JDBJ] The administrator must manually regererate the serialized object database for deployed packages to take effect.
25 Jul 2007 12:36:27,400 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
25 Jul 2007 12:36:27,400 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
25 Jul 2007 12:36:27,556 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [BASE] com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
25 Jul 2007 12:36:27,556 [SEVERE] - [BASE] com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C. com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.
25 Jul 2007 12:36:27,571 [SEVERE] - [JAS] SpecException occured in the JDEOWDirect.getSpec(): | User Name : JDE, Environment : DV812, Role : *ALL, Language : null com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
...
om.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local - DV812.
at com.jdedwards.database.impl.physical.JDBConnectionManager.createNewConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getPhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.physical.JDBRetryableConnection.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
OneWortld Local - DV812 is the local location defined in the jdbj.ini file so that the web client is hitting the local tables instead of the Serialized Object tables used by the web server.
Here is the definition from the jdbj.ini file:
[JDBj-SPEC DATA SOURCE]
name=OneWorld Local - DV812
databaseType=M
server=localhost
serverPort=3372
database=JDELocal_DV812
physicalDatabase=JDELocal_DV812
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=sa
password=
Any ideas???