Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.85369_CLOUD_184840_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-06-13 20:04:05 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/2485369_3.sql: __________________________ Updating: /opt/cm/v12/test/sql/2485369_3.sql - This is a new file, no information available on disk - size (new file): 10119 bytes - last modified (new file): 2024-06-13 13:07:42.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2485369_3.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/2485369_3.sql.sh to run 2485369_3.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/2485369_3.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-06-13_20_04_06.745/2485369_3.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 20:04:14 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.85369, Work Item 3 -- Custom OCO Report -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2485369_3.sql Output in 2485369_3.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 f) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,458 INDEX 49,723 INDEX PARTITION 53 JOB 253 LOB 1 MATERIALIZED VIEW 3,106 PACKAGE 3,099 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,547 SYNONYM 7,854 TABLE 32,351 TABLE PARTITION 20,512 15 TRIGGER 262 TYPE 10,146 1 VIEW -------- ********** -------- 136,579 sum 17 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,269 SYNONYM 2 TABLE 372 TRIGGER 1,175 VIEW -------- ********** -------- 2,831 sum 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 785 JSR PACKAGE 785 PACKAGE BODY 3 SYNONYM 2,847 VIEW -------- ********** -------- 4,420 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,111 2 VIEW -------- ********** -------- 6,146 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 803 TRIGGER 21 TYPE 413 VIEW -------- ********** -------- 3,869 sum -------- -------- 156,132 19 =================================================== =================================================================================== == 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" ====================================================================== =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,458 INDEX 49,723 INDEX PARTITION 53 JOB 253 LOB 1 MATERIALIZED VIEW 3,106 PACKAGE 3,099 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,547 SYNONYM 7,854 TABLE 32,351 TABLE PARTITION 20,512 15 TRIGGER 262 TYPE 10,146 1 VIEW -------- ********** -------- 136,579 sum 17 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,269 SYNONYM 2 TABLE 372 TRIGGER 1,175 VIEW -------- ********** -------- 2,831 sum 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 785 JSR PACKAGE 785 PACKAGE BODY 3 SYNONYM 2,847 VIEW -------- ********** -------- 4,420 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,111 2 VIEW -------- ********** -------- 6,146 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 803 TRIGGER 21 TYPE 413 VIEW -------- ********** -------- 3,869 sum -------- -------- 156,132 19 ========================================================================== 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_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_BIU_PYEMPTIMSHT_TEMP DA TRIGGER DBT_I_IUD_SD#APIPRGSECBYPASS DA VIEW SD#APIPRGSECBYPASS =================================================================== DB=test A_TEST01 13-JUN-24 08.04.23.091448 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-017-2-HF-CL03-02c SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 f) -- ==================================================================================================== -- ====================================================================== -- 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 -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== Begin * ERROR at line 1: ORA-20666: NO-ERROR-CODEUnable to find Tenant "UJAMAA" ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104 ORA-06512: at "UIG.DBK_SA_INFO", line 428 ORA-06512: at line 2 drop table TMP_REPORTS_WITHIN_APPS * ERROR at line 1: ORA-00942: table or view does not exist --========================================================= -- Creating Temporary TABLES --========================================================= --========================================================= --PROCESSING table DA.REPORTS_WITHIN_APPS --====================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Get the current State of the Database -- ====================================================================== -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 f) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,458 INDEX 49,723 INDEX PARTITION 53 JOB 253 LOB 1 MATERIALIZED VIEW 3,106 PACKAGE 3,099 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,547 SYNONYM 7,855 TABLE 32,351 TABLE PARTITION 20,512 15 TRIGGER 262 TYPE 10,146 1 VIEW -------- ********** -------- 136,580 sum 17 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,269 SYNONYM 2 TABLE 372 TRIGGER 1,175 VIEW -------- ********** -------- 2,831 sum 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 785 JSR PACKAGE 785 PACKAGE BODY 3 SYNONYM 2,847 VIEW -------- ********** -------- 4,420 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,111 2 VIEW -------- ********** -------- 6,146 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 803 TRIGGER 21 TYPE 413 VIEW -------- ********** -------- 3,869 sum -------- -------- 156,133 19 =================================================== =================================================================================== == 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" ====================================================================== =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,458 INDEX 49,723 INDEX PARTITION 53 JOB 253 LOB 1 MATERIALIZED VIEW 3,106 PACKAGE 3,099 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,547 SYNONYM 7,855 TABLE 32,351 TABLE PARTITION 20,512 15 TRIGGER 262 TYPE 10,146 1 VIEW -------- ********** -------- 136,580 sum 17 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,269 SYNONYM 2 TABLE 372 TRIGGER 1,175 VIEW -------- ********** -------- 2,831 sum 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 785 JSR PACKAGE 785 PACKAGE BODY 3 SYNONYM 2,847 VIEW -------- ********** -------- 4,420 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,111 2 VIEW -------- ********** -------- 6,146 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 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 803 TRIGGER 21 TYPE 413 VIEW -------- ********** -------- 3,869 sum -------- -------- 156,133 19 ========================================================================== 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_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_BIU_PYEMPTIMSHT_TEMP DA TRIGGER DBT_I_IUD_SD#APIPRGSECBYPASS DA VIEW SD#APIPRGSECBYPASS =================================================================== DB=test A_TEST01 13-JUN-24 08.04.32.292465 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-017-2-HF-CL03-02c SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 f) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2485369_3.sql completed. Output in 2485369_3.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.85369 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: 5 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 473 | * 474 | ERROR at line 1: 475 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "UJAMAA" 476 | 475 | ORA-20666: NO-ERROR-CODEUnable to find Tenant "UJAMAA" 476 | 477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104 478 | ORA-06512: at "UIG.DBK_SA_INFO", line 428 476 | 477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104 478 | ORA-06512: at "UIG.DBK_SA_INFO", line 428 479 | ORA-06512: at line 2 477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104 478 | ORA-06512: at "UIG.DBK_SA_INFO", line 428 479 | ORA-06512: at line 2 480 | 483 | * 484 | ERROR at line 1: 485 | ORA-00942: table or view does not exist 486 | =============================== End of Installation Log Review ===============================