TestStand Saving Results to Database Error

[Tims]

Hi All

I am getting this error when some of the teststand steps fail.
I know there is something wrong with a numeric limit test but what does "The supplied value is not a valid instance of data type float." mean.

Cheers

Tim

An error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database Logging'
An error occurred executing a statement.
Schema: GATE SQL Server.
Statement: STEP_NUMERICLIMIT.
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
Description: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
Number: -2147217900
NativeError: 8023
SQLState: 42000
Reported by: Microsoft OLE DB Provider for SQL Server

Source: TSDBLog

-2147217900; User-defined error code.

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

[Scott_Richardson]

Tim -
The information that would be useful is:

• What version of TestStand are you using?
• In the STEP_NUMERICLIMIT statement, what kind of statement is it
• What type of parameter is #9 and what is the Expected Properties, Precondition and Expression settings for this parameter?
• Do you know what step is causing this to fail?
• Does the result for this step have the expected data type required by the logging statement?

It might be helpful if you exported your schema to an ini file and shared the file with us.

[plf]

-2147217900; User-defined error code. An error occurred calling 'LogResults' in 'ITSDBLog' of 'DBLog 1.0 Type Library' An error occurred executing a statement. Schema: Rev01 Drager SQL Server Stored Proc. Statement: STEP_NUMERICLIMIT. The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. Description: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. Number: -2147217900 NativeError: 8023 SQLState: 42000 Reported by: Microsoft OLE DB Provider for SQL Server Source: TSDBLog Step 'Log Results to Database' of sequence 'Log To Database' in 'Database.seq'

[plf]

I am getting a similar error trying to log data to a SQL Server 2008 database. The issue seems to happen when a numeric type DBL is reported as 'INF' by TestStand.

I am using TestStand 3.5, LabVIEW 8.2 & SQL Server 2008.

The complete error message I get is as follows:

-2147217900; User-defined error code.

An error occurred calling 'LogResults' in 'ITSDBLog' of 'DBLog 1.0 Type Library'

An error occurred executing a statement.

Schema: Rev01 Drager SQL Server Stored Proc.

Statement: STEP_NUMERICLIMIT.

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.

Description: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 9 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.

Number: -2147217900

NativeError: 8023

SQLState: 42000

Reported by: Microsoft OLE DB Provider for SQL Server

Source: TSDBLog

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

Has anyone seen this before???

Thanks,

pete

[MichaelAE]

Hi plf,

I believe you may have a conflict between the TestStand type that you are trying to write and the database type that you have chosen.  What value is your database expecting?
http://digital.ni.com/public.nsf/allkb/D9D351C8D566078286256BCF00676E9F?OpenDocument

Regards,

Michael Miracle

NI Americas | AE