Error encountered while reading routing status from the database


Hello,

I got following error while executing the step, wm.tn.route:routeBizdoc > wm.tn.doc:isRoutable
[TNS.0000.2199C] Error encountered while reading routing status from the database. The exception message is : [wm-cjdbc36-0007][Oracle J
DBC Driver][Oracle]ORA-00942: table or view does not exist.
What table didn’t I install?
Please advise. Thanks in advance.


- IS version: 7.1.2.0
- JVM: Sun Microsystems 1.5.0_15 (49.0)
- OS: Windows XP
- Updates: TNS_7-1-2_DB_Fix2, TNS_7-1-2_Partner_Fix1

Here is detail log.
wm.tn.doc:recognize
2011-09-19 17:17:56 KST [TNS.0001.2030D] BizDocTypeReg: recognize and create starting
2011-09-19 17:17:56 KST [TNS.0001.2023D] BizDocTypeReg: recognizing pipeline
2011-09-19 17:17:56 KST [TNS.0001.2005D] BizDocTypeReg: pipeline will be a com.wm.app.tn.doc.XMLDocType

2011-09-19 17:17:56 KST [TNS.0001.2010T] Recognize: trying XML doctype ORDERS
2011-09-19 17:17:56 KST [TNS.0001.2055T] Recognize: XML DOCTYPE ORDERS == CustomXML
2011-09-19 17:17:56 KST [TNS.0001.2013T] Recognize: /CustomXML[0]/MessageHeader[0]/DocumentType[0] == ORDERS
2011-09-19 17:17:56 KST [TNS.0001.2013T] Recognize: /CustomXML[0]/MessageHeader[0]/SenderID[0] == H04
2011-09-19 17:17:56 KST [TNS.0001.2001D] New doc is a ORDERS

2011-09-19 17:17:56 KST [TNS.0001.2038T] XMLDocType ORDERS: Creating document from IData
2011-09-19 17:17:56 KST [TNS.0001.2034T] Setting envelope attribute for ORDERS:DocumentID = 20110919171716660
2011-09-19 17:17:56 KST [TNS.0001.4004D] Got PID: 50kr8u005rftoivd0000000a for H04(99)
2011-09-19 17:17:56 KST [TNS.0001.2034T] Setting envelope attribute for ORDERS:SenderID = 50kr8u005rftoivd0000000a
2011-09-19 17:17:56 KST [TNS.0001.4004D] Got PID: 50kr8u005rfu3pbh0000000c for HMI(99)
2011-09-19 17:17:56 KST [TNS.0001.2034T] Setting envelope attribute for ORDERS:ReceiverID = 50kr8u005rfu3pbh0000000c
wm.tn.doc:persist
2011-09-19 17:20:24 KST [TNS.0000.2073I] Inserting doc 0fup01006a0c6kd60000002tinto datastore
2011-09-19 17:20:24 KST [TNS.0000.2191T] Inserting attributes for doc 0fup01006a0c6kd60000002t
2011-09-19 17:20:24 KST [TNS.0000.3006D] No errors to insert for doc 0fup01006a0c6kd60000002t
2011-09-19 17:20:24 KST [TNS.0000.2010D] Inserting content for doc 0fup01006a0c6kd60000002t
2011-09-19 17:20:24 KST [TNS.0000.2030T] Doc 0fup01006a0c6kd60000002t has 1953 bytes of content
2011-09-19 17:20:24 KST [TNS.0002.1082T] Document persisted
2011-09-19 17:20:24 KST [TNS.0000.2024T] No relationships on doc 0fup01006a0c6kd60000002t
2011-09-19 17:20:24 KST [TNS.0000.3003D] Document 0fup01006a0c6kd60000002t (from 50kr8u005rftoivd0000000a) persisted
2011-09-19 17:20:37 KST [TNS.0005.5077T] TN Task Manager processing active jobs.
wm.tn.route:routeBizdoc
2011-09-19 17:22:06 KST [TNS.0005.4044D] Processing document 0fup01006a0c6kd60000002t

2011-09-19 17:22:06 KST [TNS.0005.4042D] Checking processing rule Vaatz ORDERS
2011-09-19 17:22:06 KST [TNS.0005.4016T] Vaatz ORDERS: passed on Errors
2011-09-19 17:22:06 KST [TNS.0005.4016T] Vaatz ORDERS: passed on ReceiverID
2011-09-19 17:22:06 KST [TNS.0005.4016T] Vaatz ORDERS: passed on TypeID
2011-09-19 17:22:06 KST [TNS.0005.4016T] Vaatz ORDERS: passed on UserStatus
2011-09-19 17:22:06 KST [TNS.0005.4091D] Vaatz ORDERS matched!
2011-09-19 17:22:06 KST [TNS.0002.1082T] Routing rule Vaatz ORDERS selected
2011-09-19 17:23:31 KST [TNS.0000.2105D] Changing status on doc 0fup01006a0c6kd60000002t
2011-09-19 17:23:31 KST [TNS.0000.2019D] System status for 0fup01006a0c6kd60000002t ==> NOT ROUTED
2011-09-19 17:23:31 KST [TNS.0000.2198D] Loading routing statuses from database
2011-09-19 17:23:31 KST [TNS.0000.2199C] Error encountered while reading routing status from the database. The exception message is : [wm-cjdbc36-0007][Oracle J
DBC Driver][Oracle]ORA-00942: table or view does not exist.
2011-09-19 17:23:31 KST [ISU.0000.9999C] java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Make sure all the required TN tables got created esp Bizdoc table:

Also are you able to login TNC fine?

HTH,
RMG

yes, all bizdoc related tables(BIZDOC, BIZDOCARRAYATTRIBUTE, BIZDOCATTRIBUTE, BIZDOCATTRIBUTEDEF, BIZDOCCONTENT, BIZDOCRELATIONSHIP,BIZDOCTYPEATTRIBUTE, BIZDOCTYPEDEF,BIZDOCUNIQUEKEYS) were created and data inserted into BIZDOC when document persisted. I’m also able to login TNC without any error.

Hello,

Install all the scripts of Trading Networks once again, keeping IS down, by selecting Trading Networks from drop down, in Database Configurator.

Also check your JDBC pools.

I am checking more into this issue. Will keep you posted.

Suvigya

Thanks, Suvigya.
I believe that it will work if I reinstall TN DB scripts.
However, I just wonder what table is accessed when wm.tn.doc:isRoutable service is executing.

Also please check this thread if applicable:

http://advantage.webmethods.com/article/?id=SR-1-56855926