Return
-
Title
Mapping Archiving (Cargo Bay) -
Description
Mapping Archiving (Cargo Bay) -
Resolution
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)
Prerequisites
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:
Status Description 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 Cancelled Archiving cancelled The following notifications might be seen when performing enablement or disablement of mapping archiving:
Action Notification 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.