Issue With the “Open SQL Query” Step in TestStand

Issue Details

I encountered unexpected behaviour when trying to run the following statement in the TestStand: "INSERT INTO [AUX_Test] (Project_Alias) OUTPUT INSERTED.id VALUES ('"+ Locals.Project_Name +"')" by the "Open SQL Statement" step. The sequence runs without any problems, but I have 3 extra rows instead of one in the database. (You can see in attached photo)

When I execute the same statement in the database, everything works as expected. It created one row.

I tried based on TS 19 and 21, with both I got the same issue.

Solution

1. You need to put in the False statement "Identity" from the Column Properties. You can go into this article or contact your IT for this.

1.1 You may check your identity status by going to your DB table

1.2 Expand tree view:

1.3 From here expand the tree view of the Columns folder

1.4 Then by right-clicking by "ID", go to the property section

1.5 And in the pop-up window, you will see it (it should be False)

2. After completing the first step, please go to the sequence file in the TestStand.

   2.1 Go to the step "Insert into Aux table" and open Edit Open SQL Statement.

   2.2 Then modify SQL statement. You will need to add a table and a column after INSERTED.ID there, as shown below:

  "INSERT INTO [AUX_Test] (Project_Alias) OUTPUT INSERTED.ID INTO [New_AUX_Test_2] (ID) VALUES ('" + Locals.Project_Name + "')"

   2.3 To do test