stored procedure - Teststand data logging to SQL Server

[plf]

Using TestStand 2013

SQL Server 2012

When TestStand goes to log to the SQL Server catalog I get the following error:

An error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database Logging'
An error occurred executing a statement.
Schema: SQL Server Stored Proc (NI)
Statement: UUT_RESULT.
Description: Could not find stored procedure 'InsertUUTResult'.
Number: -2147217900
NativeError: 2812
SQLState: 42000
Reported by: Microsoft OLE DB Provider for SQL Server

Source: TSDBLog

I created the catalog in SQL Server and used TestStand to generate the tables and stored procedures... the 'InsertUUTResult' stored procedure is there so why is it complaining that it can not find it?

Additional Note... when creating the tables I ran ito issues with the 'constraint' SQL commands TestStand was using:

CONSTRAINT STEP_RESULT_FK FOREIGN KEY (UUT_RESULT) REFERENCES  (ID))

this must actually be:

CONSTRAINT STEP_RESULT_FK FOREIGN KEY (UUT_RESULT) REFERENCES UUT_RESULT (ID))

Note.... the 'UUT_RESULT' infront of (ID), without this the statement fails.

Am I running into an TestStand SQL syntext error on logging??? If so how do I correct this?

Also note this use to work with SQL Server 2008 and TestStand 3.5.

Pete

[plf]

I have verified the stored procedure exists in the database but no luck with actually using it from TestStand... has anyone seen this???

[NIExpert]

I just ran into this issue with SQL Server 2012 and TestStand 2014SP1 using Microsoft Native Client 11.0

Did you ever resolve this?