topic Re: JMP14 Unable to fetch results set in Discussions

JMP14 Unable to fetch results set

hagaishalev — Sun, 19 Aug 2018 08:28:48 GMT

Trying to get data from SQL server with stored procedure failed in JMP14 and succeed in JMP8 and JMP9.

in JMP14 there is an error:

JMP Alert: Unable to fetch results set.

JMP Alert

and there is no result table (show(t1); return "t1=.)

I get the same issue in JSL and with "Databse Open Table"

The stored procedure output countains few empty sets, which need to be skkiped. Apperntly the JMP8 is doing it automatcly, but not the JMP14.

SQL output

Using Python I overcome this issue by cursor.nextset() untill I get a set with values.

I tried variety of formats, including:

dbc = Create Database Connection(
 
       "DSN=*******;UID=*****;PWD=*********;APP=JMP;WSID=SYS-CB2;DATABASE=Iserve;LANGUAGE=us_english;"
 
);
 
 
t1 = Execute SQL( dbc, "exec PL_RawData_restart '50110326','08/01/2018','08/16/2018' " );

RawData_dt=Open Database("DSN=*******;UID=****;PWD=*****;APP=JMP;WSID=SYS-CB2;DATABASE=Iserve;LANGUAGE=us_english", "exec PL_RawData_restart '48300134', '2018-07-17', '2018-07-31'");

Re: JMP14 Unable to fetch results set

gzmorgan0 — Mon, 20 Aug 2018 08:16:28 GMT

I have not used a stored procedure, but here is a link to a JMP blog March 2017 for JMP 13

https://community.jmp.com/t5/Discussions/Database-stored-procedure/td-p/36885

another regarding NO COUNT ON for JMP 11

https://community.jmp.com/t5/Discussions/JMP11-MSSQL-Stored-Procedure-Call/td-p/10906

a note on why a stored procedure worked in JMP 8 and not in JMP 11

https://community.jmp.com/t5/Discussions/Importing-SQL-using-a-temp-table/td-p/11760

Hope these give you some leads.

Re: JMP14 Unable to fetch results set

hagaishalev — Tue, 21 Aug 2018 04:51:33 GMT

Thank you! There might be no solution for my issue from the JMP side.