Migrate the Oracle database for the Command Prediction Service microservice

When you upgrade from Teamcenter 13.x / 14.x to Teamcenter 2606, you must run scripts to migrate the existing data, so that the Teamcenter Assistant can store the history of clicks performed by users and predict the next command successfully. Note These migration scripts migrate the command data for Teamcenter Assistant. The scripts do not migrate the actual commands. Prerequisites You must migrate the commands and then run the migration scripts. Changes required for custom commands in updated UI should be completed Create the following lists of custom group commands that you want to migrate: A list of custom group commands that will be visible when you click … or More in the work area toolbar or primary toolbar. A list of custom group commands that will be visible directly on the work area toolbar or primary toolbar. Procedure Copy the template scripts from \tc\microservices\commandprediction_service.zip\tc\db_scripts\tc2312_migration\oracle. To migrate the data generated for commands that are included with the default Teamcenter installation, run the assistant_tc2312_migration_script_oracle.sql script as follows: Copy sqlplus -s username/password@database @assistant_tc2312_migration_script_oracle.sql To migrate the data generated for custom group commands created by the user that were originally present on the primary toolbar on the right, do the following: Modify the tokens in the assistant_tc2312_custom_migration_script_oracle.sql as follows: Token Example value Description @@LIST_OF_ANCHORS_FOR_WORKAREA_TOOLBAR_MORE@@ ‘Group1’,’Group2’,‘Group3’ List of custom command groups that will be migrated to “More” group in workarea toolbar. @@LIST_OF_ANCHORS_FOR_WORKAREA_TOOLBAR_MORE@@ ‘Group1’,’Group2’,‘Group3’ List of custom command groups that will be migrated to group in workarea toolbar. Note You do not need to run this script for custom commands, this script is needed only for the custom group commands. Save the modifications and run the script use the following command: Copy sqlplus -s username/password@database @assistant_tc2312_custom_migration_script_oracle.sql