Kbase P112406: Oracle Dsrv: Errors 2720 and 4507 after new index added via delta.df/delta.sql
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
Oracle DataServer
SYMPTOM(s):
Getting error 2720 and 4507 when doing a simple 4GL statement
Fail to compare ORACLE schema; file <file-name> counted num flds: <count> fildes: <count>. (2720)
Fail to compare ORACLE schema; file <user.file-name> counted num flds: <count1> fildes: <count2>. (2720)
RECIDFLG set; fldinfo count: <number>. (4507)
CHANGE:
Files delta.df/delta.sql were loaded into schema holder and ORACLE, new index was added on a none case sensitive character field
CAUSE:
This is a known issue being investigated by Development. SHADOW-COL and FIELD-MISC15 for the character field have been wrongly valued within the .df generated.
FIX:
1. Find which u##columnY within Oracle table "user.file-name" has position "count2" from within error
Fail to compare ORACLE schema; file <user.file-name> counted num flds: <count1> fildes: <count2>. (2720)
2. Find within the schema holder
- which file <fileX> has FOREIGN-NAME "file-name"
- which field <fieldY> OF <fileX> has FOREIGN-NAME "columnY"
and create a "rectify.df" file with the following:
UPDATE DATABASE "<Oracle_DB>"
UPDATE FIELD "<fieldY>" OF "<fileX>"
SHADOW-COL "<count2>"
FIELD-MISC15 <count2>
3. Load "rectify.df" in the schema holder