Post reply

the report server cannot process the report.the data source connection information has been delete(rsInvalidDataSourceReference)

  • October 9, 2014 at 11:50 pm

    #311661

    Hi All

    IN one of our reporting server whille application team are trying to fetch reports they are getting this error

    "the report server cannot process the report.the data source connection information has been delete(rsInvalidDataSourceReference)"

    and internetpage cannot be displayed

    thanks

    naga.rohikumar

    Thanks
    Naga.Rohitkumar

  • October 10, 2014 at 12:36 am

    #1751492

    What do you mean with "fetch reports"?

    The error seems clear to me: there are issues with the data source.

    Are the reports using shared data sources?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 10, 2014 at 3:04 am

    #1751521

    in the sense it should connect to data base and even i feel the same but the people who are using or trying to get reports

    are saying that this issue is occurring some times when there is a performance issue in sqlserver and

    asked me to find the root cause of this issue and iam new to this organization can you please say what is the exact solution...

    i have configure the reports earlier also by that i have conveyed the same to them but they said i have Miss understood

    1.The actual issue may occurs when the datasource .rdl file is missing or path is changed.

    2.when the Symantec anti virus is blocking

    3.network polices are changed

    4.port 8080 issues from network

    5.iis services stopped.

    Thanks

    Naga.Rohitkumar

    Thanks
    Naga.Rohitkumar

  • October 10, 2014 at 3:21 am

    #1751529

    First of all you have to be 100% sure the reports are correctly configured.

    If they are, my next step would be to check the SSRS logs.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 13, 2014 at 9:27 pm

    #1752112

    what need to check in ssrs logs can you please confirm on it

    Thanks
    Naga.Rohitkumar

  • October 14, 2014 at 1:00 am

    #1752122

    naga.rohitkumar (10/13/2014)

    what need to check in ssrs logs can you please confirm on it

    Errors and/or warnings probably?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply