Attribute Assistant - Underlying DBMS error

[MarkTurnbull]

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

[MarkTurnbull]

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