Re: Issue with Delete record through webservice
Hi Satya Gandhi, Depending on your app, it may be possible to set the delete-flag/field through Web Services, and then use an Escalation to delete the record. That would cause a slight delay before the escalation runs and actually deletes the record though... I have some times created a Delete-form where I push a record id and form name. An escalation then runs on the delete form and deletes the required record as dictated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Dear Listers, I have a regular form which holds some records. A webservice is exposed on this form which is consumed by a .Net webservice from a external application. This .Net webservice sets a flag to YES on a particular record based on the input given by the webservice (Request ID on the form = Request ID coming from the.Net webservice). A On Modify filter is written which checks if the FLAG = YES; then delete the particular record using the Run Process Application-Delete-Entry. When the webservices sets the FLAG as YES; the on modify filter is triggered and the entry is deleted and it throws me an error Entry does not exist in the database. When i look at the logs; the filter processes the Applicaiton-Delete-Entry and deletes these records and after which a select statement is issued from the T table on the condition C1 = $Request ID$. This is the culprit here. We have tried using filter phase overriding Application-Query-Delete-Entry also with no use. Still the same error persists. We recently upgraded to v7.0.1 p4 and we have tried the same on a server running v6.00.03 p1497 with no use. Can someone throw some light on this? -- Thanks Regards Satya Gandhi Consultant - Remedy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Issue with Delete record through webservice
Misi, We recently upgrade to v7.0.1 from v6.1 and after the upgrade this is the first time we are testing this feature and got this error. It used to work perfectly in v6.1. Any idea? Satya On 9/26/07, Misi Mladoniczky [EMAIL PROTECTED] wrote: Hi Satya Gandhi, Depending on your app, it may be possible to set the delete-flag/field through Web Services, and then use an Escalation to delete the record. That would cause a slight delay before the escalation runs and actually deletes the record though... I have some times created a Delete-form where I push a record id and form name. An escalation then runs on the delete form and deletes the required record as dictated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Dear Listers, I have a regular form which holds some records. A webservice is exposed on this form which is consumed by a .Net webservice from a external application. This .Net webservice sets a flag to YES on a particular record based on the input given by the webservice (Request ID on the form = Request ID coming from the.Net webservice). A On Modify filter is written which checks if the FLAG = YES; then delete the particular record using the Run Process Application-Delete-Entry. When the webservices sets the FLAG as YES; the on modify filter is triggered and the entry is deleted and it throws me an error Entry does not exist in the database. When i look at the logs; the filter processes the Applicaiton-Delete-Entry and deletes these records and after which a select statement is issued from the T table on the condition C1 = $Request ID$. This is the culprit here. We have tried using filter phase overriding Application-Query-Delete-Entry also with no use. Still the same error persists. We recently upgraded to v7.0.1 p4 and we have tried the same on a server running v6.00.03 p1497 with no use. Can someone throw some light on this? -- Thanks Regards Satya Gandhi Consultant - Remedy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Thanks Regards Satya Gandhi Consultant - Remedy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Issue with Delete record through webservice
Hello Satya, To remove this problem keep 1st action in one filter and another in 2nd filter and give them proper order. You are using delete so please take care of exception also. Filter phasing exceptions: 1) For get and delete actions, phase 1 and phase 3 actions occur together. 2) For get operations, there is generally no database change, so the actions need not be phased. (Note that there might be database changes as the result of Push Fields actions that the get operation triggers.) 3) For delete operations, you cannot defer actions because the delete action removes the current record, so the record would be unavailable for the actions later. The subsequent actions need to run when the data is still present. Regards, Tarun Sharma From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Satya Gandhi Sent: Wednesday, September 26, 2007 9:55 AM To: arslist@ARSLIST.ORG Subject: Issue with Delete record through webservice ** Dear Listers, I have a regular form which holds some records. A webservice is exposed on this form which is consumed by a .Net webservice from a external application. This .Net webservice sets a flag to YES on a particular record based on the input given by the webservice (Request ID on the form = Request ID coming from the.Net webservice). A On Modify filter is written which checks if the FLAG = YES; then delete the particular record using the Run Process Application-Delete-Entry. When the webservices sets the FLAG as YES; the on modify filter is triggered and the entry is deleted and it throws me an error Entry does not exist in the database. When i look at the logs; the filter processes the Applicaiton-Delete-Entry and deletes these records and after which a select statement is issued from the T table on the condition C1 = $Request ID$. This is the culprit here. We have tried using filter phase overriding Application-Query-Delete-Entry also with no use. Still the same error persists. We recently upgraded to v7.0.1 p4 and we have tried the same on a server running v6.00.03 p1497 with no use. Can someone throw some light on this? -- Thanks Regards Satya Gandhi Consultant - Remedy __20060125___This posting was submitted with HTML in it___ This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Issue with Delete record through webservice
Dear Listers, I have a regular form which holds some records. A webservice is exposed on this form which is consumed by a .Net webservice from a external application. This .Net webservice sets a flag to YES on a particular record based on the input given by the webservice (Request ID on the form = Request ID coming from the.Net webservice). A On Modify filter is written which checks if the FLAG = YES; then delete the particular record using the Run Process Application-Delete-Entry. When the webservices sets the FLAG as YES; the on modify filter is triggered and the entry is deleted and it throws me an error Entry does not exist in the database. When i look at the logs; the filter processes the Applicaiton-Delete-Entry and deletes these records and after which a select statement is issued from the T table on the condition C1 = $Request ID$. This is the culprit here. We have tried using filter phase overriding Application-Query-Delete-Entry also with no use. Still the same error persists. We recently upgraded to v7.0.1 p4 and we have tried the same on a server running v6.00.03 p1497 with no use. Can someone throw some light on this? -- Thanks Regards Satya Gandhi Consultant - Remedy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are