Forum Discussion

Don's avatar
Don
Contributor
7 years ago

OnLogError Sender Returning Null Value, Updated to X64 for TestComplete and Office 2016

Hello Community,   I recently upgraded to the new TestComplete 12.42 which has x64 bit support. Because TC automatically installs x64 support, I installed Office 2016 with AccessDatabase 2016 both ...
  • Don's avatar
    Don
    7 years ago

    Ok So I may have found the solution.

     

    First I uninstalled the latest version of testcomplete and did a complete uninstall of office 2016. I then installed office 16, followed by Access Database 2010 followed by an older version of testcomplete. I then upgraded to the latest version.

     

    I also removed the excel code within the onLogError code. This excel code was there so it can write to the excel sheet the problem that occurred during the run. By removing it I won't be able to see why the run failed but I will still see that it failed. I will have to find a new solution for this but this is better than not having my tests work at all when doing a regression run.

     

    One last note. I installed only 32 bit version of office and access database. I am also using the 32bit version of TestComplete instead of the 64 bit. 

     

    Thanks to everyone who replied to this post. I will continue to update if needed with any new findings.

     

    I hope this helps anyone running into a similar issue.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

What is in your OnLogError event handler code?  It might be helpful to see what's being executed there to determine what other changes might need to be done.

 

Additionally, while by default TestComplete runs in 64 bit, you can still access a 32-bit version.  Typically installed in C:\Program Files (x86)\SmartBear\TestComplete 12\Bin\

  • Don's avatar
    Don
    Contributor
    7 years ago

    Thanks for the info about accessing the 32bit version. I am already fully invested in the 64 bit version and if I can't find a solution I will uninstall everything and reinstall it with the 32bit version

     

    Here is the code that I am using. It works fine with the 32 bit version that I haven't updated but like mentioned in the main post the 64 bit doesn't send the Sender value.

     

     

    function GeneralEvents_OnLogError(Sender, LogParams){
//  Log.Message(Sender);
  if (driver == true){
  Log.Message(typeof runSheet);
  var type = typeof runSheet;
  if(String(runSheet.cells(loopCounter,2)).search("AD_") == 0) {
  excel_library.quitExcel();
//    eval("excel_library.quitExcel()");
  }
  handlingRecursiveCallPopup();

     

     

    • tristaanogre's avatar
      tristaanogre
      Esteemed Contributor
      7 years ago

      I think you misunderstood... you don't need to re-install anything... the 32-bit version is installed already along with the 64-bit version.  You just need to run from a different directory.  I would try that and see if that works for you.

       

      In any case, I'm not sure the "Sender" is something generally accessible and usable.  If it's returning a "null" value, then it's probably because there's nothing there for you to access in the way of Log.Message.  I'm assuming, from your original post, that is what the problem is, that the Log.Message(Sender) line is not functioning?

       

      I see some code in there referencing Excel, some object called "runSheet" and a library of excel_library.  Could share that code as well?  It's possible that something needs updated in there to use the 64-bit drivers.

      • Don's avatar
        Don
        Contributor
        7 years ago

        That code that I use is the same code I'm using in the non Updated Version and it works fine. When I debug the code I see that Sender has values in the other machine that has the 32bit Software while the computer with the 64bit sends null.

         

        Im uploading some code from the Excel_library which is on a different script page.

         

        function readData(filePath,sheetname,rowNum){         
  getData(filePath);     
  var sheet = wb.Worksheets(sheetname);                       
  var colCount = sheet.usedrange.columns.count;
  dataArray=[];                    
  for (i=2;i<=colCount;i++) {
    dataArray.push(sheet.cells(rowNum,i).value);                       
  }
  wb.close();
  xl.Application.Quit();
  return dataArray;
}

        As for RunSheet that is just a globalVariable at the top.