Masking ADM Shows JBO-27122 Error and when Clicking On Action button in ADM most Options Are Greyed Out (Doc ID 3015287.1)

Last updated on JUNE 16, 2024

Applies to:

Symptoms

Executing "emcli verify_adm" multiple times is inserting multiple rows into db_ddrm_job_info and results in ADM corruption.

We receive the following error JBO when clicking on Masking ADM.

Error :

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT UNIQUE

C.DDRM_ID AS DDRM_ID, 
C.DDRM_REF_TGT_ID AS DDRM_REF_TGT_ID,
(SELECT TARGET_NAME FROM MGMT_TARGETS WHERE MGMT_TARGETS.TARGET_GUID=C.DDRM_REF_TGT_ID) AS TARGET_NAME,
(SELECT TARGET_TYPE FROM MGMT_TARGETS WHERE MGMT_TARGETS.TARGET_GUID=C.DDRM_REF_TGT_ID) AS TARGET_TYPE,
(SELECT DECODE(DDRM_SRC_TGT_ID, C.DDRM_REF_TGT_ID, 'Y', 'N') "DEFAULT" FROM DB_DDRM_DEFS WHERE DDRM_ID=C.DDRM_ID) AS ADM_DEFAULT,
(SELECT STATUS FROM DB_DDRM_JOB_INFO WHERE JOB_TYPE IN (1,2) AND DDRM_ID=C.DDRM_ID AND TARGET_GUID=C.DDRM_REF_TGT_ID) AS ADM_STATUS,
(SELECT FLAGS FROM DB_DDRM_DEFS WHERE DDRM_ID=C.DDRM_ID AND DDRM_SRC_TGT_ID=C.DDRM_REF_TGT_ID) AS SRC_STATUS,
(SELECT H.STATUS_INTERNAL FROM DB_DDRM_JOB_INFO V, MGMT$JOB_EXECUTION_HISTORY H WHERE V.JOB_TYPE IN (1,2) AND V.DDRM_ID=C.DDRM_ID AND V.TARGET_GUID=C.DDRM_REF_TGT_ID AND V.JOB_ID=H.JOB_ID AND V.EXECUTION_ID=H.EXECUTION_ID) AS JOB_STATUS,
(SELECT H.END_TIME FROM DB_DDRM_JOB_INFO V, MGMT$JOB_EXECUTION_HISTORY H WHERE V.JOB_TYPE IN (1,2) AND V.DDRM_ID=C.DDRM_ID AND V.TARGET_GUID=C.DDRM_REF_TGT_ID AND V.JOB_ID=H.JOB_ID AND V.EXECUTION_ID=H.EXECUTION_ID) AS JOB_END_TIME,
(SELECT JOB_ID FROM DB_DDRM_JOB_INFO WHERE JOB_TYPE IN (1,2) AND DDRM_ID=C.DDRM_ID AND TARGET_GUID=C.DDRM_REF_TGT_ID) AS JOB_ID,
(SELECT EXECUTION_ID FROM DB_DDRM_JOB_INFO WHERE JOB_TYPE IN (1,2) AND DDRM_ID=C.DDRM_ID AND TARGET_GUID=C.DDRM_REF_TGT_ID) AS EXECUTION_ID,
(SELECT APPSUITE_NAME FROM DB_DDRM_DEFS WHERE DDRM_ID=C.DDRM_ID) AS APPSUITE_NAME,
(SELECT OPS_NAME FROM DB_DDRM_DEFS WHERE DDRM_ID=C.DDRM_ID) AS OPS_NAME,
(SELECT DDRM_GUID FROM DB_DDRM_DEFS WHERE DDRM_ID=C.DDRM_ID) AS DDRM_GUID
FROM DB_DDRM_TGT_ASSOCS C
WHERE C.DDRM_REF_TGT_ID IN (SELECT SOURCE_ME_GUID FROM GC$ASSOC_INST_WITH_INVERSE WHERE SOURCE_ME_GUID IN (SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_TYPE='oracle_pdb') AND DEST_ME_GUID IN (SELECT TARGET_GUID FROM GC_LICENSED_TARGETS WHERE PACK_NAME IN ('db_mas','db_lifecycle_mgmt')) UNION SELECT TARGET_GUID FROM GC_LICENSED_TARGETS WHERE PACK_NAME IN ('db_mas','db_lifecycle_mgmt') AND TARGET_GUID NOT IN ( SELECT t.target_guid FROM mgmt_targets t, mgmt_target_properties c WHERE C.property_name = 'CDB' AND c.target_guid = t.target_guid AND c.property_value = 'YES'))) QRSLT WHERE DDRM_ID = :Bind_DdrmId ORDER BY TARGET_NAME
javax.el.ELException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT UNIQUE
C.DDRM_ID AS DDRM_ID, ..........

Also when clicking "Action" button on Application Data Modeling we got pull down is greyed out. 

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.