NIM058818 for ArcSDE/Enterprise Geodatabase

Número de ID del error	NIM058818
Enviado	July 7, 2010
Última modificación	April 2, 2025
Relacionado con	ArcSDE/Enterprise Geodatabase
Versión encontrada	9.3.1
Sistema operativo	Windows OS
Versión de sistema operativo	2003
Estado	Known Limit

Información adicional

Multiversioned view edits called via a trigger can fail due to transaction scope issues. See the workaround for more info on changes in next release.

Solución alternativa

This is a known limit. The SQL Server trigger is expecting to close with a transaction count of 1. The Edit_version stored procedure expects a transaction count of 0 to close a state at 9.3.1, or returns the transaction count to 0 (10.0 SP4 fix). Either case is causing the trigger to abort.At 9.3.1 & earlier there is no workaround.For edits exclusively to the default version, upgrade to 10.0 SP4 or later. Edits to default no longer use the edit_version stored procedure. See the 10.1 documentation for more information.For edits to child versions at 10.0 SP4 or later you can test adding a 'BEGIN TRAN' statement to the assessment_xy_to_assessment_mobile trigger immediately after the exec sde.insert_assessment_mv stored procedure call. This will increment the transaction count to 1. This should satisfy the trigger requirement without impacting the stored procedure. The transaction count is returned to 0 when the trigger completes.