OMFT Purge Schdule Is Failing Everytime (Doc ID 2972823.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Symptoms

In MFT prod and non-prod environments, purge is failing everytime with below error message


ERROR
-----------------------

[2023-06-02T16:31:06.040+00:00] [XXXXXXXXXX_server_2] [ERROR] [] [oracle.mft.ENGINE] [tid: ESS Execute Thread [RequestId:XXXXXXXX]] [userId: XXXXXXX] [e cid: XXXXXXXXXXXXXXXXXXXXXXXXXXX] [APP: mft-app] [partition-name: DOMAIN] [tenant-name: GLOBAL] [ESS_JobMetadataID: JobDefinition:/ /oracle/apps/ess/seeded/mft/MFT_OTHER_JOB] [ESS_RequestID: XXXXXX] [FlowId: XXXXXXXXXXXXXXX] [ESS_Module: Processor] Purge instance data operation failed[[
7677 javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20210201-5edd0eb): org.eclipse.persistence.e xceptions.DatabaseException
7678 Internal Exception: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
7679 ORA-06512: at "XXXXXXX_MFT.MFT_PURGE_CAPTURE_SNAPSHOT", line 243
7680 ORA-06512: at "XXXXXX_MFT.MFT_PURGE_CAPTURE_SNAPSHOT", line 144
7681
7682 Error Code: 6502
7683 Call: CALL MFT_Purge_Capture_Snapshot (?, ?, ?, ?, ?, ?, ?)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.