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.

 View Only
  • 1.  trading network error

    Posted Fri December 04, 2009 10:39 AM

    hi all,

    first i run the scripts and configured the jdbc pool configuaration.after i opened the TN Console.but i am getting below the error .can any one help me how to over come this errors.

    wm.tn.route:init

    Error encountered while reading processing rules from the database. The exception message is : [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    .
    (0) java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    (1) java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    

    com.wm.app.tn.route.RoutingException

    java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    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.RROperations.insertRuleModification(RROperations.java:557)
    
    at com.wm.app.tn.db.RROperations.getChangeId(RROperations.java:533)
    
    at com.wm.app.tn.db.RROperations.loadAll(RROperations.java:364)
    
    at com.wm.app.tn.route.RoutingRuleStore.load(RoutingRuleStore.java:172)
    
    at wm.tn.route.init(route.java:54)
    
    at wm.tn.admin.startup(admin.java:732)
    
    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)
    

    Thanks
    kumar.


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


  • 2.  RE: trading network error

    Posted Fri December 04, 2009 11:41 AM

    Hi to all,

    In Is menu,I clicked on trading network under solutions
    I am getting the errors as below.
    Service wm.tnweb.configFlow:loadMenu Error class com.wm.app.tn.err.EXMLException
    TRNSERV.000012.000066 Could not get host profile. java.lang.NullPointerException java.lang.NullPointerException at wm.tn.profile.getHostProfile(profile.java:249) 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.BaseService.invoke(BaseService.java:155) at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324) at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:580) at com.wm.lang.flow.FlowState.step(FlowState.java:438) at com.wm.lang.flow.FlowState.invoke(FlowState.java:403) at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1749) 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.ns.Namespace.invoke(Namespace.java:533) at com.wm.util.template.Reporter.invoke(Reporter.java:963) at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75) at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java:214) at com.wm.util.template.TemplateToken.eval(TemplateToken.java:180) at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299) at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274) at com.wm.util.template.Reporter.reportIData(Reporter.java:1163) at com.wm.app.b2b.server.HTTPDocHandler._process(HTTPDocHandler.java:490) at com.wm.app.b2b.server.HTTPDocHandler.process(HTTPDocHandler.java:112) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:311) at com.wm.util.pool.PooledThread.run(PooledThread.java:105) at

    Trading network console:
    While opening this ,I am getting the error as follows.

    Title : wm.tn.route:init
    Message : Error encountered while reading processing rules from the database. The exception message is : [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    .(0) java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    (1) java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    class : com.wm.app.tn.route.RoutingException
    stack trace : java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

    java.sql.SQLException: [wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
    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.RROperations.insertRuleModification(RROperations.java:557)
    
    at com.wm.app.tn.db.RROperations.getChangeId(RROperations.java:533)
    
    at com.wm.app.tn.db.RROperations.loadAll(RROperations.java:364)
    
    at com.wm.app.tn.route.RoutingRuleStore.load(RoutingRuleStore.java:172)
    
    at wm.tn.route.init(route.java:54)
    
    at wm.tn.admin.startup(admin.java:732)
    
    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)
    

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


  • 3.  RE: trading network error



  • 4.  RE: trading network error

    Posted Sat December 05, 2009 04:06 AM


  • 5.  RE: trading network error

    Posted Sat December 05, 2009 06:59 PM

    It should work…After installing fixes restart IS or reload WmTN package.

    Re-login to TNC.

    HTH,
    RMG


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