Hi All, @mailto:support@tableausoftware.com
I am getting the error attached while connecting to the procedure. I am having problem only with this procedure, i am able to connect to the others procedures.
Please
Regards,
Ratan
Hello Ratan,
Thanks for your question.
The error: "Invalid cursor state" indicates that Tableau is receiving information in an unexpected format from the data source. The error can generally be prevented by adding a “SET NOCOUNT ON” statement to the beginning of the stored procedure. Information about SET NOCOUNT is available at the following link: http://technet.microsoft.com/en-us/library/ms189837.aspx
This issue and its solution are also addressed in more detail at the following community thread: null
Ethan
Tableau Technical Support
Server Specialist