4. TADB/PRT Backing File Synchronization and Recovery

Synchronization and recovery overview.

Synchronization report and implementation steps.

Backing file recovery when there are decreases in PRT configuration components.

Synchronization and recovery overview

The PRT Collector manages discrepancies or corruption in the PRT backing files as follows.

Synchronize data

When the project is not running a user can have the PRT Collector synchronization  PRT and TADB.

During synchronization PRT data overwrites TADB data.

Note: Any items in TADB that are assigned to regions in TADB, but are not in PRT are deleted. PRT values overwrite TADB values.

Recover data

When a project starts PRT Collector validates the data between PRT backing files and TADB.

If PRT backing files are corrupt the PRT Collector will:

  1. Delete the corrupt backing files.

  2. Create new blank backing files.

  3. Query the TADB database for the data needed to recover the backing files.

  4. Recover the data from the database.

Synchronization report and implementation steps

Step 1

Open the Synchronization Report window.

Step 2

Create a new PRT vs. TADB Validation Report.

Step 3

Review and copy report data.

Step 4

Synchronize PRT backing files and TADB.

Backing File Recovery when there are Decreases in PRT Configuration Components

When the PRT configuration changes after items have been logged to the database involve reductions, e.g. fewer regions, fewer locations, fewer items in a location, recovery attempts to:

Maintain the item sequence.

Maintain item associations.

When warranted, move items to the next location or region.

Report all changes and issues in the Status Log.

The following examples portray two possible situations.

Example 1

REGION1's capacity initially is 200.

The capacity is reduced to 150.

Recovering items from the database starts at Location 1.

Items are recovered from 1-150.

At 150, the revised capacity is full; there is no more room for items.

Item 151 is not recovered.

An initial warning and failure are logged to the status log that:

Item count %d <200> exceeds Item capacity %d<150> for region <REGION1>.

Location %d<151> for Item %s<widgets> exceeds region <REGION1> locations %d<150>.

Reports about all items over 151 are also logged to the Status Log.

Note: The recovery maintains the initial integrity of items/location. If the location allows 2 items and only 1 item is in the location at the time of recovery, the location will continue to have only 1 item.

Example 2

The location capacity in REGION1 is initially is 3 items.

The capacity is reduced to 2 items.

If the database contains 3 items in a location recovery will attempt to fulfill three requirements.

Maintain the item sequence.

Maintain item associations.

Reduce the number of items in the location to 2 or 1.

The recovery starts with the first item in the location.

The following table displays how database items in locations that previously allowed 3 items are allocated during recovery.


Database Items

Recovered Items


1A, 1B, 1C

1A, 1B


2A, 2B, 2C



3A, 3B, 3C

2A, 2B


4A, 4B



5A, 5B, 5C

3A, 3B


6A, 6B


For each instance that an item is re-assigned to the next location a report is logged in the Status Log.

Adjusted %s<1C> location from %d<1> to %d<2> during recovery. Updating TADB to match.

For each instance that there is an attempt to re-assign an item and the region/location capacity is exceeded, a report is logged in the Status Log.

Adjusted location %d<7> from %d<4> for %s<4A> exceeds %s<REGION1> %d<6> locations.

Note: If an unforeseen error occurs while recovering an item from the TADB, the following message is logged to the status log.

Failed recovery %s to %s at adjusted location %d, %d orig.

Where the message components are:

Failure to recover <item> to <region> at adjusted location <attempted location>, <database location>.

More information

TADB overview.