Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.88853_CLOUD_271234_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-09-19 20:03:27 The following directories are used: CMiC Home: "/opt/cm", as specified in /home/oracle/.cms/cms.conf. Oracle Home: "D:/as10g2/midtier", default value. JSP Oracle Home: "/u01/app/oracle/midtierjsp", as specified in /home/oracle/.cms/cms.conf. Mobile Oracle Home: "/u01/app/oracle/midtiermobile", as specified in /home/oracle/.cms/cms.conf. Oracle Client Home: "/u01/app/oracle/product/19.19/PROD", as specified in /home/oracle/.cms/cms.conf. /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc7.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc6.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc8.jar Connection string: jdbc:oracle:oci:da/********@test - File: sql/2488853_4.sql: __________________________ Updating: /opt/cm/v12/test/sql/2488853_4.sql - This is a new file, no information available on disk - size (new file): 11102 bytes - last modified (new file): 2024-09-13 15:12:32.0 - File: jasper/hotfixes/JSRHF_JBINVP_TOG_V12_019_2.zip: _______________________________________________________ Updating: /opt/cm/v12/test/jasper/hotfixes/JSRHF_JBINVP_TOG_V12_019_2.zip - This is a new file, no information available on disk - size (new file): 504107 bytes - last modified (new file): 2024-09-13 15:10:32.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2488853_4.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/2488853_4.sql.sh to run 2488853_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/2488853_4.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-09-19_20_03_28.157/2488853_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 19 20:03:47 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 24.88853, Work Item 4 -- Modify Invoice -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2488853_4.sql Output in 2488853_4.lst -- ====================================================================== -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,670 INDEX 57,625 INDEX PARTITION 492 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 8,038 TABLE 37,892 TABLE PARTITION 21,114 22 TRIGGER 266 TYPE 10,468 6 VIEW -------- ********** -------- 151,894 sum 29 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,324 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 2,933 sum 1 230 JS80 INDEX 22 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 22 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 431 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,322 4 VIEW -------- ********** -------- 6,357 sum 4 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 153 INDEX PARTITION 74 LOB 153 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 53 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,868 sum -------- -------- 171,842 34 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-09-19 20:04:04 special list (before special recompiling) 2024-09-19 20:04:04 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-09-19 20:04:05 special list (after special recompiling) 2024-09-19 20:04:06 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,670 INDEX 57,625 INDEX PARTITION 492 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 8,038 TABLE 37,892 TABLE PARTITION 21,114 22 TRIGGER 266 TYPE 10,468 6 VIEW -------- ********** -------- 151,894 sum 29 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,324 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 2,933 sum 1 230 JS80 INDEX 22 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 22 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 431 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,322 4 VIEW -------- ********** -------- 6,357 sum 4 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 153 INDEX PARTITION 74 LOB 153 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 53 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,868 sum -------- -------- 171,842 34 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401K7JYA_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_EMP_AVAILFLT3_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_INVRGCODED7JYA_OBJSE DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE7JYA_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 19-SEP-24 08.04.07.875743 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04 SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Columns, Tables, Views, Other Objects -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install/Update System Data -- ====================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. .========================================================= . Dropping Temporary TABLES .========================================================= Table dropped. drop table TMP_SDCODES * ERROR at line 1: ORA-00942: table or view does not exist drop table TMP_sddata_user_table * ERROR at line 1: ORA-00942: table or view does not exist .========================================================= . Creating Temporary TABLES .========================================================= Table created. Table created. Table created. ================================================================ Creating Temporary INDEXES ================================================================ Index created. Index created. .========================================================= . PROCESSING table DA.REPORTS_WITHIN_APPS .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 0 rows updated. Commit complete. .=INSERT================================================== 1 row created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.REPORTS_WITHIN_APPS .========================================================= .========================================================= . PROCESSING table da.SDCODES .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 0 rows updated. Commit complete. .=INSERT================================================== 1 row created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.SDCODES .========================================================= .========================================================= . PROCESSING table da.sddata_user_table .=TMP===================================================== 1 row created. .=UPDATE=================================================== 0 rows updated. Commit complete. .=INSERT=================================================== 1 row created. Commit complete. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.sddata_user_table .========================================================= .========================================================= . Dropping Temporary TABLES .========================================================= Table dropped. Table dropped. Table dropped. 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Get the Current State of the Database -- ====================================================================== -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,670 INDEX 57,625 INDEX PARTITION 493 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 8,037 TABLE 37,892 TABLE PARTITION 21,114 22 TRIGGER 266 TYPE 10,468 6 VIEW -------- ********** -------- 151,894 sum 29 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,324 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 2,933 sum 1 230 JS80 INDEX 22 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 22 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 431 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,322 4 VIEW -------- ********** -------- 6,357 sum 4 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 153 INDEX PARTITION 74 LOB 153 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 53 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,868 sum -------- -------- 171,842 34 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-09-19 20:04:25 special list (before special recompiling) 2024-09-19 20:04:25 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-09-19 20:04:26 special list (after special recompiling) 2024-09-19 20:04:27 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,670 INDEX 57,625 INDEX PARTITION 493 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 8,037 TABLE 37,892 TABLE PARTITION 21,114 22 TRIGGER 266 TYPE 10,468 6 VIEW -------- ********** -------- 151,894 sum 29 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,324 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 2,933 sum 1 230 JS80 INDEX 22 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 22 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 431 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,322 4 VIEW -------- ********** -------- 6,357 sum 4 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 153 INDEX PARTITION 74 LOB 153 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 53 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,868 sum -------- -------- 171,842 34 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401K7JYA_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_EMP_AVAILFLT3_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_INVRGCODED7JYA_OBJSE DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE7JYA_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 19-SEP-24 08.04.28.812873 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04 SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Update Menu Items in Treeview -- ====================================================================== -- ====================================================================== -- 2488853_4.sql completed. Output in 2488853_4.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 Copying /opt/cm/v12/test/jasper/hotfixes/JSRHF_JBINVP_TOG_V12_019_2.zip, to be imported Start execution of command /opt/cm/ias/j2ee/test/jasper/bin/cmic-js-import.sh --input-zip /opt/cm/ias/j2ee/test/jasper/hotfixes/JSRHF_JBINVP_TOG_V12_019_2.zip --update --skip-user-update Wait for procedure starts Executing Pro version -Xms128m -Xmx512m -Djava.net.preferIPv4Stack=true -noverify -Djava.security.policy=jasper.policy First resource path: /opt/cm/v12/test/jasperserver/buildomatic/conf_source/iePro Loading configuration resources Initialization complete Preparing the jasper temporary directory /opt/cm/ias/j2ee/test/jasper/jasperTempDir recreating /opt/cm/ias/j2ee/test/jasper/jasperTempDir Unzipping Multitenant Prepared successfully. Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_CUSTOM/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG/REPORTS/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG/REPORTS/JBINVP_TOG.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/P_REQUESTING_SESSIONID.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_SORT_BY_PROJECT_MANAGER_FLAG.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_REPORT_CODE.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_INV_SORT_ORDER.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_DATASOURCES/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_DATASOURCES/CMiCDataSource.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_fr_CA.properties.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_US.properties.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_SG.properties.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_CA.properties.xml Renaming /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/organizations to /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/public Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/resources/public/.folder.xml Replacing all organizations with public in the file /opt/cm/ias/j2ee/test/jasper/jasperTempDir/index.xml Importing the Objects into the repository ... First resource path: /opt/cm/v12/test/jasperserver/buildomatic/conf_source/iePro Loading configuration resources Initialization complete Processing started Updating folder /public/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS Created repository folder /public/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG Created repository folder /public/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG/REPORTS Updated resource /public/cmic/CMIC_DATASOURCES/CMiCDataSource Updated resource /public/cmic/CMIC_REPORT_PARAMETERS/P_REQUESTING_SESSIONID Updated resource /public/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_REPORT_CODE Updated resource /public/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_INV_SORT_ORDER Updated resource /public/cmic/CMIC_REPORT_PARAMETERS/MANUAL_INTERNAL_PARAMETERS/P_SORT_BY_PROJECT_MANAGER_FLAG Updated resource /public/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_CA.properties Updated resource /public/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_US.properties Updated resource /public/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_en_SG.properties Updated resource /public/cmic/CMIC_REPORTS/_COMMON_RESOURCES_/RESOURCE_BUNDLES/CMIC_RESOURCE_BUNDLE_fr_CA.properties Imported resource /public/cmic/CMIC_CUSTOM/CMIC_CUSTOM_REPORTS/TOG/REPORTS/JBINVP_TOG Starting the upgrade process for AdhocReportUnit objects. This process may be very time-consuming, depending on the number of Ad Hoc reports in your repository. Number of AdhocReportUnits found: 0 Done First resource path: /opt/cm/v12/test/jasperserver/buildomatic/conf_source/iePro Loading configuration resources Initialization complete Cleanup. Successful cleanup. Deleting /opt/cm/ias/j2ee/test/jasper/hotfixes/JSRHF_JBINVP_TOG_V12_019_2.zip deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.88853 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 2 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 519 | * 520 | ERROR at line 1: 521 | ORA-00942: table or view does not exist 522 | 525 | * 526 | ERROR at line 1: 527 | ORA-00942: table or view does not exist 528 | =============================== End of Installation Log Review ===============================