When using the Mapping Archiving feature, item data associated with finished mappings is moved from active tables to a backup database (the Cargo Bay). This reduces the number of records in active tables, thus improving performance when you’re interacting with active item data.
Enable Mapping Archiving (Cargo Bay)
Before enabling Cargo Bay, you need to install SQL Server Integration Services 14.0 on the core machine. Here’s how to do it:
- Download the SQL Server 2017 installer (Enterprise or Developer).
- Run the setup.exe file.
- Click Installation > New SQL Server stand-alone installation (shown below).
- In the ‘Feature Selection’ area, select ‘Integration Services’ and click ‘Next’.
- In the ‘Server Configuration’ section, select ‘Manual’ from the ‘Startup Type’ field.
- Finish the installation and then restart IIS.
Once the prerequisites have been installed, execute the following SQL statement on the Archive Shuttle Directory database. If the migration environment is using Archive Shuttle Cloud, contact the Customer Experience Team
Update SettingDefinition set DefaultValueNumeric = 1 WHERE Name = 'EnableCargoBay'
Enabling for a small number of mappings
It is possible to enable archiving on just a selection of the mappings. This can be done by selecting the mappings and clicking the button ‘Enable Mapping Archiving’. This is available on the following screens:
- Existing mapping screen (on the ‘Main’ tab)
- Stage 1 screen (on the ‘Actions’ tab)
- Stage 2 screen (on the ‘Mapping Archiving’ tab)
Mapping Archiving statuses and notifications
The following statuses might be seen against a mapping:
|NotStarted||Archiving not started or mapping not eligible for archiving|
|Running||Archiving in progress|
|Failed||Archiving is failed|
|Finished||Archiving finishes successfully|
|ArchivingForced||Archiving of mapping is forced|
|ArchivingDisabled||Archiving of mapping is disabled|
|ArchivingDisabledAutomatically||Archiving of mapping is automatically disabled due to failed item detection|
|Finished with Warnings||Archiving finished successfully, but with warnings because empty tables were not deleted|
The following notifications might be seen when performing enablement or disablement of mapping archiving:
|Enable||Mapping(s) successfully enabled for archiving|
|Enable||Mapping(s) cannot be enabled for archiving|
|Enable||Mapping(s) already enabled for archiving|
|Enable||Not all mappings were enabled for archiving. See logs for more details.|
|Disable||Mapping(s) successfully disabled for archiving|
|Disable||Mapping(s) cannot be disabled for archiving|
|Disable||Mapping(s) already disabled for archiving|
|Disable||Not all mappings were disabled for archiving. See logs for more details.|