Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.84913_CLOUD_213630_install_2_install.sh Client home /u01/app/oracle/product/19.19/PROD Installation started at: 2024-07-15 20:03:54 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.84913, has been installed 7 times on the application server while it is installed 3 times on the database! Entryname Update:JSR_JBPB_U10.vw@UIG/SQL - File: UIG/SQL/JSR_JBPB_U10.vw: ________________________________ Updating: /opt/cm/v12/test/UIG/SQL/JSR_JBPB_U10.vw - size (on disk): 217916 bytes - last modified (on disk): 2024-07-02 12:55:20.0 -project (on disk): - version (on disk): - size (new file): 218361 bytes - last modified (new file): 2024-07-12 12:20:02.0 - File: UIG/SQL/JSR_2484913_11.sql: ___________________________________ Updating: /opt/cm/v12/test/UIG/SQL/JSR_2484913_11.sql - This is a new file, no information available on disk - size (new file): 2482 bytes - last modified (new file): 2024-07-15 13:31:38.0 db=test Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:JSR_2484913_11.sql@UIG/SQL Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/JSR_2484913_11.sql.sh to run JSR_2484913_11.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/JSR_2484913_11.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-15_20_03_55.476/JSR_2484913_11.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 15 20:04:13 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.84913, Work Item 11 -- Progress Billing Forms Modificatrions -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test Connected. -- ====================================================================== -- Started JSR_2484913_11.sql Output in JSR_2484913_11.lst -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ==================================================================================================== -- Started: JSR_JBPB_U10.vw -- ==================================================================================================== -- ================================================================================ -- jsr.JSR_JBPB_U10_PREV_CHG_SUB -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_jbpb_u10_chg_sub -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_jbpb_u10_cont_det_sub -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JFPBD_CONT_DET_BUYOUT -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_SC_DET -- ================================================================================ No errors. -- ================================================================================ -- jsr.JBPB_C10_BODY_DET -- ================================================================================ No errors. -- ================================================================================ -- jsr.JBPB_PCI_DET -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_Comp_Remit_Address -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_REQUISITION_DETAIL -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_jbpbc12_det_sub -- ================================================================================ No errors. -- ================================================================================ -- jsr.jbpbstd_cont_all_chgord_det2 -- ================================================================================ No errors. -- ================================================================================ -- jsr.jbpbstd_cont_all_chgord_det -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPCI_DET_BILLING -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_jbpb_u10 -- ================================================================================ Warning: View created with compilation errors. Errors for VIEW JSR.JSR_JBPB_U10: 0/0 ORA-00904: "JBPBSM_SHOW_TAX2_REGISTRATION": invalid identifier grant select on jsr.JSR_jbpb_u10 to da * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_U10" has errors grant select on jsr.JSR_jbpb_u10 to dar * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_U10" has errors grant select on jsr.JSR_jbpb_u10 to uig * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_U10" has errors -- ================================================================================ -- jsr.JSR_JBPB_PYTRADES -- ================================================================================ Warning: View created with compilation errors. Errors for VIEW JSR.JSR_JBPB_PYTRADES: 0/0 ORA-04063: view "JSR.JSR_JBPB_U10" has errors GRANT SELECT ON jsr.JSR_JBPB_PYTRADES TO DA * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors GRANT SELECT ON jsr.JSR_JBPB_PYTRADES TO DAR * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors GRANT SELECT ON jsr.JSR_JBPB_PYTRADES TO UIG * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors -- ================================================================================ -- jsr.JSR_JBPB_CONTDET_REIMB_EXP -- ================================================================================ No errors. -- ================================================================================ -- jsr.jbpbstd_cont_chgord_per_draw -- ================================================================================ No errors. -- ================================================================================ -- jsr.jbpbstd_cont_co_per_draw_m -- ================================================================================ No errors. -- ================================================================================ -- jsr.jbpbstd_cont_pcidetbilling -- ================================================================================ No errors. -- ================================================================================ -- jsr.JBPBSTD_CONT_PCIDETBILL_M -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_C11_BODY_SUB_PCI -- ================================================================================ -- ================================================================================ -- jsr.jbpbstd_cont_co_per_draw_all -- ================================================================================ No errors. -- ================================================================================ -- jsr.JBPBSTD_CONT_PCIDETBILL_MAIN -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_U10_CONT_DET_MAIN -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JB_OCO_PCIDET_SUB : This view gives the pci detail of the owner change code for all draws. -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JFPBD_CONT_DET_SUMMARY : Created for cloud AGP client custom invoice 20.32158 -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JFPBD_CONT_DET_SUMMARY_V2 : Created for cloud AGP client custom invoice 20.32158 -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_WAIVER : Created for MOSAIC 21.38322 -- ================================================================================ Warning: View created with compilation errors. Errors for VIEW JSR.JSR_JBPB_WAIVER: 0/0 ORA-04063: view "JSR.JSR_JBPB_U10" has errors grant select on jsr.JSR_JBPB_WAIVER to da * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors grant select on jsr.JSR_JBPB_WAIVER to dar * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors grant select on jsr.JSR_JBPB_WAIVER to uig * ERROR at line 1: ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors -- ================================================================================ -- jsr.jsr_jbcont_det_nonpci -- ================================================================================ No errors. -- ================================================================================ -- jsr.JSR_JBPB_HOLDBACK_INV -- ================================================================================ No errors. -- ================================================================================ -- jsr.jsr_JBPB_PY_SUMMARY -- ================================================================================ -- ================================================================================ -- jsr.jsr_JBPB_PY_SUMMARY_MAIN -- ================================================================================ -- ================================================================================ -- JSR.JSR_JBPB_U10_C3G -- ================================================================================ No errors. -- ================================================================================ -- Completed: JSR_JBPB_U10.vw -- ================================================================================ -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- JSR_2484913_11.sql completed. Output in JSR_2484913_11.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 The following invalid objects were created after this installation: =================================================================== JSR VIEW JSR_JBPB_PYTRADES JSR VIEW JSR_PJ_JBPBINV_WAIVER JSR VIEW JSR_PJ_JBPBINV JSR VIEW JSR_JBPB_U10 JSR VIEW JSR_JBPB_WAIVER *** end of new invalid object *** deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.84913 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 1 Warning Errors: 0 Informative Errors: 12 ---------CRITICAL ERRORS--------- 319 | The following invalid objects were created after this installation: 320 | =================================================================== 321 | JSR VIEW JSR_JBPB_PYTRADES 322 | JSR VIEW JSR_PJ_JBPBINV_WAIVER 323 | JSR VIEW JSR_PJ_JBPBINV 324 | JSR VIEW JSR_JBPB_U10 325 | JSR VIEW JSR_JBPB_WAIVER ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 169 | 170 | Errors for VIEW JSR.JSR_JBPB_U10: 171 | 0/0 ORA-00904: "JBPBSM_SHOW_TAX2_REGISTRATION": invalid identifier 172 | grant select on jsr.JSR_jbpb_u10 to da 173 | * 174 | ERROR at line 1: 175 | ORA-04063: view "JSR.JSR_JBPB_U10" has errors 176 | 179 | * 180 | ERROR at line 1: 181 | ORA-04063: view "JSR.JSR_JBPB_U10" has errors 182 | 185 | * 186 | ERROR at line 1: 187 | ORA-04063: view "JSR.JSR_JBPB_U10" has errors 188 | 195 | 196 | Errors for VIEW JSR.JSR_JBPB_PYTRADES: 197 | 0/0 ORA-04063: view "JSR.JSR_JBPB_U10" has errors 198 | GRANT SELECT ON jsr.JSR_JBPB_PYTRADES TO DA 199 | * 200 | ERROR at line 1: 201 | ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors 202 | 205 | * 206 | ERROR at line 1: 207 | ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors 208 | 211 | * 212 | ERROR at line 1: 213 | ORA-04063: view "JSR.JSR_JBPB_PYTRADES" has errors 214 | 268 | 269 | Errors for VIEW JSR.JSR_JBPB_WAIVER: 270 | 0/0 ORA-04063: view "JSR.JSR_JBPB_U10" has errors 271 | grant select on jsr.JSR_JBPB_WAIVER to da 272 | * 273 | ERROR at line 1: 274 | ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors 275 | 278 | * 279 | ERROR at line 1: 280 | ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors 281 | 284 | * 285 | ERROR at line 1: 286 | ORA-04063: view "JSR.JSR_JBPB_WAIVER" has errors 287 | =============================== End of Installation Log Review ===============================