E-ES: Full Index Build fails with ORA-01555: on DELETE FROM PSAPMSGPUBDATA WHERE EXISTS
Last updated on JUNE 22, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.56 [Release 8.4]
Information in this document applies to any platform.
On : 8.55 version, Search Framework
Full Index No Success.
The process went for more than 2.5 hours and gave below error.
SQL error. Function: SQLExec Error Position: 0 Return: 1555 - ORA-01555: snapshot too old: rollback segment number 5 with name "_SYSSMU5_7508024 73$" too small Statement: DELETE FROM PSAPMSGPUBDATA WHERE EXISTS (SELECT '*' FROM PSAPMSGARCHTMP2 B, PSAPMSGSUB CON C WHERE (PSAPMSGPUBDATA.IBTRANSACTIONID = C.CANONICALTRSFRMID OR PSAPMSGPUBDATA.IBTRANSACTIONID = C.IBTRANSACTIONID) AND B.IBTRANSACTIONID = C.IBPUBTRANSACTID) Original Statement: DELETE FROM PSAPMSGPUBDATA WHERE EXISTS (SELECT '*' FROM PSAPMSGARCHTMP2 B, P SAPMSGSUBCON C WHERE (PSAPMSGPUBDATA.IBTRANSACTIONID = C.CANONICALTRSFRMID OR PSAPMSGPUBDATA.IBTRANS
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms