Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.89604_CLOUD_296535_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD Installation started at: 2024-10-21 14:13:36 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 Warning: Issue 24.89604, has been installed 7 times on the application server while it is installed 0 times on the database! Entryname Update:JSR_APCHK02.vw@uig/sql - File: uig/sql/JSR_APCHK02.vw: _______________________________ The new copy of the file "/opt/cm/v12/test/uig/sql/JSR_APCHK02.vw", shipped with the package, is different from the current copy on disk, and the file on disk has a newer timestamp! Updating: /opt/cm/v12/test/uig/sql/JSR_APCHK02.vw - size (on disk): 24426 bytes - last modified (on disk): 2024-10-16 14:10:26.0 -project (on disk): - version (on disk): - size (new file): 24388 bytes - last modified (new file): 2024-10-07 16:19:46.0 Warning: The file was not modified. - File: uig/sql/JSR_2489604_4.sql: __________________________________ The new copy of the file "/opt/cm/v12/test/uig/sql/JSR_2489604_4.sql", shipped with the package, is different from the current copy on disk, but the timestamps on both files are the same! Updating: /opt/cm/v12/test/uig/sql/JSR_2489604_4.sql - size (on disk): 2336 bytes - last modified (on disk): 2024-10-07 16:27:12.0 - size (new file): 2396 bytes - last modified (new file): 2024-10-07 16:27:12.0 Warning: The file was not modified. db=test Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:JSR_2489604_4.sql@uig/sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/JSR_2489604_4.sql.sh to run JSR_2489604_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/JSR_2489604_4.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-21_14_13_38.007/JSR_2489604_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 21 14:14:00 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.89604, Work Item 4 -- BOA Check Format -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test Connected. -- ====================================================================== -- Started JSR_2489604_4.sql Output in JSR_2489604_4.lst -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ==================================================================================================== -- Started JSR_APCHK02.vw -- ==================================================================================================== ================================================================= Creating view JSR_APCHK02 ================================================================= No errors. ================================================================= Creating view JSR_APCHK02_DETAILS ================================================================= No errors. ================================================================= CREATING VIEW JSR.ALL_CHK_DETAILS_TEMP_V ================================================================= Warning: View created with compilation errors. Errors for VIEW JSR.ALL_CHK_DETAILS_TEMP_V: 0/0 ORA-01730: invalid number of column names specified GRANT ALL ON JSR.ALL_CHK_DETAILS_TEMP_V TO CMIC_ROLE_ALL * ERROR at line 1: ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors GRANT ALL ON JSR.ALL_CHK_DETAILS_TEMP_V TO UIG * ERROR at line 1: ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors GRANT ALL ON JSR.ALL_CHK_DETAILS_TEMP_V TO DAR * ERROR at line 1: ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors ================================================================= CREATING VIEW JSR.APCHK02_DETAIL ================================================================= Warning: View created with compilation errors. Errors for VIEW JSR.APCHK02_DETAIL: 0/0 ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 0/0 ORA-54039: table must have at least one column that is not invisible GRANT ALL ON JSR.APCHK02_DETAIL TO CMIC_ROLE_ALL * ERROR at line 1: ORA-04063: view "JSR.APCHK02_DETAIL" has errors GRANT ALL ON JSR.APCHK02_DETAIL TO UIG * ERROR at line 1: ORA-04063: view "JSR.APCHK02_DETAIL" has errors GRANT ALL ON JSR.APCHK02_DETAIL TO DAR * ERROR at line 1: ORA-04063: view "JSR.APCHK02_DETAIL" has errors -- ==================================================================================================== -- Finished JSR_APCHK02.vw -- ==================================================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- JSR_2489604_4.sql completed. Output in JSR_2489604_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 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.89604 was successfully installed, but with warnings. 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: 9 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 136 | Errors for VIEW JSR.ALL_CHK_DETAILS_TEMP_V: 137 | 138 | 0/0 ORA-01730: invalid number of column names specified 139 | GRANT ALL ON JSR.ALL_CHK_DETAILS_TEMP_V TO CMIC_ROLE_ALL 140 | * 141 | ERROR at line 1: 142 | ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 143 | 146 | * 147 | ERROR at line 1: 148 | ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 149 | 152 | * 153 | ERROR at line 1: 154 | ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 155 | 163 | Errors for VIEW JSR.APCHK02_DETAIL: 164 | 165 | 0/0 ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 166 | 0/0 ORA-54039: table must have at least one column that is not 164 | 165 | 0/0 ORA-04063: view "JSR.ALL_CHK_DETAILS_TEMP_V" has errors 166 | 0/0 ORA-54039: table must have at least one column that is not 167 | invisible 170 | * 171 | ERROR at line 1: 172 | ORA-04063: view "JSR.APCHK02_DETAIL" has errors 173 | 176 | * 177 | ERROR at line 1: 178 | ORA-04063: view "JSR.APCHK02_DETAIL" has errors 179 | 182 | * 183 | ERROR at line 1: 184 | ORA-04063: view "JSR.APCHK02_DETAIL" has errors 185 | =============================== End of Installation Log Review ===============================