akalogeropoulos
Occasional Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Get keywordTest results from Project logs
I need to get the results of each keywordtest executed in the specific project. So i could update my test coverage via API function I added at the end of the project in a script. I do not need any details, only if OK / Failed. I included an image of the "TestItems" tab of one of my projects, that demonstrates the structure of my projects test items. Best regards, Anastasios KalogeropoulosError code "530 5.7.1 Client was not authenticated" sending email.
I'm getting the erreur code "530 5.7.1 Client was not authenticated" when i try to send an email. I was working before but since IT has update the email server it stop working. They provide me with username and password to use in my code but it still does not work. Code: function SendEmail(mFrom, mTo, mSubject, mBody, mAttach) { var i, schema, mConfig, mMessage; try { schema = "http://schemas.microsoft.com/cdo/configuration/"; mConfig = Sys.OleObject("CDO.Configuration"); mConfig.Fields.Item(schema + "sendusing") = 2; // cdoSendUsingPort mConfig.Fields.Item(schema + "smtpserver") = "ServerName"; // SMTP server mConfig.Fields.Item(schema + "smtpserverport") = 25; // Port number mConfig.Fields.Item(schema + "smtpauthenticate") = 0; // Authentication mechanism mConfig.Fields.Item(schema + "sendusername") = Username; // User name (if needed) mConfig.Fields.Item(schema + "sendpassword") = Password; // User password (if needed) mConfig.Fields.Update(); mMessage = Sys.OleObject("CDO.Message"); mMessage.Configuration = mConfig; mMessage.From = mFrom; mMessage.To = mTo; mMessage.Subject = mSubject; mMessage.HTMLBody = mBody; if(mAttach != "") { aqString.ListSeparator = ","; for(i = 0; i < aqString.GetListLength(mAttach); i++) mMessage.AddAttachment(aqString.GetListItem(mAttach, i)); } mMessage.Send(); } catch (exception) { Log.Error("E-mail cannot be sent", exception.description); CollectGarbage(); return false; } Log.Message("Message to <" + mTo + "> was successfully sent"); CollectGarbage(); return true; Best regards, Anastasios.Connect to SQL Server via ADO object
I'm trying to connect SQL database using the ADO object. Everything installed on same machine, TC(v10.60), SQL Express 2014. I'm getting the following error message. Named Pipes Provider: Could not open a connection to SQL Server [53] function checkDatabse() { var AConnection; AConnection = ADO.CreateADOConnection(); AConnection.ConnectionString = "Provider=SQLNCLI11;Server=myserver\SQLEXPRESS;Database=MyDatabase;Uid=User;Pwd=password;"; AConnection.LoginPrompt = false; try { AConnection.Open(); Log.Message("Database Opened") } catch(e) { Log.Message(e.message) } } Best regards, Anastasios KalogeropoulosUnexpected character in query string while parsing in XML 4.0
I need to extract certain information and compile it into an email. Then send when all the tests are done. I serach and found this bit of code on Smartbear community. When I execute the code, i get the following error message: Unexpected character in query string. Nodes/Node[@na--><--me="root"]/Prp[@name="warning count"]/@value Here is my code in JScript: function getInformationData() { //var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\" + Math.floor(Math.random() * 10000) + "\\"; var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\testXML\\"; aqFileSystem.CreateFolder(tempFolder); Log.SaveResultsAs(tempFolder, lsXML); var xDoc = Sys.OleObject("MSXML2.DOMDocument.4.0"); xDoc.load(tempFolder + "Description.tcLog"); Log.Message(xDoc.xml); // Warning count var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning count"]/@value').text); //var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning test count"]/@value').text); //Error count var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error count"]/@value').text); //var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error test count"]/@value').text); //Execution time var startTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="start time"]/@value').text); var stopTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="stop time"]/@value').text); aqFileSystem.DeleteFolder(tempFolder, true); var res = "Errors: " + errC + "\r\n" + "Warnings: " + wrnC + "\r\n" + "Start Time: " + DateTimeToStr(startTime) + "\r\n" + "Stop Time: " + DateTimeToStr(stopTime) + "\r\n" + "Run Time: " + aqConvert.DateTimeToFormatStr(stopTime - startTime, "%H:%M:%S"); Log.Message(res); //return res; } I also included a screen capture of the error message: Best regards, Anastasios KalogeropoulosUnexpected character in query string in msxml4.dll
I copie the code I found in the smartbear community. Everytime I execute the keywordtest and then i run the function "getInformationData()", so i could retrieve warning /error count and the time it took to execute the test. Error message: Unexpected character in query string. Nodes/Node[@na--><--me="root"]/Prp[@name="warning count"]/@value Here is the code JScript : function getInformationData() { //var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\" + Math.floor(Math.random() * 10000) + "\\"; var tempFolder = aqEnvironment.GetEnvironmentVariable("temp") + "\\testXML\\"; aqFileSystem.CreateFolder(tempFolder); Log.SaveResultsAs(tempFolder, lsXML); var xDoc = Sys.OleObject("MSXML2.DOMDocument.4.0"); xDoc.load(tempFolder + "Description.tcLog"); Log.Message(xDoc.xml); // Warning count var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning count"]/@value').text); //var wrnC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="warning test count"]/@value').text); //Error count var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error count"]/@value').text); //var errC = VarToInteger(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="error test count"]/@value').text); //Execution time var startTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="start time"]/@value').text); var stopTime = VarToFloat(xDoc.selectSingleNode('Nodes/Node[@name="root"]/Prp[@name="stop time"]/@value').text); aqFileSystem.DeleteFolder(tempFolder, true); var res = "Errors: " + errC + "\r\n" + "Warnings: " + wrnC + "\r\n" + "Start Time: " + DateTimeToStr(startTime) + "\r\n" + "Stop Time: " + DateTimeToStr(stopTime) + "\r\n" + "Run Time: " + aqConvert.DateTimeToFormatStr(stopTime - startTime, "%H:%M:%S"); Log.Message(res); //return res; Best reagrds, Anastasios KalogeropoulosRe: TestComplete 10.6 - Problems with parameters in Run Keyword Test
The link you provided does not work. When I click on TestComplete, it directs me to another page that displays "http://smartbear.force.com/License is under construction". I'm not able to request the patch. Best regards, Anastasios Kalogeropoulos
