Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 production issue need to replicate and resolve

Author  Topic 

nextaxtion
Yak Posting Veteran

54 Posts

Posted - 2014-12-19 : 01:16:11
hi team,

there are some issues identified in my application at production but issues occurred once in 1000 transaction not every time.
i tried to replicate with same data but on my development server there is no such issue may be due to load or any other factor.
but my manager told me to find root cause and resolve the issue asap.

The issue is that a procedure is called from front end and it calls multiple nested procs to process some data tat will affect(insert and update )some table.
so what is best approach to start with and is there any database settings i need to check.

Kindly suggest.

prithvi nath pandey

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-19 : 07:21:53
you haven't really stated what the problem is so its really pretty difficult to advise you.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-19 : 12:18:04
Depending upon the frequency (time), I'd probably run a trace until the issue occurs and then pour through that data to walk the transactions.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

nextaxtion
Yak Posting Veteran

54 Posts

Posted - 2014-12-20 : 14:33:47
The actual problem is that a table ia not updated with any value the null value is updated istaed of s
ome value

prithvi nath pandey
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-22 : 12:17:55
quote:
Originally posted by nextaxtion

The actual problem is that a table ia not updated with any value the null value is updated istaed of s
ome value

prithvi nath pandey



Can't you change the column so that it's NOT NULL and then handle the exception from the application when a NULL is attempted to be inserted?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

nextaxtion
Yak Posting Veteran

54 Posts

Posted - 2014-12-22 : 13:01:28
but the question is how to find root cause. when all the code is write to update value so where is null value coming in picture.
in this case i can also check the value of variable but i how i find the actual issue.


prithvi nath pandey
Go to Top of Page
   

- Advertisement -