Re: Not able to delete a form Overlay
Hi! Thank you for the suggestion. We tried this and this resolved the issue perfectly. J Take care! Kind regards, Kim Ericsson From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: den 30 juni 2011 16:13 To: arslist@ARSLIST.ORG Subject: Re: Not able to delete a form Overlay ** Kim, I would recommend switching to Base Development mode, delete and then re-create all of the indexes thereit should correct your situation. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kim Ericsson Sent: Thursday, June 30, 2011 5:34 AM To: arslist@ARSLIST.ORG Subject: Not able to delete a form Overlay ** Greetings! I got an issue with deletering a overlay for a form. Please see below for a detailed description of the problem. Environment Win 2008 R2 64-bit servers SQL 2008 SP1 64-bit Problem description Have upgraded the staging server from: AR Server 7.5 patch 004 7.6.04 SP1 CMDB 7.6 7.6.04 SP1 ITSM 7.6 7.6.04 SP1 SLM 7.6 7.6.04 SP1 I've run the BPCU and converted to overlays etc. Am now trying to remove an Overlay for a form but are not able to and need assistance. I want to remove the Overlay for the form SLM:ConfigGoalType but when I try to do this I receive this error message: ERROR (382): The value(s) for this entry violate a unique index that has been defined for this form; ERROR (552): The SQL database operation failed.; Cannot drop the index 'T1990.I1990_8_1', because it does not exist or you do not have permission. I've tried to remove all indexes on the Overlay form but was not able to remove the unique index for the Status field, since the remove button is grey... The other indexes I removed successfully but still get the same error message when trying to delete the Overlay. If I run this query in the db: select schemaId,name from arschema where name like '%SLM_ConfigGoalType%' I get the result: 1990 SLM:ConfigGoalType 2304 SLM:ConfigGoalType__o This query: select indexname from schema_index where schemaid = 2304 Get this result: I1990_300905300_1 This query: select indexname from schema_index where schemaid = 1990 Get this result. I1990_300473700_1 I1990_300695300_1 I1990_300905300_1 I1990_8_1 Seems to me Dev Studio tries to remove an index that is not present for some reason... Any ideas on how to solve this one is much appreciated! _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Java Plugin Filter Plugin Time Outs
Hi , The issue is there are not separate web services admin in their env Actually they wrote a filter which is calling a web service at some point of time its throwing this message ,, any help on how to increase the java socket session timed out value?? thanks On Tue, Jun 28, 2011 at 8:09 PM, LJ LongWing lj.longw...@gmail.com wrote: Uday, That is quite simply that the web service you are calling is not responding within the timeframe of your timeout setting. You should contact the person running that web service and determine where the time lag is happening. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of uday kiran Sent: Tuesday, June 28, 2011 4:14 AM To: arslist@ARSLIST.ORG Subject: Re: Java Plugin Filter Plugin Time Outs I did the performance tuning by increasing the number of list and fast threads to 30 30 ,, I narrowed down the issue but now the issue is with java.net.SocketTimeoutException: Read timed out help me out thanks Uday On Fri, Jun 24, 2011 at 9:05 PM, Joe Martin D'Souza jdso...@shyle.net wrote: The Plugin-Filter-API-Threads is perhaps what you need to change.. I remember having a similar issue (ARERR 8939) a couple of years ago that was resolved with that.. Does anyone know what is the right method (besides tweak till it works) to arrive at a good number for the min and max for this thread? A sort of a algorithm based on X, Y and Z Joe -Original Message- From: patchsk Sent: Friday, June 24, 2011 10:50 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Java Plugin Filter Plugin Time Outs Yes these need to be changed in ar.conf If you post what are the values you currently have in your ar.conf that would help. In our system we currently have Filter-Api-Timeout: 180 Plugin-Filter-API-Threads: 2 6 Server-Plugin-Default-Timeout: 1 Plugin-ARDBC-Threads: 2 4 On Jun 24, 9:30 am, uday kiran uday.rem...@gmail.com wrote: Hi Vamsi, Do I need to change these values in ar.cfg if yes ,, what are the values i can set ,, thanks On Fri, Jun 24, 2011 at 3:15 AM, patchsk vamsi...@gmail.com wrote: Please do some research around these parameters. Plugin-ARDBC-Threads: Plugin-Filter-API-Threads: Server-Plugin-Default-Timeout: Filter-Api-Timeout: See if you can increase the values to these parameters than what you have currently in your system. On Jun 23, 3:42 pm, uday kiran uday.rem...@gmail.com wrote: Hi Folks Look at this error and suggest me We receive Plug-in server not responding messages quite often. Also seeing some filter api plug-in timeouts. Is there some configuration tweaks or performance tuning we can look at? arerror.log: The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. (ARERR 8939) javaplugin log: 2011-06-23 11:35:14,556 ERROR [pool-3-thread-4] com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - ARSYS.ARF.WEBSERVICEjava.net.SocketTimeoutException: Read timed out java.net.SocketTimeoutException: Read timed out 2011-06-23 11:35:14,557 ERROR [pool-3-thread-4] com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository (?:?) - ARFilterApiCall FAILs in plugin: ARSYS.ARF.WEBSERVICE ERROR (9130): Error encountered while executing a Web Service; ; nested exception is: java.net.SocketTimeoutException: Read timed out at com.bmc.arsys.ws.plugin.WSPlugin.ThrowException(Unknown Source) at com.bmc.arsys.ws.plugin.WSPlugin.filterAPICall(Unknown Source) at com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository.ARFilterApiCall (Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com
Fran Kautzer/Corp/Walgreens is out of the office.
I will be out of the office starting 06/30/2011 and will not return until 07/18/2011. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Not able to delete a form Overlay
Hi, The server apparently thinks that the index should be there, but it is not. Something has probably failed somewhere, but the rollback was not complete, leaving a discrepancy between the database and the arsystem-repository-tables. Maybe a random timeout issue or something like that. You may need to manually create an index with that name, to allow the system to continue. By manually I mean through SQL inside the database. You can always turn on SQL logging, and then create an index via dev-studio, to find the exact syntax. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Kim, I would recommend switching to Base Development mode, delete and then re-create all of the indexes there..it should correct your situation. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kim Ericsson Sent: Thursday, June 30, 2011 5:34 AM To: arslist@ARSLIST.ORG Subject: Not able to delete a form Overlay ** Greetings! I got an issue with deletering a overlay for a form. Please see below for a detailed description of the problem. Environment Win 2008 R2 64-bit servers SQL 2008 SP1 64-bit Problem description Have upgraded the staging server from: AR Server 7.5 patch 004 7.6.04 SP1 CMDB 7.6 7.6.04 SP1 ITSM 7.6 7.6.04 SP1 SLM 7.6 7.6.04 SP1 I've run the BPCU and converted to overlays etc. Am now trying to remove an Overlay for a form but are not able to and need assistance. I want to remove the Overlay for the form SLM:ConfigGoalType but when I try to do this I receive this error message: ERROR (382): The value(s) for this entry violate a unique index that has been defined for this form; ERROR (552): The SQL database operation failed.; Cannot drop the index 'T1990.I1990_8_1', because it does not exist or you do not have permission. I've tried to remove all indexes on the Overlay form but was not able to remove the unique index for the Status field, since the remove button is grey. The other indexes I removed successfully but still get the same error message when trying to delete the Overlay. If I run this query in the db: select schemaId,name from arschema where name like '%SLM_ConfigGoalType%' I get the result: 1990 SLM:ConfigGoalType 2304 SLM:ConfigGoalType__o This query: select indexname from schema_index where schemaid = 2304 Get this result: I1990_300905300_1 This query: select indexname from schema_index where schemaid = 1990 Get this result. I1990_300473700_1 I1990_300695300_1 I1990_300905300_1 I1990_8_1 Seems to me Dev Studio tries to remove an index that is not present for some reason. Any ideas on how to solve this one is much appreciated! _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
SRM 7.6.4
Dear all, I am having an issue with User responses not being mapped to the backend incident. The value of the mapping gets truncated to 254 by the time its written to the back end incident. I am concatenating the values from user responses which when added up teh sum goes beyond the 255 characters. There are two problem here, the first is a field mapping_trunc which is set 255 and a filter called SRS:QSR:SetTruncMapping_500 which even if you increase the field mapping_trunc it will filter will truncate the sting to 254. My question is, would changing the field size and the filter have any ramifications, and is there a work arround to this? Kind Regards, frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Command-line import (v7.0.1) fails on Unicode data
Hi, You do not say if you are on Linux/Unix, but the basic thing would be to either set your environ variables or your language setting. More recent versions, I think, is better at handling Unicode than older version. Try to get hold of the newest possible arimporcmd-tool. Setting this in unix: LANG=en_US.UTF-8 export LANG locale (to check if it worked) When looking at the arimportcmd-docs for 7.1, I do not se a way yo sett the login parameter for ClientCharSet... I have not, at the moment, find a way to set environment variables to allow Windows-client to default to UTF-8. If you are lucky, a newer version of arimportcmd will be able to look att the first line of you import file for an encoding string. It should work with ARX-files, but I am not sure about other formats. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi, We're on Remedy ARS v7.0.1 (+ mid-tier), and I'm trying to import Eastern European text data in our system via the Unicode-safe (as mentioned in the release notes) command-line version of BMC Remedy Import (arimportcmd). The text data in the .CSV data file is correctly encoded in Unicode/UTF-8 (I checked with Notepad), but after importing it the data is corruped (when checking via the mid-tier)! How can I tell arimportcmd that the data file is Unicode/UTF-8 so it will be correctly imported? Tommy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
7.6.4 SP2
Hello, does anyone have a release date for SP2? Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p [cid:image001.gif@01CC37CF.2E0306D0] This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Areinline: image001.gif
Re: Java Plugin Filter Plugin Time Outs
How long is it taking to call that web service, and do you know who administers the service? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of uday kiran Sent: Friday, July 01, 2011 2:12 AM To: arslist@ARSLIST.ORG Subject: Re: Java Plugin Filter Plugin Time Outs Hi , The issue is there are not separate web services admin in their env Actually they wrote a filter which is calling a web service at some point of time its throwing this message ,, any help on how to increase the java socket session timed out value?? thanks On Tue, Jun 28, 2011 at 8:09 PM, LJ LongWing lj.longw...@gmail.com wrote: Uday, That is quite simply that the web service you are calling is not responding within the timeframe of your timeout setting. You should contact the person running that web service and determine where the time lag is happening. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of uday kiran Sent: Tuesday, June 28, 2011 4:14 AM To: arslist@ARSLIST.ORG Subject: Re: Java Plugin Filter Plugin Time Outs I did the performance tuning by increasing the number of list and fast threads to 30 30 ,, I narrowed down the issue but now the issue is with java.net.SocketTimeoutException: Read timed out help me out thanks Uday On Fri, Jun 24, 2011 at 9:05 PM, Joe Martin D'Souza jdso...@shyle.net wrote: The Plugin-Filter-API-Threads is perhaps what you need to change.. I remember having a similar issue (ARERR 8939) a couple of years ago that was resolved with that.. Does anyone know what is the right method (besides tweak till it works) to arrive at a good number for the min and max for this thread? A sort of a algorithm based on X, Y and Z Joe -Original Message- From: patchsk Sent: Friday, June 24, 2011 10:50 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Java Plugin Filter Plugin Time Outs Yes these need to be changed in ar.conf If you post what are the values you currently have in your ar.conf that would help. In our system we currently have Filter-Api-Timeout: 180 Plugin-Filter-API-Threads: 2 6 Server-Plugin-Default-Timeout: 1 Plugin-ARDBC-Threads: 2 4 On Jun 24, 9:30 am, uday kiran uday.rem...@gmail.com wrote: Hi Vamsi, Do I need to change these values in ar.cfg if yes ,, what are the values i can set ,, thanks On Fri, Jun 24, 2011 at 3:15 AM, patchsk vamsi...@gmail.com wrote: Please do some research around these parameters. Plugin-ARDBC-Threads: Plugin-Filter-API-Threads: Server-Plugin-Default-Timeout: Filter-Api-Timeout: See if you can increase the values to these parameters than what you have currently in your system. On Jun 23, 3:42 pm, uday kiran uday.rem...@gmail.com wrote: Hi Folks Look at this error and suggest me We receive Plug-in server not responding messages quite often. Also seeing some filter api plug-in timeouts. Is there some configuration tweaks or performance tuning we can look at? arerror.log: The AR System Plug-In server is not responding. Cannot connect to the system at this time. Contact your AR System Administrator for assistance. (ARERR 8939) javaplugin log: 2011-06-23 11:35:14,556 ERROR [pool-3-thread-4] com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - ARSYS.ARF.WEBSERVICEjava.net.SocketTimeoutException: Read timed out java.net.SocketTimeoutException: Read timed out 2011-06-23 11:35:14,557 ERROR [pool-3-thread-4] com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository (?:?) - ARFilterApiCall FAILs in plugin: ARSYS.ARF.WEBSERVICE ERROR (9130): Error encountered while executing a Web Service; ; nested exception is: java.net.SocketTimeoutException: Read timed out at com.bmc.arsys.ws.plugin.WSPlugin.ThrowException(Unknown Source) at com.bmc.arsys.ws.plugin.WSPlugin.filterAPICall(Unknown Source) at com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository.ARFilterApiCall (Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
Re: 7.6.4 SP2
SP1 was released on 09-May-2011. That was about 3 months after GA. Service Packs typically come out every 3-4 months. So you can use that information to estimate a release date. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rodriguez, Rafael J x23718 Sent: Friday, July 01, 2011 06:14 AM To: arslist@ARSLIST.ORG Subject: 7.6.4 SP2 ** Hello, does anyone have a release date for SP2? Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p [cid:image003.gif@01CC37CA.F4091860] This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are inline: image003.gif
Support Company Access Configuration - Infinite loop!
Another disturbing code issue for those of us working with multi-tenancy in 7.6.4 SP1. I was setting up a support company using the 'Support Company Access Configuration' form (as directed by the Multi-Tenancy doc): I opened the 'Support Company Access Configuration form. I clicked on 'Create' and set Bowker as the company and ProQuest as the support company - no problem. I used the search with Bowker set as 'Company' to confirm the relationship - successful, entry with Bowker and Proquest, enabled. Here's the problem - I used the 'Update' button as directed to update the people permissions, with the menu set to Bowker - The user tool locked and went unresponsive in a minute or so. On Task Manager, the memory displayed a constantly increasing number. After ten minutes or so, I stopped the task. I tried again, with logging running - again the tool locked and memory kept increasing. Again I ended the task. On the log, I found an infinite loop. The code is a set of active links prefixed CFG:CCS:Update_, linked to the CFG:SupportCompanyAccessSetup form. The primary issue is that the code loops to generate a full list of companies that support the chosen company, but the link that is supposed to check (Update_025) only runs when 'z1D_Action' = Yes. 'z1D_Action' is only set to Yes if there is an error found and the user confirms they want to continue in the dialog displayed (Update_020). So, when the links loop to Update_025, it does nothing, the links loop again, ad infinitum. As a workaround, I've updated the error link (Update_020) with an Else action to set 'z1D_Action' to Yes if no error is found. This seems to work, as using the 'Update' button now results in the 'Vendor Assignee Groups' field on the company's people entries being set. Looking at the code though, I do find it a bit concerning that the loop is done with Go To actions instead of using an active link guide, that the links proclaim that the Update completed successfully when there is no check for this, and that the filter on SYS:Action (SYS:ACT:PEOPLESUPPORTUPDATE_105_PPPL) uses an SQL command to modify the People entries. Combined with the original error, the entire section seems sloppy and not to Remedy coding standards. Has anyone else reported this? Is this a known issue? Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Un-expected Filter/Filter Guide Processing when errors occur....
Debra, You say: If any of the push actions fail a subsequent filter does the following Are you using an Error Handler filter to process the fail condition? If so, once your error handler filter handles the error, the system considers the error handled and processing continues as if there were no error. Phasing is also affected. Check the Workflow Objects guide for details (I only 7.1 docs handy, so I don't have a page # for your version). Hope that helps, Thad On Thu, Jun 30, 2011 at 3:49 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Everyone! Hoping folks on the list with more experience might be able to explain unexpected filter processing behavior I am seeing. We are using 7.0 version ** ** Here is an overview of how my workflow is setup ** ** 1 – Filter 1A fires on Modify on Form_A – Note this filter name is using thte `! syntax for override filter phasing. Actions are in this: Set fields Call Guide 2A using server-side table loop Call Guide 2B ** ** Filter 2A – seems to work as expected (based on review of filter log). It calls several filters that loop thru table entries again using `! syntax. Each entry in the table results in a Push field action to two forms B C. If any of the push actions fail a subsequent filter does the following *** * 1 – Run Process command to run unix script to add entry to log server file 2 - Message action of type Error is reported to end-user As expected after this error occurs none of the push field changes are applied to the database – this is what I want to happen J ** ** However after the error occurs the top level filter still calls Guide 2B (I see this in the filter log after the error is logged) however the actions in the Guide are not fully executed but the one a Run Process action on a unix shell command does execute but after this runs the next actions which are Set/Push fields are not executed. ** ** Any ideas why my 2nd Call Guide action would execute after the first Guide called produces an error – my expectation was that if the first Guide produced an error the filter that called the guide would stop processing all together and the 2nd Guide would not be executed at all. ** ** Any thoughts? ** ** Thanks Debra ** ** Debra Anderson *T* 415.808.9118 | *F* 415.808.3535 600 Harrison St • San Francisco, CA • 94107 *PRN** |** *media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ** ** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Un-expected Filter/Filter Guide Processing when errors occur....
Thanks Thad! Actually I'm not using a specific error handler filter not sure what that would be. My next filter checks if the number of rows updated by the Push is 1 (via the LASTCOUNT value) if it is not 1 I do a Message action of type Error to alert the user. The filter log shows this error caused the current filter guide to stop processing steps and all my push changes are not applied to the database. However the next filter guide called gets called but only the Set fields and Run Process action actually does anything the other Push fields action is not applied. Below is excerpt from the filter log where this happens. Thanks Debra FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Check_Row_Update`! (505) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425 zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /tmp/report_error.sh 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Message FLTR TID: 07 RPC ID: 203425Error Processing Device Transaction #: 0002070 FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 2: Call Guide (this is the 2nd guide which I would expect not to be called at all) FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Verify_Updates`! (510) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425 audit_error_message (536871633) = Processing records failed - Records prepared= 8 and Records Processed=6 FLTR TID: 07 RPC ID: 203425 audit_report_status (536871632) = ErrorX FLTR TID: 07 RPC ID: 203425 zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /opt/ars/server/db/report_error.sh 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Push Fields FLTR TID: 07 RPC ID: 203425 2: Push Fields (ARERR 73001) FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, July 01, 2011 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: Un-expected Filter/Filter Guide Processing when errors occur ** Debra, You say: If any of the push actions fail a subsequent filter does the following Are you using an Error Handler filter to process the fail condition? If so, once your error handler filter handles the error, the system considers the error handled and processing continues as if there were no error. Phasing is also affected. Check the Workflow Objects guide for details (I only 7.1 docs handy, so I don't have a page # for your version). Hope that helps, Thad On Thu, Jun 30, 2011 at 3:49 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Everyone! Hoping folks on the list with more experience might be able to explain unexpected filter processing behavior I am seeing. We are using 7.0 version Here is an overview of how my workflow is setup 1 - Filter 1A fires on Modify on Form_A - Note this filter name is using thte `! syntax for override filter phasing. Actions are in this: Set fields Call Guide 2A using
Re: Un-expected Filter/Filter Guide Processing when errors occur....
I agree, all filter processing should have stopped as soon as the error occurred in this situation. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson Debra (PRN) Sent: Friday, July 01, 2011 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: Un-expected Filter/Filter Guide Processing when errors occur ** Thanks Thad! Actually I'm not using a specific error handler filter not sure what that would be. My next filter checks if the number of rows updated by the Push is 1 (via the LASTCOUNT value) if it is not 1 I do a Message action of type Error to alert the user. The filter log shows this error caused the current filter guide to stop processing steps and all my push changes are not applied to the database. However the next filter guide called gets called but only the Set fields and Run Process action actually does anything the other Push fields action is not applied. Below is excerpt from the filter log where this happens. Thanks Debra FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Check_Row_Update`! (505) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /tmp/report_error.sh 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Message FLTR TID: 07 RPC ID: 203425Error Processing Device Transaction #: 0002070 FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 2: Call Guide (this is the 2nd guide which I would expect not to be called at all) FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Verify_Updates`! (510) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425 audit_error_message (536871633) = Processing records failed - Records prepared= 8 and Records Processed=6 FLTR TID: 07 RPC ID: 203425 audit_report_status (536871632) = ErrorX FLTR TID: 07 RPC ID: 203425zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /opt/ars/server/db/report_error.sh 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Push Fields FLTR TID: 07 RPC ID: 203425 2: Push Fields (ARERR 73001) FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St . San Francisco, CA . 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, July 01, 2011 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: Un-expected Filter/Filter Guide Processing when errors occur ** Debra, You say: If any of the push actions fail a subsequent filter does the following Are you using an Error Handler filter to process the fail condition? If so, once your error handler filter handles the error, the system considers the error handled and processing continues as if there were no error. Phasing is also affected. Check the Workflow Objects guide for details (I only 7.1 docs handy, so I don't have a page # for your version). Hope that helps, Thad On Thu, Jun 30, 2011 at 3:49 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Everyone! Hoping