Kbase P128220: Missing columns when trying to add a table and copy columns in DB Navigator
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/12/2008 |
|
Status: Unverified
SYMPTOM(s):
Within the OpenEdge Architect DB Navigator, all columns are not shown for some tables when trying to add a table and copy columns.
Only the first few tables have the "+" symbol next to them to allow you to expand the tree to view the columns of the table.
If you close the window that lists the tables and columns to copy, and then reopen it, tables that had the tree expansion "+" symbol next to them no longer have the symbol.
FACT(s) (Environment):
Windows XP
OpenEdge 10.1B02 32-bit Service Pack
CAUSE:
Bug# OE00161644
CAUSE:
A property value (most likely the description field for a table or columns) contains too many characters and exceeds the SQL maximum length or precision.
FIX:
Upgrade to 10.1C or later.
If unable to upgrade, then the following to work around is available:
1.- Run the DBTOOL command.
2.- From the command line, navigate to the directory containing your database and then type DBTOOL <database-name>.
3.- Select '2. SQL Width Scan w/Fix Option' and follow the prompts to fix the SQL Width.