May 8, 2019 at 6:19 am
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.
May 8, 2019 at 4:09 pm
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