My Oracle Support Banner

MFT 12c Snapshot Table Not Getting Dropped If Purge Script IS Run With No Records To Be Purged (Doc ID 2016787.1)

Last updated on FEBRUARY 02, 2019

Applies to:

Oracle Managed File Transfer - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

On MFT 12.1.3.0.0
When running purge script and there are no records to purge, it will create Snapshot tables (MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId}) with empty values and its not got dropped by the purge script.

ACTUAL BEHAVIOR  
---------------
After running the purge script with no records purged, tables MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId} are created and not dropped after purge ends

EXPECTED BEHAVIOR
-----------------------
Tables MFT_PURGE_MESSAGE_INFO_{BatchId} and MFT_PURGE_PAYLOAD_INFO_{BatchId} should be deleted when purge ends

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to $MIDDLEWARE_HOME/mft/common/bin directory and run ./wlst.sh
2. Connect using --> connect("<USERID>", "", "t3://:")
3. Run purgeInstanceData()
4. Check in _MFT schema mentioned tables are not deleted

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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