Kbase P94825: field1 in table1 had a change to FORMAT which was not passed to the df file and no ALTER TABLE state
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/19/2008 |
|
Status: Verified
SYMPTOM(s):
Errors recorded in .e file after running delta SQL progress to Oracle / MS SQL utility
field1 in table1 had a change to FORMAT which was not passed to the df file and no ALTER TABLE statement was created to change field size.
These messages are not seen when running delta utility in Progress 9 lower than 9.1E
FACT(s) (Environment):
Oracle DataServer
MS SQL DataServer
Progress 9.1E
OpenEdge 10.0A
OpenEdge 10.0B
All Supported Operating Systems
OpenEdge 10.1x
CAUSE:
This is informational message, they do not indicate errors. Proto tool converts Progress data types to corresponding foreign data types according to the Format definition during an initial proto session (option "Progress DB to ..") . Delta SQL Progress to Oracle / SQL server ignores the Format change over existing fields.
These messages are newly added for OpenEdge, in 9.1E, even we do not make changes over format, the .e does not record this fact.
FIX:
If you'd like to migrate the change to Oracle and schema holder, make manual changes in the generated delta SQL file, load the delta SQL into Oracle, then migrate the change to schema holder.
There are two ways to accomplish it:
1. Manually edit the delta.sql file to change the size of the field, load the sql into Oracle
2. Connect to both schema holder and modified Oracle database. Use Add/update table definitions utility to update the affected tables
3. Connect to original Progress database and schema holder, run Adjust Schema utility against affected tables.
or
1. Manually edit the delta.sql file to change the number field, load the sql into Oracle
2. Recreate an empty database, do a complete schema pull of all the tables from Oracle
3. Connect to original progress database and schema holder, Adjust Schema against all the tables.