Skip to main content
D
djung11-Visitor
1-Visitor
July 13, 2017
Solved

Stored Procedure Error

  • July 13, 2017
  • 2 replies
  • 2053 views

Hi guys,

I'm trying to run a service that is a SQL query that execute a Stored Procedure from MSSQL.

execute.PNG

When I try to execute the query on ThingWorx, I get the following error:
error.PNG

However, when I execute this exactly stored procedure on SQL Management Studio, it works fine and get the following result:

result.PNG

Does anyone know how to solve this?

Thanks,

De Hong

    Best answer by djung1

    I fixed the problem.
    Based on another post here, I just wrote "SET NOCOUNT ON;" in the procedure and it worked!

    But Thanks Sushant Pandey!

    2 replies

    S
    supandey5-Regular Member
    5-Regular Member
    July 14, 2017

    Hi De Hong, what sort of an sql statement that procedure is executing? I just tested with SQLQuery service with following procedure that requires an input parameter

    execute demoproc3 @colname =2

    And it works fine. Note procedure contains select statement and returning single column as result

    D
    djung11-VisitorAuthorAnswer
    1-Visitor
    July 27, 2017

    I fixed the problem.
    Based on another post here, I just wrote "SET NOCOUNT ON;" in the procedure and it worked!

    But Thanks Sushant Pandey!

    Terms & ConditionsCookie settingsAccessibility statement