Could you tell me The TN console cannot start. The following errors occuured while trying to start the console.
Title: wm.tn.admin:startup
Message: There was a database error fetching the model version information from your database.
(0) java.lang.IllegalStateException: The main connection to the datastore has not been initialized. Check the
Trading Networks JDBC connection pool.
(1) java.lang.IllegalStateException: The main connection to the datastore has not been initialized. Check the
Trading Networks JDBC connection pool.
Class: com.wm.app.tn.db.DatastoreException
Stack Trace: java.lang.IllegalStateException: The main connection to the datastore has not been initialized.
Check the Trading Networks JDBC connection pool. java.lang.IllegalStateException: The main connection to
the datastore has not been initialized. Check the Trading Networks JDBC connection pool.
java.lang.IllegalStateException: The main connection to the datastore has not been initialized. Check the Trading
Networks JDBC connection pool. at com.wm.app.tn.db.Datastore.getConnection(Datastore.java:268) at
com.wm.app.tn.db.Datastore.getDBMetaData(Datastore.java:505) at com.wm.app.tn.db.Datastore.init(Datastore.java:175)
at wm.tn.admin.startup(admin.java:674) 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.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287) at
com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554) at
com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at
com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221) at
com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49) at
com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194) at
com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39) at
com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384) at
com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486) at
com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359) at
com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246) at
com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128) at
com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:100) at
com.wm.app.b2b.server.SessionInvoke.run(Session.java:705) at
com.wm.util.pool.PooledThread.run(PooledThread.java:105) at java.lang.Thread.run(Thread.java:534)
TNConnectDialog
connectToNewServer
Tue Jul 04 17:52:40 IST 2006
Error connecting to server.
Not a ServiceException
Check that server specification is correct and that server is running and accessible.
com.wm.ui2.UiException: java.net.ConnectException
Connection refused: connect
at com.wm.ui2.UiException.handle(UiException.java:215)
at com.wm.ui2.UiException.handle(UiException.java:184)
at com.wm.app.tn.ui.Server.connect(Server.java:183)
at com.wm.app.tn.ui.util.TNConnectDialog.connectToNewServer(TNConnectDialog.java:138)
at com.wm.app.tn.ui.TNMainFrame.doConnect(TNMainFrame.java:1217)
at com.wm.app.tn.ui.TradingNetworks$1.run(TradingNetworks.java:147)
at java.lang.Thread.run(Thread.java:534)
at com.wm.ui2.UiFrame$5.run(UiFrame.java:340)
java.net.ConnectException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at com.wm.app.b2b.client.ServiceException.getOriginalException(ServiceException.java:364)
at com.wm.ui2.UiException.handle(UiException.java:181)
at com.wm.app.tn.ui.Server.connect(Server.java:183)
at com.wm.app.tn.ui.util.TNConnectDialog.connectToNewServer(TNConnectDialog.java:138)
at com.wm.app.tn.ui.TNMainFrame.doConnect(TNMainFrame.java:1217)
at com.wm.app.tn.ui.TradingNetworks$1.run(TradingNetworks.java:147)
at java.lang.Thread.run(Thread.java:534)
at com.wm.ui2.UiFrame$5.run(UiFrame.java:340)
I’m also facing a similar kinda pbm. The below error is thrown when trying to login into the TN console,
wm.tn.admin:startup
There was a database error fetching the model version information from your database.
(0) com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc33-0069][SQLServer JDBC Driver][wm-cjdbc33-0069][SQLServer JDBC Driver]The requested instance is either invalid or not running.
(1) com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc33-0069][SQLServer JDBC Driver][wm-cjdbc33-0069][SQLServer JDBC Driver]The requested instance is either invalid or not running.
com.wm.app.tn.db.DatastoreException
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc33-0069][SQLServer JDBC Driver][wm-cjdbc33-0069][SQLServer JDBC Driver]The requested instance is either invalid or not running.
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc33-0069][SQLServer JDBC Driver][wm-cjdbc33-0069][SQLServer JDBC Driver]The requested instance is either invalid or not running.
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc33-0069][SQLServer JDBC Driver][wm-cjdbc33-0069][SQLServer JDBC Driver]The requested instance is either invalid or not running.
at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)
at com.wm.dd.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnectionStartup.run(Unknown Source)
As I’m new to this stuff any inputs u cud provide will be really helpfull.
Ramya,
Last time is this error, Our DBA changed the DB ports.
Make sure the DB Port TN pool connects to are alive and listening.
Make sure the DB instance is up and running.
Make sure you have created the tables using the right scripts.
hope this works out for you.
Scoobydoo
Please refer the “webMethods Installation Guide for 6.5 or 6.1” .pdf doc section called “Database Component Installation” section and look for Trading Networks portion.Generally sql scripts are located in the webMethods_directory\common\db\scripts\create directory.
You can get this document from the Advantage.webmethods.com or from your webMethods home installation folders IntegrationServer/doc or Developer/doc.