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.
| 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. |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 some valueprithvi nath pandey |
|
|
|
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 some valueprithvi 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
|
|
|
production issue need to replicate and resolve