Start a conversation
  1. Pivotal Support
  2. Pivotal Articles
  3. Articles

Resolving RDF File Restoration Issues with Pivotal SyncStream on Windows Server 2022

Overview

The error "unable to update the shadow tablesSELECT Tables_Id, Table_Name FROM Rsys_Tables" occurs when attempting to restore RDF files using Pivotal SyncStream on Windows Server 2022. This issue is linked to a Microsoft update (KB5062572) that affects database operations. The problem can be resolved by uninstalling the update or modifying the registry to disable bulk copy operations.

Information

Error Message: "unable to update the shadow tablesSELECT Tables_Id, Table_Name FROM Rsys_Tables"

Cause: The issue is caused by a Microsoft update (KB5062572) that affects the functionality of Pivotal SyncStream on Windows Server 2022, leading to failures in database operations such as updating shadow tables.

Resolution Steps

  1. Uninstall Microsoft Update:
    • Navigate to Control Panel → Programs → View installed updates.
    • Locate "2025-07 Cumulative Update for Microsoft server operating system version 21H2 for x64-based Systems (KB5062572)".
    • Select the update and click "Uninstall".
    • Restart the server to complete the uninstallation process.
  2. [Optional] Modify Registry to Disable Bulk Copy:
    • Open the Registry Editor (regedit).
    • Navigate to HKEY_CURRENT_USER\Software\Pivotal\Relationship.
    • Create a new DWORD (32-bit) Value named "DisableBCP".
    • Set the value of "DisableBCP" to 1.
    • Restart the server to apply changes.
  3. Verify Resolution:
    • Attempt to restore RDF files using Pivotal SyncStream.
    • Confirm that the error message no longer appears and the restore process completes successfully.

Note: Use the DisableBCP registry key with caution, as it may affect other functionalities within the Pivotal Admin Console.

Frequently Asked Questions

How do I identify if this error applies to my situation?
You will encounter the error message "unable to update the shadow tablesSELECT Tables_Id, Table_Name FROM Rsys_Tables" when attempting to restore RDF files using Pivotal SyncStream on Windows Server 2022.
What should I do if uninstalling the update doesn't resolve the issue?
If uninstalling the update does not resolve the issue, try setting the DisableBCP registry key to 1 as an alternative solution.
Are there any known side effects of using the DisableBCP registry key?
Using the DisableBCP registry key may cause issues with the Pivotal Admin Console, such as connectivity problems. It is recommended to use this solution with caution.
How can I ensure I have the correct ODBC driver version?
Verify the ODBC driver version through the ODBC Data Source Administrator and ensure it matches the version required by your Pivotal setup. Discrepancies in driver versions can lead to connectivity issues.
Choose files or drag and drop files
ai_initiated
atlas_studio
kb_automation
Was this article helpful?
Yes
No

  1. Priyanka Bhotika

  2. Posted

Comments