In SQL server is there any issue to fetch same data from different service

Question

0.00/5 (No votes)

See more:

I have two services and they are calling different store Proc. But both the store Proc are fetching data from same table. Sometimes, the same record from the table is being fetched by both service.
Sometimes, I am facing Null object reference error. I am not sure if this may be one of the cause. Can you one please help me.

What I have tried:

I have tried to run both services locally, but no issue found. But issue is happening in production.

Posted 15-Jun-16 11:47am

Member 4228925

Add a Solution

Comments

an0ther1 15-Jun-16 18:09pm

Improve your question by adding additional detail.
There is several reasons as to why the problem may be occurring but without an idea of what your Stored Procedures look like & additional details we cannot provide any information.
Typically when a stored procedure is called (assuming no record locking is used & no read hints) then both should return the expected data but if one is using ReadCommitted and the other is using ReadCommittedLock then you may experience this.

Kind Regards

Member 7434378 15-Jun-16 20:30pm

Show some code, but a null reference error occurs when you referencing something that is null, you declared an object but didn't initialize it.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)