SSRS 2014 + Report Manager Error + System.InvalidCastException: Specified cast is not valid.

Paul Chandran 0 Reputation points
2023-06-06T10:53:30.71+00:00

Hi All - I'm getting a very strange error in SSRS 2014. Both Report Manager and Reporting Service are now unavailable. I get an error - An internal error occurred on the report server. See the error log for more details. (rsInternalError). When I interrogate the SSRS logs I see the error - ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.

Any help is much appreciated.

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,813 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,321 Reputation points Microsoft Vendor
    2023-06-07T02:23:44.5333333+00:00

    Hi @Paul Chandran

    From what I've searched, this error mostly occurs when pointing to Oracle or installing PowerBI reporting services.

    What is your environment like? Did this error happen suddenly? Or what did you do?

    You can refer to these links:

    https://stackoverflow.com/questions/52707150/ssrs-system-invalidcastexception-at-oracledatareader-getdecimalint32-i

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/0fffeeca-f51a-4ac2-aa9b-53b95851c94b/reporting-services-not-working-soap-error-specified-cast-is-not-valid?forum=sqlreportingservices.

    Best regards,

    Aniya

    0 comments