Data driven test won't stop

Question

Hi All,Having an odd problem with a data driven test - being fairly new to TestComplete I thought I'd post this here to see if anyone has had a similar problem.&nbsp; We created a data driven keyword test to validate some data on one of our forms, and it works pretty good.&nbsp; We are using an Excel worksheet for our data, there is about 200 rows and 5 columns of data, and&nbsp;there are no blank cells in any of the data.&nbsp; The problem we're having is that the first 200 times through the data driven loop everything works fine, however, TestComplete tries the loop 201 times, and of course that last&nbsp;time it&nbsp;fails because the entire row is empty.&nbsp; In the data driven loop we did not define how many rows to execute as we expect this list of data to expand as time goes on.&nbsp; We've tried everything else, i.e., validating that rows 201+ are all entirely blank.&nbsp; We've even tried reducing the number of rows down to 4 and TestComplete still tries the loop 5 times.&nbsp; We've also copy and pasted just the table data to a new Excel sheet and it still tries to do more data driven loops than data rows.&nbsp; The especially odd thing is that when we were developing the test we started with a sheet with 4 rows of data, and it worked as expected.&nbsp; This problem started after we expanded the worksheet to 200 rows of data, and the problem continues even if we reduce the worksheet to the original 4 rows of data.So, is TestComplete supposed to automatically figure out the end of the Excel file?&nbsp; Has anyone else had an issue like this?Thanks.

chicks · Answer

Hi,Most of my tests are data driven from excel files.&nbsp;&nbsp; I'm using the following standard template.(javascript).I think the only time I've seen similar behavior is when I've got extra rows in the data sheet and I can typically check for this by doing a ctrl 'down arrow' to check the last row that excel thinks is defined.Regards,&nbsp; Curt Hicks .&nbsp;&nbsp;&nbsp; var Driver = DDT.ExcelDriver(excelData, " &lt; sheet name&gt; ", true);&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; var rowNbr = 0; &nbsp;&nbsp;&nbsp; var index = 0;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; var reply, replyObject; &nbsp;&nbsp;&nbsp; var dataFetchedWithNoError; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; while (! Driver.EOF() ) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; omit = aqConvert.VarToStr(Driver.Value(omitHeader));&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // skip row if there's anything other than whitespace in the omit column &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( /\S+/.test(omit) == false) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rowNbr++; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log.Message ("non-omitted data row : "+rowNbr );&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // read rest of expected data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;data&gt; = aqConvert........&nbsp; blah blah bla&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Fetch data for comparison &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( dataFetchedWithNoError ) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log.PushLogFolder(Log.CreateFolder(" verifying row "&nbsp; ) );&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // compare returned data with expected data &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log.PopLogFolder();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp; // END IF - do verification if no error in the API call &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; index++;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } // END IF - row was not omitted &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Driver.Next(); &nbsp;&nbsp;&nbsp; }&nbsp; // END -WHILE &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; DDT.CloseDriver(Driver.Name); &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; if ( 0 == rowNbr) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log.Warning("No data rows existed in the spreadsheet ");&nbsp;&nbsp;&nbsp; }

sealockw · Answer

Hi Curt,We've tried everything we can think of looking at the data, even starting with a new Excel worksheet containing no content from the original and still the problem exists.What we ended up doing was re-recording our test and re-building the data driven portion of the test.&nbsp; This new one works fine with the full Excel file.Weird.I can only surmize that we did something in the original test that caused some odd interaction with Excel - given that it was a keyword test to begin with, I'm not sure how, but that is what happened.For now I'm going to assume the problem is resolved and if we keep having a problem like this we'll open a support case.Thanks.

Forum Discussion

Data driven test won't stop

2 Replies

Recent Discussions

Firefox 140.0 ESR support?

How to Ignore "The git.exe process crashed."?

How to replace a Value with a Variable.

Related Content

Data Driven Loops

Data Driven Testing - in Soapui Free version

Data-Driven Loop