Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: tomadams on 17 Nov 2011 07:37:17 AM

Title: Stored procedure not returning data in Framework 10
Post by: tomadams on 17 Nov 2011 07:37:17 AM
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
Title: Re: Stored procedure not returning data in Framework 10
Post by: ahmerzaidi on 09 Aug 2012 11:35:03 AM
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.
Text only | Text with Images