Look for a rollback transaction in the SQL logs. It is often a problem when making a custom integration into one of the Remedy applications (saw this in my integration to MySoft telecomm system back on Help Desk 5.5), or trying to set up an AIE job correctly.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nall, Roger Sent: Thursday, October 21, 2010 4:15 PM To: [email protected] Subject: Web Service Issue ** ARS 7.1 Patch 4 Win2k SQL2k We have a situation where we create tickets in another system consuming a web service. The Output of the web service is the ticket number from the other system. Our process to create this ticket is as follows: * Make a change on Remedy ticket. * Push data from Remedy ticket to an intermediate form in Remedy. * Call web service from intermediate Remedy form. * Push ticket number from other system back to Remedy ticket. On a daily basis, we end up with duplicate tickets in the other system. In all cases, the only record in the intermediate Remedy form has a create date and ticket number from the second ticket in the other system. I have always suspected that on the first web service call, the other system returned an error whereby all changes were backed out of Remedy. On the second submission there was no error and thus all changes were committed. I have one user who is saying that he is not encountering an error when making the first web service call but at the same time he is not getting a ticket number back. Can someone tell me if a ticket number or an error is not returned what happens to the transaction on the Remedy side? Thanks Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Helpful Links: | Reports<http://bi.eng.t-mobile.com:8080/InfoViewApp> |SA_Suggestion Box<http://saintake.t-mobile.com/> | SA_Trouble Ticket<http://natweb.eng.t-mobile.com/sites/TTWeb/CreateTicket.aspx> | _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
