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 OCTOBER 25, 2016

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("weblogic", "", "t3://:")
3. Run purgeInstanceData()
4. Check in _MFT schema mentioned tables are not deleted

Cause

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