Discrepany Between Log Files Expected And Actually Generated During Database Upgrade To V5.0
(Doc ID 1275927.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 5.0.0 and laterInformation in this document applies to any platform.
Goal
Customer upgraded from Argus Safety 4.2 HF1 to 5.0 and found the following discrepancies in the log files generated:A. Upgrade from 4.2 HF1 to 4.2 SP1 HF1B:
System displayed saying that the following Log Files are generated as part of this upgrade:
1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
Found the following discrepancies in the log files generated:
Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
B. Upgrade from 4.2 SP1 HF1B to 4.2 SP1 HF2: list of log files generated
System displayed saying that the following Log Files are generated as part of this upgrade:
1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
Found the following discrepancies in the log files generated:
Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
C. Upgrade from 4.2 SP1 HF2 to 5.0: list of log files generated
System displayed saying that the following Log Files are generated as part of this upgrade:
1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
Found the following discrepancies in the log files generated:
Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)
Log files generated but not listed during database Upgrade Execution:
UPG_case_prod_drugs_log.log
UPG_case_product_log.log
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |