Oracle error in BusinessConnect EDI Protocol:ORA-00942: table or view does not exist.

Products	Versions
TIBCO BusinessConnect EDI Protocol Powered by Instream	-
Not Applicable	-

Description

Description:
The following error:

ORA-00942: table or view does not exist

appears in the Interior Server log when BusinessConnect processes an EDI transaction:

2015 Aug 31 06:50:44:142 GMT -0700 BW.BusinessConnect-Interior_Server Info [bw.logger] BW-EXT-LOG-300000 EDI OverdueAckChecker Starts ...

2015 Aug 31 06:50:44:176 GMT -0700 BW.BusinessConnect-Interior_Server Error [bw.logger] BW-EXT-LOG-100000 Error occurs while checking Overdue Acknowlegements Records. Exception: Error executing transaction.: ORA-00942: table or view does not exist

at com.tibco.ax.tibedi.runtime.pf.alert.OverdueAckAlert.getOverdueAcks(OverdueAckAlert.java:66)

at com.tibco.ax.tibedi.runtime.pf.alert.OverdueAckAlert.Start(OverdueAckAlert.java:39)

at com.tibco.ax.tibedi.ack.OverdueAckHandler.handleOverdueAck(OverdueAckHandler.java:96)

at com.tibco.ax.tibedi.runtime.EDIBootStrapExtension.processMiscMessage(EDIBootStrapExtension.java:1224)

at com.tibco.ax.fw.runtime.transport.interComponent.InterCompCommunicator.sForwardMsg(InterCompCommunicator.java:456)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.tibco.ae.processapi.ui.javachooser.JavaClassMethodUtility.invokeMethod(Unknown Source)

at com.tibco.plugin.java.JavaMethodActivity.for(Unknown Source)

at com.tibco.plugin.java.JavaMethodActivity.eval(Unknown Source)

at com.tibco.pe.plugin.Activity.eval(Unknown Source)

at com.tibco.pe.core.TaskImpl.eval(Unknown Source)

at com.tibco.pe.core.Job.a(Unknown Source)

at com.tibco.pe.core.Job.k(Unknown Source)

at com.tibco.pe.core.JobDispatcher$JobCourier.a(Unknown Source)

at com.tibco.pe.core.JobDispatcher$JobCourier.run(Unknown Source)

Subexception stack trace follows:

Error executing transaction.: ORA-00942: table or view does not exist

Issue/Introduction

Oracle error in BusinessConnect EDI Protocol:ORA-00942: table or view does not exist.

Resolution

This error occurs when the BusinessConnect EDI protocol-related tables are not created in the database. To correct this error use the procedure outlined below.

NOTE: This procedure should only be used by users familiar with BC operating processes, DB queries against BC tables and the composition of Java JAR files. If you are not sure of any of the details below, open an SR and have a BusinessConnect Support Engineer assist you with this procedure in your environment.

To manually create these tables, run the Oracle-tibcobc-edi.sql scripts file. You can find this file by opening the $BC_HOME/protocols/tibedi/lib/tibedi.jar file with an uncompress program and then find the scripts under location com.tibco.ax.tibedi.resource.ddl in the JAR file. Once you have executed the script and verified that the tables are created, activate the EDI protocol from the Administrator>BusinessConnect>Manage Installation button>Protocols and Plugins Activation tab.

Additional Information

No reference

Welcome to "KB Articles"