Kbase P83857: Can not insert record to a SQL server table that has identity column
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/19/2008 |
|
Status: Verified
SYMPTOM(s):
Can not insert record to a table that has identity column
Error 110 inserting record to a table that has identity column
** <file-name>.<field-name> is mandatory, but has unknown (?) value. (110)
FACT(s) (Environment):
MS SQL DataServer
The table on SQL server side has identity column
The identity column on SQL server is turned on to "yes"
The table is pulled into schema holder and the identity column is shown as int
Windows
Progress 9.x
OpenEdge 10.x
CAUSE:
The identity (int) field in schema holder has mandatory turned on, so each time a record is inserted, dataserver will try to generate a value and insert into SQL server, but since this column on SQL server is set to yes, SQL server already maintains the column by auto generated values, thus the conflict.
FIX:
Turn off mandatory on the field in schema holder