Gather Schema Statistics Fails with: FDPSTP Failed Due To ORA-12899: Value Too Large For Column "<SCHEMA NAME>"."FND_STATS_HIST"."SCHEMA
(Doc ID 1905601.1)
Last updated on MAY 04, 2024
Applies to:
Oracle Concurrent Processing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
The gather statistics concurrent program fails with the following errors in the concurrent request logfile:
FNDGSCST module: Gather Schema Statistics
+---------------------------------------------------------------------------+
Current system time is 28-JUN-2014 19:00:46
+---------------------------------------------------------------------------+
**Starts**28-JUN-2014 19:00:47
ORACLE error 12899 in FDPSTP
Cause: FDPSTP failed due to ORA-12899: value too large for column "<SCHEMA NAME>"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
ORA-06512: at "APPS.FND_STATS", line 780
ORA-06512: at line 1
.
The SQL statement being exe
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL:20:8:NOBACKUP::LASTRUN:GATHER::Y percent= 10 degree = 24 internal_flag= NOBACKUP
ORA-12899: value too large for column "<SCHEMA NAME>"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDGSCST with request ID 7124699 to start at 05-JUL-2014 19:00:00 (ROUTINE=AFPSRS)
+---------------------------------------------------------------------------+
Current system time is 28-JUN-2014 19:00:46
+---------------------------------------------------------------------------+
**Starts**28-JUN-2014 19:00:47
ORACLE error 12899 in FDPSTP
Cause: FDPSTP failed due to ORA-12899: value too large for column "<SCHEMA NAME>"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
ORA-06512: at "APPS.FND_STATS", line 780
ORA-06512: at line 1
.
The SQL statement being exe
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL:20:8:NOBACKUP::LASTRUN:GATHER::Y percent= 10 degree = 24 internal_flag= NOBACKUP
ORA-12899: value too large for column "<SCHEMA NAME>"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDGSCST with request ID 7124699 to start at 05-JUL-2014 19:00:00 (ROUTINE=AFPSRS)
Changes
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 |
| Changes |
| Cause |
| Solution |