Stored procedure not returning data in Framework 10

[tomadams]

Hi,

This problem occurred suddenly.  We are moving from 8.4 to 10.  I had a customer call and say that a long running report in 8.4 was not returning data.  The SQL Server stored procedure worked as designed, but when I tested the stored procedure in framework it did not return data.  I have the same issue in the 10.1 version.  Now I see this is intermittent issue.  Some stored procedures return data, a few others do not.  Any thoughts on what the problem is or a course of debugging would be appreciated.

Thanks in advance

[ahmerzaidi]

You may have done this but I'll bring it up any ways,  have you run a test on the Stored Procedure with sample parameters? I have a suspicion that if the stored procedure has been modified in anyway and the object hasn't been updated it may cause a problem.  Update and Validate the object.