Hi,

When I start TN6.0.1 I am getting following message.“Please configure a database pool for functional alias “TN” and restart WmTN package”.
Any help on configuring db pool for TN would be highly appreciated.

Cheers,

Paul

Pauly,

Go into the IS Administrator in IE and select Pools from the menu on the right.
Create an Alias, usually JDBC driver, test it and assign it to TN all on this screen.
This info is all in the installation Guide.

HTH

Pls,Follow the path as Chris mentioned:

Here is the sample configuration params for jdbc connection pool for ORACLE that is used by TN

JDBC Connection Pool Alias:
Alias Name TNdatabasePool
Alias Description Trading Networks DB Pool
Associated Driver Alias DataDirect Connect JDBC Oracle Driver
Database URL jdbc:oracle://ipaddress:1521;SID=orcl (example)
User Id :scott (sample)
Password: *****
Minimum Connections 5
Maximum Connections 20
Idle Timeout 60000 milliseconds

HTH.

Thanks for resp. Inspite of having a conn pool for Oracle, i am getting the error which has been mentioned in first post. In that case what cud be the soln.

Cheers,

Pauly

Well. I do have this alias which has been created. The above error message will be displayed when I start the TN console. But here is the error message at IS console when I start IS which might causes TN startup to fail.

003-09-25 16:25:29 EDT [ADA.0001.0101D] Connected to database on “localhost” with “LOCAL_TRANSACTION”.
003-09-25 16:25:29 EDT [SCC.0126.0001E] SCC ConnectionManager Pool Started
003-09-25 16:25:29 EDT [ART.0118.5508V1] Adapter Runtime (Connection): Skipping start of connection JDBC:connectOracle. User has disabled this connection.
003-09-25 16:25:29 EDT [ISS.0028.0012C] WmOmiTN: Startup service (omi.wm.tn.pkginit:setACLs)
ava.lang.ExceptionInInitializerError: 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.ProfileIDOps.getHostID(ProfileIDOps.java:18)
at com.wm.app.tn.profile.ProfileStore.getProfileStore(ProfileStore.java:76)
at com.wm.app.tn.delivery.DeliveryUtils.init(DeliveryUtils.java:85)
at com.wm.app.tn.delivery.JobMgr.<init>(JobMgr.java:94)
at com.wm.app.tn.delivery.JobMgr.init(JobMgr.java:160)
at omi.wm.tn.pkginit.<clinit>(pkginit.java:86)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:344)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:498)
003-09-25 16:25:29 EDT [ISS.0028.0013E] Startup service exited with the following error: java.lang.NullPointerException
003-09-25 16:25:29 EDT [ISS.0028.0012C] WmOmiTN: Startup service (omi.wm.tn.pkginit:init)
ava.lang.NoClassDefFoundError: omi/wm/tn/pkginit
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:344)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:498)
003-09-25 16:25:30 EDT [ISS.0028.0013E] Startup service exited with the following error: java.lang.NullPointerException

I could not find the docs(pdf) on this. How to make sure that TN uses the alias which I have created.Any help would be greatly appreciated.

Cheers,

Pauly

The Error message indicates that you have not created/configured Functional Alias for TN (Function Name TN)

So,make sure whether you have defined the Functional Alias definition
and assigned the TNDatabasePool alias and test it. It will show up
with “Test of TN successful” message.

Finally reload the WmTN package and after that open the TNconsole.

HTH.

Hi,

Its working now after I run the script create_TN_6-0_Oracle.sql.

Cheers,

Pauly