Report Blocked Requests by Rule fails for longer time periods or periods with large data amounts

This article applies to:

• WebMarshal Reports 6.X
• Marshal Reporting Console 2.1
• Report "Blocked Requests by Rule"

Symptoms:

• Running the report for a short time period (or a small group) succeeds
• Running the report for a longer time period fails
• Error message: No rowset was returned for this table, query or procedure
• Error message: Error detected by database DLL

Causes:

• A variable in the SQL Stored Procedure that summarizes data for this report is incorrectly defined. Large data values are not permitted.

Resolution:

To resolve this issue, upgrade to the latest version of MRC. This issue was first fixed in release 2.5.0.1189.

Workaround

If you cannot upgrade immediately and you are comfortable editing SQL stored procedures, you can correct the issue.

1. Open the WebMarshal database using SQL Server Enterprise Manager or SQL Server Management Studio.
2. For WebMarshal Reports, edit/Modify the Stored Procedure RPT_ExceptionByRule
3. Locate the line [FileSize] int,
4. Alter this line to read [FileSize] bigint,
5. Update the Stored Procedure by saving or clicking Execute, depending on the version of SQL management software you are using.
6. For Marshal Reporting Console, edit/Modify the Stored Procedure MRC_BlockedRequestsByRule
7. Locate the line [FileSize] int,
8. Alter this line to read [FileSize] bigint,
9. Update the Stored Procedure by saving or clicking Execute, depending on the version of SQL management software you are using.