trading network error

[mkreddy]

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.

[vuruvakili]

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)

[gupta_r.17495]

This is an old/legacy critical issue for TN which wM/SAG has provided fixes already:

You guys should check these Advantage articles.

Fixes for the critical issue which today impact all TN versions are available:
TN Version 6.1:

• TNS_6-1_Fix15 - [URL=“https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1611845574”]http://advantage.webmethods.com/article/?id=1611845574[/URL]
• TNC_6-1_Fix13 - [URL=“https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1612426739”]http://advantage.webmethods.com/article/?id=1612426739[/URL] (only required for 6.1 version)

TN Version 6.0.1:

• TNS_6-0-1_Fix39 - [URL=“https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1611845575”]http://advantage.webmethods.com/article/?id=1611845575[/URL]

TN Version 4.6:

• TNS_4-6_FIX_86 - [URL=“https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1611845576”]http://advantage.webmethods.com/article/?id=1611845576[/URL]

TN Version 4.0.1:

• TNS_4-0-1_FIX_24 - [URL=“https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1611849159”]http://advantage.webmethods.com/article/?id=1611849159[/URL]

Last but not least:[URL]http://advantage.webmethods.com/article/?id=SR-1-55784935[/URL]

HTH,
RMg

[vuruvakili]

Hi,

TN Version 6.1:

• TNS_6-1_Fix15 - [URL]http://advantage.webmethods.com/article/?id=1611845574[/URL] ([URL]https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1611845574[/URL])
• TNC_6-1_Fix13 - [URL]http://advantage.webmethods.com/article/?id=1612426739[/URL] ([URL]https://advantage.webmethods.com/main.jsp?targChanId=-536884334&oid=1612426739[/URL]) (only required for 6.1 version)

i used the above fixes.

i am getting the error what i posted in my previous thread

[gupta_r.17495]

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

Re-login to TNC.

HTH,
RMG