Kbase P113032: MS SQL server - Dictionary code change in OE causes errors during schema pull of table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2009 |
|
Status: Verified
SYMPTOM(s):
Error during schema pull of table
ERROR: Table table_name has unsupported data types. Skipping this table..."
The table is not pulled into schema holder
FACT(s) (Environment):
MS SQL DataServer
OpenEdge 10.x
The above error is written to ds_upd.e file
There are uniqueidentifier fields in the table defined in SQL server
In Progress version 9, the same table can be pulled into schema holder
CAUSE:
Uniqueidentifier fields are not supported by Progress.
In Progress version 9, we built the table even if we had detected the unsupported data type. You would have problems working with this table at runtime.
In OpenEdge 10, the Data Dictionary will error out during the schema pull when we detect the unsupported data types rather than waiting until you ran code at runtime.
FIX:
Expected behavior.
There are two workarounds to this problem documented in solution 21636, "Workaround: MS SQL unsupported data type uniqueidentifier"