Unable to register delivery defaults

Guest · February 20, 2009, 10:55am

hi all ,
when i am satrting TN am getting this error and unable to open TN console

Title
Unable to register delivery default
message:
Unable to register delivery service Primary HTTP - SQLException inserting new delivery service Primary HTTP: ORA-00001: unique constraint (TN60.PK_DELISERV_SERVNAME) violated

(0) com.wm.app.tn.db.DatastoreException: SQLException inserting new delivery service Primary HTTP: ORA-00001: unique constraint (TN60.PK_DELISERV_SERVNAME) violated

(1) com.wm.app.tn.db.DatastoreException: SQLException inserting new delivery service Primary HTTP: ORA-00001: unique constraint (TN60.PK_DELISERV_SERVNAME) violated

Class:
com.wm.app.tn.delivery.DeliveryException
Stack Trace :
com.wm.app.tn.db.DatastoreException: SQLException inserting new delivery service Primary HTTP: ORA-00001: unique constraint (TN60.PK_DELISERV_SERVNAME) violated

com.wm.app.tn.db.DatastoreException: SQLException inserting new delivery service Primary HTTP: ORA-00001: unique constraint (TN60.PK_DELISERV_SERVNAME) violated

at com.wm.app.tn.db.DeliveryStore.insertService(DeliveryStore.java:411)
at com.wm.app.tn.delivery.ServiceMgr.registerService(ServiceMgr.java:179)
at com.wm.app.tn.delivery.ServiceMgr.registerService(ServiceMgr.java:228)
at wm.tn.delivery.registerDefaults(delivery.java:108)
at wm.tn.adminimpl.startup(adminimpl.java:749)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:322)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:612)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:226)
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:411)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:521)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:369)
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:803)

wM version 6.5.1 and TN 6.5 and
JDBC pool

Alias name : tndbpool
alias decription : trading network pool
Associate Dri…DataDirect Connect JDBC Oracle Driver

DB url jdbc:oracle:…
Plz its urgent

Thanks in advance

gupta_r.17495 · February 21, 2009, 10:34pm

pls make sure you successfully ran the TN db scripts and also check with the ORA dba if he see any things unusal in the db logs as it looks like scripts were executed twice with out dropping the tables which could be the possibility.

HTH,
RMG

ylo · March 16, 2009, 7:01am

You may have the delivery service created previously. Check the delivery service again. I think the delivery service name needs to be unique. Try the getDeliveryService to retrieve all previously created delivery service and check the names.