Hi
We run a testmanager written in CVI 6.0 for several years with no problems.
Last fryday all of a sudden, all testmanagers gave errors on DBActivateSQL.
This command return -10 as errorcode. But what dus this errorcode mean ?
But this happens not allways. There are teststeps working well (see log below) using DBActivateSQL
And then all of a sudden the testmanager gives an error on hstmt = DBActivateSQL
hstmt = -10.
There are no windows updates done in the last few weeks.
We use Microsoft SQL server 2000
Labwindows CVI 6.0
Teststand 2.0
SQL toolkit 2.0.6
Does anyone know what the problem is ?
The parameters for the stored procedure exec TMUI_PutStepResult are :
@seqResultID bigint = 0,
@stepID bigint = 0,
@barcode varchar(255) = '',
@dateTime datetime = 0,
@testTime bigint = 0,
@result float = 0.0,
@resultDescription varchar(255) = '',
@passFail varchar(255) = ''
Eventlog from our testsystem :
00000276 481.92571982 [1280] > StepID retrieved from DB by TMUI_GetStepID: 314192
00000277 481.92592971 [1280] > TMUI_PutStepResult =
00000278 481.92592971 [1280] exec TMUI_PutStepResult @seqResultID = 1205155, @stepID = 314192, @barcode = '0031428947',@dateTime = '10-06-2010 15:02:44', @testTime = 0, @result = 0.000000, @resultDescription = '', @passFail = 'Done'
00000279 482.01746518 [1280] > StepID retrieved from DB by TMUI_GetStepID: 314193
00000280 482.01768253 [1280] > TMUI_PutStepResult =
00000281 482.01768253 [1280] exec TMUI_PutStepResult @seqResultID = 1205155, @stepID = 314193, @barcode = '0031428947',@dateTime = '10-06-2010 15:02:44', @testTime = 0, @result = 0.002849, @resultDescription = '', @passFail = 'Passed'
00000282 486.14602886 [1280] > StepID retrieved from DB by TMUI_GetStepID: 314194
00000283 486.14624035 [1280] > TMUI_PutStepResult =
00000284 486.14624035 [1280] exec TMUI_PutStepResult @seqResultID = 1205155, @stepID = 314194, @barcode = '0031428947',@dateTime = '10-06-2010 15:02:48', @testTime = 0, @result = 0.000000, @resultDescription = '', @passFail = 'Done'
00000285 516.80509528 [1280] > DBAL_PutStepResult, Error hstmt <=0 hstmt= -10 and DBhandel hdbc = 1
00000286 516.80577789 [1280] >--errormessage in DBAL_PutStepResult() error = -1
with kind regards
Tonnie te Braake
