I am getting the following problem when trying to process reports with
parameters. If I restart IIS, it fixes the problem for a while. I'm on IIS
6. Reporting Services SP1.

An error has occurred during report processing. (rsProcessingAborted) The
processing of group expression for the table 'table1' cannot be performed.
The comparison failed. Please check the data type returned by group
expression. (rsProcessingError)


The log has the following information...


--- End of inner exception stack trace ---
w3wp!library!8a0!02/08/2005-11:48:30:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!8a0!02/08/2005-11:48:45:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the table 'table1' cannot be performed.
The comparison failed. Please check the data type returned by group
expression.
w3wp!library!e4c!2/8/2005-11:54:52:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!1084!2/8/2005-12:04:52:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!1084!2/8/2005-12:14:52:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!e4c!2/8/2005-12:24:52:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!8a0!02/08/2005-12:27:00:: i INFO: Call to GetPermissions:/Evolv
w3wp!library!8a0!02/08/2005-12:27:00:: i INFO: Call to GetSystemPermissions
w3wp!library!734!2/8/2005-12:34:52:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!8a0!02/08/2005-12:35:32:: i INFO: Call to GetPermissions:/
w3wp!library!8a0!02/08/2005-12:35:32:: i INFO: Call to GetSystemPermissions
w3wp!library!8a0!02/08/2005-12:35:35:: i INFO: Call to GetPermissions:/Evolv
w3wp!library!6ec!02/08/2005-12:35:35:: i INFO: Call to GetSystemPermissions
w3wp!library!1370!02/08/2005-12:35:37:: i INFO: Call to
GetPermissions:/Evolv/Accounting
w3wp!library!e4c!02/08/2005-12:35:37:: i INFO: Call to GetSystemPermissions
w3wp!library!8a0!02/08/2005-12:35:41:: i INFO: Call to
GetPermissions:/Evolv/Accounting/GL Account Detail
w3wp!library!8a0!02/08/2005-12:35:42:: i INFO: Call to GetSystemPermissions
w3wp!library!1084!02/08/2005-12:35:53:: i INFO: Call to GetPermissions:/
w3wp!library!8a0!02/08/2005-12:35:53:: i INFO: Call to GetSystemPermissions
w3wp!library!734!02/08/2005-12:35:58:: i INFO: Call to GetPermissions:/Evolv
w3wp!library!1084!02/08/2005-12:35:58:: i INFO: Call to GetSystemPermissions
w3wp!library!8a0!02/08/2005-12:35:59:: i INFO: Call to
GetPermissions:/Evolv/CSIS
w3wp!library!1084!02/08/2005-12:35:59:: i INFO: Call to GetSystemPermissions
w3wp!library!8a0!02/08/2005-12:36:02:: i INFO: Call to
GetPermissions:/Evolv/CSIS/CSIS-Standard
w3wp!library!8a0!02/08/2005-12:36:02:: i INFO: Call to GetSystemPermissions
w3wp!library!8a0!02/08/2005-12:36:11:: i INFO: Call to RenderFirst(
'/Evolv/CSIS/CSIS-Standard' )
w3wp!processing!8a0!2/8/2005-12:36:11:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Exception of type
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Exception of type
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was
thrown.
w3wp!processing!8a0!2/8/2005-12:36:16:: e ERROR: An exception has occurred
in data source 'CSIS'. Details:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the list 'list1' cannot be performed. The
comparison failed. Please check the data type returned by group expression.
w3wp!processing!8a0!2/8/2005-12:36:21:: e ERROR: An exception has occurred.
Trying to abort processing. Details:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the list 'list1' cannot be performed. The
comparison failed. Please check the data type returned by group expression.
w3wp!processing!8a0!2/8/2005-12:36:21:: i INFO: Merge abort handler called.
Aborting data sources ...
w3wp!processing!8a0!2/8/2005-12:36:21:: i INFO: Data source 'evolv_cs_work':
Abort handler called. CanAbort = True.
w3wp!processing!8a0!2/8/2005-12:36:21:: i INFO: Abort callback successful.
w3wp!processing!8a0!2/8/2005-12:36:26:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the list 'list1' cannot be performed. The
comparison failed. Please check the data type returned by group expression.
--- End of inner exception stack trace ---
w3wp!processing!8a0!2/8/2005-12:36:36:: e ERROR: Data source
'evolv_cs_work': An error has occurred. Details:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the list 'list1' cannot be performed. The
comparison failed. Please check the data type returned by group expression.
w3wp!processing!8a0!2/8/2005-12:36:36:: w WARN: Data source 'evolv_cs_work':
Report processing has been aborted.
w3wp!processing!8a0!2/8/2005-12:36:42:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The
processing of group expression for the list 'list1' cannot be performed. The
comparison failed. Please check the data type returned by group expression.
--- End of inner exception stack trace ---
w3wp!library!8a0!02/08/2005-12:36:42:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.

Yes - I has to build an application pool specifically for reporting services.
Then I didn't get the problem anymore.

[quoted text, click to view]