Discussion:
SQL error message while running Audit report Usage_-_Object_Access
(too old to reply)
Markyboy
2009-05-07 10:13:01 UTC
Permalink
I'm getting the following error message while trying to run the Audit Report
Usage_-_Object_Access Report in Operations Manager.

Error message "An error has occurred during report processing. The
Processing of SortExpression for the table 'table' cannot be performed. The
comparison failed. Please check the data type returned by the SortExpression.

Can somebody please help me :-(
Markyboy
2009-05-07 12:42:01 UTC
Permalink
I did yes and most of the the other Audit Reports are working. It just seems
to be this one that's causing the most problems
Hello Markyboy,
Have you done all the installation steps? http://contoso.se/blog/?p=198
Have it worked before? Are you running AD 2008? Then look at http://contoso.se/blog/?p=288
Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se
Post by Markyboy
I'm getting the following error message while trying to run the Audit
Report Usage_-_Object_Access Report in Operations Manager.
Error message "An error has occurred during report processing. The
Processing of SortExpression for the table 'table' cannot be
performed. The comparison failed. Please check the data type returned
by the SortExpression.
Can somebody please help me :-(
Markyboy
2009-05-07 12:44:06 UTC
Permalink
I did yes and most of the Audit reports are working except for this one!
Hello Markyboy,
Have you done all the installation steps? http://contoso.se/blog/?p=198
Have it worked before? Are you running AD 2008? Then look at http://contoso.se/blog/?p=288
Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se
Post by Markyboy
I'm getting the following error message while trying to run the Audit
Report Usage_-_Object_Access Report in Operations Manager.
Error message "An error has occurred during report processing. The
Processing of SortExpression for the table 'table' cannot be
performed. The comparison failed. Please check the data type returned
by the SortExpression.
Can somebody please help me :-(
Anders Bengtsson [MVP]
2009-05-07 13:54:56 UTC
Permalink
Hello Markyboy,

Look at which event it tries to list, and make you are generating them on
your ACS forwarder machines.

Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se
Post by Markyboy
I did yes and most of the Audit reports are working except for this one!
Hello Markyboy,
Have you done all the installation steps?
http://contoso.se/blog/?p=198 Have it worked before? Are you running
AD 2008? Then look at http://contoso.se/blog/?p=288
Anders Bengtsson
Microsoft MVP - System Center Operations Manager
www.contoso.se
Post by Markyboy
I'm getting the following error message while trying to run the
Audit Report Usage_-_Object_Access Report in Operations Manager.
Error message "An error has occurred during report processing. The
Processing of SortExpression for the table 'table' cannot be
performed. The comparison failed. Please check the data type
returned by the SortExpression.
Can somebody please help me :-(
Loading...