|
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
|