Stage 3 fails to create default offer template

Problem or error: The stage3 script fails to create the default offer template, and an error appears in the migration log indicating that five or more offer codes are in use.

Solution:Unica Campaign does not support multi-part offer codes that contain more than four parts. You must modify these offers on the source system before you can migrate them to the target system.

To work around this issue, follow these steps:

  1. Modify the offers on your source system so that none contain offer codes with more than four parts.

    For example, on a Unica Campaign 6.2.5 source system, set the UACOfferCodeUsed property in the unica_acsvr.cfg file to a value less than five. The unica_acsvr.cfg file is located in the /Campaign/config directory of your Unica Campaign source system.

  2. Run the appropriate DDL scripts for your database type to re-create and re-populate the Unica Campaign system tables.
  3. Remove the temporary migration tables (prefixed with MIG_) from the target system's database.
  4. Delete any files and folders that have been added to the default folders (partitions/<partition_name>/campaigns, partitions/<partition_name>/catalogs, and so on) for the partition on the target system. Do not delete the default folders.
  5. Delete the bootstrap_migration.xml file from the location where you are running the data migration scripts.
  6. Restart the target system and verify that it is a clean system.
  7. Rerun the data migration stages beginning with Stage 1.