snapshot isolation level error

  • we configured Allwayson configuration. Read /write Primary and Read secondary. Using Microsoft dynamics the users are connecting to database through listener.

    Through citrix when users are connecting to primary and listener No issue. But when users are connecting to secondary through citrix the below error is coming.

    Microsoft Dynamics Nav Classic

    The following SQL Server error occured

    3961,42000,[Microsoft],[ODBC SQL Server Driver][sql server] snapshot isolation transaction failed in the database 'abc' because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction.It is disalowed because the metadata is not versioned. A concurrent update to metadata can lead to inconsistency if mixed with snapshot isolation.

    Please help me to resolve.

    Thanks in advance.

  • How are they connecting to the secondary?  By directly connecting to the secondary server, or by connecting to the listener and adding "ApplicationIntent=ReadOnly" to the connect strings?

    Do you have read-only routing properly configured in the AG?

     

    This article describes it pretty well.  https://www.rdx.com/blog/configuring-read-only-routing-always-availability-group

     

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply