GSS error R12

[satish]

Hi erman,

Gather Schema Statistics erroring out in erp r12.2.5, can u pls guide us to fix it.

Application Object Library: Version 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDGSCST: Gather Schema Statistics
Current system time is 05-MAR-2025 03:00:05
**Starts**05-MAR-2025 03:00:05
**Ends**05-MAR-2025 03:05:17
ORA-0000: normal, successful completion
Start of log messages from FND_FILE
+--
+-
--+
In GATHER_SCHEMA_STATS, schema_name= ALL percent= 10 degree = 8 internal_flag= NOBACKUP
stats on table WMS_WCS_AQ_QUEUE_TBL is locked
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=XXTTD.XXTTD_RMS_GL_STG_TBL***ORA-12801: error signaled in parallel query server P006, instance erpproddb2.ttd.com:prodcdb2 (2)*** +--
Error #1: ERROR: While GATHER_TABLE_STATS:
End of log messages from FND_FILE
+--
Successfully resubmitted concurrent program FNDGSCST with request ID 65211924 to start at 06-MAR-2025 03:00:00 (ROUTINE AFPSRS)
No completion options were requested.
Output file size:
e
Deleting empty output file.



object_name=XXTTD.XXTTD_RMS_GL_STG_TBL*** is custom table but what to  check is the query.
Thank you,
GD

[ErmanArslansOracleBlog]

Hi,

You can just get rid of that error using exec dbms_stats.unlock_table_stats('table_owner','table_name');

but, this is not expected.. Probably your codelevel/patchlevel - related to Gather stats is old.
Having the latest FND_STATS code is a good thing, and probably resolve this.. But again you have a workaround as a mentioned above. Review the references below;

Ref:

Gather Schema Stats Fails With FND_CP_GSM_IPC_AQTBL is Locked (Doc ID 2051321.1)
stats on table is locked and unable to purge (FND_STATS_HIST) table. (Doc ID 2828920.1)
Gather Schema Statistics Failed Due To Locks (Doc ID 2168100.1)