Kbase P4439: Errors 1461 & 4212 occurs on running any 4GL statement after an incremental.df is loaded
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Oracle DataServer
SYMPTOM(s):
Errors 1461 & 4212 occurs when running any 4GL statement
Schema holder does not match database schema -- file field . (1461)
A column in this row being inserted or updated is too large (4212)
CHANGE:
An Incremental/delta.df was loaded. Changes includes an addition of a field and index with DESC components
CAUSE:
Bug# 20020702-013
CAUSE:
Example of the problem and how it unfolds:
Notice that that last field of the schema, PROGRESS-RECID, has FOREIGN-POS of 253
ADD TABLE "cont" TYPE ORACLE
AREA "Schema Area"
LABEL "Container"
DESCRIPTION "Container Table"
DUMP-NAME "cont"
FOREIGN-NAME "CONT"
FOREIGN-OWNER "CONT"
FOREIGN-TYPE "TABLE"
PROGRESS-RECID 253
When new field (CONT_REF) is added, notice that FOREIGN-POS is 254. This is accruate as the value is in sequence, 253, next 254.
ADD FIELD "cont-ref" OF "cont" AS character
FOREIGN-NAME "CONT_REF"
DESCRIPTION "Unique comm. ref"
FORMAT "X(15)"
FOREIGN-POS 254
FOREIGN-TYPE "VARCHAR2"
FIELD-MISC13 15
FIELD-MISC14 1
FOREIGN-MAXIMUM 15
POSITION 45
INITIAL ""
HELP "Unique comm. ref"
LABEL "Unique comm. ref"
COLUMN-LABEL "Unique comm. ref"
CAN-READ "*"
CAN-WRITE "*"
ORDER 560
NULL-ALLOWED
NOT-CASE-SENSITIVE
However, position of the hidden field, SHADOW-COL, is marked as 264.
UPDATE FIELD "cont-ref" OF "cont"
SHADOW-COL "264"
FIELD-MISC15 264
The mismatch of schema is caused by the hidden field for the DESC being counted as a field so that the newly added field has the wrong position.
FIX:
Issue has been fixed in Progress Service Pack 9.1D01