Error Msg: The Server did not provide a meaningful reply; ....

  • rdsb_2170

    SSC Eights!

    Points: 812

    Good Morning,

    I have a report that includes DataSets pointing to Stored Procedures and three Datasets for date range query. I'm getting the following error when I try to run the report.

    "The Server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error."

    The store procedures run without issue in SSMS.

    I've checked to make sure each SP is using unique #Temp Table names, I have all referenced joins with NO Lock. Each of my Data Parameters are uniquely named (DateRange, DateRangeW, DateRangeY, StartDate, EndDate, StartDateW, EndDateW,....etc.).

    We have hundreds of reports running without issue, and I've never encountered this error. It seems kind of ambiguous

    Any suggestions on how to fix this or troubleshoot further would be greatly appreciated!!!

    Best Regards,


Viewing post 1 (of 1 total)

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