Attribute Assistant - Underlying DBMS error

MarkTurnbull — Fri, 25 Sep 2015 04:42:43 GMT

HI AA Gurus

I was wondering if there is any way to debug the following error from the AA logs, any further?

------------------------------------------------

Row Info

Row Number 1

TableName: Feature

FieldName: Active

ValueInfo: Inspection|ActiveFlag|GlobalID|Feature_GlobalID

ValueMethod: UPDATE_LINKED_RECORD

On Create: False

On Change: True

Checking for Subtype Restriction

Field Name: Active was found at index: 5

Trying: UPDATE_LINKED_RECORD

Getting Value Info

Checking values

Checking Field in Edited Layer

Checking for related record

ERROR: UPDATE_LINKED_RECORD

Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0]Syntax error, permission violation, or other nonspecific error] [GDLGISINS2.GIS_ADMIN.Inspection]

Finished: UPDATE_LINKED_RECORD

------------------------------------------------

Thanks

Mark

Re: Attribute Assistant - Underlying DBMS error

MarkTurnbull — Tue, 20 Oct 2015 04:29:56 GMT

A month later and no response on this one.

I have tried to trace the SQLs being generated with Profiler but cant seem to locate the query causing the Underlying DBMS error.

Through trial and error, I have been able to narrow the issue down to AA having some issue with using the globalid field as the primary key field. Can anyone tell me if this problem is likely to be caused by the differing data types of the key fields?

Thanks

Mark

topic Re: Attribute Assistant - Underlying DBMS error in State & Local Government Questions

Attribute Assistant - Underlying DBMS error

Re: Attribute Assistant - Underlying DBMS error