You might see the following error when you type in some value in any text fields of the web report filters.
"An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set MainDataSet. (rsErrorReadingNextDataRow)
The conversion of the nvarchar value '3664103174' overflowed an int column. Maximum integer value exceeded."
Some of the text fields in the SRS report are using integer (int) and int only supports value between -2147483648 and 2147483647. One example is the 'Firewall all connections [Detailed]' report with traffic filter between 3664103174 and 3664103200
The conversion of the nvarchar value '3664103174' will overflow the int column.
WORKAROUND
Edit the the RDL file following the step below:CAST(BytesIn.StringValue AS INT ) + CAST(BytesOut.StringValue AS INT ) AS [Traffic]" and replace it with "CAST(BytesIn.StringValue AS BIGINT ) + CAST(BytesOut.StringValue AS BIGINT ) AS [Traffic]"
1. Open Knowledge Portal
2. Browse to 'Firewall all connections [Detailed]' report (substitute
3. Click Report Properties and click Edit
4. Save report to Desktop (or folder of your choice)
5. Open the file in notepad and find the following section "
6. Save the file
7. Return to the screen from step 3. and choose Upload and then browse to saved file
8. Click OK to save report
Note: BIGINT can support value between -9223372036854775808 and 9223372036854775807
STATUS
Waiting for fix in a future release
This solution can apply to any of the SRS reports that use large values for filters.
