Qlik Replicate captures no Data after the Oracle Source has been upgraded to 4 Node RAC

[Bill_Steinagle]

The SCN value of the Qlik Replicate task is no longer valid after the Oracle environment upgrade as the SCN has changed.

Example:

Oracle was upgraded from a two-node RAC to a four-node RAC.

If the old SCN value is used during the restart of a Task, it will not capture changes. If SOURCE_CAPTURE is set to VERBOSE in the Qlik Replicate logs, you will see it log  No Data. 

Resolution

Before the upgrade: check the task log from the task being stopped for the Final saved task state.

The last source timestamp has the timestamp you can run on the Oracle Source using the Oracle function scn_to_timestamp using the value as shown from the last source timestamp (1667933318000000).

Final saved task state. Stream position 00000000.0117643d.00000001.0000.00.0000:181.137796.16, Source id 5406, next Target id 37, confirmed Target id 33, last source timestamp 1667933318000000

Select scn_to_timestamp(1667933318000000) as timestamp from dual:

TIMESTAMP

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

04-DEC-22 01:48:38

The timestamp returned can be used as the start option for the task doing an Advance Run Option start from timestamp. This will start processing from the Oracle environment from the time the Task stopped and restarts reading from the saved timestamp prior to the upgrade.