Kbase P96710: dbtool reports 2 sql width errors against sports2000 database in 9.1D09 and 9.1E
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/08/2010 |
|
Status: Verified
SYMPTOM(s):
dbtool when ran against a copy of the sports2000 database reports 2 SQL width errors.
2 errors reported on _Field table
Current max fieldLen for _Field (-2):
Fld# SQLWidth Max Width ERROR
---- -------- --------- -----
7: 60 66 ***
42: 100 113 ***
One schema record, label string length is larger than the width defined for field _label
Another record is an application record. _string length of view-as for field Rating in table Feedback is larger than the width defined for it
Steps to Reproduce:
1. cd /tmp
2. prodb db1 sports2000
3. dbtool db1
4. Select option 9 to record logging
5. Select 0 for single user
6. Select option 1 to report SQL width issues
7. Enter all for table number
8. Enter all for area number
9. Set verbose level for 3
10. When completed, look at dbtool.out in current working directory and search for ***. You will see the errors mentioned above for the table
_Field
FACT(s) (Environment):
Progress 9.1D09
Progress 9.1E
CAUSE:
Bug# OE00109663
FIX:
Workaround:
Use dbtool and select menu option 2. SQL Width Scan w/Fix Option to detect SQL width problem and fix it.
Upgrade to 10.0A or later.