Audit Table Query Error: Expected value between 1 and 1 inclusive.

[clintonbale]

Was playing around with querying the audit table and ended up running into an error, I've narrowed it down to using distinct on the audit table. Any of the following queries throw the same error, example:

select distinct audit.createdon, audit.objectid from audit where audit.action = 64 and audit.objectidtype = 'systemuser'

select distinct audit.objectid from audit

Throws this error

Msg 10337, Level 16, State 1, Line 7
Expected value between 1 and 1 inclusive.

System.ArgumentOutOfRangeException: Expected value between 1 and 1 inclusive.
Parameter name: entityExpression
Actual value was 2.
See the Execution Plan tab for details of where this error occurred

---

• Deployment: Online
• DB Version: 9.2.24071.168
• Connection Controls Version: 1.2023.6.56
• XrmToolBox Version: 1.2023.12.68
• Tool Version: 9.2.0.0