Kbase P130566: Getting progress error 1443 followed by ODBC errors 23000 and 37000 during the creation of a new re
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2010 |
|
Status: Verified
SYMPTOM(s):
Getting progress error 1443 followed by ODBC errors 23000 and 37000 during the creation of a new record when there is a timestamp field on a table
23000: [Microsoft][ODBC SQL Server Driver]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column
37000: [Microsoft][ODBC SQL Server Driver]Statement(s) could not be prepared.
Duplicate Unique key in Database table. (1443)
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
OpenEdge 10.x
MS SQL DataServer
CAUSE:
The timestamp data type is not supported with the Microsoft SQL Server DataServer, but the pull utility still brings the field with timestamp data type in to the schema holder.
FIX:
The workaround is to remove the timestamp field from the table(s) in the schema holder and commit the change.