15 Troubleshooting

This chapter lists some of the error messages that might be displayed while working with Argus Mart, the cause for those messages, and the resolution.

The following is the list of error messages:

• Dictionary Reload Error

• ETL Execution Pre-Requisite Check Failed Error

• FR Consistency Log Error

• MedDRA Mismatch Error

• Multiple Enterprise Creation Messages

• SMQ-CMQ Loop Error

15.1 Dictionary Reload Error

Error Message

The following error message is displayed during the ETL process, whenever the dictionary is reloaded in Argus Safety:

Figure 15-1 Dictionary Reload Error Message

You can also view this error message by logging on to the SQL Developer as the AM_MART_USER, as shown in the following figure:

Figure 15-2 Dictionary Reload Error Message: SQL Developer

Cause of Error

Whenever there is a dictionary reload in Argus Safety, some of the required privileges for the Argus Safety user, which you created, using the Schema Creation Tool during the Installation Process, are lost.

Resolution

You must give the required privileges to the Argus Safety user. To do so, click the Argus User Creation link on the Schema Creation Tool, select the user that you created during the installation process in the Argus Safety User Creation dialog box, enter the name of the log file and click OK to give the required privileges to the user.

You can refer to Section 3.5.1, Creating User for the Argus Safety Database, for more information.

15.2 ETL Execution Pre-Requisite Check Failed Error

Error Message

There are some Pre-requisite checks that you must do before the execution of the ETL. The following is the error message, which is displayed if any of the Pre-requisites checks are not done:

Figure 15-3 Pre-Requisite Check Failed Error

Cause of Error

The following are the possible causes of this error message:

• If you are trying to run the Initial ETL on a database again without executing the Re-initial script.

• If you are trying to execute the Incremental ETL prior to the Initial ETL.

• If you have not configured the First Human Language Profile Switch using the Argus Safety console for the enterprises configured in Argus Mart. You must not leave the value for the First Human Language Profile Switch, as Blank.

• If the previous instance of the ETL is still not complete for the Load Plan.

Resolution

To resolve this error message, you must:

• Ensure that you run the Initial ETL on a database again only if you have already executed the Re-initial script. For more information on Re-initial script, see Chapter 14, "Re-initializing the ETL Process."

• If you are trying to run the Incremental ETL on a database, ensure that the Initial ETL has already been executed on it.

• Ensure that you have not left the value for the First Human Language Profile Switch for the enterprises configured in Argus Mart, as Blank.

• Ensure that the Previous Instance of the ETL process is complete. You can either resume the ETL process if it is in Stopped state, or you can execute the re-initial script on the database and restart the ETL process from the first step.

  For more information on resuming or restarting the ETL process, see Chapter 8, "Extracting, Transforming, and Loading Data."

15.3 FR Consistency Log Error

Error Message

You can run the following query using the SQL developer to view the Flexible Re-categorization (FR) Consistency warning message:

SELECT enterprise_id, code_list_id, decode_context, code, fr_type, log_message, log_date_time FROM etl_fr_consistency_log ORDER BY enterprise_id, code_list_id

The following is the error message:

Figure 15-4 FR Consistency Error

Cause of Error

The display value for a codelist is NULL in the rm_code_list_detail_discrete table in Argus Safety.

Resolution

You must update the value for the codelist in the rm_code_list_detail_discrete table in Argus Safety and re-run the ETL.

15.4 MedDRA Mismatch Error

Error Message

You can run the following query using the SQL developer to view the MedDRA mismatch warning message in the etl_mart_log table:

SELECT * FROM am_mart_user.etl_mart_log WHERE table_name = 'p_check_signal_meddra_schema' ORDER BY 1 DESC;

The following is the error message:

Figure 15-5 MedDRA Mismatch Error

Cause of Error

During the ETL process, a check is done between the Argus Safety and the Argus Mart database to ensure that they are using the same MedDRA version. This warning message is displayed when these values do not match.

Resolution

You must update the value for the MedDRA version in the SIGNAL_MEDDRA_VER table to ensure that it matches with the Argus Safety database value.

15.5 Multiple Enterprise Creation Messages

The following is the list of validation messages that are displayed while creating multiple enterprises in Argus Mart:

• Source Enterprise Does Not Exist In Mart

• Enterprise Does Not Exist In Argus Safety

• Enterprise Does Not Exist For Configuration In Mart

15.5.1 Source Enterprise Does Not Exist In Mart

Error Message

Given Source enterprise does not exist in Mart. Close the window and run application again.

Cause of Error

While creating multiple enterprises in Argus Mart, you must enter an enterprise name which can be used as a template to create other enterprises. This enterprise is referred to as the Source Enterprise.

If the name of the Source Enterprise that you have entered while creating multiple enterprises does not exist in Argus Mart, this validation message is displayed.

Resolution

The name of the Source Enterprise that you enter while creating multiple enterprises must exist in Argus Mart.

15.5.2 Enterprise Does Not Exist In Argus Safety

Error Message

From the list provided, no enterprise exists in Argus Safety. Close the window and run application again.

Cause of Error

The name of the enterprises that you enter while creating multiple enterprises in Argus Mart must also exist in the Argus Safety database.

If these enterprise names do not exist in Argus Safety, this validation message is displayed.

Resolution

You must ensure that the name of the enterprises that you enter while creating multiple enterprises in Argus Mart exist in the Argus Safety database.

15.5.3 Enterprise Does Not Exist For Configuration In Mart

Error Message

From the list provided, no enterprise is valid for configuration in Mart. Close the window and run application again.

Cause of Error

This validation message is displayed if all the enterprise names that you have entered on the Multiple Enterprise Creation screen already exist in the Argus Mart database.

Resolution

You must ensure that the enterprise names that you want to create in Argus Mart using the Multiple Enterprise Creation screen do not already exist in Argus Mart.

15.6 SMQ-CMQ Loop Error

Error Message

Error in p_set_Child_Record while processing term code self referencing parent child relationship leading to an infinite loop

Cause of Error

There is an SMQ, which is a Parent in the hierarchy, and has also been referenced as a Child in the hierarchy. This is termed as the Self Referencing Parent Child relationship, which leads to an infinite loop.

Resolution

You must ensure that an SMQ, which serves as a Parent in the hierarchy, must not also be present as a Child in the hierarchy.