Migrate legacy effectivity data to a new effectivity object

If you have legacy effectivity data stored in the CFM_date_info object, you must migrate it to the new effectivity object called Effectivity, as the old object is obsolete.

You can run the effupgrade utility in the CFM date info occurrence effectivity upgrade mode as follows on the Teamcenter command prompt:

effupgrade -cfm_date_info_occ

The -cfm_date_info_occ mode further contains Report and Upgrade sub-modes. You must first use the Report sub-mode, then the Upgrade sub-mode. As a system administrator or a business user, you must not modify any effectivity data while the utility is running in these sub-modes.

Procedure

1. On the Teamcenter command prompt, run the Report sub-mode:

   effupgrade -u=<username> -p=<password> -g=<group> -cfm_date_info_occ -report
   

   The Report mode queries the Teamcenter database and displays the statistics that contain PSOccurrence counts, orphan CFM date info objects, duplicate IDs, and multi-site references. This information helps you verify the data consistency and prioritize issue resolution.

2. Run the Upgrade sub-mode:

   effupgrade -u=<username> -p=<password> -g=<group> -cfm_date_info_occ -upgrade
   

   The Upgrade mode migrates legacy CFM_date_info effectivity data to the new effectivity objects:

   • The CFM_date_info objects referenced by PSOccurrence are upgraded by creating effectivity objects, re-linking occurrences, and deleting the old CFM objects in configurable batches.
   • The orphan CFM_date_info objects, not referenced by any PSOccurrence, are upgraded.

   The utility processes PSOccurrence in batches with a default batch size. To specify a custom batch size, use the -batchSize option:

   effupgrade -u=<username> -p=<password> -g=dba -cfm_date_info_occ -upgrade -batchSize=<batch_size>
   

   Example: to migrate 10000 records of PSOccurrence in one batch:

   effupgrade -u=<username> -p=<password> -g=<group> -cfm_date_info_occ -upgrade -batchSize=10000
   

   You can also specify the number of batches to run:

   effupgrade -u=<username> -p=<password> -g=<group> -cfm_date_info_occ -upgrade -batchSize=<batch_size> -maxBatchesPerRun=<batches>
   

   Example: to migrate two batches of 10000 PSOccurrence records:

   effupgrade -u=<username> -p=<password> -g=dba -cfm_date_info_occ -upgrade -batchSize=10000 -maxBatchesPerRun=2
   

The Upgrade sub-mode migrates the CFM date info to the Effectivity object and then cleans up the legacy CFM_date_info object after its data is migrated.

For more information about the CFM date info occurrence effectivity upgrade mode, run effupgrade -occ_eff_help. To view all information about the effupgrade utility, run effupgrade -h.