Link to home
Start Free TrialLog in
Avatar of ukerandi
ukerandiFlag for United Kingdom of Great Britain and Northern Ireland

asked on

The transaction has aborted. Transaction Timeout

Hi, I'm getting following error message  when i'm running the stored procedure.But sometime it's working fine.
The transaction has aborted.
Transaction Timeout
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

I think its a timeout issue..if you raise the timeout (seconds) probably you will get away with this.
But you really need to check the Stored Procedure...just wait for the next error...grab what you have send to SQL and check if it was OK... (just run the exact SP with the arguments you supplied on SSMS) ...maybe something is wrong.
Other than that check your network....
Avatar of ukerandi

ASKER

I think its a timeout issue:
How to solve this.Any better coding for this or any recommendation for this
You haven't provided any sample of your code and what ever strategy you use to connect to SQL server...
In the connection properties you can define the Timeout.
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectiontimeout?view=netframework-4.8
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.