The 3 sql jar files are in the right place. Shud we generate the objects before loggin into JAS. I configured the generator , but cannot login with DEMO/DEMO/DEMO812/*ALL.
Below is the jas.log
05 Jul 2007 13:03:19,421 [SEVERE] - [JAS] OneWorld JAS startup initiated
05 Jul 2007 13:03:21,578 [SEVERE] - [JAS] OneWorld JAS startup complete
05 Jul 2007 13:03:26,359 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.
05 Jul 2007 13:03:26,359 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.
05 Jul 2007 13:03:26,375 [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 Local.) com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.)
05 Jul 2007 13:03:26,375 [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 Local.) 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 Local.)
05 Jul 2007 13:03:26,390 [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 Local.)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(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)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
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)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.get(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.jas.services.userpref.UserPrefLookup.getUserDisplayPrefInfo(Unknown Source)
at com.jdedwards.jas.JDESignon.getUserLanguage(Unknown Source)
at com.jdedwards.jas.JDESignon.buildUserSession(Unknown Source)
at com.jdedwards.jas.JDESignon.buildUserSessionWithPass(Unknown Source)
at com.jdedwards.jas.JDESignon.jdeSignon(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.servletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callLogin(Unknown Source)
at com.jdedwards.jas.net.NetConnection.login(Unknown Source)
at com.jdedwards.jas.net.NetConnection.createNetConnection(Unknown Source)
at com.jdedwards.services.login.JASLoginWrapper.login(Unknown Source)
at com.jdedwards.services.login.JASLoginWrapper.login(Unknown Source)
at com.jdedwards.services.login.LoginContext.login(Unknown Source)
at com.jdedwards.services.login.InitialParameterLoginState.changeState(Unknown Source)
at com.jdedwards.services.login.LoginContext.changeState(Unknown Source)
at com.jdedwards.services.login.InitialState.changeState(Unknown Source)
at com.jdedwards.services.login.LoginContext.<init>(Unknown Source)
at com.jdedwards.services.login.Login.processLogin(Unknown Source)
at com.jdedwards.services.webaccess.WebAccessServlet.processRequest(Unknown Source)
at com.jdedwards.services.webaccess.WebAccessServlet.service(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doService(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at com.jdedwards.base.JDEFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:649)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.
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)
at com.jdedwards.database.impl.physical.JDBConnectionManager.getConnection(Unknown Source)
at com.jdedwards.database.services.bootstrap.JDBBootstrapPhysicalConnectionFactory.newPhysicalAccess(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.resolvePhysicalConnection(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.select(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.select(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.prime(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.searchOCM(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCM.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.ocm.OCMObjectLookupService.getDatabaseDataSource(Unknown Source)
at com.jdedwards.database.services.base.JDBServiceAugmentedKeyFactory.newAugmentedKey(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.get(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.database.services.base.JDBBaseLookupService.getSingle(Unknown Source)
at com.jdedwards.jas.services.userpref.UserPrefLookup.getUserDisplayPrefInfo(Unknown Source)
at com.jdedwards.jas.JDESignon.getUserLanguage(Unknown Source)
at com.jdedwards.jas.JDESignon.buildUserSession(Unknown Source)
at com.jdedwards.jas.JDESignon.buildUserSessionWithPass(Unknown Source)
at com.jdedwards.jas.JDESignon.jdeSignon(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.jdedwards.jas.ServletProxy.callServerComponent(Unknown Source)
at com.jdedwards.jas.ServletProxy.servletProxy(Unknown Source)
at com.jdedwards.jas.ServletProxy.dispatch(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callJAS(Unknown Source)
at com.jdedwards.jas.net.NetConnection.callLogin(Unknown Source)
at com.jdedwards.jas.net.NetConnection.login(Unknown Source)
at com.jdedwards.jas.net.NetConnection.createNetConnection(Unknown Source)
at com.jdedwards.services.login.JASLoginWrapper.login(Unknown Source)
at com.jdedwards.services.login.JASLoginWrapper.login(Unknown Source)
at com.jdedwards.services.login.LoginContext.login(Unknown Source)
at com.jdedwards.services.login.InitialParameterLoginState.changeState(Unknown Source)
at com.jdedwards.services.login.LoginContext.changeState(Unknown Source)
at com.jdedwards.services.login.InitialState.changeState(Unknown Source)
at com.jdedwards.services.login.LoginContext.<init>(Unknown Source)
at com.jdedwards.services.login.Login.processLogin(Unknown Source)
at com.jdedwards.services.webaccess.WebAccessServlet.processRequest(Unknown Source)
at com.jdedwards.services.webaccess.WebAccessServlet.service(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doService(Unknown Source)
at com.peoplesoft.e1.container.MafletServiceContainer.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at com.jdedwards.base.JDEFilter.doFilter(Unknown Source)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:649)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:322)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.mapInstanceNameToPort(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)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
... 58 more