Kbase P135148: DB Navigator complains about SQL Width violations in Schema elements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/09/2008 |
|
Status: Unverified
SYMPTOM(s):
DB Navigator complains about SQL Width violations in Schema elements
A column property value (most likely the description field) for the selected table contains too many character, exceeding the SQL maximum length or precision
FACT(s) (Environment):
Windows 32 Intel
OpenEdge 10.1x
CAUSE:
When migrating an application to OpenEdge Architect and assuming use of the DB Navigator tool to take over DDL tasks you may be confronted with the error "A column property value (most likely the description field) for the selected table contains too many character, exceeding the SQL maximum length or precision". This error indicates that there is some table or field in your database which has a property that exceeds SQL width.
FIX:
As the latter part of the message suggests running the dbtool utility with option 2 should fix all SQL Width issues.