Synchronization error in Service Disconnected

This error occurs when the SRO is closed in Syteline before the SRO has been closed and completed in the Disconnected Service.

To resolve install Microsoft SQL Server Management Studio on the engineer laptop.

When opened this will detect the SQLExpress database which is installed with the Disconnected service.

Select the correct Database name in the drop down 'Available Databases'

Use the below query to find the SRO that is causing the problem.

select * from fs_sro

where sro_num = 'SRO Number'  

the SRO may exist in the following tables: fs_sro_line, fs_sro_labor, fs_sro_matl, fs_sro_misc, fs_sro_oper.

Check these tables with the same query but changing the table name.

This SRO will need to be deleted from all the tables that it exists in using the following delete statement.

delete from fs_sro

where sro_num = 'SRO Number'

Use this for each table that the SRO exists in. 

In Syteline make sure the SRO status is changed to Open and saved.

Carry out a Schedule synchronization on the disconnected service, the error message should now have gone.