TestComplete 11.0 - Memory Issue
Environment Details: Windows 7, 64 Bit, 8 GB RAM TestComplete 11.0 Project Details: Used NameMapping Approach Defined All object references in one script file as Global Variables. There are 3000+ Variables. Reading and Writing Data from Excels Problem: When i open my project. RAM usage is 320-340 MB When i run any of my test function RAM usage will increase to 450-500 MB If i keep on running test functions RAM usage will increase to 800+ MB This is making my test execution go slow and crashing application under test. Anybody faced this kind of issue ? Why RAM usage will be increasing every time ? Is there any memory leakage ? Why after execution RAM usage is not coming to normal ?5.4KViews1like18CommentsTestComplete returns NULL from Excel in Property Checkpoint, but returns Correct value in Jscript
I am using the PropertyCheckpoint to verifya value from UI with a value from an Excel. Thecheckpoint returns a NULL value from the Excel, but when i use a script to do the same, i get the correct value. Pleaselet me knowwhat the issue is. P.S: This is just one of themany "irregularities" i have found in TestComplete. Willbring them upwhen i get time.Solved4.6KViews0likes9CommentsTest result status not refreshing
I have this function which I have picked up from a few examples online and managed to get it to write to excel with the result of the test that run. However it seems that either it doesn't refresh after every run or it gets the previous result log. I have created a test to test this function which writes log messages and putting the result in the 3 possible outcomes and everything I run it it puts the precious result to excel... Could someone point me in the right direction as I believe I'm using this method incorrectly. function WriteDataToExcel(fname, sheetName,testTime, errorCount, warnCount) { var app = Sys.OleObject("Excel.Application"); var book = app.Workbooks.Open(fname); var sheet = book.Sheets.Item(sheetName); var rowCount = sheet.UsedRange.Rows.Count+1; var columnCount = sheet.UsedRange.Columns.Count; var Logs; var Count; var Name; var Status = null; // Obtains the object that holds the list of project logs Logs = Project.Logs; Count = Logs.LogItemsCount // Iterates through the list of project logs for (var i = 0; i < Count; i++) { var LogItem = LogsCol.LogItem(i); Name = Logs.LogItem(i).Name; Status = Logs.LogItem.Status; } var TestResult = Status; switch (Status) { case 0: TestResult = "Passed" break; case 1: TestResult = "Warnings" break; case 2: TestResult = "Failed" break; default : TestResult = "Error" break; } app.Cells(rowCount,columnCount-5) = (aqConvert.DateTimeToFormatStr(aqDateTime.Now(), "%d/%m/%y %H:%M")); app.Cells(rowCount,columnCount-4) = Name; app.Cells(rowCount,columnCount-3) = TestResult; app.Cells(rowCount, columnCount-2) = testTime; app.Cells(rowCount, columnCount-1) = errorCount; app.Cells(rowCount, columnCount-0) = warnCount; book.Save(); app.Quit(); }Solved3.8KViews0likes18CommentsHandling POIXML Exception in Groovy Scripting
We are trying to read data from xlsx file using apache POI, we have all the jars files placed under soap/bin/ext. It gives us below error when running our groovy script. org.apache.poi.ooxml.POIXMLException: org.apache.xmlbeans.XmlOptions.setEntityExpansionLimit(I)Lorg/apache/xmlbeans/XmlOptions; error at line: 15 Code: import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; import org.apache.poi.ss.usermodel.CellStyle; FileInputStream inputStream = new FileInputStream("D:\\SOAP\\ExcelPOI.xlsx") Workbook wb = WorkbookFactory.create(inputStream) Sheet sheet1 = wb.getSheet("Sheet Name") int rows = sheet1.getLastRowNum(); log.info(rows)2.5KViews0likes11CommentsUsing Excel file as input to Soap call. Date issue uses slash separation.
Hi I'm trying to call a soap method where one of the inputs is a date. All the other input work fine. The date-format inthe excel sheet is DD-MM-YYYY but when SoapUI Pro reads it, it comes out as DD/MM/YYYY. I.e. it is separated by slashes instead of hyphens. Now the request does not adhere to the xsd schema and hence I cannot send it. So the question is how do I change the date format of the input in SoapUI? Thanks in advance.Solved2.1KViews0likes4CommentsTestComplete data driven loops not working for second row of an xls file
Hi Does anyone know of any simple misktakes that could stop a data-driven loop from and xls file stop working for a web page? My data loop successfully takes the data from the first row of a spreadsheet (to set up new users in a web app), but fails to find the data in the second row. When watching the script on the second iteration I can see that TestComplete goes to the correct field to enter the new username, but nothing happens ans it continues without erroring. Alternatively, does anyone know whoe to debug a data-driven loop to see if I can understand what is happening in the background. Many thanks, Dom.1.5KViews0likes4CommentsAlternatives to fixing issue with excel file not getting unlocked
Currently, after test runs I write to excel file for capturing test metrics. It seems that at times Microsoft does not unlock the excel spreadsheet and the test hangs until I manually kill the excel process. Are there any suggestions on how to fix this issue. This prevents us from running our tests overnight all the way through. The only alternative I can come up with is to write it to a text file as a .csv file. P.S. I am writing to excel as an ActiveXObject Looking for other alternatives. Thanks, JeffSolved1.4KViews0likes2CommentsTrying to process data from an Excel file
I'm trying to process the rows in an Excel file. Is there a way to do that by just reading in the worksheet once and then iterate through the rows.?? Each row will cause the flow of the test case to be conditionally changed as the required test steps for the active row is run depending on the values in different columns of the row.Solved1.4KViews0likes3CommentsExporting variable to CVS file to use in a later test
Hi All. I am generating a variable in Test1, that I would like to write/output to a CSV file (or even Excel would work) for use in Test2. Does anyone know of an easy way to do this? Or can provide some information on where to look on how to write to specific fields in a CSV/Excel file? Thanks.Solved1.2KViews0likes3Comments