hi
i am getting the following error while opening tn

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:585)

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:595)

Dear,

similar problem arised to me when installing trading networks it as follows

com.wm.app.tn.err.EXMLException: wm.tn.route:init com.wm.app.tn.route.RoutingException 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 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

please intimate if u got reply,

regards
varma

Sunil,

could you indicate the IS version which you are using the the operatiing system?

hi khan,
IS version is 6.1

Have you installed the SP for IS and TN because it looks like the problem which was solved by IS fix TNS_6-1_Fix15 and TNConsole fix TNC_6-1_Fix13 but I believe if you install SP for IS and TN these fixes are included in them.

hi khan,
we installed those patches but still it is giving the same problem