Hi All,

I installed WM 6.1 with TN. I have configured the TN Pool Alias Definitions and tested the connection it is showing as success there.

But When I try to run the the TN Console the following error comes up:

Title:
wm.tn.route:init

Message:

Error encountered while reading processing rules from the database. The exception message is : [wm-cjdbc33-0069][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
.
(0) java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column
(1) java.sql.SQLException: [wm-cjdbc33-0069][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-0069][Oracle JDBC Driver][Oracle]ORA-01401: inserted value too large for column

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

java.sql.SQLException: [wm-cjdbc33-0069][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:587)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:229)
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:407)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:503)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:367)
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)

Any help to resolve this is highly appreciated.

Thanks,
Johnrose.

Hi John,

I think u installed database tables as an anouther version.Thats might be the reasion throws an error.

Regards,

Hello Smile,

Thanks for your reply Buddy. We fixed this issue. what we did was we did a clean install of everything from IS 6.1 SP2 to database scripts.

Luckily this resolved the error that I was facing.

Thanks.