Client home /u01/app/oracle/product/19.19/PROD
Start execution of command /opt/cm/v12/test/1_hotfix_test/24.82699_CLOUD_85064_install_1_install.sh
Client home /u01/app/oracle/product/19.19/PROD
You specified version v12
Installation started at: 2024-11-06 20:46:30
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.82699, has been installed 5 times on the application server while it is installed 0 times on the database!
- File: sql/2482699_15.sql:
___________________________
Updating: /opt/cm/v12/test/sql/2482699_15.sql
- This is a new file, no information available on disk
- size (new file): 10335 bytes
- last modified (new file): 2024-11-05 16:21:10.0
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/tempPtfcompx.sql"
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/PTFCompX.sh
Running dir /opt/cm/v12/test/sql
The number of groups of SQL scripts 2
The group 0
entry Name Update:2482699_15.sql@sql
Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/2482699_15.sql.sh to run 2482699_15.sql
File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/2482699_15.sql.sh
Running dir /opt/cm/v12/test/sql
Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-11-06_20_46_30.903/2482699_15.sql.sh
Wait for procedure starts
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 6 20:46: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.82699, Work Item 15
-- CMiC logon issue
-- ======================================================================
ERRORtput: No value for $TERM and no -T specified
USER is "DA"
test
USER is "DA"
test
USER is "DA"
test
-- ======================================================================
-- Started 2482699_15.sql Output in 2482699_15.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
17,841 INDEX
59,218 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,543 SYNONYM
18,226 TABLE
39,424 TABLE PARTITION
61,782 12 TRIGGER
270 TYPE
40,989 10 VIEW
-------- ********** --------
246,138 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,509 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,118 sum 1
230 JS80 INDEX
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 sum
6 JSD PACKAGE
6 PACKAGE BODY
1 SYNONYM
124 VIEW
-------- ********** --------
137 sum
799 JSR PACKAGE
799 PACKAGE BODY
2 SYNONYM
2,904 VIEW
-------- ********** --------
4,504 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
34,188 38 VIEW
-------- ********** --------
34,223 sum 38
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
390 VIEW
-------- ********** --------
543 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
135 INDEX PARTITION
74 LOB
135 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
47 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,826 sum
-------- --------
304,098 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-11-06 20:47:11
special list (before special recompiling)
2024-11-06 20:47:11
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-11-06 20:47:13
special list (after special recompiling)
2024-11-06 20:47:13
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
17,841 INDEX
59,218 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,543 SYNONYM
18,226 TABLE
39,424 TABLE PARTITION
61,782 12 TRIGGER
270 TYPE
40,989 10 VIEW
-------- ********** --------
246,138 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,509 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,118 sum 1
230 JS80 INDEX
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 sum
6 JSD PACKAGE
6 PACKAGE BODY
1 SYNONYM
124 VIEW
-------- ********** --------
137 sum
799 JSR PACKAGE
799 PACKAGE BODY
2 SYNONYM
2,904 VIEW
-------- ********** --------
4,504 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
34,188 38 VIEW
-------- ********** --------
34,223 sum 38
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
390 VIEW
-------- ********** --------
543 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
135 INDEX PARTITION
74 LOB
135 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
47 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,826 sum
-------- --------
304,098 62
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE
DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI
DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI
DA VIEW UETD_EMP_AVAILFLT3_FATVIEW
DA VIEW UETD_EMP_AVAILKOFX_FATVIEW
DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW
DA VIEW UETD_EMP_AVAILKOFX_VIEW
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 06-NOV-24 08.47.15.602833 PM -05:00
Flag value=V
DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05f 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
-- ======================================================================
-- ======================================================================
-- Install Views
-- ======================================================================
-- ======================================================================
-- Install Triggers
-- ======================================================================
-- ======================================================================
-- Install Package Bodies
-- ======================================================================
-- ======================================================================
-- Install or Update System Data
-- ======================================================================
-- ======================================================================
-- Update Data, Modify Table/Column Definitions
-- ======================================================================
-- ======================================================================
-- Data Correction Statements
-- ======================================================================
Start the timec invited users rollback
Start the timec invited users rollback for ANA.GUEVARA@TIMECRSC.COM
Enable the tenanted user TOG||GUEVARAA
Enable the tenanted user TOGTEST||AGUEVARA
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Start the timec invited users rollback for ANGELICA.CORONA@TIMEC.COM
Enable the tenanted user TOGMOCK||CORONAA
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
Enable the tenanted user TOGTEST||ACORONA
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
Enable the tenanted user TOG||CORONAA
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Start the timec invited users rollback for CONNER.CLEMENT@TIMEC.COM
Enable the tenanted user TOG||CLEMENTC
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Start the timec invited users rollback for LYDIA.KEITH@TIMECRSC.COM
Enable the tenanted user TOGTEST||LKEITH
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
Enable the tenanted user TOG||KEITHL
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Start the timec invited users rollback for SUZETT.SANCHEZ@TIMEC.COM
Enable the tenanted user TOG||SANCHEZSU
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Start the timec invited users rollback for VERONICA.DIAZ@TIMEC.COM
Enable the tenanted user TOGTEST||VDIAZ
ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
Enable the tenanted user TOG||RUELASV
ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
: : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1479
ORA-06512: at "SYS.DBMS_LDAP", line 709
Complete the timec 6 invited users rollback
-- ======================================================================
-- 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
17,841 INDEX
59,218 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,543 SYNONYM
18,226 TABLE
39,424 TABLE PARTITION
61,782 12 TRIGGER
270 TYPE
40,989 10 VIEW
-------- ********** --------
246,138 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,509 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,118 sum 1
230 JS80 INDEX
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 sum
6 JSD PACKAGE
6 PACKAGE BODY
1 SYNONYM
124 VIEW
-------- ********** --------
137 sum
799 JSR PACKAGE
799 PACKAGE BODY
2 SYNONYM
2,904 VIEW
-------- ********** --------
4,504 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
34,188 38 VIEW
-------- ********** --------
34,223 sum 38
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
390 VIEW
-------- ********** --------
543 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
135 INDEX PARTITION
74 LOB
135 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
47 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,826 sum
-------- --------
304,098 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-11-06 20:47:32
special list (before special recompiling)
2024-11-06 20:47:32
t_in1p=0 t_in2p=0 t_errp=0
.
t_in1d=0 t_in2d=0 t_errd=0
2024-11-06 20:47:34
special list (after special recompiling)
2024-11-06 20:47:34
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
17,841 INDEX
59,218 INDEX PARTITION
56 JOB
259 LOB
1 MATERIALIZED VIEW
3,161 PACKAGE
3,154 PACKAGE BODY
24 1 PROCEDURE
5 QUEUE
176 SEQUENCE
1,543 SYNONYM
18,226 TABLE
39,424 TABLE PARTITION
61,782 12 TRIGGER
270 TYPE
40,989 10 VIEW
-------- ********** --------
246,138 sum 23
3 DAR INDEX
1 LOB
4 PACKAGE
4 PACKAGE BODY
1 SEQUENCE
11,509 SYNONYM
2 TABLE
390 1 TRIGGER
1,204 VIEW
-------- ********** --------
13,118 sum 1
230 JS80 INDEX
20 INDEX PARTITION
22 LOB
1 SEQUENCE
2 SYNONYM
122 TABLE
20 TABLE PARTITION
5 TRIGGER
5 VIEW
-------- ********** --------
427 sum
6 JSD PACKAGE
6 PACKAGE BODY
1 SYNONYM
124 VIEW
-------- ********** --------
137 sum
799 JSR PACKAGE
799 PACKAGE BODY
2 SYNONYM
2,904 VIEW
-------- ********** --------
4,504 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
34,188 38 VIEW
-------- ********** --------
34,223 sum 38
8 REPORT_WRI INDEX
1 LOB
55 PACKAGE
55 PACKAGE BODY
1 PROCEDURE
7 SYNONYM
18 TABLE
8 TYPE
390 VIEW
-------- ********** --------
543 sum
1 UIG DATABASE LINK
3 EVALUATION CONTEXT
1,140 INDEX
135 INDEX PARTITION
74 LOB
135 LOB PARTITION
322 PACKAGE
320 PACKAGE BODY
6 QUEUE
30 RULE
36 RULE SET
15 SEQUENCE
39 SYNONYM
287 TABLE
47 TABLE PARTITION
800 TRIGGER
21 TYPE
415 VIEW
-------- ********** --------
3,826 sum
-------- --------
304,098 62
==========================================================================
Objects with errors
========== =================== ==============================
Owner Type Object
========== =================== ==============================
DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE
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_SCPRELIM6FA5_OBJSEQ
DA TRIGGER DBT_AUTO_COLD_STORE_1389320892
DA TRIGGER DBT_AUTO_COLD_STORE_1389363935
DA TRIGGER DBT_AUTO_COLD_STORE_2456605959
DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE
DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE
DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI
DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI
DA VIEW UETD_EMP_AVAILFLT3_FATVIEW
DA VIEW UETD_EMP_AVAILKOFX_FATVIEW
DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW
DA VIEW UETD_EMP_AVAILKOFX_VIEW
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 06-NOV-24 08.47.36.089666 PM -05:00
Flag value=V
DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05f SVN Release
-- ====================================================================================================
-- Completed PTFCOMPX.sql (version R12 g)
-- ====================================================================================================
-- ======================================================================
-- Turn Patch Flag OFF
-- ======================================================================
PL/SQL procedure successfully completed.
-- ======================================================================
-- 2482699_15.sql completed. Output in 2482699_15.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.82699 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: 38
---------CRITICAL ERRORS---------
---------WARNINGS---------
---------INFORMATIONAL ISSUES---------
509 | Enable the tenanted user TOG||GUEVARAA
510 | Enable the tenanted user TOGTEST||AGUEVARA
511 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
512 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
510 | Enable the tenanted user TOGTEST||AGUEVARA
511 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
512 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
513 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
511 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
512 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
513 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
514 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
512 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
513 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
514 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
515 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
513 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
514 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
515 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
516 | ORA-06512: at "SYS.DBMS_LDAP", line 709
514 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
515 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
516 | ORA-06512: at "SYS.DBMS_LDAP", line 709
517 | Start the timec invited users rollback for ANGELICA.CORONA@TIMEC.COM
517 | Start the timec invited users rollback for ANGELICA.CORONA@TIMEC.COM
518 | Enable the tenanted user TOGMOCK||CORONAA
519 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
520 | Enable the tenanted user TOGTEST||ACORONA
519 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
520 | Enable the tenanted user TOGTEST||ACORONA
521 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
522 | Enable the tenanted user TOG||CORONAA
521 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
522 | Enable the tenanted user TOG||CORONAA
523 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
524 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
522 | Enable the tenanted user TOG||CORONAA
523 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
524 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
525 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
523 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
524 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
525 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
526 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
524 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
525 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
526 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
527 | ORA-06512: at "SYS.DBMS_LDAP", line 709
525 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
526 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
527 | ORA-06512: at "SYS.DBMS_LDAP", line 709
528 | Start the timec invited users rollback for CONNER.CLEMENT@TIMEC.COM
528 | Start the timec invited users rollback for CONNER.CLEMENT@TIMEC.COM
529 | Enable the tenanted user TOG||CLEMENTC
530 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
531 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
529 | Enable the tenanted user TOG||CLEMENTC
530 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
531 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
532 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
530 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
531 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
532 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
533 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
531 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
532 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
533 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
534 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
532 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
533 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
534 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
535 | ORA-06512: at "SYS.DBMS_LDAP", line 709
533 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
534 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
535 | ORA-06512: at "SYS.DBMS_LDAP", line 709
536 | Start the timec invited users rollback for LYDIA.KEITH@TIMECRSC.COM
536 | Start the timec invited users rollback for LYDIA.KEITH@TIMECRSC.COM
537 | Enable the tenanted user TOGTEST||LKEITH
538 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
539 | Enable the tenanted user TOG||KEITHL
538 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
539 | Enable the tenanted user TOG||KEITHL
540 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
541 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
539 | Enable the tenanted user TOG||KEITHL
540 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
541 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
542 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
540 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
541 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
542 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
543 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
541 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
542 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
543 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
544 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
542 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
543 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
544 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
545 | ORA-06512: at "SYS.DBMS_LDAP", line 709
543 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
544 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
545 | ORA-06512: at "SYS.DBMS_LDAP", line 709
546 | Start the timec invited users rollback for SUZETT.SANCHEZ@TIMEC.COM
546 | Start the timec invited users rollback for SUZETT.SANCHEZ@TIMEC.COM
547 | Enable the tenanted user TOG||SANCHEZSU
548 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
549 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
547 | Enable the tenanted user TOG||SANCHEZSU
548 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
549 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
550 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
548 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
549 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
550 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
551 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
549 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
550 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
551 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
552 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
550 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
551 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
552 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
553 | ORA-06512: at "SYS.DBMS_LDAP", line 709
551 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
552 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
553 | ORA-06512: at "SYS.DBMS_LDAP", line 709
554 | Start the timec invited users rollback for VERONICA.DIAZ@TIMEC.COM
554 | Start the timec invited users rollback for VERONICA.DIAZ@TIMEC.COM
555 | Enable the tenanted user TOGTEST||VDIAZ
556 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
557 | Enable the tenanted user TOG||RUELASV
556 | ORA-20000: SD-000238-ERRUnable to disable user there were no entry found.
557 | Enable the tenanted user TOG||RUELASV
558 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
559 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
557 | Enable the tenanted user TOG||RUELASV
558 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
559 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
560 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
558 | ORA-20999: DBK_USER_MAINT.delete_fed_ldap_user.Delete entry in the ldap directory.
559 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
560 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
561 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
559 | : : ORA-31202: DBMS_LDAP: LDAP client/server error: No such object. Entry to be deleted not found.
560 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
561 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
562 | ORA-06512: at "SYS.DBMS_LDAP", line 709
560 | ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
561 | ORA-06512: at "SYS.DBMS_LDAP", line 1479
562 | ORA-06512: at "SYS.DBMS_LDAP", line 709
563 | Complete the timec 6 invited users rollback
===============================
End of Installation Log Review
===============================