[CDC] Get Processing Range error Timeout

Get Processing Range error Timeout

Reason:

It's because you have a CDC transaction not committed yet.

Solution:

DBCC OPENTRAN

Find out the active sessions running the program: MSXDBCDC$OracleCDCService1$xxxxYourCDC Database

Kill the sessions
Rerun the Initial Load for "Mark Initial Load Start" and "Mark initial load end"
Fixed.