TN testing error

, ,
1

hi,all
i am getting the error while configuring TN.
While testing the Functional Alias Definitions

"Test of TN Failed
[wm-cjdbc33-0069][SQLServer JDBC Driver] No more data available to read. "

this is the error i got. Plz suggest me
thanks,

regards
Kishor

2

Seems you are using a very old version of the cjdbc driver. which version of IS are you running?
Can you give the about page and connection pool settings.

3

Thanks for help …
IS ver. is 6.1 &

JDBC Connection Pool Alias is…

Alias Name - Tnalies
Alias Description - tnaction

Associated Driver - DataDirect Connect JDBC SQL Server Driver
Database URL - jdbc:wm:sqlserver://localhost:5555;DatabaseName=TN;SelectMethod=cursor;

User Id - sa

Password -**

Minimum Connections - 1

Maximum Connections- 60
Idle Timeout -6000 milliseconds

regards,

Kishor

4

You should try with default sql server/port:

URL - jdbc:wm:sqlserver://dbserver:1433;DatabaseName=TN;SelectMethod=cursor

HTH,
RMg

5

Thanks RMG Sir,

Now the Test of TN successful… But some problems in start up …

The console can not start. The following errors occured while trying to start the console.
The details are..

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
Stake 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:689)

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:587)

at com.wm.app.b2b.server.invoke.StatisticsProcessor.process
 (StatisticsProcessor.java:44)

at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process
            (ServiceCompletionImpl.java:229)

at com.wm.app.b2b.server.invoke.ValidateProcessor.process
          (ValidateProcessor.java:49)

at com.wm.app.b2b.server.ACLManager.process
                (ACLManager.java:198)

at com.wm.app.b2b.server.invoke.DispatchProcessor.process
                   (DispatchProcessor.java:39)

at com.wm.app.b2b.server.AuditLogManager.process
                     (AuditLogManager.java:407)

at com.wm.app.b2b.server.invoke.InvokeManager.invoke
                (InvokeManager.java:503)

at com.wm.app.b2b.server.invoke.InvokeManager.invoke
                    (InvokeManager.java:367)

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)

Please suggest me…
Thanks again in advance …

Kishor …

6

Once you ran all the TN db scripts sucessfully and tested the JDBC pool for TN restart the the IS (best option) or reload WmTN package…

PS:Make sure on the TN db side everything is fine (user a/c,privileges,access etc…)

HTH,
RMg