i Was getting this error in record sync
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
Discussion posts and replies are publicly visible
Batch your integration to sync at max 50k rows at a time in the record.
The error is with the Scheduler sync
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.
thank you harsha can you help me out with the difference between Scheduled Full Sync and Smart Service sync
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
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.
here the smart service sync in failing but we don't have any instance with the failed sync error
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.