IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  com.wm.app.tn. db.DatastoreException

    Posted 12/07/06 12:25 PM

    This error is coming whenever we start TN. Any idea what is going wrong and how to fix it ?

     com.wm.app.tn.db.DatastoreException: Database error putting type 000000000000000000111111: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    (0) java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    (1) java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("WM65"."ACTIVITYLOG"."ACTIVITYLOGID")
    
    at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
    at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
    at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
    at com.wm.dd.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
    at com.wm.dd.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
    at com.wm.app.tn.db.EventOperations.log(EventOperations.java:122)
    at com.wm.app.tn.db.BDTypeOperations.insert(BDTypeOperations.java:139)
    at com.wm.app.tn.db.BizDocTypeStore.insert(BizDocTypeStore.java:268)
    at com.wm.app.tn.db.Import.installTypes(Import.java:249)
    at com.wm.app.tn.db.Import.installData(Import.java:78)
    at com.wm.app.tn.db.Datastore.checkAndLoadInitXML(Datastore.java:670)
    at wm.tn.adminimpl.startup(adminimpl.java:768)
    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: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.pwm.tn.admin:startup     

    Kishen Das


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: com.wm.app.tn. db.DatastoreException

    Posted 12/07/06 04:18 PM

    Did you run success all the TN related DB scripts??

    HTH,
    RMG


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: com.wm.app.tn. db.DatastoreException

    Posted 12/08/06 10:40 AM

    Will try re-creating all the DB tables and see whether it will work.
    Thanks for your suggestion.

    Kishen Das


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB