You are viewing limited content. For full access, please sign in.

Question

Question

Always On Availability Group Support in Audit Trail

Audit Trail
Updated August 25, 2017
asked on August 15, 2017

We have been testing with Always on Availability and noticed that in Audit Trail whenever we try to add a date range we receive the following error when Always On Availability Group is turned on.

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation cannot be performed on database "LACOE_HRS_RIO_LFAudit" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.

This is with LF 10.2. Is this just something that cannot be enabled with Audit Trail or is it something that will be supported at some point?

Thank you!

0 0

Answer

SELECTED ANSWER
replied on August 15, 2017

The only thing that comes to mind is this http://answers.laserfiche.com/questions/102886/Block-DBCC-in-SQL#103793 but that should be fixed if you are running version 10.2.  Can you confirm that you also upgraded Audit Trail and not just LFS?  Otherwise there should be additional information in the event log on the audit trail server that will help track down the root cause.

0 0

Replies

replied on August 15, 2017

Thank you for your response Brian,

Yes, the Audit Trail application was also updated to 10.2  at the same time the LF instance was. The only error displayed in the even viewer app log was the one posted in the original post, the SQL error. The error was from the Audit Trail application. 

 

0 0
replied on August 15, 2017

Is there a stack trace recorded in the event log?

0 0
replied on August 25, 2017

I apologize for the delay Brian. From what we saw while we were looking at it the only errors that were being recorded were the error I referenced in the opening question.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...