SAP Knowledge Base Article - Preview

2528125 - Database error connecting to tables that exist in DQ_SAP_DS datastore - DQM for SAP

Symptom

  • ORA-00942: table or view does not exist
  • Product version report
  • Batch match job fails to start
  • Job Job_Realtime_DQ_SAP_Product_Version_Report fails when running in designer
  • Job Job_Realtime_Batch_DQ_SAP_Name_And_Address_Match
  • Service_Realtime_DQ_SAP_Product_Version_Report fails to start as a real-time service

  • (14.2) 08-15-17 12:20:22 (E) (53036:648955680) DBS-070300: |Session Job_Realtime_DQ_SAP_Product_Version|Data flow DF_Realtime_DQ_SAP_Product_Version|Reader DQ_SAP_PRODUCT_VERSION SQL submitted to Oracle Server <server_name> resulted in error <ORA-00942: table or view does not exist>. The SQL submitted is <SELECT "PROD_NAME", "PROD_RELEASE", "EXTRELEASE", "DESCRIPTION" FROM "username"."DQ_SAP_PRODUCT_VERSION">.


Read more...

Environment

Data Quality Management for SAP, Data Services connection

Product

SAP Data Quality Management, version for SAP solutions all versions

Keywords

DQM, DS, DQ, real time, empty, FLDQ, /FLDQ/RSPRODVER, realtime , KBA , EIM-DQM-SAP , Data Quality Management for SAP , 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.