MSCDROPS: Error In Dropping Snapshots Process - During Data Collections (Doc ID 2056254.1)

Last updated on JANUARY 23, 2023

Applies to:

Symptoms

EBS Source version 12.2.4
VCP 12.2.4.1

Errors when running Data Collections program:

MSCDROPS: Error in Dropping Snapshots Process : ORA-20001: Error while executing:-DROP MATERIALIZED VIEW AHL.AHL_VISITS_SN(1): ORA-00933: SQL command not properly ended

MSRFWOR: Refresh Collection Snapshots
+---------------------------------------------------------------------------+

Current system time is 04-SEP-2015 07:15:37

+---------------------------------------------------------------------------+

**Starts**04-SEP-2015 07:15:37
**Ends**04-SEP-2015 07:16:37
User-Defined Exception
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
04-SEP 07:15:37 : The beginning of Refresh Snapshot
04-SEP 07:15:37 : Standalone RCS - no instance details
04-SEP 07:15:37 : ref mode - 2
04-SEP 07:15:37 : snp name - ALL SNAPSHOTS
04-SEP 07:15:37 : The degree of parallelism for Refreshing snapshots is set to: 0
04-SEP 07:15:37 : Request : 70575842 :Checks for Snapshots which have changed and Drops them
04-SEP 07:16:37 : Source Setup Objects Creation Requests did not complete Successfully
04-SEP 07:16:37 : Please check the Log files for the appropriate message:
04-SEP 07:16:37 : 70575842
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 :
04-SEP 07:16:37 : Error Setting Up Source Objects

Changes

 Applied VCP 12.2.4.1 patch to VCP instance only

Cause

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