Deleting and re-adding the mover is the only way to get the Safeguard mover to read the product audit pool records from the beginning if re-populating an XMA database that was re-partitioned and data was lost.

Deleting the Mover:

Using XMA_MANAGER STOP and DELETE the Mover.

When deleting the mover, it can be either removed completely or partially.  The default is to purge completely.  When a mover is completely purged, all entries for that mover are removed from the Mover and State tables.  However, all audit information previously processed, will still be present in the audit tables.  Re-adding a deleted mover could result in processing duplicates depending on the date supplied when/if a mover is re-added.

If a mover is partially deleted, the mover will be flagged as ?deleted? in its Mover table and that serverclassname will no longer be allowed to be used.  No data will be deleted from either the mover or state tables.  When re-adding a previously partially deleted mover, the same server name will not be allowed.  Additionally, if you specify a beginning start processing time of -1, the mover will check the state table and resume processing from the last record read.

Re-Adding the Mover:

Ensure that existing data does not exist in the XMA database for the product data that is going to be reprocessed. Either use SQLCI DELETE commands to manually remove specific data, or STOP the Pathway and use the XMA_MANAGER  3:Database - > 3:Cleanup Database option to remove all records for all products.

You must supply information for configuring your mover.  Please refer to section 1.3.7 Adding Mover Serverclasses for one example of the details you must provide.  Additional information is also available starting from Section 6.6 BASE24 Movers.

In addition, you must determine the date from which you will begin processing (I.E. reading Audit records).

Your options are:

-1                              Start processing from the beginning of existing audit files

{Number of Days}    Start processing from a certain number of days ago.  A date will be calculated by subtracting the number of days provided from midnight of the current date.

{Specific Date}         To start processing from a specific date onwards, enter a date in the format yyyy-mm-dd [hh:mn]

{Return}                    Entering nothing will start processing from midnight of the current day.

If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.