Skip to main content
B
bhavikav0002
March 30, 2023
Question

Record sync via smart service paused

  • March 30, 2023
  • 3 replies
  • 0 views

Hi,

There is a stored procedure that updates the database and soon after we trying to sync records in a subprocess.
Sync of all records and related records based on identifier is done.
It has been observed that certain processes are being paused while others are completed fine. This is random behavior and no error on process model.

Please let me know if any solution regarding this.

Thanks,

Bhavika

3 replies

stefanhelzle0001
stefanhelzle0001
Brainy
March 30, 2023

Did you check the log files for any details?

adityag9712
adityag9712
March 30, 2023

Hi, which Appian Version are you currently using, there is a platform specific bug which the fixed in the 22.4 release. 

Please refer to docs.appian.com/.../Hotfixes.html

  • AN-225494 - Medium
    Fixed an issue that was causing process model failures due to a previous database transaction that was incorrectly marked for rollback.

B
bhavikav0002Author
March 30, 2023

Hi [mention:d602801622814df0b8116f5a4474a806:e9ed411860ed4f2ba0265705b8793d05]

Appian Version 22.4.480.0.

As I understand we don't have the hotfix installed for the next one which we will try out. However, there is no rollback of transaction this is successful stored procedure executed.


        
                                                

        

    


            

                                        

            
                        

                                                                                                            
            






        

                    

    
    





    


                                        

                                                        

            
        
    






                                    
Terms & ConditionsAccessibility statement