Kbase P127618: Getting IDENTITY_INSERT is set to off when inserting data through ABL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/9/2008 |
|
Status: Verified
SYMPTOM(s):
Getting IDENTITY_INSERT is set to off when inserting data through ABL
The following errors are apparent when inserting the records on the table
2300: [Microsoft][ODBC SQL Server Driver][SQLServer] Cannot insert explicit value for identity column in table '<table name>' when IDENTITY_INSERT is set to off
Duplicate unique key in database table (1443)
FACT(s) (Environment):
The SQL Server table has a identity column, which is set to auto increment by SQL Server
Not inserting data on the identity column
The error is only apparent on OE10.1B03
MS SQL DataServer
OpenEdge 10.1B
OpenEdge 10.1C
Windows NT 32 Intel/Windows 2000
CHANGE:
Upgraded from OE10.1B02 to OE10.1B03
CAUSE:
Bug# OE00162531
FIX:
Upgrade to OpenEdge 10.1C01 or later