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

Akash Dani

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)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
Hi,

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

Regards
Rijwan
+1
Akash Dani5y ago
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
+1
Sachin Singh5y ago
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.
+3
Jignesh Kumar5y ago
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
+1
Salman Beg5y ago
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
+1