My Oracle Support Banner

Can "Skipping below sql files from execution" Warnings Be Ignored While Installing OIDF 8.1 (Doc ID 2728324.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Oracle Insurance Data Foundation - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Insurance Data Foundation (OIDF)

Goal

The following two questions have come up during new installation of OIDF 8.1:

Question 1: This is a fresh installation. As part of the installation there is a step to apply one patch (OIDF Data Model <Patch 31924513>) which is having the model upgrade. But that patch is giving error as pasted below.

Error while executing - DECLARE EXS NUMBER(5); flg varchar2(3); Z EXCEPTION; Z1 EXCEPTION; BEGIN select count(*) INTO EXS from util_configuration where V_APP_ID='OFS_OIDF' AND V_PATCH_NAME ='8.1.0.0.0'; IF EXS = 1 THEN select is_exec_flag into flg from util_status where app_id = 'OFS_OIDF'; if flg = 'N' then PRESCRIPT_SCD_METADATA_DEL_810;PRESCRIPT_DQ_METADATA_DEL_810;RESTORE_SPECIFIC_TBLS_810;RESTORE_DROPPED_TBLS_COLS_810;RESTORE_SCD_METADATA_810;RESTORE_DQ_METADATA_810;update util_status set is_exec_flag = 'Y', exec_time = sysdate where app_id = 'OFS_OIDF';EXECUTE IMMEDIATE 'DROP PROCEDURE PREPARE_CUSTM_TBL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DEFAULT_VALUES_810';EXECUTE IMMEDIATE 'DROP PROCEDURE prescript_drop_tbles_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DROP_COLUMNS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_SCD_METADATA_BKP_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DQ_METADATA_BKP_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_SCD_METADATA_DEL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DQ_METADATA_DEL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_DROPPED_TBLS_COLS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_SPECIFIC_TBLS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_SCD_METADATA_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_DQ_METADATA_810';else RAISE Z1; end if;else raise Z; end if; for x in (SELECT TABLE_NAME FROM REV_TABLES_B WHERE TABLE_NAME in (SELECT TABLE_NAME FROM DROPPED_DATAELEMENTS_CUSTOMIZATION_81 WHERE COLUM_NAME IS NULL)) loop UPDATE DROPPED_DATAELEMENTS_CUSTOMIZATION_81 SET RETAIN_AS_CUSTOMIZATION='Y' WHERE TABLE_NAME = ''||X.TABLE_NAME||'' AND COLUM_NAME IS NULL; end loop;COMMIT;for x in (SELECT TABLE_NAME, COLUMN_NAME FROM REV_TAB_COLUMNS WHERE TABLE_NAME || '.' || COLUMN_NAME IN ( SELECT TABLE_NAME || '.' || COLUM_NAME FROM DROPPED_DATAELEMENTS_CUSTOMIZATION_81 WHERE COLUM_NAME IS NOT NULL)) loop UPDATE DROPPED_DATAELEMENTS_CUSTOMIZATION_81 SET RETAIN_AS_CUSTOMIZATION='Y' WHERE TABLE_NAME = ''||X.TABLE_NAME||'' AND COLUM_NAME = ''||X.COLUMN_NAME||''; end loop;COMMIT;MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20015 MESSAGE_CD,'Tables/Columns with RETAIN_AS_CUSTOMIZATION value as Y are the customized data elements in table DROPPED_DATAELEMENTS_CUSTOMIZATION_81, please validate' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT); exception when z then MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20014 MESSAGE_CD,'8.1 Installation is not happnened properly after Pre Script execution as part of offline utility, please check' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT);WHEN Z1 THEN MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20013 MESSAGE_CD,'PostScripts are already Executed. Please update is_exec_flag to N of util_status table to execute Post Scrip again' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT);WHEN OTHERS THEN if sqlcode != -4043 then raise; end if; COMMIT; COMMIT; END;
ORA-06550: line 8, column 32:
PL/SQL: ORA-00942: table or view does not exist


Is there any action to be taken to fix above error when applying <Patch 31924513> for a new installation?
 
Question 2 : Can the following error message while performing the installation on OIDF can be ignored:

[17-10-20 03:43:16,960 EST AM] [WARN ] SYSADMN has failed to create FIV Stage path on the webserver OFSAAINFO

[17-10-20 05:45:00,787 EST AM] [WARN ] **** Skipping below sql files from execution... ***
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FSI_EXCHANGE_RATES.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_COMMODITIES_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_CREDIT_DERIVATIVES_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_INVESTMENTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_LOANS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MM_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MUTUAL_FUNDS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_REPO_CONTRACTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_TRUSTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_COMMODITIES_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_CREDIT_DERIVATIVES_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_INVESTMENT_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_LOAN_CONTRACT_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MM_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MUTUAL_FUNDS_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_REPO_TRANSACTIONS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_TRUSTS_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FCT_MGMT_REPORTING_STG_GL_DATA.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FFSIS_STG_TRUSTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FCT_MGMT_REPORTING_STG_GL_DATA.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/commonapps_core_forms_locale_en_us.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] **** End of skipping sql files from execution... ***

[17-10-20 05:59:34,381 EST AM] [WARN ] **** Skipping below sql files from execution... ***
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/dt_buss_day_calc.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/VW_FSI_RATE_TRIANGULATION.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/fsi_create_sequence.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/fsi_messages.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/insert/DQCUSTACCT0003_STG_BORROWING_COMMITMENTS_N_UNDRAWN_AMT.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/insert/DQCUSTACCT0017_STG_LEASES_CONTRACTS_V_LV_CODE.sql

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.