Kbase P91345: Inserting new record in Oracle table fails after oracle_db.df and delta.sql loaded
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1D
SYMPTOM(s):
Inserting new record in Oracle table fails after oracle_db.df and delta.sql loaded
oracle_db.df and delta.sql generated from a delta.df by Schema Migration Tools
ORACLE error -1840 see "ORACLE Error Messages and Codes Manual". (1252)
** input value not long enough for date format
new index added on VARCHAR2 column "new_col"
Date column just before U##NEW_COL
foreign-position set wrongly for VARCHAR2 column
CAUSE:
Bug# 20030429-005
FIX:
As the bug is fixed in 9.1D07, you might choose to
1. Restore backup
2. Install 9.1D07
3. Rerun the migration
Otherwise, you solve the problem by loading a new delta.df containing, for the sample given:
UPDATE DATABASE "oracle_db"
UPDATE FIELD "NEW_COL" OF "XXXX"
SHADOW-COL "189"
FIELD-MISC15 189