Forum Discussion

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 resolve this issue.

Keyword Tests

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.

BenoitB
Community Hero
5 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
  SmartBear Alumni (Retired)
  5 years ago
  Benoit, thanks!
  
  csachanandani Were you able to figure this out? Was this a dll problem? Please share.
  - csachanandani
    Occasional Contributor
    5 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
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
  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
    SmartBear Alumni (Retired)
    5 years ago
    csachanandani Thank you for the update in this thread!