ContributionsMost RecentMost LikesSolutionsRe: DB Table Variable Not Holding Correct Value sonya_m Yeah, it's very odd. Issue was reliably happening until Tuesday morning when it just stopped occurring. In talking to our infrastructure team, no changes were made to the development vm during this time frame. Additionally, I had a team member attempt to run the same wrapper function while the error was happening for me and the issue did not occur on their development vm. Glad it's not happening anymore, just wish I could have identified what caused it in the first place. DB Table Variable Not Holding Correct Value Have a weird instance of a problem I was hoping to see if anyone else has encountered. Within a keyword test, we have a DB Table variable that points to an excel file as a data source for the test. For example, lets say it's at the location'C:\Temp\Test\MainBranch\ProjecSuite\Data_Files\datafile.xlsx'. When you view how the location is saved on the Variables tab of the Keyword Test, it displays as "..\..\Data_Files\datafile.xlsx". When I attempted to run my test today (that has worked in the past), it reported the error of "Unable to connect to the data source" and listed a path on the Details tab of the log of'C:\Temp\Test\ProjecSuite\Data_Files\datafile.xlsx'. I have no idea why it decided to drop the folder from the path, but when I went to edit the variable to verify it was pointing to the correct location, it was. Any ides or thoughts as to why this might happen? Re: Log.SaveResultsAs Reporting Error for lsXML Option The response I received from support was verifying the issue, with the potential reason possibly being that since I was specifying a folder path with the xml option that this doesn't actually generate a xml file, but rather the tclog file. From that, since an xml file wasn't generated, the error was logged. Since we aren't tied to using that method, we'll go forward with one of the others that don't log an error. And currently we are just trying to get up to version 14.1, so I would not know the functionality of this feature in 14.2. Log.SaveResultsAs Reporting Error for lsXML Option Test Machine Information - VM running Windows 10, with TestComplete 14.1 installed, and coding in VBScript. Was hoping to get some feedback to see if anyone else has had this issue. When using the Log.SaveResultsAs method (https://support.smartbear.com/testcomplete/docs/reference/project-objects/test-log/log/saveresultsas.html) to export to a folder location using thelsXML option, the full TestComplete log reports that the operation failed. However, when I go to look at the folder it appears that all necessary files have been saved to the location. From this I went and tested other Log.SaveResultsAs options, and none of those reported an error. This included thelsZip option that saves thexml export files in a zip file. Below is my sample code testing this functionality out. From all of that, has anyone seen this occur for them when using theLog.SaveResultsAslsXML option? Sub testlogfunctions Dim html_Path Dim xml_Path Dim mht_Path Dim zip_Path Dim packedhtml_Path Call Log.Message("Post to log to have data for log save") Call aqutils.Delay(500) Call Log.SaveToDisk() Call aqutils.Delay(500) html_Path = "C:\TEMP\html_Folder\" xml_Path = "C:\TEMP\xml_Folder\" mht_Path = "C:\TEMP\mht_Folder\file.mht" zip_Path = "C:\TEMP\zip_Folder\file.zip" packedhtml_Path = "C:\TEMP\packedhtml_Folder\file.zip" 'lsXML = 0 If Log.SaveResultsAs(xml_Path, 0, False, 0) <> True Then Log.Error("SaveResultsAs failed for XML") Else Log.Message("SaveResultsAs successful for XML") End If Call aqutils.Delay(500) 'lsHTML = 1 If Log.SaveResultsAs(html_Path, 1, False, 0) <> True Then Log.Error("SaveResultsAs failed for HTML") Else Log.Message("SaveResultsAs successful for HTML") End If Call aqutils.Delay(500) 'lsMHT = 2 If Log.SaveResultsAs(mht_Path, 2, False, 0) <> True Then Log.Error("SaveResultsAs failed for MHT") Else Log.Message("SaveResultsAs successful for MHT") End If Call aqutils.Delay(500) 'lsZip = 3 If Log.SaveResultsAs(zip_Path, 3, False, 0) <> True Then Log.Error("SaveResultsAs failed for Zip") Else Log.Message("SaveResultsAs successful for Zip") End If Call aqutils.Delay(500) 'lsPackedHTML = 4 If Log.SaveResultsAs(packedhtml_Path, 4, False, 0) <> True Then Log.Error("SaveResultsAs failed for Packed HTML") Else Log.Message("SaveResultsAs successful for Packed HTML") End If Call aqutils.Delay(500) End Sub SolvedRe: Pull code from repository on VM startup? Sounds good, thanks again. I'll pass this over to the others working on our upgrade to see if this is the solution they were hoping for. Re: Pull code from repository on VM startup? Thanks for the quick reply. From the command line code listed there, aside from needing a version of visual studio installed on the VM, I'm guessing you need to have an account logging in to the VM that has access to the TFS repository and has mapping defined to pull to a location (in this case, defined on the master vm so it exists on runner vm creation/recreation), yes? Or is it possible in the command line string to define permissions and the folder location to write the code to? Our test user for our vm's currently doesn't have access to our repository since we've only manually pushed code to the vm's so far. Pull code from repository on VM startup? Hello Everyone, I tried doing some searching, but wasn't able to find help related to what we're trying to do with a new VM setup. We are currently being upgraded to new windows 10 vm's with the plan that we will have one master that all of our test runner machines will be created from on start/restart. Once the vm's are created, they will just have the software installed we need to run our tests through TestExecute. When a vm is restarted, it will then be re-built each time from the master to try and keep the machine as clean as possible. The part we're trying to figure out is how we can on vm startup pull code from our TFS repository so the VM has the latest version of code to run tests/processes we use it for. This restart would most likely happen over the weekend and we have processes that run daily early in the morning (2 AM) that would need this code to be able to run when no one is there to push code to the vm. In our current setup, we are able to copy code manually down to our VM's that are not rebuilt upon a restart and thus keep the code necessary to run day to day. Any suggestions on how to approach this are appreciated, thanks. SolvedSplit Parameter at Runtime with VBScript? I don't think what I'm about to ask for is possible, but wanted to see if anyone has done this, or has potential ideas. Current language we are utilizing is VBScript as noted in the subject. We're currently making a function that will be used to manage email notifications utilizing the built in Test Complete SendMail function. This is so we can set default values around running SendMail usage, and report to the log if a parameter was not properly set before actually running the built in function. However, this currently limits us to only specifying one attachment since we now have a default call when using this function ofBuiltIn.SendMail(ToAddress,FromHost,FromName,FromAddress,Subject,Body,FileName1). What we would like to be able to do in the listed call above is pass an array as FileName1 that can then be split at run time and processed as multiple parameters so that while the call looks like above, it actually processes asBuiltIn.SendMail(ToAddress,FromHost,FromName,FromAddress,Subject,Body,FileName1, FileName2, etc.). The correct answer very well may be "no, this is impossible", but figured it can't hurt to ask. Solved