You can run dbtool at the database server:
Code:
dbtool [I]path-todatabase/databasename[/I]
Choose option 9: (export to file)
option 2: SQL width scan w/ fix option
then:
- 1 (number of threads depending on # cpu )
- Depending on version padding (I always choose 0 because I had some problems with value > 0 )
- all (all tables)
- all (all area's)
- 3 (verbose logging level, depending on what you want to see in the output)
Dbtool is a tool which corrects _field._width field.
In Progress fields are of indefinite length, this causes problems with SQL92. In SQL92 fields are
required to have fixed length. Normally Progress uses twice the display format as the value of _field._width this isn;t always sufficient. By running dbtool progress scnas the entire database for fields which exceed _field._width in length and adjusts _width accordingly.
You can also run it with option 1 then only the scan and no changes are made. If the table which gives the error is in the list then probably that is your problem.
On the other hand, verify as well that there are no extent fields in the table you are referencing. You can only reference array fields per field and not as a whole.
N.B.: If you use that particular database to create delta.df files then be aware that the delta.df shows more changes then you want after you ran dbtool
.
HTH,
Casper