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

Question

Question

Audit Trail Issue: There was an error while applying your changes. at WebAuditConfig.WS.AddSearchableData(RangeType type, Object parameters)

asked on March 23, 2017 Show version history

I've installed Audit Trail on Avante 10.2 and am now configuring it and ran into an issue.

Server is Window 12 64bit

SQL Express 12 64bit

 

I am able to connect the repository and connect the DB but when I try to set an age or date range, I get an error.  When I look in Event Viewer, I see the following:

There was an error while applying your changes. at WebAuditConfig.WS.AddSearchableData(RangeType type, Object[] parameters)

 

I've ensured that the logs are being written and the user is able to access the Audit Trail webpage.  The issue arises when they try to view a report as it fails, since no data range is being sent to the DB.  The account set in audit trail to access the DB is the same one that I used to create the DB and I have ensured it is a db.owner.

Please Advise.

0 0

Answer

SELECTED ANSWER
replied on March 27, 2017

Turns out we had an issue using Window Authentication as the login for SQL.  We enable the sa login and used that and everything is working fine now.

2 0

Replies

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

Sign in to reply to this post.