My Oracle Support Banner

Concurrent Request 'Gather Schema Statistics' Errors With ORA-20000: Unable to Analyze TABLE "APPS"."<object>", Insufficient Privileges or Does Not Exist (Doc ID 2354215.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Concurrent Processing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On E-Business Suite 12.1.3:


When attempting to run "Gather Schema Statistics",
the following error occurs.

ERROR
-----------------------
First Run:
------------

**Starts**12-JAN-2018 21:01:09
**Ends**13-JAN-2018 14:28:07
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 90 degree = 32 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=APPS.CMP3$305574***ORA-20000: Unable to analyze TABLE "APPS"."CMP3$305574", insufficient privileges or does not exist***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=APPS.CMP4$305574***ORA-20000: Unable to analyze TABLE "APPS"."CMP4$305574", insufficient privileges or does not exist***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

Second Run:
---------------

**Starts**19-JAN-2018 21:01:15
**Ends**20-JAN-2018 14:35:25
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 90 degree = 32 internal_flag= NOBACKUP
stats on table AQ$_WF_CONTROL_P is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=XLA.CMP4$460524***ORA-08103: object no longer exists***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "Gather Schema Statistics"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run "Gather Schema Statistics". This could result in loss of functionality and in turn, financial loss.

Changes

 No changes, N/A

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!


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