Kbase P140834: Getting Microsoft error 37000 when inserting in two tables in MS SQL server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/5/2009 |
|
Status: Verified
SYMPTOM(s):
Getting Microsoft error 37000 when inserting in two tables in MS SQL server
37000:[Microsoft][ODBC SQL Server Driver][SQL Server]<Msg Tag>[Add] is not applicable
37000:[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction ended in the trigger. The batch has been aborted.
FACT(s) (Environment):
The stack trace reviews the error is generated by the second RECID function during the two insertions
The SQL server database is not migrated from Progress database and is created by 3rd party
Windows
OpenEdge 10.x
OpenEdge DataServer Category: SQL Server
MS SQL DataServer
CAUSE:
There are two table triggers in the tables tables that have inserts. The trigger caused the MS SQL server error
FIX:
Disable the triggers in the SQL server side