Hi Everyone, I have issue that I am syncing the records with sync record smart service within a process model in batch after the excel upload ;the excel have around 67k+ entries I am inserting the data using strore proc after some data manipulation ; after the sync completed when I check in the data preview section for updated records they are available there but when I try to query the records I m not getting those newly added rows. So I did manual sync then I was able to query it. What could be the reason can anyone help?
Discussion posts and replies are publicly visible
As you’re working with a large dataset, the issue likely occurs because the Sync Records Smart Service runs before the stored procedure fully commits the data. To avoid this, ensure the stored procedure completes execution and add a short timer between the stored procedure and the sync step. This ensures the data is committed and available when the sync runs.Give it a try
Hi Shubham, I will give a try , one question even if I use another process model that 's sub process the sync node will start before the insertion?
iswaryan3520 It totally depends on the stored procedure execution time. As Shubham suggested, please use a timer in between and a synchronous subprocess. This will ensure the insertion through the stored procedure is completed before the sync starts.
Hi PavanSrihari I tried as you suggested but its not working it db i have 58k active entries but when i query using record only 54k is available , the newly added records are not synced
If possible could you please share snapshot of your process for better understanding.
this is the model triggered while uploading excel ,
this is the suporcess for syncing the records in batch , this I followed Sync Records Smart Service - Appian 23.4 its giving enumurated id starts from 1 , I was using query to get the record id's before that also didn't work . I added delay for 2 minutes