Sqlserver stored procedure is stopped while run from front end asp.net

Question

I have a sql stored procedure to upload the group of files. when I run that procedure from front end half of the files are uploaded and theprocedure is stopped suddenly. but when I run it from backend its running.I don't know the exact reason. Please can anyone help me.(Note: Iam using IIS to run the application)

Sachin Singh · Answer

It is a problem with sql server 2008 , use upgraded version and you won't face such issues. also use nolock in the query, you can also use timeout cmd.commandTimeout=0; but ultimately, its purely server issue which slows down the execution and leads to timeout. call your DBA if he can do something with sql server 2008.

Rijwan Ansari · Answer

Hi, I think, it could be because of timeout error. Can you please share error msg? Regards Rijwan

Akash Dani · Answer

I tried by setting the Connection timeout 0 but its not working. I used the try catch also its not throwing any error. But while the procedure running itself its calling the master page. I dont know why its calling master page while procedure is running

Jignesh Kumar · Answer

Hi Aakash, How long its take from front end. I think you are facing time out issue due to this its get stop to run. Put try catch block and get exact error then you can troubledhoot your issue

Salman Beg · Answer

May be you are getting some error while running the stored procedure from front-end. So put try catch block to catch any errors and log it. Also debug each and every line by putting breakpoint so that you will get to know the errors easily. Thanks