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

  • rdsb_2170

    Mr or Mrs. 500

    Points: 571

    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,

    Cervello

Viewing post 1 (of 1 total)

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