ranchgirl60
Member
We are trying to move a customer to Win 2008 and SQL 2008.
I had everything working pretty well including the web servers. I am now installing a new OAS server on Win 2008 and just about have everything running. In the midst of doing this they swapped the environment Datasources to SQl 2008 database, but left all the system databases on SQL 2005.
now my Jas and Webdev clients are not able to sign on. I get this error on the jas client:
Sign In Error: An unknown JAS sign in error occurred. Please contact the System Administrator
and this is in my jas logs on the web server.
18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. java.sql.SQLException: No suitable driver
18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] 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.
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] 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.)
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] 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.)
18 Sep 2015 22:45:08,353 [Line -1] [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.)
we are using the SQL 2005 JDBC. Any guidance would be helpful. I am not the best with web and jas issues. And of course I am on a big fast deadline.
Many Thanks
I had everything working pretty well including the web servers. I am now installing a new OAS server on Win 2008 and just about have everything running. In the midst of doing this they swapped the environment Datasources to SQl 2008 database, but left all the system databases on SQL 2005.
now my Jas and Webdev clients are not able to sign on. I get this error on the jas client:
Sign In Error: An unknown JAS sign in error occurred. Please contact the System Administrator
and this is in my jas logs on the web server.
18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. java.sql.SQLException: No suitable driver
18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] 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.
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] 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.)
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] 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.)
18 Sep 2015 22:45:08,353 [Line -1] [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.)
we are using the SQL 2005 JDBC. Any guidance would be helpful. I am not the best with web and jas issues. And of course I am on a big fast deadline.
Many Thanks