Cleanup failed..

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Cleanup failed..

satish
Hi erman,

Cleanup phase failed with below error.Any suggestion please.

Running cleanup in FULL mode.
Log: @ADZDSHOWLOG.sq| "2022/10/06
11:07:49"
Statement Handler Error Code: 600
Statement Handler Error Message: ORA-00600: internal error code, arguments: [kq|chg-parent-not-pinned], [XXTTD_EMP_INT_PKG], [PER_PERSON _TYPES], 01, 01, 01, 01, 01, O, O, D], []
ORA-06512: at "SYS.DBMS_SQL", line 1163
ORA-06512: at "SYS.AD_ZD_SYS", line 263
ORA-06512: at "APPS.AD_ZD", line 447
ORA-06512: at "APPS.AD_ZD", line 960
ORA-06512: at line 3 (DBD ERROR:
OCIStmtExecute)
Reference of statement-handler is valid, not attempting database reconnect.
Failed to execute SQL statement:
begin
execute immediate 'alter session set
DDL_LOCK_TIMEOUT = 600';
ad_zd.cleanup('FULL');
end;
Error Message:
ORA-00600: internal error code, arguments:
[kqlchg-parent-not-pinned],
[XXTTD_EMP_INT_PKG],
[PER_PERSON _TYPES], 01, 01, 01, 01, 01, O, O, D], []
ORA-06512: at "SYS.DBMS_SQL", line 1163
ORA-06512: at "SYS.AD_ZD_SYS", line 263
ORA-06512: at "APPS.AD_ZD", line 447
ORA-06512: at "APPS.AD_ZD", line 960
ORA-06512: at line 3 (DBD ERROR:
OCIStmtExecute) [UNEXPECTED]Error occurred calling cleanup PL/SQL API.


Thanks,
Satish
Reply | Threaded
Open this post in threaded view
|

Re: Cleanup failed..

satish
Running utlrp.sql also returns these errors.
We are on R12.2.5
Database version 12.1.0.2
Reply | Threaded
Open this post in threaded view
|

Re: Cleanup failed..

ErmanArslansOracleBlog
Administrator
Please see MOS doc -> ORA-600[KQLCHG-PARENT-NOT-PINNED] Running UTLRP After Applied OCT2021 PSU (Doc ID 2830398.1)

2 alternative solutions;

(Upgrade to DB version 12.2.0.1 with latest release update. OR Apply interim patch for Bug 21467695 -> Patch 21467695 for 12.1.0.2 which is available in MOS. )