Error adding SIDs during SIDHistory migration for 'CN=####' (SQL ID: ####). The remote procedure call failed and did not execute.
Check the communication between Domain controllers and the Application servers and follow the documentation about the ports that needs to be open in the Firewall.

Please review the product documentation requirements for specific scenarios, such as the Directory Sync Pro profile with SID History Synchronization selected.
https://support.quest.com/technical-documents/directory-sync-pro-for-active-directory/20.11.4/installation-guide/4#TOPIC-2320280
Also, identify if the Windows dynamic RPC port ranges are opened dynamically.
49152-65535 are the dynamic port ranges - the firewall should allow communication between source/target DCs on these ports. The port scanner known as "NMAP" can assist you in detecting if the port is opened. Dynamic ports open upon request.