It sounds like the code is written to not fail if the procedure does. CF normally just waits for the dB to return something.
Your guess about the timeout could be correct and you may need to see what the dB is doing when it should be completing your procedure. I could only be more definite if I had a test setup that imitated your production server and dB People write this 'silent fail' type of code all the time when they think they dont have to own the problem that is causing the failure. (e.g. maybe the dB admin needs to look at backups to see if they hog resources just when your proc needs them) > To: [email protected] > Subject: Re: cf stored procedure question > Date: Mon, 7 Mar 2011 11:22:28 -0500 > From: [email protected] > > > >Can you get a test page into production? > > > >You might need to find out if its only this stored procedure that is timing > >out. > > > >Can you run a conventional query that does the same thing and test it? > > > I can not get a test page onto production. I know that it's running half way > through the page fine because data is updated in those update sql scripts. > After that, there's a bunch of if/else statement. The first thing in each of > those if/else statements is this stored procedure. There is information that > should be updated after that stored procedure, none of which are being > updated. This led me to the stored procedure as the possible culprit. > > Still, what is the expected action of the page if the stored procedure times > out? I know I can set a timeout to a query, but not to a stored procedure. > If it does time out, what happens to the rest of the cold fusion page? I'm > trying to determine the reason that the rest of the fields aren't being > updated. > > thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6931 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
