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

Question

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.

Answer 1

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