locked
An internal error occurred on the report server - SSRS RRS feed

  • Question

  • Hi All,

    I've an a SQL server 2005 on Windows 2003 server(Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)_Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)) . In recently we had an a issue with SSRS Report manager. Am able to see some once modified Data source in Report manager and after that we ware not able to Data source on report manager, getting below error while trying open and it's not allowing to me delete & modify. more than 200 reports are connected to this DS.I am not able to find any additional info in SSRS logs please help me in this. Please help on this. 

    An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

    Regards,

    Syed Jakeer.


    Syed Jakeer

    Monday, December 19, 2016 5:06 PM

Answers

  • Hi All,

    thanks for the reply. now issue has been resolved. I've found 1 duplicate data source for the same report, not sure how its got created.  below is the code which i approached to resolve this issue,

    1. select * from catalog where path = '/Data Sources/Data Source name' -- to get Item ID

    2. select *  from datasource where itemID='xxxxx-xxxx-xxxx-xxxxx-xxxxxxxx' -- to get DSID

    3. Delete the duplicate ID

    begin tran

    delete from datasource where DSID='xxxxx-xxxx-xxxx-xxxxx-xxxxxxxx'

    commit


    Syed Jakeer

    • Marked as answer by Syed Jakeer Monday, January 9, 2017 7:49 PM
    Monday, January 9, 2017 7:48 PM

All replies