For many years we worked with Access-Databases.
Now we started with the SQL-Server.
We have only an UutResultTable and a StepResultTable
(because we started already with TestStand 1.02).
We worked with Integers as Primarykey (UutResultId, StepResultId)
I get the following Error, when I work with this 'Integer As Primary Keys'.
An error occurred calling 'LogResults' in 'ITSDBLog' of 'zNI TestStand Database Logging'
An error occurred executing a statement.
Schema: E4DatabaseSchema
Statement: UUT RESULT.
Description: The parameterized query '(@P1 int,@P2 nchar(50),@P3 int,@P4 nchar(50),@P5 nchar(50),@P6 n'
expects the parameter '@P1', which was not supplied.
Number: -2147217900
NativeError: 8178
SQLState: 42000
Reported by: Microsoft OLE DB Provider for SQL Server
Source: TSDBLog
My Questions:
Is it necessary to work with GUID's to use the Generic Insert (NI) Schema?
Does working with GUID's not reduce the Database-Performance?
We are using
TestStand 4.2
SQL Server 2008 R2
CVI 2010
Windows XP Service Pack 3
Thank you very much for your help
Paul
