Parameter list access gives 'Something went wrong. Try again later' error in a SSRS report hosted in report server

Udhay 0 Reputation points
2023-08-03T00:34:38.59+00:00

While running a SSRS report hosted in report server, it gives a processing aborted error stating that the one of the parameter list cannot be read.

Error: An error has occurred during report processing. (rsProcessingAborted)

Cannot read the next data row for the dataset 'ParamListProjectDefinitionCd'. (rsErrorReadingNextDataRow)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Upon checking the Parameters in the SSRS report Manage list, it throws an error 'Something went wrong. Please try again later'. The downloaded copy of the RDL file works good without any issues.

Please let me know what could be the issue. I am not a DBA or a expert on this subject.

Error

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-08-03T01:25:52.6733333+00:00

    Hi @Udhay

    Since the error message contains the text "For more information about this error, navigate to the report server on the local server machine, or enable remote errors", you can set the EnableRemoteErrors property to access additional information that can help you troubleshoot the problem. You can refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/enable-remote-errors-reporting-services?view=sql-server-ver16.

    Best regards,

    Aniya

    0 comments No comments