Resolving Synchronization Failures in ConnectAll On-Prem

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

This article outlines the recommended procedures for resolving synchronization failures in ConnectAll On-Prem when bulk records fail to sync.

Environment

• ConnectAll On-Prem
• Database management tool (e.g., pgAdmin, DBeaver)

Resolution

Method 1: Retry via Dashboard

For individual or small numbers of failed items, use the dashboard functionality:

1. Navigate to the Related Artifacts section of the dashboard.
2. Locate the failed synchronization items.
3. Select the checkbox next to the failed items.
4. Click Retry.

Method 2: Bulk Retry via Database

When a large volume of records requires a retry, perform the following database operation:

1. Export the failed records from the Related Artifacts section.

2. Filter the list to include only the records you wish to retry.

3. Extract the ca_id values from the exported file.

4. Create a comma-separated string of the ca_id values (e.g., ####, ####, ####).

5. Open your database administration tool (e.g., pgAdmin or DBeaver).

6. Execute the following SQL command, replacing the empty parentheses with your comma-separated list of IDs:

   sql

    

   -- ⚠️ IMPORTANT: Always test queries first in a non-production environment. Take a backup before implementing in production.
   
   UPDATE record_map SET last_sync_error = 'Retry' WHERE ca_id IN (####, ####, ####);

7. The records will be queued for retry during the next scheduled automation run.