17.7.3 Data Ingestion Query

You can query for the error logging schema using the Data Ingestion Query window. From the PMF pipeline execution log, you can retrieve the query and use it to fetch the final data used by Data Ingestion. The error records which are causing the failure if a connector during the Data Ingestion fails, or if the connector passes the error records are loaded to source error logging entity and target error entity. You can view the error records using the SQL prompt.

Data Ingestion Query Window is listed and available as a Data Set in your service instance. This is accessible via Data Sets on the Home portal. It is also accessible via Data - Data Sets navigation path. You can click the Prepare option and select the Edit Definition button to view the Data Ingestion Query window. Note that you may be taken to the Visualize option by default.

In the Results user interface navigate to Edit Definition to access the query window.

Note:

This function should only be used if data ingestion errors are encountered and the logged query requires to be analyzed, as instructed by Oracle Support.

Note:

When the data ingestion process run is successful, the PMF execution log final select query cannot be used for fetching data. You can use it only in case of a failure.