Client home /u01/app/oracle/product/19.19/PROD
Start execution of command /opt/cm/v12/test/1_hotfix_test/24.89430_CLOUD_69750_install_1_install.sh
Client home /u01/app/oracle/product/19.19/PROD
You specified version v12
Installation started at: 2024-09-05 20:15:04
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/2489430_1.sql:
__________________________
Updating: /opt/cm/v12/test/sql/2489430_1.sql
- This is a new file, no information available on disk
- size (new file): 5743 bytes
- last modified (new file): 2024-09-04 10:24:06.0
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/tempPtfcompx.sql"
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/PTFCompX.sh
Running dir /opt/cm/v12/test/sql
The number of groups of SQL scripts 2
The group 0
entry Name Update:2489430_1.sql@sql
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/2489430_1.sql.sh to run 2489430_1.sql
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/2489430_1.sql.sh
Running dir /opt/cm/v12/test/sql
Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-09-05_20_15_05.279/2489430_1.sql.sh
Wait for procedure starts
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 5 20:15:23 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.89430, Work Item 1
-- ATGC cmic_report_writer credentials
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ======================================================================
-- Started 2489430_1.sql Output in 2489430_1.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,657 INDEX
56,973 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,157 PACKAGE
3,150 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,552 SYNONYM
8,023 TABLE
37,253 TABLE PARTITION
20,945 19 TRIGGER
266 TYPE
10,436 6 VIEW
-------- ********** --------
149,942 sum 26
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
1,314 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
2,923 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,894 VIEW
-------- ********** --------
4,492 sum
14 OWF_MGR EVALUATION CONTEXT
276 INDEX
52 LOB
151 PACKAGE
146 PACKAGE BODY
1 PROCEDURE
34 QUEUE
11 RULE
39 RULE SET
30 SEQUENCE
194 TABLE
4 TYPE
3 TYPE BODY
100 VIEW
-------- ********** --------
1,055 sum
1 REPORT_VIE PACKAGE
1 PACKAGE BODY
33 SYNONYM
6,323 35 VIEW
-------- ********** --------
6,358 sum 35
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
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
169,870 62
===================================================
===================================================================================
== Recompiling invalid objects for "da"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "dar"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "owf_mgr"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "uig"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "js80"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "jsr"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "jsd"
===================================================================================
======================================================================
== Re-compiling invalid objects for "cmic_bi"
======================================================================
======================================================================
== Re-compiling invalid objects for "FMWW"
======================================================================
start additional_compx.sql
2024-09-05 20:15:39
special list (before special recompiling)
2024-09-05 20:15:40
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-09-05 20:15:41
special list (after special recompiling)
2024-09-05 20:15:41
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,657 INDEX
56,973 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,157 PACKAGE
3,150 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,552 SYNONYM
8,023 TABLE
37,253 TABLE PARTITION
20,945 19 TRIGGER
266 TYPE
10,436 6 VIEW
-------- ********** --------
149,942 sum 26
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
1,314 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
2,923 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,894 VIEW
-------- ********** --------
4,492 sum
14 OWF_MGR EVALUATION CONTEXT
276 INDEX
52 LOB
151 PACKAGE
146 PACKAGE BODY
1 PROCEDURE
34 QUEUE
11 RULE
39 RULE SET
30 SEQUENCE
194 TABLE
4 TYPE
3 TYPE BODY
100 VIEW
-------- ********** --------
1,055 sum
1 REPORT_VIE PACKAGE
1 PACKAGE BODY
33 SYNONYM
6,323 35 VIEW
-------- ********** --------
6,358 sum 35
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
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
169,870 62
==========================================================================
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_EMP_AVAILFLT3_OBJSEQ
DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE
DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE
DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_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
DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI
DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI
DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW
DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW
DA VIEW UETD_SLC_ARTAXRDKRE_VIEW
DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW
DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW
DA VIEW UETD_SLC_TAXREFDKRE_VIEW
DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V
===================================================================
DB=test A_TEST01 05-SEP-24 08.15.43.242627 PM -04:00
Flag value=V
DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03f SVN Release
-- ====================================================================================================
-- Completed PTFCOMPX.sql (version R12 g)
-- ====================================================================================================
-- ======================================================================
-- Drop Obsolete Database Objects
-- ======================================================================
.
-- ====================================================================
-- SPECIAL NOTES
-- ====================================================================
- prompt -- Everything needs to be done in both
-- CloudR12Upg_PROD and CloudR12Upg_TEST
-- so when PROD is cloned to TEST,
-- TEST will continue to work.
- prompt .
-- ====================================================================================================
-- Create proxy users SCOTTBTEST on CloudR12Upg_TEST and CloudR12Upg_PROD
-- ====================================================================================================
.
begin
*
ERROR at line 1:
ORA-20000: SD-000152-ERRUser "ATSTRACK" already exists
ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
ORA-06512: at "DA.DBK_CMIC_REPORT_VIEWS", line 1526
ORA-06512: at line 26
.
-- ================================================================================
-- =====
-- ===== EXPECTING Exactly 4 Rows
-- =====
-- ===== SAC_CLIENT_ORASEQ SAC_CLIENT_CODE SAC_CLIENT_NAME
-- ===== =================== =============== ================================.
-- ===== VM8J3081GL285750 AMERICANTS American Track Services
-- ===== R0QIXDEAYI231328 ATGCTEST American Track Services
-- ===== KUKAP9D41O9I1177558 ATSTEST2 American Track Services
-- ===== LAS8NLF1QG286093 ATSTRACK American Track Services
-- ================================================================================
.
SAC_CLIENT_ORASEQ SAC_CLIENT_CODE SAC_CLIENT_NAME
------------------------------ ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VM8J3081GL285750 AMERICANTS American Track Services
R0QIXDEAYI231328 ATGCTEST American Track Services
KUKAP9D41O9I1177558 ATSTEST2 American Track Services
LAS8NLF1QG286093 ATSTRACK American Track Services
4 rows selected.
.
-- ================================================================================
-- =====
-- ===== EXPECTING Exactly 4 Rows
-- =====
-- ===== PROXY CLIENT
-- ===== ============ ================================.
-- ===== AMERICANTS CMIC_REPORT_WRITER
-- ===== ATGCTEST CMIC_REPORT_WRITER
-- ===== ATSTEST2 CMIC_REPORT_WRITER
-- ===== ATSTRACK CMIC_REPORT_WRITER
-- ================================================================================
.
PROXY CLIENT
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
AMERICANTS CMIC_REPORT_WRITER
ATGCTEST CMIC_REPORT_WRITER
ATSTEST2 CMIC_REPORT_WRITER
ATSTRACK CMIC_REPORT_WRITER
4 rows selected.
-- ======================================================================
-- Get the current 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,657 INDEX
56,973 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,157 PACKAGE
3,150 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,552 SYNONYM
8,023 TABLE
37,253 TABLE PARTITION
20,945 19 TRIGGER
266 TYPE
10,436 6 VIEW
-------- ********** --------
149,942 sum 26
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
1,314 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
2,923 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,894 VIEW
-------- ********** --------
4,492 sum
14 OWF_MGR EVALUATION CONTEXT
276 INDEX
52 LOB
151 PACKAGE
146 PACKAGE BODY
1 PROCEDURE
34 QUEUE
11 RULE
39 RULE SET
30 SEQUENCE
194 TABLE
4 TYPE
3 TYPE BODY
100 VIEW
-------- ********** --------
1,055 sum
1 REPORT_VIE PACKAGE
1 PACKAGE BODY
33 SYNONYM
6,323 35 VIEW
-------- ********** --------
6,358 sum 35
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
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
169,870 62
===================================================
===================================================================================
== Recompiling invalid objects for "da"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "dar"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "owf_mgr"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "uig"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "js80"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "jsr"
===================================================================================
===================================================================================
== Re-compiling invalid objects for "jsd"
===================================================================================
======================================================================
== Re-compiling invalid objects for "cmic_bi"
======================================================================
======================================================================
== Re-compiling invalid objects for "FMWW"
======================================================================
start additional_compx.sql
2024-09-05 20:15:58
special list (before special recompiling)
2024-09-05 20:15:59
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-09-05 20:16:00
special list (after special recompiling)
2024-09-05 20:16:00
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,657 INDEX
56,973 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,157 PACKAGE
3,150 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,552 SYNONYM
8,023 TABLE
37,253 TABLE PARTITION
20,945 19 TRIGGER
266 TYPE
10,436 6 VIEW
-------- ********** --------
149,942 sum 26
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
1,314 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
2,923 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,894 VIEW
-------- ********** --------
4,492 sum
14 OWF_MGR EVALUATION CONTEXT
276 INDEX
52 LOB
151 PACKAGE
146 PACKAGE BODY
1 PROCEDURE
34 QUEUE
11 RULE
39 RULE SET
30 SEQUENCE
194 TABLE
4 TYPE
3 TYPE BODY
100 VIEW
-------- ********** --------
1,055 sum
1 REPORT_VIE PACKAGE
1 PACKAGE BODY
33 SYNONYM
6,323 35 VIEW
-------- ********** --------
6,358 sum 35
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
153 INDEX PARTITION
74 LOB
153 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
53 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,868 sum
-------- --------
169,870 62
==========================================================================
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_EMP_AVAILFLT3_OBJSEQ
DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE
DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE
DA TRIGGER DBTI_UETD_INVRGCODEDFLT3_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
DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI
DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI
DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW
DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW
DA VIEW UETD_SLC_ARTAXRDKRE_VIEW
DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW
DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW
DA VIEW UETD_SLC_TAXREFDKRE_VIEW
DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V
===================================================================
DB=test A_TEST01 05-SEP-24 08.16.01.755518 PM -04:00
Flag value=V
DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03f SVN Release
-- ====================================================================================================
-- Completed PTFCOMPX.sql (version R12 g)
-- ====================================================================================================
-- ======================================================================
-- Turn Patch Flag OFF
-- ======================================================================
PL/SQL procedure successfully completed.
-- ======================================================================
-- 2489430_1.sql completed. Output in 2489430_1.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.89430 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: 4
---------CRITICAL ERRORS---------
---------WARNINGS---------
---------INFORMATIONAL ISSUES---------
474 | *
475 | ERROR at line 1:
476 | ORA-20000: SD-000152-ERRUser "ATSTRACK" already exists
477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
475 | ERROR at line 1:
476 | ORA-20000: SD-000152-ERRUser "ATSTRACK" already exists
477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
478 | ORA-06512: at "DA.DBK_CMIC_REPORT_VIEWS", line 1526
476 | ORA-20000: SD-000152-ERRUser "ATSTRACK" already exists
477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
478 | ORA-06512: at "DA.DBK_CMIC_REPORT_VIEWS", line 1526
479 | ORA-06512: at line 26
477 | ORA-06512: at "UIG.DBK_SYS_ERROR", line 1104
478 | ORA-06512: at "DA.DBK_CMIC_REPORT_VIEWS", line 1526
479 | ORA-06512: at line 26
480 |
===============================
End of Installation Log Review
===============================