Kbase P4933: Update schema holder skips over fields that are newly added in the Oracle Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/09/2008 |
|
Status: Verified
SYMPTOM(s):
Update schema holder skips over some of the fields that were created in the oracle database after the schema holder was created
Deleting from the schema holder and re-pulling the table back skips over those particular fields
Deleting and re-creating the schema holder still skips those fields
FACT(s) (Environment):
Oracle DataServer
Progress 9.1x
CAUSE:
When updating a schema holder, progress is only looking at the existing fields for any updates (modification or deletion) but not looking at the newly added fields in the oracle database . This is a known issue with Progress and will be fixed in the future release.
FIX:
Upgrade to Progress 9.1E or later
Or,
if upgrade is not possible use the following steps to workaround the problem:
1. Dump the table definition (df).
2. Manually add the missing fields.
3. Delete the tables.
4. Re-load the df.
After following the above steps, perform Add/Update schema holder. This will fix the fields for further discrepancies to match in oracle database.