Page 1 of 1
Could not find stored procedure in version 2014.2
Posted: Fri Jan 09, 2015 3:57 am
by jackvaughn03
Hi,
After upgrading from previous version 2012 to 2014.2.2004. The upgrading of the reports were totally smooth.
All the reports generating are stored procedure in the Data Source.
The error message is: Could not find stored procedure.
If I compare from the previous version. There is no error message like this.
So how can I fix this the new version?
Thanks,
Jack
Re: Could not find stored procedure in version 2014.2
Posted: Fri Jan 09, 2015 6:14 am
by Alex K.
Hello,
Can you please describe your issue in more details. Also, if possible, please send us a sample report with test data for analysis.
Thank you.
Re: Could not find stored procedure in version 2014.2
Posted: Fri Jan 09, 2015 8:35 am
by jackvaughn03
Actually, in our last version (2013.1) we have no problem encountered like this, especially in data source executing of stored procedure. In the design and run time a report.
However, I just installed the latest version 2014.2 and 2014.3. Please see attached file.
If you click the Exclamation ( Run button ) it will show the error message.
But if you retrieve the columns, if perfectly works.
I you want to test to the error, just make a report that will call any stored procedure and you will see the same problem I encountered.
Thank you for your quick response.
Re: Could not find stored procedure in version 2014.2
Posted: Fri Jan 09, 2015 8:59 am
by jackvaughn03
This version was from 2013.1.
Executed the Query Text and the message return: Executed SQL statement successfully.
Thank you.
Jack
Re: Could not find stored procedure in version 2014.2
Posted: Fri Jan 09, 2015 10:56 am
by Alex K.
Hello,
It is difficult to say something without sample.
Can you please send us your report and this procedure (create query) for analysis.
Thank you.
Re: Could not find stored procedure in version 2014.2
Posted: Tue Sep 15, 2015 7:42 am
by anuj130989
Hi Jack,
Facing the same issue with new 2015, just need to know that how did you resolve your issue?
Thanks,'
Anuj
jackvaughn03 wrote:Hi,
After upgrading from previous version 2012 to 2014.2.2004. The upgrading of the reports were totally smooth.
All the reports generating are stored procedure in the Data Source.
The error message is: Could not find stored procedure.
If I compare from the previous version. There is no error message like this.
So how can I fix this the new version?
Thanks,
Jack
Re: Could not find stored procedure in version 2014.2
Posted: Tue Sep 15, 2015 8:31 am
by HighAley
Hello,
To help you we need to know the cause of the issue.
Could you specify what issue do you have? With totally smooth or with store procedure.
Please, send us all information about the issue that will help to reproduce it.
Thank you.
Re: Could not find stored procedure in version 2014.2
Posted: Sat Oct 10, 2015 10:29 am
by vsolar
i have same problem in this version of Stimulsoft
i solve it by selecting type "Table" instead of "Procedure"
and write query like this:
Execute Procedure_name
@Parameter_name1,
@Parameter_name2,
...
Re: Could not find stored procedure in version 2014.2
Posted: Mon Oct 12, 2015 6:40 am
by Alex K.
Hello,
If you uses query statement - "exec procedurename parameter1, parameter2 ... ", you need set the type as "Table/Query", if uses only procedure name in the query then need set the Type as "Procedure".
Thank you.