NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Teststand Logging BIGINT to Microsoft SQL Database

Solved!
Go to solution

Hi everyone,

I tried to do lot of research but wasn't able to find solution so I will try to ask here.

 

I am using Teststand 16, and Microsoft SQL Server Management Studio

 

Server have column Internal_SN data type set to bigint,

bigint.PNG

i can also see that setting in HeidiSQL

heidisql bigint.PNG

 

then i got problem when validating database schema in Teststand, for some reason Teststand see data type of database column as "8 Byte Signed Integer" (which is technically correct(?)) but expect "Big Integer" which is set in schema.

validation.PNG

Column setting is as follows

schema column settings.PNG

So i quess that problem is somewhere between Teststand and how it process informations about database structure from server, but I have no idea how to move forward to solve this.

I did not have issues with any other data type but bigint.

 

Has anybody seen this before?

Any suggestions what to do/try?

 

Thank you

Ondra

 

0 Kudos
Message 1 of 2
(2,139 Views)
Solution
Accepted by topic author OndrejTylich

Ondra -

The validation feature has some known issues and there might be an issue with how it is comparing what the database is returning and what the schema defines. I have created a bug with ID 702836 for this specific issue.

 

If you ignore the "error" that the validation feature reports, database logging will still work during an execution.

 

Scott Richardson
Message 2 of 2
(2,108 Views)