The best way to troubleshoot this issue if it is reproducible is to start a SQL Server Profiler trace to observe exactly what the database is doing.
Maybe the CF code is running twice, the first is working and the second is failing. -Mike Chabot On Wed, Jan 13, 2010 at 2:40 PM, Ali Awan <[email protected]> wrote: > > I have run into a unique situation, the first time in my 10 years of using CF. > > I have a pseudo-fusebox app, and I have an act page we'll call it: > act_process.cfm > > it calls 2 qry files that in turn call one stored proc each. > > When the act page runs, I have checked the database and all the procs ran and > updated the necessary data and inserted the necessary records. > > However coldfusion throws an error saying that the first proc failed due to a > primary key constraint. The 1st proc is the only one that does inserts. > > I am using ColdFusion 8, and the database is SQL 2008. > > The error is: > [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY > constraint 'PK_mypkname'. Cannot insert duplicate key in object 'dbo.tableA'. > > Any help would be appreciated. > > Thanks, > Ali > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
