Skip to main content
I
iswaryan3520
June 24, 2025
Question

Records are not syncing properly

  • June 24, 2025
  • 8 replies
  • 0 views

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?

8 replies

davidj137213
davidj137213
June 24, 2025

How do you synchronize the record after the data insertion? It seems that this is the issue — the data is being inserted, but you're not synchronizing the record

I
iswaryan3520Author
June 24, 2025

I am having a subprocess node for data syncing after all the insertion / manipulation done. I was able see the new/update records in the particular record type's data preview section but not in record list and not able to see when I query before manual syncing. 

shubhama926776
shubhama926776
June 24, 2025

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

I
iswaryan3520Author
June 24, 2025

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? 

P
pavans123939
June 24, 2025

 [mention:04120ccb8dd74d76bb8fe18fa5a7ea03:e9ed411860ed4f2ba0265705b8793d05] 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.

Terms & ConditionsAccessibility statement