error with sync record

Question

i Was getting this error in record sync

Alert

Details

Could not sync because too many rows were updated in the source at the same time. To prevent this from occurring, limit the associated smart service or integration to not update more than 50,000 rows at a time.

Process Name: [Not Available] Modified Source Rows By Primary Key: 49814, 49815, 49816, 49817, 49818 and mo

Stefan Helzle · Answer

OK. Do you have any specific question?

Harsha Sharma · Answer

Batch your integration to sync at max 50k rows at a time in the record.

Shubham Aware · Answer

thammireddybinduniharika said: To prevent this from occurring, limit the associated smart service or integration to not update more than 50,000 rows at a time. 
 Appian already suggested this. But i would recommend, Add Source Filter now for quick relief - it excludes irrelevant source rows from sync, reducing deltas and avoiding the 50k update error.

Harsha Sharma · Answer

Scheduler sync can be full or incremental depending on the frequency of changes in external system. Recommendation is to do full sync once a day or week during non peak work hours or have regular incremental syncs throughout the day. Depending on your case I suggest you to explore if incremental syncs can help your case better. Though, You need to have a field to determine latest data that Appian will sync into Appian. 
 Also suggest you to look at Rate Limit and configure it appropriately to handle full syncs better.

Shubham Aware · Answer

Appian has a 50K row update limit during schedule sync, causing your scheduler to fail. Add a source filter to narrow data below 50K rows; this resolves it immediately and prevents future issues.

Shubham Aware · Answer

Scheduled Full Sync runs daily (configurable time) to replace all synced data with current source snapshot - ideal for complete refreshes outside peak hours. 
 Smart Service Sync (e.g., a!syncRecords() or auto from a!writeRecords()) syncs specific rows (by PKs) on-demand or in processes for real-time/incremental updates. Batch the source updater + Source Filter for ongoing Smart Service syncs

Harsha Sharma · Answer

Scheduled sync syncs the record type at specified scheduled time regularly. Its a repeated sync to synchronise the record data with source automatically at scheduled time. 
 Smart service can sync records from a process model and so when process runs and reaches the node record data is synchronized. As minimum as 1 record (as per primary key) or multiple records can be updated using this smart service. 
 Scheduled (Full/Incremental) sync is configured for regular record sync while smart service is configured for on demand/on action record data sync.

Harsha Sharma · Answer

Identify any expression where a!syncecords() smart service function might be used instead of having process model with sync records smart service node. This smart service can sync 1000 records at a time so find where you might be using this and then investigate on the cause behind the failure.

Harsha Sharma · Answer

thammireddybinduniharika said: an error appears in the Sync History when the user initiates batch syncing from the front-end UI 
 Can you provide more details on how the user is initiating batch syncing from front-end UI - are you using a!syncRecords() in an interface and that is failing ?