AnsweredAssumed Answered

Load Dataware House Job Failing with Couldn't execute SQL: UPDATE DWH_META_COLUMNS SET COL_MODIFIED = 1 WHERE (DWH_TABLE,DWH_COLUMN)

Question asked by Sai95 on Mar 21, 2018
Latest reply on Mar 21, 2018 by Sai95

Hello,

The Load Dataware house job is failing with the following error.

Attached is the DWH Log file generated. Any help would be appreciated.



dwh_db_check_ - An error occurred executing this job entry :  Couldn't execute SQL: UPDATE DWH_META_COLUMNS SET COL_MODIFIED = 1 WHERE (DWH_TABLE,DWH_COLUMN) IN       (      SELECT     META_TGT_TAB_NAME,     META_TGT_COL_NAME      FROM           (SELECT                UPPER(A.DWH_TABLE_NAME) META_TGT_TAB_NAME,                 UPPER(A.DWH_COLUMN_NAME) META_TGT_COL_NAME,                UPPER(A.ATTR_DATA_TYPE) META_TGT_DATA_TYPE,                A.ATTR_DATA_SIZE META_TGT_DATA_SIZE,                B.DWH_TABLE,                B.DWH_COLUMN,                B.ATTRIBUTE_DATA_TYPE DWH_DATATYPE,                SUBSTR(B.ATTRIBUTE_DATA_TYPE, INSTR(B.ATTRIBUTE_DATA_TYPE,'(', 1)+1,INSTR(B.ATTRIBUTE_DATA_TYPE,')',1)-(INSTR(B.ATTRIBUTE_DATA_TYPE,'(', 1)+1)) DWH_DATA_SIZE           FROM                DWH_META_COLUMNS@SC51339gDWH_SC51339g A INNER JOIN DWH_META_COLUMNS B           ON                UPPER(A.DWH_TABLE_NAME) = B.DWH_TABLE AND UPPER(A.DWH_COLUMN_NAME) = B.DWH_COLUMN           WHERE                 UPPER(A.ATTR_DATA_TYPE) LIKE '%VARCHAR%' AND UPPER(A.ATTR_TYPE) <> 'CLOB')   WHERE META_TGT_DATA_SIZE<>DWH_DATA_SIZE)  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-02019: co

Attachments

Outcomes