NIM058818 for ArcSDE/Enterprise Geodatabase

不具合 ID 番号	NIM058818
送信されました	July 7, 2010
最終更新日	April 2, 2025
適用対象	ArcSDE/Enterprise Geodatabase
見つかったバージョン	9.3.1
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	2003
ステータス	Known Limit

参考情報

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.

対処法

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.