TS 2012 SP1 : STEP_Result recording always fail in a MySQL database (standard schema)

[CyGa]

Hi all,

I'm using TS 2012 SP1 to run very simple sequences (few sequence calls in the same file and some simple tests without any adapters) with the sequential model (see attachements). Each time database logging step fails with error -2147352567 on statement STEP_RESULT.

This means I cannot log my step results in my MySQL 5.2 database (UUT_RESULT seems to be recorded...).

My configuration is :

• Win 7 32 bits
• TS 2012 SP1
• MySQL 5.2 + ODBC connectors

The database has been built using MySQL Workbench using the sql file found in the TS Components folder.

Under TS, the schema used is a simple duplication of MySQL Insert schema delivered with TS. (see attachements).

Any idea of what's happening ? Any workaround ?

[Scott_Richardson]

zyl7 - 

1) Is there any additional information in the error that TestStand is raising?

2) If you choose the TestStand default schema do you get the same error?

3) Have you tried to see if the TestStand results will log with the "Use On-The-Fly Logging" option unchecked? If this also errors, what is the error specifically?

[CyGa]

Hi Scott,

1) Is there any additional information in the error that TestStand is raising?

=> Nothing else (see pic attached), TS considers its a user-defined error.

2) If you choose the TestStand default schema do you get the same error?

=> If you mean 'generic recordset' schema, it's intended to be used with MS SQL or Access. If I chosse the default MySQL schema it produces the same error. My schema is a simple duplication of MySQL schema without any modifications (except its name).

3) Have you tried to see if the TestStand results will log with the "Use On-The-Fly Logging" option unchecked? If this also errors, what is the error specifically?

=> With On-the-fly logging it produces the same error.

[Al.B]

Hi,

I have been able to log successfully to this version of mySQL, so I'm not sure why it would be failing on your end.  A couple other things to try:

1. Confirm that the "test connection" button in the build options window (click Build... in the data link tab) does not produce any errors
2. Are you able to log to the database successfully outside of TestStand?

[CyGa]

Hi Al,

1. Confirm that the "test connection" button in the build options window (click Build... in the data link tab) does not produce any errors

=> No error, connection test passed

2. Are you able to log to the database successfully outside of TestStand?

=> SQL requests from MySQL Workbench (or any other SQL IDE) work fine.

=> I even can write in 'STEP_RESULT' table using the sequence attached to this post.

[CyGa · Accepted solution]

Problem fixed !

I upgraded the MySQL ODBC driver to version 5.2.5 (instead of 5.2.4) and the problem is gone !

Thanks for the help.

[Romain_Duval]

Hi Al, Scott, Upgrading the ODBC connector to 5.2.5 resolved the issue. On my side I couldn't reproduce the issue with a previous version (5.2.2) than the one used by Zyl7 (5.2.4). Have a good NI Week! Regards

[Scott_Richardson]

zyl7 -

Thanks for letting us know. Glad that the fix was that simple.