SAP Knowledge Base Article - Preview

2480116 - CollaborationHandlerSO nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Symptom

In SAP Manufacturing Execution (ME) activities which trigger Collaboration events result in errors

  • Scenario 1:
    • When changing Shop Order status from 'Releaseable' to 'Closed' or 'Done' and Save,  error message shown:  'An internal error occurred; contact technical support'
    • Exceptions appear in Default Trace like:
      • System exception
        [EXCEPTION]
        javax.ejb.EJBTransactionRolledbackException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.collaboration.CollaborationHandlerSOBean.processMessage(com.sap.me.collaboration.CollaborationMessage) throws com.sap.me.collaboration.CollaborationException method on bean instance com.sap.me.collaboration.CollaborationHandlerSOBean@47afb4fd for bean sap.com/me~ear*xml|me.integration.collaboration.ejb-151.3.2.jar*xml|CollaborationHandlerSO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
        ...

 

  • Scenario 2:
    • Attempt to complete SFC in POD results in POD error:  Exception occurred while executing Complete (Activity ID PR510) (Message 11400)
    • Exceptions appear in Default Trace like:
      • System exception
        [EXCEPTION]
        javax.ejb.EJBTransactionRolledbackException: ASJ.ejb.005044 (Failed in component: sap.com/me~ear) Exception raised from invocation of public com.sap.me.frame.Data com.sap.me.collaboration.CollaborationHandlerSOBean.processMessage(com.sap.me.collaboration.CollaborationMessage) throws com.sap.me.collaboration.CollaborationException method on bean instance com.sap.me.collaboration.CollaborationHandlerSOBean@47afb4fd for bean sap.com/me~ear*xml|me.integration.collaboration.ejb-151.3.2.jar*xml|CollaborationHandlerSO in application sap.com/me~ear.; nested exception is: javax.ejb.EJBException: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
        ...

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Manufacturing Execution (ME)
  • SAP Manufacturing Execution Integration (MEINT)

Product

SAP Manufacturing Execution 15.0 ; SAP Manufacturing Execution 15.1 ; SAP Manufacturing Execution 6.1

Keywords

CollaborationSO,  MEINT CTC, MEINT Standard Interfaces , KBA , MFG-ME-MNT , Maintenance Activities , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.