Clarity

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

I see the error ORA-02019: connection description for remote database not found. 

Does your DB link and DWH works 

ERROR 2017-08-07 04:00:37,890 [ETL_JOB_META_LOAD UUID: c4fcafe3-b344-41a2-a0d3-e61309fe2621] dwh.event 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: connection description for remote database not found

Hello Suman,

Yes the Error is specific to only one environment and DB and DWH Links are working. This is an OnDemand Environment. 

Can you suggest anyway to trouble shoot?

Thanks and Regards,

Sai.

And one more thing is... could you please tell how DB and DWH are connected? where is that  we point out DB to DWH. so that we can check if the link is damaged there.

Please open a case and we need to check. To run the DWH job PPM and DWH schema needs to be connected via DB link 

Regards

Suman Pramanik 

Sure.. I submitted it