spMFUpdateSynchronizeError¶

Returns

1 = Success
-1 = Error

Parameters

@TableName varchar(100)

Class table name (e.g., ‘MFCustomer’)

@Update_ID int (output)

Update run identifier to correlate to prior run

@RetainDeletions bit (optional)

Default = 0 (No)
Set to 1 to retain deletions in class tables

@IsDocumentCollection bit (optional)

Default = 0 (No)
Set to 1 if the class refers to a document collection

@ProcessBatch_ID int (optional, output)

ProcessBatch ID for logging

@Debug int (optional)

Default = 0
1 = Standard Debug Mode
101 = Advanced Debug Mode

Purpose¶

Reprocess and fix synchronization errors from a previous update run for a specific class table.

Examples¶

DECLARE @Update_ID INT,
        @ProcessBatch_ID INT;

EXEC dbo.spMFUpdateSynchronizeError
     @TableName       = 'MFCustomer',
     @Update_ID       = @Update_ID OUTPUT,
     @RetainDeletions = 0,
     @IsDocumentCollection = 0,
     @ProcessBatch_ID = @ProcessBatch_ID OUTPUT,
     @Debug           = 0;

Changelog¶

Date	Author	Description
2022-09-02	LC	Update to include RetainDeletions and DocumentCollections
2022-08-03	LC	fix bug on calling proc in sync precedence
2022-08-03	LC	Updating debug logging to aid error trapping
2019-08-30	JC	Added documentation
2018-08-29	LC	Include this process as a part of the logging of MFUpdateTable
2018-08-23	LC	Update procedure to only process the errors from the prior update run