My Oracle Support Banner

Error –CDM Job Failure Wf_SIL_CDM_W_CDM_CODE_REPOS_TYPE_D - Cannot Insert NULL Into "ENT" (Doc ID 2790369.1)

Last updated on JULY 13, 2021

Applies to:

Oracle Healthcare Foundation - Version 7.2.1.1 and later
Information in this document applies to any platform.

Symptoms

Oracle Healthcare Foundation - Version 7.2 and later

Production CDM load is stuck while loading W_CDM_CODE_REPOS_TYPE_D table and the following error occurs:

ERROR
-----------------------
Database driver error...
CMN_1022 [DECLARE TMP_REQUEST_ID NUMBER;
 
BEGIN SELECT ETL_PROC_WID INTO TMP_REQUEST_ID FROM CDM.C_LOAD_DATES_INFA WHERE ENTITY_NM= 'W_CDM_CODE_REPOS_TYPE_D';
 EXECUTE IMMEDIATE 'alter session set nls_date_format=''MM/DD/YYYY HH24:MI:SS''';
 CDM.ETL_DATA_INGESTION.ETL_STATUS_PROC('s_SIL_CDM_W_CDM_CODE_REPOS_TYPE_D','Cohort Datamart','Incremental','wf_SIL_CDM_W_CDM_CODE_REPOS_TYPE_D','RUNNING',
TMP_REQUEST_ID,SYSDATE,NULL,NULL,NULL,CDM.EXECUTION_SEQ.NEXTVAL,NULL,NULL,'<UserName>','<UserName>', NULL);
 END;

ORA-01400: cannot insert NULL into ("ENT"."ERR_LOG"."ERR_CD")
ORA-06512: at "ENT.ETL_DATA_INGESTION", line 399
ORA-12801: error signaled in parallel query server P002, instance <Server_Name>:<SID> (1)
ORA-01460: unimplemented or unreasonable conversion requested
ORA-06512: at "ENT.ETL_DATA_INGESTION", line 33
ORA-06512: at "ENT.ETL_DATA_INGESTION", line 177
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run CDM load
2. Error occurred while loading W_CDM_CODE_REPOS_TYPE_D table.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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