AnsweredAssumed Answered

Load DataWarehouse Job Fails

Question asked by prakashsinghoec on Jan 19, 2017
Latest reply on Jan 24, 2017 by prakashsinghoec
Branched from an earlier discussion

hi,

 

i am using everything in upper case but still getting the same issue.

Could you please let me know why i am getting error here.

---------------------------------------

SELECT @SELECT:INV.MANAGER_ID:MANAGERID@,
@SELECT:SRM.FULL_NAME:MANAGER_NAME@,
@SELECT:INV.LAST_UPDATED_BY:LAST_UPDATED_BY@,
@SELECT:INV.LAST_UPDATED_DATE:LAST_UPDATED_DATE@


FROM
INV_INVESTMENTS INV, INV_PROJECTS PRJ,SRM_RESOURCES SRM
WHERE
@WHERE:SECURITY:PROJECT:INV.ID@
AND INV.ID=PRJ.PRID
AND SRM.USER_ID=INV.MANAGER_ID
AND PRJ.IS_TEMPLATE=0
AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)
AND INV.ID= @WHERE:PARAM:USER_DEF:INTEGER:ID@
AND
@FILTER@
@BROWSE-ONLY:AND INV.is_active=1:BROWSE-ONLY@

--------------------------------------------------------

 

Error message:- 

 

---------------------------------------------------------

 

ClarityDB - isOracle? - An error occurred executing this job entry :  Couldn't execute SQL: MERGE INTO DWH_LKP_JS_GIV_MANAGER1 TGT USING       (            select LAST_UPDATED_DATE as CLARITY_UPDATED_DATE, MANAGERID as JS_GIV_MANAGER1_KEY, MANAGER_NAME as JS_GIV_MANAGER1, to_date('2017/01/19 16:22:49', 'yyyy/mm/dd HH24:MI:SS') as dw_updated_date  from DWH_LKP_JS_GIV_MANAGER1_V@MUN580TDWH_MUN580T where 1=1 AND LAST_UPDATED_DATE >= to_date('2017/01/15 12:25:47', 'yyyy/MM/dd HH24:mi:ss')       ) SRC ON       (           SRC.JS_GIV_MANAGER1_KEY = TGT.JS_GIV_MANAGER1_KEY       ) WHEN MATCHED THEN      UPDATE SET TGT.CLARITY_UPDATED_DATE = SRC.CLARITY_UPDATED_DATE, TGT.JS_GIV_MANAGER1 = SRC.JS_GIV_MANAGER1, TGT.dw_updated_date = SRC.dw_updated_date  WHEN NOT MATCHED THEN      INSERT (CLARITY_UPDATED_DATE, JS_GIV_MANAGER1_KEY, JS_GIV_MANAGER1, dw_updated_date)      VALUES (SRC.CLARITY_UPDATED_DATE, SRC.JS_GIV_MANAGER1_KEY, SRC.JS_GIV_MANAGER1, SRC.dw_updated_date)  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30926: unable to get a stable set of 

Outcomes