TestStand 4.2: error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database'

[PeggyC]

I just installed TestStand 4.2 and SQL Server Express on a brand new Windows XP computer.  In TestStand, I set up the "Database" property so that it tested connection successfully.  But when I open the Demo/C/computer.seq file to test, it is giving me error in logging the result.  On-the-Fly Logging is not enabled.

The following is the error message I am receiving.

 ------------------------------------------------

An error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database Logging'
An error occurred executing a statement.
Schema: Generic Insert (NI)
Statement: UUT_RESULT.
Description: Invalid object name 'UUT_RESULT'.
Number: -2147217900
NativeError: 208
SQLState: 42S02
Reported by: Microsoft SQL Server Native Client 10.0Description: Statement(s) could not be prepared.
Number: -2147217900
NativeError: 8180
SQLState: 42000
Reported by: Microsoft SQL Server Native Client 10.0

Source: TSDBLog

Error Code: -2147217900; User-defined error code.

Location: Step 'Log Results to Database' of sequence 'Log To Database' in 'Database.seq'

 ------------------------------------------------

Is there something I missed in configuration?

Thank you.

Peggy

[Dennis_Knutson]

Did you run the script that creates the tables?

[PeggyC]

ha.  no.  didn't know there is a script.  Can you give me some pointers on which script and how to run?

Thanks.

Peggy

[Snowman 6008 · Accepted solution]

PeggyC,

You can get detailed information on how to log to the database in the TestStand Reference Manual, they talk about SQL script files on page 113 which coresponds to 6-6.  Hope that helps.

[PeggyC]

Thank you.  That page 6-13 is exactly of what I need to do.