Can 2 separate calls to the same web service change the varible values of each other?

C# . Net 4.0

I have a serious issue
This is a Web service
It gets called by something external
There can be multiple calls to the same web method from theses external callers

I was expecting each external call would be run in its own separate process space. But it does not seem to be( from inline traces that I dump to a text file)
I can see that one method call has changed the variable of another method call.  

Any hep is appreciated.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

is the variable part of a database insert ?
indikadAuthor Commented:
No. But it's a complex operation

The web method call gets a parameter. It's the name of a database. The database contains all the data I need to collect to compile a PDF document. T do that i am using msoffice interrop word component.

I loop through the data in the db to get the infomation. Each data set will be packed into a PDF doc. Then this PDF is emailed - not as an attachment but using he PDF data as the email body. There can be about 500 emails happening for one such web service call.

The issue is: when the first call is being run ; because there are a lot of emails to generate it takes some time. Meanwhile a second web service call is received but for a different database, but.. The second call has changed some running variable values of the first call.
ah I understand whats going on now... hmm
my initial thought was hoping that it was part of a SQL statement that could use a race condition so that the variable wouldnt change from the siutation you described.

a suggestion would be to write a procedure to see if the webmethod has been run in the last 5 min.
if yes .....
send a message back to the user saying to try again in 5 min
if no....
Run the web method
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

indikadAuthor Commented:
I cannot do a live run now. Can be catastrophic( the results)
indikadAuthor Commented:
To your knowledge do separate web method calls run in different process spaces( I thought it should)???
indikadAuthor Commented:
I still cannot comprehend how 2 separate calls can interfere with each other - as I was sure they should run in its own process space .

Hope someone can shed some light in that area .

Thanks very much.
indikadAuthor Commented:
closing due to in sufficient replies.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
indikadAuthor Commented:
no helpful comments received.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.