Migrating user data using the CPS_migrate_user_data utility

The CPS_migrate_user_data utility migrates MD5 hashed data for users, groups, and roles to SHA256 hashed data in the Command Prediction Service database. Before running this utility, you must use the admin_data_export utility export the Teamcenter user, role, and group data to a file. Copy CPS_migrate_user_data [OPTION] The following options are available: -dbplat - Database platform used for Command Prediction Services such as MSSQL, ORACLE, or POSTGRESQL. -username - Database username. -password - Database password. -hostname - Database hostname. -port - Database port. -namedinstance - For MSSQL platform, connect with named instance instead of database port. -instance - Command Prediction Service database instance name. In the case of the Oracle database, the instance is SID, while in the case of POSTGRESQL and MSSQL databases, the instance is the name of the database -inputfile - Full file path of the Organization.XML file generated using the Teamcenter admin_data_export utility. -batchsize - Number of user profiles to be updated during the user data migration run. If not provided, the utility migrates the data of all the users. Migrate user data using the CPS_migrate_user_data utility Procedure Run the admin_data_export utility to export Teamcenter user, group and role data. For Windows Open the Teamcenter command prompt. Run the following command: Copy admin_data_export -u= -p= -g=dba -adminDataTypes=Organization -outputPackage=<export_file.zip> For Linux Open the terminal at /bin. Set TC_ROOT, TC_DATA and run /tc_profilevars for the terminal. Run the following command: Copy /admin_data_export.sh -u= -p= -g=dba -adminDataTypes=Organization -outputPackage=<export_file.zip> Extract the newly created ZIP file and locate the Organization.XML file in the \ADMINISTRATION_DATA\Organization folder. Run the CPS_migrate_user_data utility to migrate the data. For Windows Open the Command prompt at the \CommandPrediction- folder. Run the following command: Copy CPS_migrate_user_data -dbplat= -hostname= -username= -password= -port= -instance= -inputfile= The log file is created in the \CommandPrediction-\Logs\UserDataMigration folder. For Linux Get the running container ID for the Command Prediction Service. Copy docker container ls Copy the Organization.XML file into the container. Copy docker cp :/app/ Run the following command: Copy ocker exec -it ./CPS_migrate_user_data -dbplat= -hostname= -username= -password= -port= -instance= -inputfile=/app/Organization.xml The log file is created in a docker container in the /tmp/Logs/UserDataMigration folder.