TestStand Numeric Multiple Limit Test Data Logging to SQL Database using Stored Procedures

[terickson]

We are receiving a foreign key constraint error when attempting to log the result of a multiple numeric limit test to a SQL Server database. Any suggestions?

[terickson]

I think it is a bug in the actual logger. I can go into the database and add a new row to the STEP_NUMERICLIMIT2. As long as the value in the PROP_RESULT field exists in STEP_NUMERICLIMIT1 then the row can be added. If it does not, I get the same error message that TestStand gives me.

[KeddyC]

Hi terckson,

Thanks for reaching out. Sorry you're having issues. It's not totally clear what's going on right now. Could you narrow down the issue to a specific log, or data type that you are sending to the server? Does it happen every time, or just some times? If you log just a single data point to your database, does the same error throw?

Thanks in advance.