Forum Discussion

JackSparrow's avatar
JackSparrow
Frequent Contributor
8 years ago

Test Complete getting crashed due to DB Error

Hi All ,   My test complete used to crash rarely but now a days it started frequently , so while I was trying to find the root cause I understood that if there is a db error(like the column name is...
Python
  • tristaanogre's avatar
    tristaanogre
    8 years ago

    Sounds like an issue to raise with the support staff directly.

    https://support.smartbear.com/message/?prod=TestComplete

     

    Something else you might want to try is, after you're finished with your ADO objects, try setting the variables to "null" to just clear them out of memory.  TestComplete does have some of the garbage collection going on in it but it's not 100% reliable. Null your objects and see if you still get the crash.

JackSparrow's avatar
JackSparrow
Frequent Contributor
8 years ago

Hi all,

 

I used try catch exception [Python] still its gets crashed every second execution

 

  AConnection = ADO.CreateADOConnection()
  AConnection.ConnectionString = "Provider=MSDASQL;" + "DRIVER=Ingres; " + "Data Source=LMK2 penelope;" + "SERVERTYPE=INGRES;" + "Database=itvtestauto;"
  AConnection.LoginPrompt = False
  try:
    AConnection.Open()
  except AConnection.Errors as excp:
    Log.Error("DB exception"+ str(excp))
    AConnection.Close()
  try:
      AConnection.Open()
      RecSet  =  AConnection.Execute_('select short_name,demo_code from demo')
      RecSet.MoveFirst();
      data_container = []
      r= []
      while not RecSet.EOF:  
        rows = RecSet.Fields.Item["short_name"].Value
        data_container.append(rows)
        RecSet.MoveNext()  
  except AConnection.Errors as e:
        Log.Error("DB exception"+ str(e))
        AConnection.Close()
  else:       
      AConnection.Close()
      Log.Message(str(data_container))
      dbcount = len(data_container)
      Log.Message("The Database Count of the Demography List is  :"+str(dbcount))
  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    Sounds like an issue to raise with the support staff directly.

    https://support.smartbear.com/message/?prod=TestComplete

     

    Something else you might want to try is, after you're finished with your ADO objects, try setting the variables to "null" to just clear them out of memory.  TestComplete does have some of the garbage collection going on in it but it's not 100% reliable. Null your objects and see if you still get the crash.

    • JackSparrow's avatar
      JackSparrow
      Frequent Contributor
      8 years ago

      tristaanogre

       

       

      I think assigning the object to Null have helped now its working .Since I have made the mistake intentionally to check does the test complete will crash or not  and executed 70 times and  the test complete did not get crashed :)

       

       

       

    • AlexKaras's avatar
      AlexKaras
      Champion Level 3
      8 years ago

      Hi,

       

      >  TestComplete does have some of the garbage collection going on in it but it's not 100% reliable.

      I think that TestComplete manages only its own objects like Project Variables, Object Browser objects, etc. I believe that for the objects created in test code, TestComplete relies on the memory management / garbage collection provided by the given scripting runtime. Some of these garbage collectors might process disposed of objects not immediately but with some delay. Yes, potentially this may cause some problems in TestComplete (especially for the Python which is a new scripting language for TestComplete), but I wouldn't treat this as a sole fault of TestComplete.

       

      P.S. But the tip from Robert is really good. For a long time it is not required (and even not recommended) to do a variables clean-up for VBScript. It looks like it is still a good idea to do a clean-up for JScript and Python...