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: Copy 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, and 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 On the Teamcenter command prompt, run the Report sub-mode for effupgrade utility as follows: Copy effupgrade -u= -p= -g= -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. Run the Upgrade sub-mode for effupgrade utility as follows: Copy effupgrade -u= -p= -g= -cfm_date_info_occ -upgrade The Upgrade mode migrates legacy CFM_date_info effectivity data to the new effectivity objects in the following steps: The CFM_date_info objects referenced by PSOccurrence are upgraded by creating effectivity objects, re-linking occurrences, and deleting the old CFM objects in the configurable batches. The orphan CFM_date_info objects, that are 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 as follows: Copy effupgrade -u= -p= -g=dba -cfm_date_info_occ -upgrade -batchSize= Example If you want to migrate 10000 records of PSOccurrence in one batch, use the following statement: Copy effupgrade -u= -p= -g= -cfm_date_info_occ -upgrade -batchSize=10000 You can also use the following statement to mention the number of batches to be run for migrating the CFM date info records: Copy effupgrade -u= -p= -g= -cfm_date_info_occ -upgrade -batchSize= -maxBatchesPerRun= Example If you want to migrate two batches of 10000 PSOccurrence records, use the following statement: Copy effupgrade -u= -p= -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, in the Teamcenter command prompt, type the following command: Copy effupgrade -occ_eff_help To view all the information available on the effupgrade utility, type the following command: Copy effupgrade -h