Test Complete crashing after scripts with SQL connections are run consecutively

[csachanandani]

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.

[BenoitB]

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]

Benoit, thanks! 

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

[csachanandani]

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]

1, Are you closing the connection after first call?

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

[csachanandani · Accepted solution]

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]

@csachanandani Thank you for the update in this thread!