cleanup_psdata

Cleans up obsolete and duplicate product structure data. This utility has three options: Clean up duplicate variants The duplicate_variants option identifies and optionally removes duplicate variants from the database. Duplicate variants occur when two variant objects have the same name and are owned by the same item. Duplicate variants can cause the importing or exporting of variants to fail. To avoid this and any other potential problems that may arise due to duplicate variants, Siemens Digital Industries Software recommends cleaning up duplicate variants. Clean up absoccViewQualifier objects The absoccViewQualifier option identifies and optionally removes unreferenced absoccViewQualifier objects from the database. Repair markup changes The repairMarkupChanges option updates the markup changes in the database. The way Mass Updates stores data has changed for some cases. This option aligns the existing data with the new way. Note You must run the utility with this option after upgrading Teamcenter from a previous release. Note You must have administrative privileges to run this utility. Syntax cleanup_psdata -u=user-ID {-p=password} [-g=group] [-duplicate_variants] [-absoccViewQualifier] [-repairMarkupChanges][-report_file_path=path] [-auto_cleanup] [-output=path] [-report] [-destroy_all] [-h] Arguments -u Specifies the user ID. The user must have administrative privileges. Note If your Teamcenter server uses Security Services single sign-on, see Before you begin for additional information. -p Specifies the user's password. -g Specifies the group associated with the user. -duplicate_variants Specifies the option to clean up duplicate variants. -absOccViewQualifier Specifies the option to clean up absoccViewQualifier objects. -report_file_path Specifies the output file path when using the duplicate_variants option. Set this to a valid local drive path for the report files. -auto_cleanup Specifies to automatically delete duplicate variants when found. -output Specifies the output file path when using the absoccViewQualifier option. Set this to a valid local drive path for the report files. -report Specifies to report unreferenced absOccViewQualifier objects found in the database. The report file is saved in the location specified by the output argument. -destroy_all Specifies to remove all unreferenced absOccViewQualifier objects found in the database. -h Displays help for this utility. -repairMarkupChanges Updates the markup changes in the database. Environment This utility should be run in a shell where the Teamcenter environment is set up. Files A report file is generated in the specified location. Restrictions None. Examples Duplicate variants report Report only To generate a duplicate variants report: Copy cleanup_psdata [-u=user-name] [-p=password] [-g=group-name] -duplicate_variants -report_file_path=path This command generates a file named duplicate_variants_report_timestamp.csv in the location specified in the report_file_path argument. The report lists all duplicate variant objects with UIDs of variant options, variant revisions, numbers of expressions referring to duplicate options, and other information. Report and clean up To generate a duplicate variants report and automatically clean up duplicate variant objects: Copy cleanup_psdata [-u=user-name] [-p=password] [-g=group-name] -duplicate_variants -report_file_path=path auto_cleanup This command generates a file named duplicate_variants_report_timestamp.csv in the location specified in the report_file_path argument. The report lists all duplicate variant objects with UIDs of variant options, variant revisions, numbers of expressions referring to duplicate options, and other information. The report also lists variants that were successfully cleaned up. absoccViewQualifier objects report Report only To generate a report of all unreferenced or invalid absoccViewQualifier objects: Copy cleanup_psdata [-u=user-name] [-p=password] [-g=group-name] -absoccViewQualifier -output=path -report This command generates a report file in the location specified in the output argument. Report and clean up To generate a report and automatically remove all unreferenced or invalid absoccViewQualifier objects from the database: Copy cleanup_psdata [-u=user-name] [-p=password] [-g=group-name] -absoccViewQualifier -output=path destroy_all This command generates a report file in the location specified in the report_file_path argument. The report lists all absoccViewQualifier found and indicates which objects were successfully cleaned up. Repair markup changes To update the markup changes in the database: Copy cleanup_psdata -[u=user-name] -p=[password] -g=[group-name] -repairMarkupChanges This command searches for all markup changes in the database that contain PSOccurrence and replaces it with PSOccurrenceThread. Related Topics Structure Management on Rich Client ─ Usage