Kbase P8469: Update Statistics generates MM- Fetching error (7721)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
SYMPTOM(s):
Running Update Statistics on table yields error 7721
MM- Fetching error (7721)
Select * from table can yield if using Green Threads
Error Code: 210012
SQL STATE: 22P00
Column <column> in table <table> has value exceeding it max length
or precision.
Select * from table can yield if using Native Threads
Native: -210012
SQL State: S1000
Column <column> in table <table> has value exceeding it max length
or precision.
CAUSE:
While performing an update statistics operation on a SQL92 table the MM-Fetch error might occur.
This has been seen to be caused by problems with SQL Width for fields within the table.
When a select * from <table> is performed it revealed the true problem which is the SQL Width is not correctly defined.
Some operations, such as Update Statistics, may put information in the database log file which lists the table that contains a record that has a SQL Width problem on one of its fields.
Example:
Progress/SQL Update Statistics:Table PUB."tablename" at Rowid 0000387843 has Column record whose value exceeding its max length or precision (9378)
FIX:
Redefine the SQL Width