ECC Full Load for Dataset oks-contract Errors with java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_HAS_FAILED_CHECK_LOG_FILE": invalid identifier (Doc ID 3018573.1)

Last updated on APRIL 23, 2024

Applies to:

Symptoms

When attempting to run ECC Full Load for dataset oks-contract,
the following error is shown in the log file:

ERROR
-----------------------
22:23:08.101 [pool-5-thread-4] ERROR 8.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule oks_ecc_util_pvt.get_ecc_data_load_info with dataset oks-contract for job 80,444
java.sql.SQLSyntaxErrorException: ORA-00904: "VIEW_HAS_FAILED_CHECK_LOG_FILE": invalid identifier

The output file shows:
15:56:46.941 [pool-5-thread-2] ERROR 8.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is an error while trying to ingest data for this load rule oks_ecc_util_pvt.GET_DESC_METADATA_LOAD_INFO with dataset oks-contract for job 86,361
oracle.ecc.exeption.ImportMetadataException: Dataset attributes doesn't have one of the attribute keys targetAttribute: OKS_CL_VST_PRODUCT_TYPEand trigger attribute: OKS_CL_VIEW_HAS_FAILED_CHECK_LOG_FILE


The issue can be reproduced at will with the following steps:
1. Using ECC Developer or service contract manager responsibility, run Full Load for dataset oks-contract.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.