Update Argus Mart 8.0 (and later) for use with Empirica Signal 8.1.1
For Argus Mart 8.0 and higher, perform these steps using the non-privileged user account on the application server.
- Copy the Update_AM_8_0_for_Signal_8_1_1_0_xxx.zip file from the distribution media to a temporary directory on the server.
- Unpack the Update_AM_8_0_for_Signal_8_1_1_0_xxx.zip file into a temporary directory, for example:
$ unzip Update_AM_8_0_for_SIGNAL_8_1_1_0_xxx.zip -d /u01/stage/
The /UPDATE_AM_8_0_FOR_SIGNAL_8_1 subdirectory is created.
- Navigate to the /UPDATE_AM_8_0_FOR_SIGNAL_8_1 directory, for example:
$ cd /u01/stage/UPDATE_AM_8_0_FOR_SIGNAL_8_1
- Using a text editor, open the create_argus_spontaneous_configurations.sql file.
- Locate the following WHERE clause:
WHERE UPPER (report_type_ve) IN (''SPONTANEOUS'',''LITERATURE'')
The WHERE clause describes the spontaneous reports from the Argus Mart database user account.
- Modify the WHERE clause as needed.
- Save and close the file.
- Execute the UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql script as the am_mart_user, for example:
$ sqlplus am_mart_user@<TNS_name> @UPDATE_AM_8_0_FOR_SIGNAL_8_1.sql
A password prompt appears.
- Enter the am_mart_user database account password, and then press Enter.