SAP Knowledge Base Article - Preview

3659081 - The processing has failed due to error in creating metadata table. : java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Symptom

An error prompt at JDBC receiver adapter when attempting to insert data into a database "com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: The processing has failed due to error in creating metadata table. : java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist". 


Read more...

Environment

  • SAP Integration Suite
  • SAP Cloud Integration

Product

Cloud Integration 4.0

Keywords

jdbc adapter, sap cloud integration, peoplesoft, ora-00942, table or view does not exist, fdspprd.ps_dpsp_ret_arqemb, database privileges, direct grants, schema prefix, public synonyms, integration flow error, com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: The processing has failed due to error in creating metadata table. : java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist", cpi. , KBA , LOD-HCI-PI-CON-JDBC , JDBC Adapter , Problem

About this page

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

Search for additional results

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