Sync Fail while writing for more than 1000 Rows.

Process data in batches: https://docs.appian.com/suite/help/24.1/Records_Monitoring_Details.html

Enable 'Keep data available at high volumes' sync :  https://docs.appian.com/suite/help/24.1/records-data-sync.html

It worked for me.

Curious!! Why 1000 limitation only by default?

Would you mind explaining to me how the option "Keep data available at high volumes" relates to the 1k limit for syncing?

Yeah Stefan Helzle I am also  having the same question from my end as well. Thanks for bringing up.

 Just out of curiosity, do you and NTRaman work in the same company or together? 

I noticed that as soon as this user asks a question, you reply within 60 seconds, always! So I was curious.

Actually you can write up to 50 000 rows at once in the Write Records node: docs.appian.com/.../Write_Records_Smart_Service.html. If you want to write more than that, you can create a loop with batches.

Also the 1000 limit is for batches of syncing data - that's where the processing of data in batches matters. And like others have mentioned, the keep data available at high volumes isn't intended to limit high volumes of batching, but high volumes of data in the sources (>4M rows).