Forum Discussion

csachanandani's avatar
csachanandani
Occasional Contributor
4 years ago
Solved

Test Complete crashing after scripts with SQL connections are run consecutively

My Test complete instance just crashes if I run my script with SQL call consecutively. Its like this first run - its successful, second run - TC crashes. Has anyone experience same? Looking ways to resolve this issue.

Keyword Tests
  • csachanandani's avatar
    csachanandani
    4 years ago

    Hello,

     

    Yes, the connection was closed after every call and there is no active connection limit on the SQL config.

     

    The issue was linked to external library calls and that wasn't working well.

    We re-wrote the code using ADO way and it is working without an issue.

6 Replies

Sort By
  • BenoitB's avatar
    BenoitB
    Community Hero
    4 years ago

    That looks more on a problem with your dll files or your db engine than a TC problem.

    Look at the event log of Windows to perhaps find the exact cause.

    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)
      4 years ago

      Benoit, thanks! 

       

      csachanandani Were you able to figure this out? Was this a dll problem? Please share.

      • csachanandani's avatar
        csachanandani
        Occasional Contributor
        4 years ago

        SmartBear is looking into the dump file. Regarding dll error, I do not see anything other than event id 5973 every time crash occurs.

  • anupamchampati's avatar
    anupamchampati
    Frequent Contributor
    4 years ago

    1, Are you closing the connection after first call?

    2, Any limit on the no of active connections in SQL config?

    • csachanandani's avatar
      csachanandani
      Occasional Contributor
      4 years ago

      Hello,

       

      Yes, the connection was closed after every call and there is no active connection limit on the SQL config.

       

      The issue was linked to external library calls and that wasn't working well.

      We re-wrote the code using ADO way and it is working without an issue.