Scripted Signal Management Configuration

If upgrading from 8.1.x, upgrade the Scripted Signal Management Configuration.

1. Navigate to the Database directory, for example:
   $ cd /u01/stage/Database
2. Start sqlplus as the Oracle Empirica Signal database user, for example:
   $ sqlplus webvdme@<TNS_NAME>
3. When prompted, enter the password.
4. Start logging, for example:
   SQL> spool <log file name>
5. Execute the create_product_field_tables.sql script, for example:
   SQL> @create_product_field_tables.sql <SMC_Id>
6. Execute the create_configurable_alerts_tables.sql
   script, for example: SQL> @create_configurable_alerts_tables.sql <SMC_Id>
7. Execute the populate_signalcodelist_table.sql
   script, for example: SQL> @populate_signalcodelist_table.sql <SMC_Id>
8. Execute the update_signaldrugoverview_view.sql script, for example:
   SQL> @update_signaldrugoverview_view.sql <SMC_Id>
9. Exit sqlplus, for example:
   SQL> quit
10. Copy 06_create_drugoverview_view.sql file from Database/update_ssm folder into the sigmgt/db subfolder of the Scripted Signal Management software directory. For instance, if Scripted Signal Management software installed in /u01/stage/projects/vaers_prep directory, run the following command:
    $ cp -f update_ssm/06_create_drugoverview_view.sql
    ../projects/vaers_prep/sigmgt/db