The TN console cannot start

[nikhil]

Hi All.......

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)

Regards
Nikhil

[paulhasse]

Hi Nikhil

1) Run the database scripts for TN.
2) Make sure you have created a JDBC pool alias for the TN database.
3) Associate the pool alias with the TN functional alias definition.
4) Restart the the TN functional definition.

HTH

Paul

[nikhil]

Hai ...

But now am getting another exception

ErrorMessage:
<errorID> TRNCONS.000001.000003 </errorID>
<errorLevel> ERROR </errorLevel>
<serverVersion> </serverVersion>
<serverName> </serverName>
<serverHostName> </serverHostName>
<clientVersion> </clientVersion>
<clientHostName> </clientHostName>
<userName> </userName>
<className> TNConnectDialog </className>
<methodName> connectToNewServer </methodName>
<errorTime> Tue Jul 04 17:52:40 IST 2006 </errorTime>
<errorText> Error connecting to server. </errorText>
<additionalErrorText> Not a ServiceException </additionalErrorText>
<suggestedActions> Check that server specification is correct and that server is running and accessible. </suggestedActions>
<exception> <superException>com.wm.ui2.UiException: java.net.ConnectException

Connection refused: connect</superException>
<sourceException>java.net.ConnectException: Connection refused: connect</sourceException>
<problem>java.net.ConnectException</problem>
<reason>Connection refused: connect</reason>
<details>null</details>
<callStack>null</callStack>
<pipeLine>null</pipeLine>
</exception>
<stackTrace> 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)
</stackTrace>

<exception> java.net.ConnectException: Connection refused: connect </exception>
<stackTrace> 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)
</stackTrace>

Regards
Nikhil

[paulhasse]

I get exactly the same error if my Integration Server is down.
Make sure the IS server is running

[ramya]

Hi everyone,

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.<init>(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.

Thanks,
Ramya

[scoobydoo]

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

[stepheny]

In which document can i find the documentation of running the scripts and these following steps ?
Thanks

[rmg]

Stepheny,

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.

HTH,
RMG