Kbase P20605: Running Update Statistics on table yields error 7721 when TPE_MM_BLOCKSIZE is set too high
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Running Update Statistics on table yields error 7721
MM- Fetching error (7721)
SQL Width is not the issue
TPE_MM_BLOCKSIZE environment variable set to 100
An SQL trace file was created with the following messages (note the first MM exception was repeated multiple times)
MM exception - status = -16003
MM exception - status = -16004
MM exception - status = -16024
Error in function ddm_set_stat_fld: ddm_build_hist failed , status = 4294951272
CAUSE:
TPE_MM_BLOCKSIZE was set too high
FIX:
Set TPE_MM_BLOCKSIZE to 32 or less