August 3, 2011 at 12:08 pm
Hey guys I need to confirm something.
I'm tracing an ERP (Dynamics Nav). The problem is that this system uses sp_preparesql and sp_execute.
So after transfering all logins to a new server I hit replay and get this error (25% of the trace errors out with this).
> Failed to match corresponding handle value.
The sql in question looks like this : exec sp_execute 246,1,'AIRTEM'
The usual suspect for this error is missing login / permissions but I've taken care of that already.
Other than recycling sql server with a trace that kicks off on reconnect. Is there any way I can go around this problem and still get a good test on the replay?
August 3, 2011 at 1:51 pm
Unless you've run sp_preparesql with the same values on both servers, you're not going to get what you need.
Have you traced those?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 3, 2011 at 2:00 pm
GSquared (8/3/2011)
Unless you've run sp_preparesql with the same values on both servers, you're not going to get what you need.Have you traced those?
That's my whole issue. Server's been online for 3 weeks so those are long gone.
I was thinking about wipping the cache but I don't know 1 if it'll work and 2 if the ERP can cope with that.
So short of recycling the server I'm out of options?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply