WM61 TN DB Connection Help

, ,
1

WM6.1 - Oracle 9i - Jdbc Thin Driver

log says - No model version information was available from the database.

from other threads i see this is due to TN not connecting to DB, what am i missing .
Test of JDBC connection for TN says - Test of TN successful

Server Log

No model version information was available from the database.
TRANET: Loading system configuration
TRANET: Starting webMethods Trading Networks
WmTN: Startup service (wm.tn.admin:startup)
Loading WmTN package

Packages Loaded

Default
WmRoot
WmPublic
WmTN
WmFlatFile

Oracle DB Scripts run for user TN - create_TN_6-1_Oracle.sql

JDBC Pool

Driver Alias Definitions
Alias Name - OracleThinDriver
Driver Class Name - oracle.jdbc.driver.OracleDriver

Pool Alias Definitions
Alias Name - TN_POOL
Associated Driver Alias - OracleThinDriver
Database URL - jdbc:oracle:thin:@192.168.1.101:1521:TestDB
User Id - TN

–

Functional Alias Definitions
TN - Trading Networks Function - Associated Pool Alias (TN_POOL)

Please help …

Tom

2

Tom.

I believe you have run all the necessary DB scripts provided by webMethods.

I noticed in your Pool Alias Definitions:the Database URL should be in this syntax from 6.1
Database URL - jdbc:wm:oracle//192.168.1.101:1521;SID:TestDB

Or else

Use the webMethods provided DataDirect JDBC Driver that comes with IS6.1.

Here are the sample JDBC connection pool settings for TN,ProcessAudit,ISCoreAudit,XRef etc…

Pool Alias Definitions
Alias Name - TN_POOL
Alias Descriptio -TN_POOL
Associated Driver Alias -DataDirect Connect JDBC Oracle Driver
Database URL - jdbc:wm:oracle://192.168.1.101:1521;SID:TestDB
User Id - TN
…

Finally Test the JDBC connection pool,similarly all the pools.

Restart the IS and login to TN.

HTH,
RMG

3

RMG,

when i changed the url …JDBC test fails

Test of TN Failed
No suitable driver

i have installed WM6.1 in WinXP ( Laptop )

How to use datadirect for Oracle , can you provide the list

  1. jar/zip lib files
    2)URL syntax

thx

Tom

4

Tom,

The DataDirect driver bundles with IS6.1 standard installation.

Here is the DataDirect for Oracle (URL,Syntax)for JDBC Pools configuration.And i gave this info in my earlier mail too.

-----------------JDBC Pool Configuration-------------

Pool Alias Definitions
Alias Name - TN_POOL
Alias Descriptio -TN_POOL
Associated Driver Alias - DataDirect Connect JDBC Oracle Driver
Database URL - jdbc:wm:oracle://192.168.1.101:1521;SID:TestDB
User Id - TN
…

Finally Test the connection…

Same config applies for ISCoreAuditPool,ProcessAuditPool,XRefPool etc…

HTH,

5

RMG,

NO luck this time also

Tried with DataDirect Connect JDBC Oracle Driver

First Used
Database URL - jdbc:wm:oracle://192.168.1.101:1521;SID:TestDB

didn’t connect , then as per other threads used changed : to =

Database URL - jdbc:wm:oracle://192.168.1.101:1521;SID=TestDB

yes this time connected - Test of TN successful

With high hopes …restarted the server …but no luck again

[1703]2004-07-17 17:33:26 CDT [ISU.0000.9999C] No model version information was available from the database. [TRNSERV.000016.000031]

6

Opps it might be my mistake when typing syntax.Appolozise me.

Hope you have executed all the DB scripts for Oracle and restarted the server.

Also please try to reload the WmTN package and attempt login to TNConsole.

HTH,

7

Tom,

Please check this thread.if it helps
[url=“wmusers.com”]wmusers.com

Make sure the Oracle server is up and also do check in the DB whether the created Oracle tables in TN are corrupted.If so then run drop
oracle script then run createTN6.1_oracle.sql from
IntegrationServer\common\db… and re-run the scripts again.

This problem happened for many users,and this is the only way of debugging and correct the problem.

HTH,

8

oh yeah got it …dropped and recreated …microsoft way if not working reboot

RMG Thx a lot …even on Sat U are there with helping hands

tom

9

Glad it worked…

you welcome Tom,