cancel
Showing results for 
Search instead for 
Did you mean: 

Test Complete crashing after scripts with SQL connections are run consecutively

SOLVED
Highlighted
Occasional Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Occasional Contributor

Re: Test Complete crashing after scripts with SQL connections are run consecutively

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.

View solution in original post

6 REPLIES 6
Highlighted
Community Leader

Re: Test Complete crashing after scripts with SQL connections are run consecutively

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.

Un sourire et ça repart

Highlighted
Community Manager

Re: Test Complete crashing after scripts with SQL connections are run consecutively

Benoit, thanks! 

 

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


Sonya Mihaljova
Community and Education Specialist
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
Occasional Contributor

Re: Test Complete crashing after scripts with SQL connections are run consecutively

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

Highlighted
Contributor

Re: Test Complete crashing after scripts with SQL connections are run consecutively

1, Are you closing the connection after first call?

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

Tags (1)
Highlighted
Occasional Contributor

Re: Test Complete crashing after scripts with SQL connections are run consecutively

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.

View solution in original post

Highlighted
Community Manager

Re: Test Complete crashing after scripts with SQL connections are run consecutively

@csachanandani Thank you for the update in this thread!


Sonya Mihaljova
Community and Education Specialist
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
Let's start July with new challenges!

Create a script to pass custom command-line arguments as a test parameter for the TechCorner tag!

Will you dare to take the challenge?


Top Kudoed Authors