Still cannot start TN console wM6

[Martijn van Hagen (Unregistered Guest)]

Hi,
When i want to start my Trading Networks Console, I now get these errors:

===========================================
Title: wm.tn.admin:startup
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 your WmTN packages startup service.
(1) java.lang.IllegalStateException: The main connection to the datastore has not been initialized; check your WmTN packages startup service.
Class: com.wm.app.tn.db.DatastoreException
Stack trace: ava.lang.IllegalStateException: The main connection to the datastore has not been initialized; check your WmTN packages startup service.
java.lang.IllegalStateException: The main connection to the datastore has not been initialized; check your WmTN packages startup service.
java.lang.IllegalStateException: The main connection to the datastore has not been initialized; check your WmTN packages startup service.
at com.wm.app.tn.db.Datastore.getConnection(Datastore.java:279)
at com.wm.app.tn.db.Datastore.getDBMetaData(Datastore.java:505)
at com.wm.app.tn.db.Datastore.init(Datastore.java:185)

===========================================

I configured my connectionpool like this:
Associated driver alias: Datadirect Connect JDBC Oracle Driver
Database URL: jdbc:oracle:thin:@localhost:1521RCL
UserId: scott
Password: tiger (as UID and PW are default for Oracle)
minium connections: 1
maximum connections: 5
Idle Timeout: 120000

After that i connected this pool to all my functional alias definitions like "Processaudit", "IsCoreAudt" , "TN", and "Xref". I tested the connections and the were sucessfull.

I also created a wmDB alias, like this:
Alias Name: wMDatabase
DB URL: jdbc:oracle:thin:@localhost:1521RCL
DB Username: scott
DB password: tiger
DB Driver: oracle.jdbc.driver.OracleDriver
minium connections: 1
maximum connections: 5
Idle Timeout: -

I can connect to the database using this Alias. When i do so, I see all installed tables. So that should be allright.

Could you please help me with this. Why can't I start my Console?

Regards,

Martijn van Hagen

[srinik (Unregistered Guest)]

Hi Martin,

Did you checked startup services in developer.Place cursor
on WmTN package.Click on startup/shutdown button in developer
make sure startup service should be wm.tn.admin:startup
shutdown service is wm.tn.admin:shutdown for selected services
space.


your db url should be DB URL: jdbc:oracle:thin:@localhost:1521;SID=ORCL


Srini

[SriniK (Unregistered Guest)]

Hi Martin,

Just I opened TNDatabase I looked into tables.There is one
table called TNMODELVERSION table.In that table there is two
columns MAJORVERSION value is 6,MINORVERSION value is 0.Probably
in your case that table may not be generated when ever you run the webmethods sql script Or there may be chance of MAJORVERSION value
is not entered as 6.Please look.If you got solution share with us.


Thanks,
SriniK

[javier]

Hi Shrinik & Martin,
I'm curious to know how did you solved this problem.. I'm getting this error in version 6.1 with SQL JBDC : Table TNModelVersion Invalid Object......
The pools connections are tested sucesfully.
Any idea will help me. The table was generated with the scripts provide by WM. I populate manually(after failure) the Major Version(6)and Minor version(1)to see if that will fix the problem. I'm still unable to launch TN console

[ricksite]

Did you solved this?

Table TNModelVersion Invalid Object......

thanks