Regarding thread related issue.

Question

User-867243936 posted

Hello guys,

holpe all are doing well.

i have some problem in thread. within a button click event of a ASP web page i need to call 10 seperate function which are usually update 10 tables. i used trunsaction scope for avoiding inconsistency data updation. its working fine.

problem is when trying to retrive data from those tables sometimes it raise race condition and not able to generate report. my application is hosted on global server, this type of condition only raise when number of user is more than 100.

please help me out from this problem.

Thanks in advance.

Answer 1

User-1925713106 posted

Hi Subhrangshu,  

Thanks for your post.

Can you ensure this issue caused by updating 10 tables in thread?

If you update value in tables without thread, retrieve data from those tables will occur that issue?

Answer 2

User-867243936 posted

hello

actually i am using transaction scope in that button click, for that reason when some one accured this scope and utill commit trunsaction ,  in the mean time if some one try to access report, not able to get proper data, and some time it raise race condition.

Answer 3

User-1925713106 posted

Hi Subhrangshu, 

Thanks for your reply.

We suggest you add the some judgment statements in code to disable access report during transaction scope.