topic Re: Stored Procedure has no return in ThingWorx Developers

Stored Procedure has no return

shen — Tue, 13 Aug 2019 14:39:56 GMT

Hi all,

i have my stored procedure runs perfectly in MSSQl, but when I create the 'SQL Query' service and execute this stored procedure, it shows 'Executing' all the time until timeout without any error. In the same Thing I have other service executes stored procedure which runs with no problem.

Anyone may know something?

Thank you

Regards,

SHEN

Re: Stored Procedure has no return

visla — Tue, 13 Aug 2019 13:48:28 GMT

Hello @shen,

could you please provide the script for the SQL Query Service that is timing out? Could you please provide the script for a SQL Query Service in this same Thing that succeeds?

Please make sure you remove any confidential data before posting the scripts.

Thanks!

Vanessa