Error encountered while reading processing rules from the database

Hi All,

I am getting the below error when i start the IS server.

" 2006-04-19 12:08:55 CDT [ISU.0000.9999D] TRANET: Loading system configuration
2006-04-19 12:09:08 CDT [ISU.0000.9999C] Error encountered while reading processing rules from the database. The exception message is : [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
. [TRNSERV.000014.000148]
2006-04-19 12:09:08 CDT [ISU.0000.9999C] java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
2006-04-19 12:09:08 CDT [ISU.0000.9999C] Error(s) encountered in WmTN initialization:

wm.tn.route:init

com.wm.app.tn.route.RoutingException
Error encountered while reading processing rules from the database. The exception message is : [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
.
(0) java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
(1) java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
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.executeQueryInternal(Unknown Source)
at com.wm.dd.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at com.wm.app.tn.db.RROperations.getChangeId(RROperations.java:529)
at com.wm.app.tn.db.RROperations.loadAll(RROperations.java:364)
at com.wm.app.tn.route.RoutingRuleStore.load(RoutingRuleStore.java:173)
at wm.tn.route.init(route.java:55)
at wm.tn.adminimpl.startup(adminimpl.java:742)
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)
"

Its says table or view does not exist, but i am not able to figure out exactly which table is missing.
We have upgraded to 6.5 from 6.0.1. I have already executed all the Db scripts required fo TN upgrade.

is this related to the WMRepository2 , as i had cleaned it up while migrating and then executed all the upgrade DB scripts.

Please let me know.

Thanks,
Amey

Amey,

Looks like TN DB scripts are not successfully executed,so try dropping all the tables and re-run the scripts.Also create JDBC pools connections for TN and test it make sure the TN connection to DB is ok.Finally restart IS/TN.

HTH,
RMG

“…is this related to the WMRepository2”

Nope.