1. Create a Dynamic Query based test lookup with the below query.
SELECT
@SELECT:TE.PRID:
[email protected],
@SELECT:SUBSTR(TSK.PRNAME,1,30):
[email protected],
@SELECT:SUBSTR(TSK.PRNAME,1,30):
[email protected],
@SELECT:LANG.LANGUAGE_CODE:
[email protected],
@SELECT:LANG.ID:
[email protected]FROM PRTIMESHEET TS, PRTIMEENTRY TE, PRASSIGNMENT ASSG, PRTASK TSK, CMN_LANGUAGES LANG
WHERE TS.PRID = @WHERE:PARAM:USER_DEF:INTEGER:
[email protected]AND TS.PRID = TE.PRTIMESHEETID
AND TE.PRASSIGNMENTID = ASSG.PRID
AND TSK.PRID = ASSG.PRTASKID
AND LANG.LANGUAGE_CODE = 'en'
AND @
[email protected]Query Reference 2. Navigate to Administration -> Project Management -> Timesheet Options
3. Modify the Value of "User Value 1 Lookup" from the default "Time Entry User Lookup Field 1" to the newly created "Test Lookup".
4. Run Load DatawareHouse Full Load.
Expected Results: Job Completes without issues.
Actual Results: Load DWH job starts failing with error [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30926: unable to get a stable set of rows in the source tables While merging DWH_META_COLUMNS