Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.87727_CLOUD_342854_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-24 19:25:28 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 Entryname Update:dbk_wkf_workflow.pb@sql - File: sql/dbk_wkf_workflow.pb: ________________________________ Updating: /opt/cm/v12/test/sql/dbk_wkf_workflow.pb - size (on disk): 98853 bytes - last modified (on disk): 2024-07-24 13:38:34.0 -project (on disk): V12 - version (on disk): 186561 - size (new file): 99870 bytes - last modified (new file): 2024-07-24 18:02:48.0 -project (new file): V12 - version (new file): 186625 Entryname Update:OWKF_SD_Object.pb@jspsql - File: jspsql/OWKF_SD_Object.pb: _________________________________ Updating: /opt/cm/v12/test/jspsql/OWKF_SD_Object.pb - size (on disk): 84751 bytes - last modified (on disk): 2024-07-24 13:42:30.0 -project (on disk): V12_JSP - version (on disk): 186562 - size (new file): 88624 bytes - last modified (new file): 2024-07-24 18:04:28.0 -project (new file): V12_JSP - version (new file): 186626 Entryname Update:dbk_wkf_workflow.ps@sql - File: sql/dbk_wkf_workflow.ps: ________________________________ Updating: /opt/cm/v12/test/sql/dbk_wkf_workflow.ps - size (on disk): 22380 bytes - last modified (on disk): 2024-07-24 13:38:36.0 -project (on disk): V12 - version (on disk): 186561 - size (new file): 22915 bytes - last modified (new file): 2024-07-24 18:02:48.0 -project (new file): V12 - version (new file): 186625 - File: jspsql/OWKF_2487727_9.sql: __________________________________ Updating: /opt/cm/v12/test/jspsql/OWKF_2487727_9.sql - This is a new file, no information available on disk - size (new file): 8116 bytes - last modified (new file): 2024-07-24 18:02:14.0 - File: sql/2487727_8.sql: __________________________ Updating: /opt/cm/v12/test/sql/2487727_8.sql - This is a new file, no information available on disk - size (new file): 8095 bytes - last modified (new file): 2024-07-24 18:01:38.0 Entryname Update:OWKF_SD_Object.ps@jspsql - File: jspsql/OWKF_SD_Object.ps: _________________________________ Updating: /opt/cm/v12/test/jspsql/OWKF_SD_Object.ps - size (on disk): 14215 bytes - last modified (on disk): 2024-07-24 13:42:30.0 -project (on disk): V12_JSP - version (on disk): 186562 - size (new file): 14908 bytes - last modified (new file): 2024-07-24 18:04:28.0 -project (new file): V12_JSP - version (new file): 186626 - File: jspsql/HIK_WKF_SC_RFP_WFT.wft: ______________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_SC_RFP_WFT.wft - size (on disk): 1362448 bytes - last modified (on disk): 2024-07-24 13:40:18.0 - size (new file): 1364150 bytes - last modified (new file): 2024-07-24 18:03:06.0 Loading file : HIK_WKF_SC_RFP_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_SC_RFP_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_SC_RFP_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 24-Jul-24 19:25:29 Ended : 24-Jul-24 19:26:18 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 3 The group 0 entry Name Update:2487727_8.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/2487727_8.sql.sh to run 2487727_8.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/2487727_8.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/2487727_8.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 24 19:26:52 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.87727, Work Item 8 -- RFP's are not auto posting -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487727_8.sql Output in 2487727_8.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 19:27:14 special list (before special recompiling) 2024-07-24 19:27:15 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 19:27:18 special list (after special recompiling) 2024-07-24 19:27:19 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 07.27.21.089186 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== ========================================================================= Started WKF_WorkFlow.ps: Workflow Procedures ========================================================================= ========================================================================= Creating OR replacing PACKAGE Dbk_Wkf_Workflow ========================================================================= No errors. ========================================================================= Creating SYNONYM Dbk_Wkf_Workflow ========================================================================= DROP PUBLIC SYNONYM Dbk_Wkf_Workflow * ERROR at line 1: ORA-01432: public synonym to be dropped does not exist ========================================================================= Completed WKF_WorkFlow.ps: Workflow Procedures ========================================================================= -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== ========================================================================= Started: Dbk_Wkf_Workflow.pb ========================================================================= ========================================================================= Workflow Procedures ========================================================================= ========================================================================= Creating OR replacing PACKAGE BODY Dbk_Wkf_Workflow ========================================================================= No errors. ========================================================================= Completed: Dbk_Wkf_Workflow.pb ========================================================================= -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 19:27:43 special list (before special recompiling) 2024-07-24 19:27:44 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 19:27:46 special list (after special recompiling) 2024-07-24 19:27:47 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 07.27.48.763760 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2487727_8.sql completed. Output in 2487727_8.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 entry Name Update:OWKF_2487727_9.sql@jspsql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/OWKF_2487727_9.sql.sh to run OWKF_2487727_9.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/OWKF_2487727_9.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_19_26_18.321/OWKF_2487727_9.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 24 19:27:48 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.87727, Work Item 9 -- RFP's are not auto posting -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started OWKF_2487727_9.sql Output in OWKF_2487727_9.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 19:28:09 special list (before special recompiling) 2024-07-24 19:28:10 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 19:28:13 special list (after special recompiling) 2024-07-24 19:28:14 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 07.28.16.298690 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== ========================================================================= Started Owkf_Sd_Object.ps: Oracle Workflow Posting Functions ========================================================================= ========================================================================= Connect as OWF Administrator on the Workflow machine ========================================================================= Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 Connected. ========================================================================= Creating OR replacing PACKAGE Owkf_Sd_Object.ps ========================================================================= No errors. ========================================================================= CMiC_Connect_DA.sql: Connect as DA on the mPower machine ========================================================================= Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 Connected. ========================================================================= Completed Owkf_Sd_Object.ps ========================================================================= -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== ========================================================================= Started: Owkf_Sd_Object.pb ========================================================================= ========================================================================= Oracle Workflow Lookup Functions ========================================================================= ========================================================================= Connect as OWF Administrator on the Workflow machine ========================================================================= Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 Connected. ========================================================================= Creating OR replacing PACKAGE BODY Owkf_Sd_Object ========================================================================= No errors. ========================================================================= START CMiC_Connect_DA.SQL ========================================================================= ========================================================================= CMiC_Connect_DA.sql: Connect as DA on the mPower machine ========================================================================= Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 Connected. ========================================================================= Completed Owkf_Sd_Object.pb ========================================================================= -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 19:28:37 special list (before special recompiling) 2024-07-24 19:28:38 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 19:28:41 special list (after special recompiling) 2024-07-24 19:28:42 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 07.28.44.496288 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- OWKF_2487727_9.sql completed. Output in OWKF_2487727_9.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 2 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.87727 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: 1 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 592 | * 593 | ERROR at line 1: 594 | ORA-01432: public synonym to be dropped does not exist 595 | =============================== End of Installation Log Review ===============================