problem with logging TN

, ,
1

Hi
Im used to try to login to the trading networks. it showing some error

Message :
Trading Networks database pool is not configured. Please configure a database pool for functional alias “TN” and restart WmTN package.

class: com.wm.app.tn.db.DatastoreException

stack trace:

com.wm.app.tn.db.DatastoreException: Trading Networks database pool is not configured. Please configure a database pool for functional alias “TN” and restart WmTN package.

at com.wm.app.tn.db.Datastore.checkDBConfig(Datastore.java:460)
at com.wm.app.tn.db.Datastore.init(Datastore.java:97)
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)

2

"Message :
Trading Networks database pool is not configured. Please configure a database pool for functional alias “TN” and restart WmTN package.

class: com.wm.app.tn.db.DatastoreException

stack trace:

com.wm.app.tn.db.DatastoreException: Trading Networks database pool is not configured. Please configure a database pool for functional alias “TN” and restart WmTN package."

Have you executed TN scripts to create TN related tables in DB? If yes, configure database pool from IS administration page and associate it with TN alias.

3

Hi
shahid
can u tell me how to create TN related tables in DB. and i created jdbc pool.

4

Create table:

  1. Open Database component configurator
  2. Select type - create and product - Trading networks and version - Latest
  3. Provide DB info
  4. Execute it.

JDBC Pools configuraton:
Goto IS Administrator–>JDBC Pools
Create pool Alias for database which you used to create TN tables.
Assoicate the above created alias in TN Funcational Alias definition.

For more info IS Adminsitrator guide, TN Administrator pdf.

5

Hi
arul
I created table in oracle.like this
ID NAME ADDRESS

2 prasad mpl
1 reddy blr
5 madhu blr

then

jdbc pool:

Alias Name :prasad
Alias Description :TN connection with jdbc
Associated Driver Alias DataDirect Connect JDBC Oracle
Database URL :jdbcOracle:thin:@localhost:5555:siva
User Id :Administrator
Password :manage
Minimum Connections :1
Maximum Connections :10
Idle Timeout milliseconds :10000

Is it correct?
please give me suggesion

thanks&regards
siva