# Troubleshooting Tips for CDC for Oracle on SQL Server

### Get Processing Range error Timeout

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

Solution:  
Run `DBCC OPENTRAN`  
Identify the active sessions running the program: `MSXDBCDC$OracleCDCService1$xxxxYourCDC Database`  
  
End the sessions  
Rerun the Initial Load for "**Mark Initial Load Start**" and "**Mark Initial Load End**"

### Error - LoadLibraryFromPath: The fully qualified DLL C:\\Windows\\oci.dll was not found.

Reason:

One of our SSIS projects repeatedly encountered the error mentioned in the subject.  
  
Solution:  
I checked the package and found it still uses the old Microsoft OLEDB driver for Oracle. A Windows Update mentioned in the link below has been installed on the server.  
[https://support.microsoft.com/en-us/kb/3147071](https://support.microsoft.com/en-us/kb/3147071)

### Could not find sys.sp\_cdc\_parse\_captured\_column\_list

Upgrade CDC for Oracle version

### Why does the component work, but I don't receive the latest data?

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1740933883376/f53e807d-a02d-4202-a6c3-4ab866f0be40.png align="center")

The dates do not match. Why? I'm not sure. I just migrated Oracle to another server, keeping the same server name and configuration. The only change was the **IP address**.

After I queried the table "`[cdc].[xdbcdc_staged_transactions]`" and compared it with the GUI, I found that the log had stopped at a certain transaction and was not progressing further.

![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVV36UU80Ijb-Zsx-gBNoQ0pOe820OmybJ7pjuc02WMSqWClDVLPwXfhCb5hA48ACOJ1Zp_VNzN4fmxrFV8Btb5sytCUZ047tHgzm-VP1wLPDzbheYaNLjdtlM5BwG_znkzyOnEj-siHA/s1600/2016-02-02_11-26-28.png align="left")

So, I executed the command to check for any non-distributed transactions:

```sql
DBCC OPENTRAN
```

![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibRkBwk3u6Ojl3ZH-iEcs6rQDuRwc4NpZy_UxAh3kg5nu_mrYdCt0d2km46553ejIefXXLod7ZnpracSVCOxZViWdJ9lC0vXEEvsoCQMXKW2lu5KpyuPdG9dgC4j9wl8EfMWEk-XlM0vM/s1600/2016-02-02_11-26-28.png align="left")

It requires a manual commit with command like

```sql
EXEC sp_repltrans
```

Microsoft has a solution for this.

<div data-node-type="callout">
<div data-node-type="callout-emoji">💡</div>
<div data-node-type="callout-text">Once you reset, the data in the system cdc table <code>cdc.cdctable_CT</code> will be truncated</div>
</div>