Forum Discussion

csachanandani's avatar
csachanandani
Occasional Contributor
5 years ago

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 r...
Keyword Tests
  • csachanandani's avatar
    csachanandani
    5 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.

anupamchampati's avatar
anupamchampati
Frequent Contributor
5 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
    5 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.

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

      csachanandani Thank you for the update in this thread!