Comments by Member 4228925

Member 4228925 15-Jun-16 16:41pm View

yes i did. I called the method of the Service 3000 times from SOAP UI, that mean 3000 the DB was also connected and Stopre proc was executed. Still no exception i found while i locally debugged the code.

SqlCommand cmd = SearchAgentsCommand(searchCriteria);
cmd.Connection = con;
con.Open();
dr = cmd.ExecuteReader();
response.Agents = new List<contracts.agent>();
while (dr.Read())
{
Agent = GetAgent(dr, searchCriteria.SearchOnly);
response.Agents.Add(Agent);
}
dr.Close();

if (searchCriteria.SearchOnly == AgentSearchType.U65Agent)
{
foreach (Contracts.Agent agent in response.Agents)
{
agent.Languages = Utilities.GetAgentLanguages(agent.AgentId, con);
}
}

Problem happening at -foreach (Contracts.Agent agent in response.Agents)
So if response.Agents is null then -Null reference exception will come.
But response.Agents can not be null as its being initialized using- response.Agents = new List<contracts.agent>();
So i am clueless...
Adding one more point- There is also another similar job which also try to fetch data from same table. Not sure if there is any race condition or any similar issue or not.

Member 4228925 13-Jun-16 17:11pm View

Thank you Tejas... But problem is not consistent. At 6:30 am, when job is run, this problem comes and later point of time this problem does not comes. So i am searching for other possible reason- Like issue in the Store proc its calling, the load in the DB , or conflict with other call which is trying to fetch the same table - which is amounting to the null object. My main concern- if it is simple null reference issue, why i dont get it in other time frame?

Member 4228925 13-Jun-16 17:11pm View

Thank you SA... But problem is not consistent. At 6:30 am, when job is run, this problem comes and later point of time this problem does not comes. So i am searching for other possible reason- Like issue in the Store proc its calling, the load in the DB , or conflict with other call which is trying to fetch the same table - which is amounting to the null object. My main concern- if it is simple null reference issue, why i dont get it in other time frame?

Member 4228925 6-May-15 14:02pm View

Thank you

Member 4228925 6-May-15 14:01pm View

Thank you

Member 4228925 21-Mar-15 17:57pm View

This is our own project. Few of the projects were developed few years back. Like i mentioned a service. No change was required in the service in last few years. No suddenly need change in the service. So i need to debug and make change. But when i see the repository only the relevant files are there but there are no solution file. So i am not able to open the files and work. Thats why i am asking for help.

Member 4228925 21-Mar-15 11:47am View

Got it..thank you

Member 4228925 21-Mar-15 11:47am View

Thank you everyone..i was guessing the reason like the CAT example given above..thank you!!

Member 4228925 8-Mar-15 16:02pm View

There is no Index right now and cant put that as well for several reason. At this moment i want to know exactly why fetching much less record using where clause is taking much longer time.

Comments by Member 4228925 (Top 9 by date)