When does TestStand log data to the database

[Mathis_B]

If the whole multi day thermal cycle is the test of one UUT batch than this is expected behaviour. As I said before, without on-the-fly logging all data gets pushed once the UUT/batch test is complete. Your best bet would be to write your own logging plugin which can cope with on-the-fly logging ... which seems not an unproblematic task.

[ATE_Dude_22]

Amen to that, thanks for your help.

[Mathis_B]

There are a couple of things you could look into ...

you could create custom step types for all relevant step types and add the database step types as post steps and manually add the items to the database. That would require a bit more knowledge of your database.

The other thing would be to see if we can make the on-the-fly reporting work for you. What are the specific problems you are seeing ... maybe there is something that can be done to work around that.

[ATE_Dude_22]

I have recently enabled on-the-fly logging, and that appears to at least get the data into the database as the cycles are running. The problem I am now having, is trying to figure out how to access the data, because the date/time associated with the entries when logged this way do not correspond to the entry in the the UUT_RESULT table because that date/time only gets updated when the cycle completes.

---

@Mathis_B wrote:

There are a couple of things you could look into ...

you could create custom step types for all relevant step types and add the database step types as post steps and manually add the items to the database. That would require a bit more knowledge of your database.

The other thing would be to see if we can make the on-the-fly reporting work for you. What are the specific problems you are seeing ... maybe there is something that can be done to work around that.

---

[Mathis_B]

I'm afraid I'm not a database person and won't be able to help on this one. Anyone else?

[johnr4]

Hello,

It is expected behavior to have the two timestamps be different with on the fly logging since they are occuring at two different places in the sequence.  I can not assist much with database customization unfortunately.  To get the timestamps to align, you would have to create a custom plugin.  Another potential option is customizing the database query settings.  Good luck!

Thanks,