RES: Java API changes in ARS v8.1
Raj, I know this thread’s from last month.. But I’ll give you a try.. In my point of view you can migrate only considering the differences between ARS API v7.6.04 (current version) and ARS API v8.1. I worked on a situation where we had to migrate a Java code of using ARS API from 6.x to 7.6.04. Basically you have only to change de jar files (the documentation of integrating has this list) and fixed the problems that you’ll face on your code. You can get both (“Integrating” manual and, the necessary jars and the javadocXX.jar) with your Support Staff - people that have Administrator roles at AR Server. P.S.: I believe you’ll have less headache with your API migration than with your Server (if I really understood you’re using AR Server 5.1.2 and calling Java API’s using ARS API 7.6.04… Isn’t it?) Att, Tadeu De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Em nome de Raj Enviada em: quarta-feira, 28 de agosto de 2013 16:28 Para: arslist@ARSLIST.ORG Assunto: Re: Java API changes in ARS v8.1 ** Thanks LJ for you help. I will initiate a ticket with BMC to get those. Would appreciate if you could send it across otherwise no problem at all. Forgot to mention earlier, we are on ARS upgrade path from v5.1.2 to v8.1. We have some customizations/code which is using Java API v7.5. Looking for Java API changes from ARS v7.5 onwards... since I will upgrading from ARS v7.6.04 to v8.1...do we need to make code changes at our end reviewing just ARS v7.6.04 ARS v8.1 JAVA API changes or all four different versions ARS v7.6.03, 7.6.04, 8.0 8.1. My understanding was reviewing just Java API changes of ARS v8.1 would suffice as it would be cumulative...but not sure? _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
RES: Developer Certification
Hey, How / Where can I get this certification? And how much is the investiment? Do I have to be a employee from a BMC partner company? Regards De: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Em nome de Jason Miller Enviada em: sexta-feira, 27 de julho de 2012 11:31 Para: arslist@ARSLIST.ORG Assunto: Re: Developer Certification ** I wish I could help but I am also going through the Developer Certification in August. At first I thought we would be classmates but the .ru domain makes me wonder of you will be in San Jose, USA also? Jason On Jul 27, 2012 12:14 AM, Vershinsky Alex vershinsky...@yandex.ru wrote: Hello All, As I am going to pass through BMC Developer Certification in August, I realy need some help in a way that make me more familiar with this exam. I believe that there are a lot of Certified Developers here who will not hasitate to share his/her expirience in taking this exam. I would be grateful if some of you give exaplese of exam's cases you remeber from this exam. P.S.: ARS version doesn't metter, but I'm going to take 7.6.04 Certification Exam. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04
Hello, Thanks for reply... but I guess I have to be more clear... When I said OOTB (Out-Of-The-Box) I mean not BMC objects, but other forms and workflows created by ourselves. For example, forms named ABC:Customer, ABC:Whatever and so on... I always understood OOTB objects as forms and workflows created as new objects, not modifying BMC/System objects (such as User, Groups, etc...) - If it's not correct please let me know. J Considering that I have an active link that calls a Run Process running a script on a server A (/opt/server_A/script.sh)... This is an object that certainly will have to be modified during Production server (considering Production server named as server_B).. so... my new Run Process will expect the script on another filesystem (/opt/server_B/script.sh).. My question is... Must I have to create an overlay of this Active Link just to change these path?? Or should I convert this Unmodified objects using BPCU feature?? I really confused about it. 'Cause I can't imagine always create an orverlay for every objects that we have built (not considering the system/BMC objects)... Thanks. Please let me know If I was not clear at all. Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: quarta-feira, 11 de janeiro de 2012 18:38 To: arslist@ARSLIST.ORG Subject: Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04 ** An OOTB box is, by definition, unmodified. i.e. you haven't modified the OOTB object. So yes, that's expected. The objects are changeable - what Developer Studio will do if you want to change them is make an overlay of the object and allow you to modify the overlay. The OOTB object will remain unmodified and your overlay object will be the actual object you modify. Of course, it's recommended that you do not modify BMC OOTB objects at all - but overlays will allow you to do so if there's no other way to accomplish what you want to do. A better option, though, is to extend the BMC applications by adding your own new fields or workflow vs. modifying BMC objects. -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 Tadeu Augusto Dutra Pinto Sent: Wednesday, January 11, 2012 12:25 PM To: arslist@ARSLIST.ORG Subject: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04 ** Hi all, We have upgraded our AR Server successfully from AR System 7.1 to 7.6.04 version. J I'd like to know if It's normal all the OOTB objects from version 7.1 become Unmodified (Customization Type) in 7.6.04 on DevStudio... P.S.: All of our 7.1 objects were imported on 7.6.04 server as Unmodified (including Forms, Filters, ActiveLinks, etc...) Is that right? Is there anyway to make these objects changeable? I have downloaded the plug-in that converts objects to Custom... Can I use this plug-in to convert all of my Unmodified objects to Custom objects? Thanks. Old Environment: AR Server 7.1 Oracle 10g Unix 5.3 New Environment: AR Server 7.6.04 P2 Oracle 11g Unix 5.3 Att, Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04
Hi LJ, First of all, the apps I was talking about is 100% COTS! I've been misunderstood all this time about OOTB J, and... in the last times I was getting scared about these new concepts related to Customization Types on ARS 7.6 architecture. Thanks a lot for your detailed reply. One more question about these Customization Types... Instead using the BPCU feature, can I use this feature through this com.bmc.arsys.studio.unsupported.overlayutils_7.6.4.201104161200.jar https://communities.bmc.com/communities/servlet/JiveServlet/downloadBod y/14382-102-2-29309/com.bmc.arsys.studio.unsupported.overlayutils_7.6.4. 201104161200.jar plug-in on Developer Studio? Since I can convert object to Custom using this plug-in (thread: https://communities.bmc.com/communities/docs/DOC-14382 https://communities.bmc.com/communities/docs/DOC-14382 ) P.S.: Thanks for sharing the idea of paths on run process. Best Regards. Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quinta-feira, 12 de janeiro de 2012 13:29 To: arslist@ARSLIST.ORG Subject: Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04 ** Tadeu, OOTB has always referred to what you get when you by the productin this case, the 'product' from BMC would be 'ITSM', or one of its other offerings...if you are talking about code you wrote, that is not OOTB because you created it...you didn't purchase it from anyone...another name for OOTB is COTS (Commercial Off The Shelf)...same conceptso, to address your actual question. Due to the fact that you are dealing with a 'Custom' system...your objects should NOT be 'base' objects, you should use the BPCU feature to convert them to 'custom' objects so that you are complying with the new standard that BMC is trying to establish. To address your question regarding paths in a run-process. The way I would handle that would be to have a table in Remedy that contains a minimum of two fields...one being the return from $SERVER$, the other being the path you want to execute on that serverso instead of having a hard coded path in your workflow, you first do a setfield from that form where $SERVER$ matches, and grab the other value...then use that as the path in your run-processthus eliminating the need to have different workflow in Prod than you have in Dev...just different data driving it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 12, 2012 6:02 AM To: arslist@ARSLIST.ORG Subject: Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04 ** Hello, Thanks for reply... but I guess I have to be more clear... When I said OOTB (Out-Of-The-Box) I mean not BMC objects, but other forms and workflows created by ourselves. For example, forms named ABC:Customer, ABC:Whatever and so on... I always understood OOTB objects as forms and workflows created as new objects, not modifying BMC/System objects (such as User, Groups, etc...) - If it's not correct please let me know. J Considering that I have an active link that calls a Run Process running a script on a server A (/opt/server_A/script.sh)... This is an object that certainly will have to be modified during Production server (considering Production server named as server_B).. so... my new Run Process will expect the script on another filesystem (/opt/server_B/script.sh).. My question is... Must I have to create an overlay of this Active Link just to change these path?? Or should I convert this Unmodified objects using BPCU feature?? I really confused about it. 'Cause I can't imagine always create an orverlay for every objects that we have built (not considering the system/BMC objects)... Thanks. Please let me know If I was not clear at all. Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: quarta-feira, 11 de janeiro de 2012 18:38 To: arslist@ARSLIST.ORG Subject: Re: OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04 ** An OOTB box is, by definition, unmodified. i.e. you haven't modified the OOTB object. So yes, that's expected. The objects are changeable - what Developer Studio will do if you want to change them is make an overlay of the object and allow you to modify the overlay. The OOTB object will remain unmodified and your overlay object will be the actual object you modify. Of course, it's recommended that you do not modify BMC OOTB objects at all - but overlays will allow you to do so if there's no other way to accomplish what you want to do. A better option, though, is to extend the BMC applications by adding your own new fields or workflow vs. modifying BMC objects. -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions
OOTB Objects upgraded as Unmodified Objects on ARS 7.6.04
Hi all, We have upgraded our AR Server successfully from AR System 7.1 to 7.6.04 version. J I'd like to know if It's normal all the OOTB objects from version 7.1 become Unmodified (Customization Type) in 7.6.04 on DevStudio... P.S.: All of our 7.1 objects were imported on 7.6.04 server as Unmodified (including Forms, Filters, ActiveLinks, etc...) Is that right? Is there anyway to make these objects changeable? I have downloaded the plug-in that converts objects to Custom... Can I use this plug-in to convert all of my Unmodified objects to Custom objects? Thanks. Old Environment: AR Server 7.1 Oracle 10g Unix 5.3 New Environment: AR Server 7.6.04 P2 Oracle 11g Unix 5.3 Att, Tadeu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade?
Hi everyone, I'm trying to figure out why after upgrade from ARS 7.1 to version 7.6.04 P2 the objects disappear on the target server (7.6.04) ? It seems that the system (AR Server and/or Database) needs to be resynchronized in any way. Does anyone knows the correct steps to have the objects from ARS 7.1 showed on ARS 7.6.04 after upgrade? OBS: Searching through the database level we noticed that all the data (forms, filters, actives) that does not appear on target server were present there. OBS: I'm not using ITSM apps. Just OOTB apps. Thkx. Tadeu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade?
Hi, Where can I turn it off and back on ? Clicking on Search menu (Ctrl + H) on DevStudio I faced with the following message... The search cannot be performed on the selected AR System server server_name because the Record Object Relationships setting is not enabled How can I deal with this? Configuring it correctly... Thanks for reply. Regards. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quinta-feira, 5 de janeiro de 2012 15:42 To: arslist@ARSLIST.ORG Subject: Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Tadeu, You may want to turn off the 'Record Object Relationships', restart, turn it back on, restart again. You may be dealing with a corrupted relationship cache, which affects Dev Studio's ability to see the objects properly. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 05, 2012 10:13 AM To: arslist@ARSLIST.ORG Subject: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Hi everyone, I'm trying to figure out why after upgrade from ARS 7.1 to version 7.6.04 P2 the objects disappear on the target server (7.6.04) ? It seems that the system (AR Server and/or Database) needs to be resynchronized in any way. Does anyone knows the correct steps to have the objects from ARS 7.1 showed on ARS 7.6.04 after upgrade? OBS: Searching through the database level we noticed that all the data (forms, filters, actives) that does not appear on target server were present there. OBS: I'm not using ITSM apps. Just OOTB apps. Thkx. Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade?
Hey, I've just found it. The property 'Record Object Relationships' is found at Server Information form. And, in our case, we have this property set to disabled. Should we set it on (enabled) and then restart the AR Server?? This property must be always enabled? If so, why it's disabled after the upgrade process? Thanks a lot. Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quinta-feira, 5 de janeiro de 2012 15:42 To: arslist@ARSLIST.ORG Subject: Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Tadeu, You may want to turn off the 'Record Object Relationships', restart, turn it back on, restart again. You may be dealing with a corrupted relationship cache, which affects Dev Studio's ability to see the objects properly. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 05, 2012 10:13 AM To: arslist@ARSLIST.ORG Subject: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Hi everyone, I'm trying to figure out why after upgrade from ARS 7.1 to version 7.6.04 P2 the objects disappear on the target server (7.6.04) ? It seems that the system (AR Server and/or Database) needs to be resynchronized in any way. Does anyone knows the correct steps to have the objects from ARS 7.1 showed on ARS 7.6.04 after upgrade? OBS: Searching through the database level we noticed that all the data (forms, filters, actives) that does not appear on target server were present there. OBS: I'm not using ITSM apps. Just OOTB apps. Thkx. Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade?
Thanks. We're trying to reinstall AR Server. Att, Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quinta-feira, 5 de janeiro de 2012 16:13 To: arslist@ARSLIST.ORG Subject: Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** It doesn't NEED to be enabled, but it helps out quite a few functions in Dev Studio...if it's currently disabled, it's obviously not the cause of your issue...but may help 'fix' the problem once enabled. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 05, 2012 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Hey, I've just found it. The property 'Record Object Relationships' is found at Server Information form. And, in our case, we have this property set to disabled. Should we set it on (enabled) and then restart the AR Server?? This property must be always enabled? If so, why it's disabled after the upgrade process? Thanks a lot. Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quinta-feira, 5 de janeiro de 2012 15:42 To: arslist@ARSLIST.ORG Subject: Re: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Tadeu, You may want to turn off the 'Record Object Relationships', restart, turn it back on, restart again. You may be dealing with a corrupted relationship cache, which affects Dev Studio's ability to see the objects properly. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 05, 2012 10:13 AM To: arslist@ARSLIST.ORG Subject: Why our old OOTB objects doesn't appear on our new AR Server 7.6.04 after upgrade? ** Hi everyone, I'm trying to figure out why after upgrade from ARS 7.1 to version 7.6.04 P2 the objects disappear on the target server (7.6.04) ? It seems that the system (AR Server and/or Database) needs to be resynchronized in any way. Does anyone knows the correct steps to have the objects from ARS 7.1 showed on ARS 7.6.04 after upgrade? OBS: Searching through the database level we noticed that all the data (forms, filters, actives) that does not appear on target server were present there. OBS: I'm not using ITSM apps. Just OOTB apps. Thkx. Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Panel / Page Holder behavior on ARS 7.6.04 P2
Hello everyone, I Hope someone could help with any kind of information about Panels / Page Holders differences between 7.0.x and 7.6.04 version of ARS. Here goes my predicament: For instance, How could I create a scenario that a Character Field is shared through 3 pages of 5 pages available on a specific form? Using the property Shared Fields (at Panels from a Page Holder component), the Character Field is visible in all of the 5 pages of my Page Holder. I'm referring to my component as Page Holder because I've done the upgrade coming from ARS 7.0.01. Since I share a field, it become available on all the 5 pages... As a workaround for this problem, I used a non-fancy way of working with Trim Box's components to hide my Character Field in specific pages... AR Server 7.6.04 Patch 2 Oracle DB 11g (11.2.0.2.0) 64 bits Mid-Tier 7.6.04 OBS: Trying to overlay components/forms to work on it using the new AR Server version (7.6.04) Regards, Att, Tadeu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Panel / Page Holder behavior on ARS 7.6.04 P2
Hi LJ, Thanks for reply. But I wonder If I not have to create these 3 separete fields. We already have a large number of fields on this form, and we are trying to avoid the creation of extra fields, considering this purpose Referring to the document “FormAppObj-7604”: Workflow considerations for panels If the Tabless Borderless property of a tabbed panel holder is set to True, you must create workflow to enable users to change which panel is displayed. For information about removing borders and tabs, see “To create a panel holder” on page 336. Remember these considerations when building workflow for panels: You can use a panel holder as a data source in workflow. For example, you can use a Run If qualification such as 'PageHolder' = Page3. For example, can I use this tip above in bold text to create an Active Link that makes a Character Field Visible / Hidden depending on the Page chosen? Ex: a) Active Link 1: Run If: ‘PageHolder’ = “Page1” Set Fields Action: Change Field “Character Field” to Visible b) Active Link 2: Run If: ‘PageHolder’ = “Page2” Set Fields Action: Change Field “Character Field” to Hidden Is that acceptable working with version 7.6.04? Cheers, Tadeu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quarta-feira, 21 de dezembro de 2011 17:42 To: arslist@ARSLIST.ORG Subject: Re: Panel / Page Holder behavior on ARS 7.6.04 P2 ** Tadeu, In 7.6.4 you can’t even share fields across multiple tabs. It supports it for fields already added in previous versions, but you cannot configure a new field as such. The BMC recommendation would likely be to create 3 separate fields and use AL’s to sync the contents. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Wednesday, December 21, 2011 11:44 AM To: arslist@ARSLIST.ORG Subject: Panel / Page Holder behavior on ARS 7.6.04 P2 ** Hello everyone, I Hope someone could help with any kind of information about Panels / Page Holders differences between 7.0.x and 7.6.04 version of ARS. Here goes my predicament: For instance, How could I create a scenario that a Character Field is shared through 3 “pages” of 5 pages available on a specific form? Using the property Shared Fields (at Panels from a Page Holder component), the Character Field is visible in all of the 5 pages of my Page Holder. I’m referring to my component as “Page Holder” because I’ve done the upgrade coming from ARS 7.0.01. Since I share a field, it become available on all the 5 pages… As a workaround for this problem, I used a non-fancy way of working with Trim Box’s components to hide my Character Field in specific pages… AR Server 7.6.04 Patch 2 Oracle DB 11g (11.2.0.2.0) 64 bits Mid-Tier 7.6.04 OBS: Trying to overlay components/forms to work on it using the new AR Server version (7.6.04) Regards, Att, Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Panel / Page Holder behavior on ARS 7.6.04 P2
Hello, I have tried to do what I described on previous email. According to Workflow considerations for panels (at FormAppObj-7604 document). It works fine (and fast) testing on User tool (v7.6.04). But when I run this action using the Mid-Tier I'm getting a slow response, I believe some javascript error (in this case it's a WARNING) is causing this delay. On the status bar from my browser is showing the message below (Warning): Line: 12 Character: 8462 Error: 'FormPaneMPanes' null or not a object Code: 0 URL: url_address Someone could tell if this message is related to the problem that 'sharing fields across panels' is not supported anymore (on 7.6.04) ? And, if the error is related to it, how can I solve this problem with slow response from server... Thanks in advance. Cheers. Tadeu -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: quarta-feira, 21 de dezembro de 2011 18:52 To: arslist@ARSLIST.ORG Subject: Re: Panel / Page Holder behavior on ARS 7.6.04 P2 Yesbut the problem with using this method is that you are still utilizing a feature of Remedy that is no longer supported in 7.6 (sharing fields across panels) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Givens, Gregory CTR NPC, Pers 54 Sent: Wednesday, December 21, 2011 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: Panel / Page Holder behavior on ARS 7.6.04 P2 Tadeu, Create an AL to change the field to Hidden when a particular Tab/Panel is selected The drawback is you'll need an AL for each Tab/Panel to Hide or Un-Hide the field. Greg Givens -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Wednesday, December 21, 2011 12:44 PM To: arslist@ARSLIST.ORG Subject: Panel / Page Holder behavior on ARS 7.6.04 P2 ** Hello everyone, I Hope someone could help with any kind of information about Panels / Page Holders differences between 7.0.x and 7.6.04 version of ARS. Here goes my predicament: For instance, How could I create a scenario that a Character Field is shared through 3 pages of 5 pages available on a specific form? Using the property Shared Fields (at Panels from a Page Holder component), the Character Field is visible in all of the 5 pages of my Page Holder. I'm referring to my component as Page Holder because I've done the upgrade coming from ARS 7.0.01. Since I share a field, it become available on all the 5 pages. As a workaround for this problem, I used a non-fancy way of working with Trim Box's components to hide my Character Field in specific pages. AR Server 7.6.04 Patch 2 Oracle DB 11g (11.2.0.2.0) 64 bits Mid-Tier 7.6.04 OBS: Trying to overlay components/forms to work on it using the new AR Server version (7.6.04) Regards, Att, Tadeu _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
[7.6.04] Upgrade didn't move OOTB forms to the new server
Hi everyone, Someone could explain the Best way for upgrade of AR Server to version 7.6.04 ? Our scenario is upgrade from 7.0.01 to 7.6.04 ... We did the upgrade of our server, but, in this case, the process didn't bring to the new Server the related data (arx) and workflow objects from OOTB applications that we have. What could've happened during the installation? Could I export def's from our AR Admin 7.0.01 and import those using the new BMC Remedy Developer without concerns about relationships and future upgrades? P.S.: I don't feel comfortable to import/export all the forms, actives, filters, etc (def files) and all the arx files as well (including arx files for forms like as User, Group that didn't go to the new server). Thankz Tadeu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
RES: Find the Active Link
generate a .def file of all your active links related with your application... and do a research by Ctrl+F command. very simple... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Brittain, Mark Enviada: qui 18/9/2008 13:08 Para: arslist@ARSLIST.ORG Assunto: Find the Active Link Hi, Is there an easy way to find the active link in the run process below? PERFORM-ACTION-ACTIVE-LINK 1 536870662 ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite ESM Operations 315-453-2912 x5418 (Office) 315-317-2897 (Cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Run Process Timeout
Hi people. How can I handle timeout on Run Process function?? I have a Run Process command that executes a shell script batch ... and this shell script code calls a Java program... Where do I have to implement my timeout controller??? In ARS, Shell Script code or Java Code??? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Passing / Receiving data from a Java Code
Hi all, I have a doubt about how to integrate ARS with out of the box products/systems... We have to access data from an external database, but this database access has an interface implemented in java code... We would like to write a plug-in code that communicates with this java interface code (it's really a classic java method)... Workflow: On a ARS form we wish that when a user type the identificator field for a client (Account Number, for example) and press enter, the system bring back complementary information about this client (such as Name, Phone Number, Email Address, etc...). These complementary data will be returned by another mainframe server, wrapped by a java method called getInfoByAccountNumber(String account). I'd like to know what is the best way to implement this request. How can I call a java program that returns information and set this information on fields in my current screen??? Any tips will be appreciated! Please let's talk a little bit more about this ... If any of you have questions about this workflow please reply this email that I will try to explain that in details... Thanks in advance We are using: AR Server 7.0.01 Patch 7 AR Admin 7.0.00 Patch 1 AR User 7.0.00 Patch 1 Oracle Database 10g Java 1.3.1 AR System API 7.0 (arapi70.jar) OS Server - Unix AIX 5.3 OS Client - WinXP IDE Java - Eclipse 3.0 Att, ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Passing / Receiving data from a Java Code
I didn't know that ARDBC plug-in was not supported on 7.x :( Why doesn't it supported?? Another question... At the first option that you said... I'll have to write a plug-in in C that calls a Java daemon??? How can I do this call?? Thanks for reply... Any other tips will be very appreciated... Att, Tadeu Augusto Dutra Pinto De: Action Request System discussion list(ARSList) em nome de Axton Enviada: qui 4/9/2008 15:39 Para: arslist@ARSLIST.ORG Assunto: Re: Passing / Receiving data from a Java Code ** The preferred method would be a java ardbc plugin, but this is not possible on 7.0.x. The options I see: - write a java daemon (based on your java api) that accepts and responds to requests, then write a filter plugin in c to send/receive requests from that daemon. - fork a java process via set fields run process that returns the values you want (gonna be slow and prone to problems since you would have to parse a string of data) I am sure there are many other approaches, but these first two come to mind. The first is more intricate but once working will work faster and more reliably than the second. Axton Grams On Thu, Sep 4, 2008 at 2:06 PM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: ** Hi all, I have a doubt about how to integrate ARS with out of the box products/systems... We have to access data from an external database, but this database access has an interface implemented in java code... We would like to write a plug-in code that communicates with this java interface code (it's really a classic java method)... Workflow: On a ARS form we wish that when a user type the identificator field for a client (Account Number, for example) and press enter, the system bring back complementary information about this client (such as Name, Phone Number, Email Address, etc...). These complementary data will be returned by another mainframe server, wrapped by a java method called getInfoByAccountNumber(String account). I'd like to know what is the best way to implement this request. How can I call a java program that returns information and set this information on fields in my current screen??? Any tips will be appreciated! Please let's talk a little bit more about this ... If any of you have questions about this workflow please reply this email that I will try to explain that in details... Thanks in advance We are using: AR Server 7.0.01 Patch 7 AR Admin 7.0.00 Patch 1 AR User 7.0.00 Patch 1 Oracle Database 10g Java 1.3.1 AR System API 7.0 (arapi70.jar) OS Server - Unix AIX 5.3 OS Client - WinXP IDE Java - Eclipse 3.0 Att, __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: QBE = Anywhere on fields filled automatically on search.
Hi, Anywhere is the default value for any fields that you create on form... to change the default QBE value for fields go to Admin Tool (Menu File - Preferences... Page Form - Default QBE Match). Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de BROTONS Oscar Enviada: ter 2/9/2008 11:42 Para: arslist@ARSLIST.ORG Assunto: QBE = Anywhere on fields filled automatically on search. ** ITSM 5.6 Some one knows why field zSchemaProperName on forms CHG:Chage, HPD:HelpDesk and CHG:Task are QBE = Anywhere ? If all records on each form have the same value. Oscar Brotons. IT Consultant. IMPORTANT: This message is intended exclusively for information purposes. It cannot be considered as an official OHIM communication concerning procedures laid down in the Community Trade Mark Regulations and Designs Regulations. It is therefore not legally binding on the OHIM for the purpose of those procedures. The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete or destroy this message and any copies. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: QBE = Anywhere on fields filled automatically on search.
Hi Oscar, This is the QBE property for that field... I believe that you can change that if you want... Fields that always receive a specific value (not variable) is recommended to use Equal QBE to improve yours SQL searches in database... If I didn't answer your question yet, please detail what your want ... thanks... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de BROTONS Oscar Enviada: ter 2/9/2008 11:59 Para: arslist@ARSLIST.ORG Assunto: Re: QBE = Anywhere on fields filled automatically on search. Hi Tadeu, ...but I didn't create that field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: 02 September 2008 16:45 To: arslist@ARSLIST.ORG Subject: RES: QBE = Anywhere on fields filled automatically on search. Hi, Anywhere is the default value for any fields that you create on form... to change the default QBE value for fields go to Admin Tool (Menu File - Preferences... Page Form - Default QBE Match). Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br http://www.cinq.com.br/ https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de BROTONS Oscar Enviada: ter 2/9/2008 11:42 Para: arslist@ARSLIST.ORG Assunto: QBE = Anywhere on fields filled automatically on search. ** ITSM 5.6 Some one knows why field zSchemaProperName on forms CHG:Chage, HPD:HelpDesk and CHG:Task are QBE = Anywhere ? If all records on each form have the same value. Oscar Brotons. IT Consultant. IMPORTANT: This message is intended exclusively for information purposes. It cannot be considered as an official OHIM communication concerning procedures laid down in the Community Trade Mark Regulations and Designs Regulations. It is therefore not legally binding on the OHIM for the purpose of those procedures. The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete or destroy this message and any copies. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ** IMPORTANT: This message is intended exclusively for information purposes. It cannot be considered as an official OHIM communication concerning procedures laid down in the Community Trade Mark Regulations and Designs Regulations. It is therefore not legally binding on the OHIM for the purpose of those procedures. The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete or destroy this message and any copies. ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How to block that a user belongs to more than one group (It's not the User / People form)
I'd like to know if someone has an idea of how I can block that a unique user does not enter in more than one group (cell). I have a Form that is called Employee.. This form has few fields... (but only 2 fields is important to us - Fields: Name and Cell). 1. Name: represents the name of employee. 2. Cell: represents de cell or group that the user is in. This form supports more than one record with Name field Tadeu, but it can't support that Tadeu is in more than one Cell (Group)... For example: If a record of Tadeu has Cell 1 in the Cell field... I would like to block the user to set another record of Tadeu with the value Cell 2 in the Cell field of this second record... (it can stay null or with the same value that was set first) How can I create a logic to do this... I wouldn't like to need to work with Table Loop and/or Guides... But If it is the best choice I'll accept it ... I'd like to hear some suggestions of you.. Thanks so much.. Good evening for all! Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Java code (.jar) via Run Process
Hi, How can I execute a java code (.jar) via Run Process ??? 1) I tried to do a 'Set Fields' action, where there is: Fields: Name: tmpField Value: $PROCESS$ /aplic/ARSD3/www/lib/sacrmvirtual.jar 123 $CpfCnpj$;echo $? This return 1 to tmpField 2) I tried to create a 'Run Process' action, where there is: Command Line: /aplic/ARS/www/lib/sacrmvirtual.jar 123 $CpfCnpj$; Both commands execute successfully... But my java code (that creates an entry on another form) does not work... Anyone knows what is going on? Am I writing the Run Process command right?? Is it necessary to put () in my values? Such as 123, or $CpfCnpj$, etc... I'm using: AR Server 7.0.01 P 7 AR User 7.0.00 P 1 AR Admin 7.0.00 P 1 Eclipse 3.0 (Java 1.3) Oracle DB 10g Thankx a lot Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Java code (.jar) via Run Process
Use this Command Line: java -cp /aplic/ARS/www/lib/sacrmvirtual.jar 123 123456789; ??? It doesn't work... Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de [EMAIL PROTECTED] Enviada: qua 13/8/2008 12:06 Para: arslist@ARSLIST.ORG Assunto: Re: Java code (.jar) via Run Process ** Use this java -cp %CLASSPATH% etc etc ! -Original Message- Date: Wed, 13 Aug 2008 17:03:22 +0200 Subject: Java code (.jar) via Run Process From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] To: arslist@ARSLIST.ORG ** Hi, How can I execute a java code (.jar) via Run Process ??? 1) I tried to do a 'Set Fields' action, where there is: Fields: Name: tmpField Value: $PROCESS$ /aplic/ARSD3/www/lib/sacrmvirtual.jar 123 $CpfCnpj$;echo $? This return 1 to tmpField 2) I tried to create a 'Run Process' action, where there is: Command Line: /aplic/ARS/www/lib/sacrmvirtual.jar 123 $CpfCnpj$; Both commands execute successfully... But my java code (that creates an entry on another form) does not work... Anyone knows what is going on? Am I writing the Run Process command right?? Is it necessary to put () in my values? Such as 123, or $CpfCnpj$, etc... I'm using: AR Server 7.0.01 P 7 AR User 7.0.00 P 1 AR Admin 7.0.00 P 1 Eclipse 3.0 (Java 1.3) Oracle DB 10g Thankx a lot Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How to pass Vm Arguments via Run Process???
Hi all, How do I use Vm Arguments of Java in Unix?? I'd like to call a Run Process passing -Dwce.home=c:/aplic/wced as VM Arguments... I'm using: AR Server 7.0.01 P 7 AR User 7.0.00 P 1 AR Admin 7.0.00 P 1 Eclipse 3.0 (Java 1.3) Oracle DB 10g Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How to execute a 'Set Fields' Action via API (Java) ?
Hi, How can I use the class FieldAssignInfo and AssignFieldInfo from API 7.0 (arapi70.jar) to execute a Set Fields Operation on a form??? I'm very very lost in this situation... Maybe this is not the correct way to do what I want / need... I'll try to explain what I'd like to do in my App: I would like to input (via API) determined values in my form, but I don't know how does API works... I'm trying to study the API's Javadoc ... but I'm very confused about that... I've already have the values that I want to post in my fields on form ... But I don't know how to integrate these datas... Remembering that I don't want to SUBMIT a record with this NEW values ... I only want to execute a 'Set Fields' Action... Is there any possibility to do this?? Can anyone help me?? Thanks in advance... Tadeu Augusto Dutra Pinto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: RES: Doubt how to use Java API (arapi.jar)
Hi Chintan.. Thank you for reply... But, I think, that we can use web services in this case... because our service that access database (mainframe) is already done... we only have to do a java class to access that and, further, use a set fields action to populate our fields on our form... I'm not sure if it's possible to do that with web services ... because we don't have a wsdl generated... please correct me if I'm wrong... Any tips and/or suggestions will be appreciated! Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Chintan Shah Enviada: sex 1/8/2008 16:34 Para: arslist@ARSLIST.ORG Assunto: Re: RES: Doubt how to use Java API (arapi.jar) ** Is it possible to use WSDL instead of Java API? You can perform set fields action in a filter by consuming a WSDL. I am only aware of this option. If you find something through API, please share. Thanks Chintan. --- On Thu, 7/31/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] Subject: RES: Doubt how to use Java API (arapi.jar) To: arslist@ARSLIST.ORG Date: Thursday, July 31, 2008, 11:11 AM anyone??? please! De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 31/7/2008 10:48 Para: arslist@ARSLIST.ORG Assunto: Doubt how to use Java API (arapi.jar) ** Good morning, I have many doubts about implementing AR System Java API (arapiXX.jar). Currently, I'm working as AR System developer and now I have to integrate my ARS Application with a service Java (which brings me client's datas when I pass an information on an ARS form). It looks like that: When I enter a value on Client's Name Field on my form and press Enter, my Application will call Java API program that will access a service (ex: getInfoClient() ) and will return the others client's information that will fill other fields in my AR System fields (Form)... Any suggestion of how I can do that? I've already have worked in implementation of arapi API, but always creating and/or modifying an entry... in this case I would like to SET some fields only ... without submit the record... Thanks a lot in advance! I'm using: API Java: arapi63.jar IDE Tool: Eclipse AR Server : 7.0.01 Patch 7 AR Admin: 7.0.00 Patch 1 AR User: 7.0.00 Patch 1 Database: Oracle 10g OS Server: AIX 5.3 OS Client: WinXP Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Doubt how to use Java API (arapi.jar)
Good morning, I have many doubts about implementing AR System Java API (arapiXX.jar). Currently, I'm working as AR System developer and now I have to integrate my ARS Application with a service Java (which brings me client's datas when I pass an information on an ARS form). It looks like that: When I enter a value on Client's Name Field on my form and press Enter, my Application will call Java API program that will access a service (ex: getInfoClient() ) and will return the others client's information that will fill other fields in my AR System fields (Form)... Any suggestion of how I can do that? I've already have worked in implementation of arapi API, but always creating and/or modifying an entry... in this case I would like to SET some fields only ... without submit the record... Thanks a lot in advance! I'm using: API Java: arapi63.jar IDE Tool: Eclipse AR Server : 7.0.01 Patch 7 AR Admin: 7.0.00 Patch 1 AR User: 7.0.00 Patch 1 Database: Oracle 10g OS Server: AIX 5.3 OS Client: WinXP Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Doubt how to use Java API (arapi.jar)
anyone??? please! De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 31/7/2008 10:48 Para: arslist@ARSLIST.ORG Assunto: Doubt how to use Java API (arapi.jar) ** Good morning, I have many doubts about implementing AR System Java API (arapiXX.jar). Currently, I'm working as AR System developer and now I have to integrate my ARS Application with a service Java (which brings me client's datas when I pass an information on an ARS form). It looks like that: When I enter a value on Client's Name Field on my form and press Enter, my Application will call Java API program that will access a service (ex: getInfoClient() ) and will return the others client's information that will fill other fields in my AR System fields (Form)... Any suggestion of how I can do that? I've already have worked in implementation of arapi API, but always creating and/or modifying an entry... in this case I would like to SET some fields only ... without submit the record... Thanks a lot in advance! I'm using: API Java: arapi63.jar IDE Tool: Eclipse AR Server : 7.0.01 Patch 7 AR Admin: 7.0.00 Patch 1 AR User: 7.0.00 Patch 1 Database: Oracle 10g OS Server: AIX 5.3 OS Client: WinXP Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Accessing Java API at Exec Time
Hi folks, I would like to know if there is a way to integrate ARS with a specific method / service java... I have an implemented service in java called getInfoCustomerByKey(), I would like that everytime that I enter a value on a determined field in my ARS Form, such as the key of the user (like loginName), my service was executed and return to ARS all the data that the service provides... Is there a way to do this with API ? Remembering that this call will be many times by minute... For example, the user enter his 'login name' (key), and the system fill out others fields (like first name, last name, address, etc... - this values will be returned by the service). Thanks, Any doubts I'll be glad to explain! Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Limiting SQL select statements by AGE
Hi, Try to use SELECT Count(C18099) FROM T1116 WHERE C18099=1 AND C3'$TIMESTAMP$'-604800 on the contrary of SELECT Count(C18099) FROM T1116 WHERE C18099=1 AND C3$TIMESTAMP$-604800 Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Payne, George Enviada: qua 23/7/2008 16:09 Para: arslist@ARSLIST.ORG Assunto: Limiting SQL select statements by AGE ** ARS 7.0.01 P05 DB Oracle 10g I'm looking to make a Set Fields Filter Action to Count the number of records in an ARS Table where the value of the field is '1' and the record is more than 1 week old. This SQL works fine (returns a value for $1$ of =392): SELECT Count(C18099) FROM T1116 WHERE C18099=1 But it fails when I try to add the criteria for the age of the record (throws an error: ARERR [552] Failure during SQL operation to the database : ORA-00904: 07/23/08 14:06:46-604800: invalid identifier): SELECT Count(C18099) FROM T1116 WHERE C18099=1 AND C3$TIMESTAMP$-604800 I've used the $TIMESTAMP$-604800 worked from an Advanced Search on the User Tool...I'm sure it's just something to do with either my SQL syntax or the way the Create Date (C3) is stored on the database. I know it's out there as number of seconds since 1/1/70, but the error seems to indicate that the $TIMESTAMP$ is being interpreted as 07/23/08 14:06:46. Maybe I need to use a FUNCTION for Timestamp that Oracle understands?? Thanks in advance, George George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Check Box Problem
Does anyone know why check box feature does not works well in AR System ??? I'm using AR Server 7.0.01 P7 AR User 7.0.00 P1 AR Admin 7.0.00 P1 I've included some items (more than 1) in my Check Box Field But It does not turn up in my form What's happening??? Thanks for any tips and/or suggestions Yours Sincerelly, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de William Rentfrow Enviada: qui 17/7/2008 12:08 Para: arslist@ARSLIST.ORG Assunto: Re: Licensing Problem This is a plug-in problem I believe. I'm not sure completely but give this a try - You need to add this to your ar.conf file: Server-Plugin-Alias: REMEDY.ARDBC.SERVER.ADMINISTRATION REMEDY.ARDBC.SERVER.ADMINISTRATION : ...where : is the fully qualified domain name of your server (making sure it is DNS resolvable), and is the port for your server if you are not using portmapper. If you are using portmapper drop the : part. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 From: Action Request System discussion list(ARSList) on behalf of Mike Tuck Sent: Thu 7/17/2008 7:51 AM To: arslist@ARSLIST.ORG Subject: Licensing Problem ** I am trying to install a new Remedy Server 7.0.3 on MS Windows 2003 64 bit and I am having a licensing problem, I cannot get the HOSTID. When I select the Licensing link to open the form I get the following errors : ARERR 8762 GETSERVERINFO Failed initialization values. ARERR 623 Authentication failed I noticed a problem with starting the service, it will not run when I select Run as a local system account but it will run when I have it run as a Domain User Account that belongs to the Domain Admin group. I added the UserID to the local Administrator Group and gave it Act as part of the Operating System and Log on as a service in the Local Security Policy. I also changed the default installation directory to d:\AR System, otherwise the initial install is plain vanilla to this point. Mike Tuck mailto: [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Filter Actions - Multiple Push Field Actions
Hi, I believe that you can use something like Guides Take a look in Filter Guide's processing and report your doubts for us... Do something like that: Create a Filter Guide: APP:ExecuteWorklfow Create a Filter with 'Call Guide' action that calls the Filter Guide above Create another that make the 'Push Fields' and 'Notify' action... then, make a validation if the record has been created on yours 2nd form... (you can do this validation pushing your RequestID value on your 2nd form, on field RequestID_from_1st_Form, for example).. If the record was created succesfully you can run another Filter that makes a 'Set Fields' with the specific value that you want... Then... Your Filter Guide will have 2 Filters... ok? Try that and post your doubts ... Guides are really a good way to do workflows Remembering... this was the 1st thing that came up to the top of my head Think better... maybe exist another simple way to do that... Yours Sincerelly, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Sanford, Claire Enviada: ter 15/7/2008 12:45 Para: arslist@ARSLIST.ORG Assunto: Filter Actions - Multiple Push Field Actions I may be going about this all wrong... I have a transport form that takes an email sent to Remedy and then pushes the information to the Ticket. I have one Push action that pushes some information to the ticket then a notify action and then another push action. The and push action will only happen if the 1st push action sets a field with a specific value. It is important that the 2nd push happens after the 1st push. I know I can create 2 filters, but want this to be as clean in terms of workflow as possible. Can I have: Push Fields Notify Push Fields ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ENC: Business Time
Hi folks, I would like to see some real implementations about using Business Time Segment form... I've been read the Configuring white paper (the same of chapter 'Using Business Time in the AR System server' in Help Menu - F1)... But I'm a little lost of how to implement this feature in my system... What Would I like to do?? Basically, I'd like to do 2 (simple) things: - input only Holidays dates in my calendar - disconsider Saturday and Sunday from my Workflow (how can I do that??) Is there necessary to use 'Business Time' or Can I do that only by $WEEKDAY$ keyword Thanks In Advance!! Any tips will be appreciated! Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Business Time
Hello Dwayne... Thanks for your reply... I have an application/form that when I create a new record, my back-office operators have to close this record in 5 days, for example... we have a limit of days to leave this record open and then, close it! What I would like to do is to disconsider Weekends and Holidays for this case For example: If a record has been opened on Wednesdey (09/07/2008), It would be closed 5 days later (disconsidering weekends and/or holidays), i.e., it would be closed on next Wednesdey (16/07/2008) P.S.: We are not considering Hours of Work (such as 8:00 - 17:00)... We consider full day, i.e., 24hs per day. Thanks-in-advance! Any tips will be appreciated! Thanks again Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Date SQL Function
Does anyone has a SQL Function that returns Date/Time from the integer that AR System generate? I need this format Date : DD/MM/ 00:00:00 I have used this function but It's returning something wrong... the Date comes correct... but the Time that I receive is 3 hours later than the original Hour saved in my ARS Form: nvl2(CreateDate, to_char(to_date('00:00:00', 'HH24:MI:SS')+ (CreateDate/(60*60*24)), 'HH24:MI:SS'), '') CreateDate Some tips will be very appreciated! Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Date SQL Function
oh, I'm so sorry. I'm using: ARS Server 7.0.01 Patch 7 ARS Clients (Admin and User) 7.0.00 Patch 1 Oracle Database 10g OS Server AIX 5.3 OS Client Windows XP Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Grooms, Frederick W Enviada: ter 1/7/2008 13:10 Para: arslist@ARSLIST.ORG Assunto: Re: Date SQL Function ** What SQL database are you on (and version please)? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, July 01, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: Date SQL Function Does anyone has a SQL Function that returns Date/Time from the integer that AR System generate? I need this format Date : DD/MM/ 00:00:00 I have used this function but It's returning something wrong... the Date comes correct... but the Time that I receive is 3 hours later than the original Hour saved in my ARS Form: nvl2(CreateDate, to_char(to_date('00:00:00', 'HH24:MI:SS')+ (CreateDate/(60*60*24)), 'HH24:MI:SS'), '') CreateDate Some tips will be very appreciated! Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Doubt about (clear) value in Menu
Hi people! I have a doubt about the valoue (clear) in Menu Character Fields... Is this a new feature in a specific version?? In my desktop I'm not seeing this value in Menus... I'm using: AR Server 7.0.01 Patch 7 AR User Tool 7.0.00 Patch 1 AR Admin Tool 7.0.00 Patch 1 But, in another machine (of my colleague) it's showing (clear) value very well... My friend is using: AR Server 7.0.01 Patch 7 AR User Tool 7.0.01 Patch 4 AR Admin Tool 7.0.01 Patch 4 Any helps/tips will be appreciated! Thanks List! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Please connect with me :)
Hi Katherine.. I'd like to keep connect with you :) kisses! heheheh De: Action Request System discussion list(ARSList) em nome de Katherine Hoffner Enviada: qui 19/6/2008 18:01 Para: arslist@ARSLIST.ORG Assunto: Please connect with me :) ** I looked for you on Reunion.com, but you weren't there. Please connect with me so we can keep in touch. Do you know Katherine? Yes http://www.reunion.com/showInviteRegistration.do?uid=266015989No http://www.reunion.com/showInviteRegistration.do?unsub=trueuid=266015989[EMAIL PROTECTED] Tell us, and see who's searching for you! http://www.reunion.com/showInviteRegistration.do?uid=266015989lid=30 Reunion.com http://www.reunion.com/showInviteRegistration.do?uid=266015989lid=30 - Find Everyone from Your Past.(tm) You have received this email because a Reunion.com http://www.reunion.com/main.do?lid=30 Member sent an invitation to this email address. For assistance, please refer to our FAQ http://help.reunion.com/selfhelp or Contact Us http://help.reunion.com/selfhelp . Our Address: 2118 Wilshire Blvd., Box 1008, Santa Monica, CA 90403-5784 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Workflow to delete records from AR System Email Messages
Ravi, How many records has your AR System Email Messages Form?? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Sokol, Brian Enviada: qua 11/6/2008 12:10 Para: arslist@ARSLIST.ORG Assunto: Re: Workflow to delete records from AR System Email Messages That is how I have been doing it for over a year without a problem. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 10:32 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow to delete records from AR System Email Messages I am being told by BMC support to not turn on archiving for system forms. This form is one of them. Sokol, Brian wrote: Can't you just turn on the archive for that form and set it to delete all records older then 90 days? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Wednesday, June 11, 2008 7:20 AM To: arslist@ARSLIST.ORG Subject: Workflow to delete records from AR System Email Messages Hi: I am trying to build a escalation to delete records from AR System Email Messages form that have a create date older than 90 days. What do I include in Command Line field within the Run Process Action? The following doesn't seem to be working. Application-Delete-Entry BMC:SSP:Issue $Request ID$ Also is there a recommended way to delete data from this form rather than using escalation? Thanks Ravi __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: ARS Scripting Plug-in for JAVA
Hi, I have a question about ARS Scripting Plug-in for JAVA, is this plug-in supported by BMC ? De: Action Request System discussion list(ARSList) em nome de Kodali Prakash Enviada: seg 9/6/2008 14:47 Para: arslist@ARSLIST.ORG Assunto: ARS Scripting Plug-in for JAVA Hi, How I can use these plug-in to create a Filter that executes a script ?? I created a script in Filter Script Library tested in Java Scripting Test Now my question is, how i can call this script from a Filter setfield action.? I cant find any reference for the script i created from the filter. Please help in this regard. Thanx-in-advance... Prakash.k ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: RES: ARS Scripting Plug-in for JAVA
Prakash, I say that because some months ago we tried to install this feature in our company. And, unfortunatly, we did not use this feature because we're having some problems during installation and the BMC's Company Representative in my Country said that they don't support us because this feature wasn't supported by BMC... I really did not understand their answer and our support staff forgot this subject considering the answer of BMC's Representative... I really was hopefull to use Java codes like script to interact with our AR System Apps ::( Tadeu Augusto Dutra Pinto De: Action Request System discussion list(ARSList) em nome de Kodali Prakash Enviada: seg 9/6/2008 15:10 Para: arslist@ARSLIST.ORG Assunto: Re: RES: ARS Scripting Plug-in for JAVA Yes, I believe. On Jun 9, 11:03 pm, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: Hi, I have a question about ARS Scripting Plug-in for JAVA, is this plug-in supported by BMC ? De: Action Request System discussion list(ARSList) em nome de Kodali Prakash Enviada: seg 9/6/2008 14:47 Para: [EMAIL PROTECTED] Assunto: ARS Scripting Plug-in for JAVA Hi, How I can use these plug-in to create a Filter that executes a script ?? I created a script in Filter Script Library tested in Java Scripting Test Now my question is, how i can call this script from a Filter setfield action.? I cant find any reference for the script i created from the filter. Please help in this regard. Thanx-in-advance... Prakash.k ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Archive old data
Hi Paul and Shyam, We want to do something like these with our AR System App... We have tables/forms with records since year 2003... We want the data accessible (searchable) to the Archive Form. Our Archive Form will have only records with 'Status' = $Closed$ We are searching for solutions and/or suggestions to export a high quantity o records at the first time. Any tips? Thanks! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Shyam Attavar Enviada: sáb 31/5/2008 02:10 Para: arslist@ARSLIST.ORG Assunto: Re: Archive old data Paul, It depends whether you want the data accessible (searchable) or not. One of the things we have seen being done is to export the data into ARX files and the associated form definitions also and archived them on tapes for posterity. Another thing you can certainly do is to export the underlying DB tables (T, H and possibly B) as is (especially if you are on Oracle) and archive them on to tape. Not sure if this is exactly what you are looking for. HTH, -- Shyam - Original Message - From: ARSsytem [EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, May 30, 2008 2:31 PM Subject: Archive old data Hi Listers, We are holding more than 7 years of data in our archive data forms (which are only regular forms, not archive forms). We would like to move part of them off line. Has anyone done that? Is there any white paper for the best practice. Thanks! Regards Paul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Initial Load of Records - ARCHIVE
Hi people, Firstly, I'd like to say that we are facing many performance troubles because of that... I'd like to know if there is a better way to implement ARCHIVE feature in an Application/Form that contains a high number of records - more than 2 million. We are searching for alternatives to do a initial load of data in our Archive Forms. Considering that if there is more than 2 million records saved in that form we wouldn't simply enable Archive feature (this would take much time) Here are our attempts about this: 1) - Enable Archive feature in a Form X (i.e. Create X_ARCHIVE Form) - Insert data in an Archive Form using Java API (arapi70.jar) Result: Unfortunatly, this tip didn't work fine. Archives form doesn't support create or modify entries. ERROR MESSAGE: Cannot modify or create entries in an Archive or Audit form. [8998] 2) - Enable Archive feature in a Form Y (i.e. Create Y_ARCHIVE Form) - Create a Filter / Escalation that executes 'Push Fields' action periodically Result: Unfortunatly, this tip didn't work fine too. Considering that Archives form does not support create entries. 3) - Use SQL Commands and/or Oracle Database functions??? Maybe! I'd like to hear some suggestions of all of you... Thanks a lot!!! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Help: Remedy Java API 7.0
Hi everyone, I'm trying to use the Java API arapi70.jar... I'm implementing a code that read records of a file and enter this records in a form/table. I would like to know if there is a way to subtitute this code: EntryItem[] entryItems = new EntryItem[15]; entryItems[0] = new EntryItem(new FieldID((new Long(536870925)).longValue()), new Value(unidade.getData1())); entryItems[1] = new EntryItem(new FieldID((new Long(536870918)).longValue()), new Value(unidade.getData2())); entryItems[2] = new EntryItem(new FieldID((new Long(536870919)).longValue()), new Value(unidade.getData3())); entryItems[3] = new EntryItem(new FieldID((new Long(4)).longValue()), new Value(unidade.getData4())); entryItems[4] = new EntryItem(new FieldID((new Long(536870915)).longValue()), new Value(unidade.Data5())); // set the entry items... entry.setEntryItems(entryItems); entry.create(); In this case above, we have only 5 fields to be inserted in a form. But If there is more than one or two hundred of fields... Do I have to write 100 or 200 lines of code only insert it??? Considering that we have all values to all fields in destiny form. Thanks for any tips and/or suggestions... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Update form without logging in
Hi, You can also create a script (shell script) that access the database directly and use this to update your record(s) ... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Eli Schilling Enviada: sex 16/5/2008 17:24 Para: arslist@ARSLIST.ORG Assunto: Update form without logging in ** Happy Friday Listers! So I'm looking for a quick and easy way to update a ticket (single field value) without requiring the user to log in. I'm on ARS 7.1 with Mid-tier 7 on Apache Tomcat. I started by trying to do it via public webservice but couldn't find a way to consume a web service using javascript (unless there's another language supported by Tomcat that would work). So then I thought...what about using jdbc to update the value directly into the database...well; that was a miserable failure as well. I know it can be done I just can't seem to find any examples of the code, nor is my syntax even close to being correct. So, has anyone taken one of these two routes and can you help me out? Or is there another, BETTER way? Thanks all! Eli __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Archive Feature in 7.0.01
Hi for all, I'm going to implement Archive feature soon... Our applications don't have this feature yet... I would like to know any tips/suggestions about building Archives forms and how this work I've already did one test in Development environment, but I'd like to hear some suggestions of you before I do it in Production environment. P.S.: The Form of my application works daily with 15K insert records/day without mentioning our searches in that table (reason for which I'd like to have an Archive/History form)... Considering that my form creates 15K records by day which are the suggestions that you could say to me?? I'm afraind that Archive feature does not support remove that quantity of records at only one time... AR Sytem 7.0.01 Oracle Database 10g OS (Server) AIX 5.3 OS (Client) Windows XP Thanks for all in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Max Index on Form!
Hi all, I'd like to know if has a white paper that describes what's max number of index to a form... I've read a document from 2003 and I've noticed that more than 7 index (or 4 composite index) in one form is bad... I have an application that has a form with 8 index (some of them composite index) ... and we're having problems with performance (searches in database).. I'd like to know if it's possible to insert more index in this form! Remembering: I'd like to improve performance... Att, Tadeu Augusto Dutra Pinto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Max Index on Form!
Thanks for your reply Rick, John and Shawn... Some data: - form receives about 15K records/month; - total number of records is almost 480K; - number of fields on form are 168; - 8 simple index; - 2 composite index (two fields per index); Thankx! Tadeu Augusto Dutra Pinto De: Action Request System discussion list(ARSList) em nome de Rick Cook Enviada: qua 14/5/2008 14:53 Para: arslist@ARSLIST.ORG Assunto: Re: Max Index on Form! ** The two things to look in determining the appropriate maximum number of indexes for a form are the usage of the form and the number of rows involved. If you have only a few hundred or thousand rows in a table, indexes probably won't help all that much, and performance might be negatively impacted if you went way over the top in your indexing. (Aside: Remedy put like 16 on HPD:HelpDesk in ITSM 7. Draw whatever conclusions you like from that). On tables with ~100k+ rows, the basic rule is that indexes speed up queries, but slow down submits, because on each submit, every index must be updated. So on forms where lots of records are submitted, you might want to keep the number of indexes lower than on a form against which reports are run. 7 indexes is not excessive, but is starting to get to the point where adding more would probably be noticed on submits. There isn't a hard number at which your performance will fall off a cliff, you will just notice gradual degradation of performance as the number increases beyond somewhere around 7. It's up to you to find the best balance of performance and functionality for your installation. One other thing to look at, if you haven't already, is how the indexes you have in place are being used, and whether changing or removing one or more of those makes sense. That takes a lot of analysis of SQL logs, and working with your DBA to determine which searches are taking the most time, etc. Rick On Wed, May 14, 2008 at 10:35 AM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: ** Hi all, I'd like to know if has a white paper that describes what's max number of index to a form... I've read a document from 2003 and I've noticed that more than 7 index (or 4 composite index) in one form is bad... I have an application that has a form with 8 index (some of them composite index) ... and we're having problems with performance (searches in database).. I'd like to know if it's possible to insert more index in this form! Remembering: I'd like to improve performance... Att, Tadeu Augusto Dutra Pinto __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Data types not appropriate for arithmitic operation
Hi, Try to use ' in your $SRVR_STRT_STP_INSTR_DESC?$ and $SRVR_FUNCTN_DESC$ Like these: '$SRVR_STRT_STP_INSTR_DESC?$' '$SRVR_FUNCTN_DESC$' Att, Tadeu De: Action Request System discussion list(ARSList) em nome de Drew Shuller Enviada: ter 13/5/2008 13:20 Para: arslist@ARSLIST.ORG Assunto: Data types not appropriate for arithmitic operation Hello everyone, could someone give me a sanity check? I have a filter that pulls data from a staging form and pushes it into the AST:WorkLog form. But it errors out:ARERR [312] Data types are not appropriate for arithmetic operation Here's my set fields: ((( Server Start/Stop Instructions: + $SRVR_STRT_STP_INSTR_DESC?$) + . ) + Server Function Description: ) + $SRVR_FUNCTN_DESC$ Those fields are character fields. The field in AST:Worklog is also a character field, with a length of 0. This should be working, shouldn't it? Or am I missing something? Drew Tulsa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
In trouble with TAB
Hi people! Is there a way to block tab spaces in a charactere field? Thankx Tadeu Augusto Dutra Pinto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Rant - New posts on ARSList - Rant
What's happenin' with this list?? De: Action Request System discussion list(ARSList) em nome de Eric Cleereman (IT) Enviada: sex 25/4/2008 18:05 Para: arslist@ARSLIST.ORG Assunto: Re: Rant - New posts on ARSList - Rant ** Hi Richard, In most cases, it seems someone's tried their resources prior to posting to this list. In some cases, it seems pretty obvious they're going to the list prior to trying reading a manual, Googling, or basically doing any research at all. That's fine too, and I don't think they should be roasted for that either. That said, the following things do bother me: - When I see someone ask a question, get one or more possibly good answers, dismiss those answers, then roasts every single person who was nice enough to have answered. - When that same someone then states they'd appreciate comments from other users, and in turn roasts those users when they provide the requested comments. - When that same someone then goes on to advocate learning by experimentation, but does not expand on what if anything was learned, when that could have been helpful to any other number of users. - When that same someone continues on by espousing the same philosopher who was so inspirational to Hitler, with seemingly no idea who that philosopher was, or what the context of the phrase they had misquoted had even meant. I've had a several users send me emails directly regarding comments and questions I sent to Remedy Maniac previously, both in favor of it, and against it. I know I could have just ignored his/her request for comments, but he/she had actually asked for them, and as much as their posted bothered me on a personal level, I would not have felt right just ignoring their request. I am not sure if you considered my questions and comments to Remedy Maniac a reaming, but I have to say I did feel a whole lot better having said them. I can see how that may have been construed to contribute to the overall hostility on the list lately, and for that I am sorry, as that was never my intent. I also see how my comments regarding karma were a bit snotty, but for those I am not sorry, as that was my intent. Regarding my doctor: I pay to see her. Even though I pay, I still have to listen to a lecture about dropping a few pounds and stopping smoking every time I see them. I'm fine with that, as I believe the reason they feel compelled to give me that lecture is that they are trying to help me. The ARSList is free, and I don't have the same expectations of it I have of a doctor who I pay a lot of money to see. While I do not think someone should be flamed for not providing enough information to answer a question, I do see how it's reasonable to ask them for more information. Eric Cleereman From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Friday, April 25, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Rant - New posts on ARSList - Rant ** opinion on An unpopular opinionbut just consider this. I believe that the reason people post questions to this list is for help. I tend to believe that they've tried their resources and not had any luck. I'm pretty sure that they've most likely googled, read, etc. and still came up empty. Remember, posting to this list has two effects - first, it acknowledges that you can't find the answer and second, that if you post to the list and don't post the right/politically correct way, you potentially open yourself up to flames from some people. I contend that it takes either guts are desperation to admit that you're ignorant of a solution, that you're unable to find anything to help you with the solution, and that you're even willing to potentially endure the flames of politically or grammatically hazardous posting.. But...does it REALLY matter what someone's name is? Does it REALLY HELP to ream them if they aren't as grammatically erudite as you are? How about just dropping the requirements of form, identification and intentand.just help them? Or.don't. But if you can't be positive, cordial and helpful, don't reply. When you are sick and go to your doctor, does he ask Well, what treatments have your researched on the internet and at the library and triedwhat drugs have you borrowed/bought and tried... before he treats you? Does your dentist ask what attempts you've done to fill your own teeth (maybe with a power drill..) before he agrees to help you? Do they say anything like I don't like the way you told me about your pain/problem..so.when you can describe it like I want it described, come back and I'll help you I think not. So.my suggestion is - I'm sure all of us were newbies at some point and appreciated a cordial reply, a kind word, a bit of understanding and a lot of hand-holding
Using sysdate on Oracle 10g
Hi people... I'm not an expert in SQL statements, and I'd like to get some suggestions about a search that I wanted to do on a table... I would like to get all records that are less than current date (ex: 22/04/2008) and more than the first day of the current month (ex: 01/04/2008)... How can I do this with SQL Statements ?? I'm using Oracle 10g with functions like 'sysdate' to get the correct data since 01/01/1970... thanks for any reply... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Improve queries with LIKE and % expressions
Hi All, How can I improve automatic queries of my database?? Analyzing queries (through AR System Log Analyzes tool) I've seen that some queries are consuming more than expected of processing on database... for example, How can I optimize a query such as: a) SELECT T107.C1,C536870927 FROM T107 WHERE ((T107.C536870927 LIKE (('%' || '02. Price') || '%')) AND ('08. By Credit Card' = T107.C536870925)) ORDER BY 1 ASC b) SELECT T137.C1,T137.C1,C4,C536870917,C536870918,C536870919,C7 FROM T137 WHERE ((T137.C536870918 LIKE 'Product%') AND (T137.C536870917 LIKE '01. Debit Card%') AND (T137.C8 LIKE 'CARTOES%') AND (T137.C4 LIKE '02. Cards%') AND (T137.C2 LIKE 't145117%')) ORDER BY 1 ASC Note: a) Field 'C536870927 ': Field Type: Character (with Menu appended) Display Type: Edit QBE Match: Leading b) Field 'C536870918': Field Type: Character (with Menu appended) Display Type: Edit QBE Match: Leading Field 'C536870917': Field Type: Character (with Menu appended) Display Type: Edit QBE Match: Leading Field 'C8': (Core Field) Field Type: Character Display Type: Edit QBE Match: Leading Field 'C4': (Core Field) Field Type: Character (with Menu appended) Display Type: Edit QBE Match: Leading Field 'C2': (Core Field) Field Type: Character Display Type: Edit QBE Match: Leading I think that's because of this LIKE expression that this queries are consuming more resources of database... But this queries run automatically... I really don't know a way to improve this someone knows if there is a possibility to improve this kind of queries ?? Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
Jorge... I think that 2,063,253 of records is really a lot of rows in the table AR System Email Messages... Recently, these week, we had problems with server crash ... and we've noticed that sql statements in this table were contributing for crash in our server ... and our AR System Email Messages table had only one million records... rs I advise you to truncate your table to clear it ... do something like these: TUNCATE TABLE T99 TUNCATE TABLE B99 TUNCATE TABLE H99 Assuming that your table id is 99.. I hope that help you.. thanks ... have a nice weekend... and drink Beer!!! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de George Jungle Enviada: sex 11/4/2008 00:59 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Thanks for all the replies guys. I've answered some of your questions 1. Gary Opela (Corporate) [EMAIL PROTECTED] Is your database local or remote? Local 2. Garrison, Sean (Norcross) [EMAIL PROTECTED] If you are on a unix server check the number of open files being used by the process. Maybe it has hit the max and locked up your server (why you aren't seeing anything in the logs). type in ulimit -a to tell you the limits you have pfiles process id to tell the number of open files used by the process. Thanks Sean, will try this out. currently ulimit says : XX $ ulimit -a core file size(blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files(-n) 256 pipe size (512 bytes, -p) 10 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) 29995 virtual memory(kbytes, -v) unlimited 3. Roger Medsker [EMAIL PROTECTED] I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? Ok. Thanks Roger. will give that a go next time it hangs... only prob is it's intermittent and we really can't have SQL logging on all the time will figure something out. 4. Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] one question how many records does your AR System Email Messages has??? 2,063,253 records... Delete Outgoing Messages is set to No. Will have to get that changed! Does this sound like a lot of rows to you? George On 4/11/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: one question how many records does your AR System Email Messages has??? De: Action Request System discussion list(ARSList) em nome de Roger Medsker Enviada: qui 10/4/2008 11:45 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** George, I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? HTH Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients
RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
That's it Darrel.. I forgot to say... After you truncate your table enable an escalation to delete records from this table ... one escalation that clear all records that are more than one week on databse, for example... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Darrell Reading Enviada: sex 11/4/2008 18:37 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) We set up an escalation that deletes old tickets. We only keep 2 to 10 thousand records in there at any given time depending on how many transactions we have that day. I can't imagine having that many rows in that form. :S Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Friday, April 11, 2008 16:24 To: arslist@ARSLIST.ORG Subject: RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) Jorge... I think that 2,063,253 of records is really a lot of rows in the table AR System Email Messages... Recently, these week, we had problems with server crash ... and we've noticed that sql statements in this table were contributing for crash in our server ... and our AR System Email Messages table had only one million records... rs I advise you to truncate your table to clear it ... do something like these: TUNCATE TABLE T99 TUNCATE TABLE B99 TUNCATE TABLE H99 Assuming that your table id is 99.. I hope that help you.. thanks ... have a nice weekend... and drink Beer!!! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br http://www.cinq.com.br/ https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de George Jungle Enviada: sex 11/4/2008 00:59 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Thanks for all the replies guys. I've answered some of your questions 1. Gary Opela (Corporate) [EMAIL PROTECTED] Is your database local or remote? Local 2. Garrison, Sean (Norcross) [EMAIL PROTECTED] If you are on a unix server check the number of open files being used by the process. Maybe it has hit the max and locked up your server (why you aren't seeing anything in the logs). type in ulimit -a to tell you the limits you have pfiles process id to tell the number of open files used by the process. Thanks Sean, will try this out. currently ulimit says : XX $ ulimit -a core file size(blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files(-n) 256 pipe size (512 bytes, -p) 10 stack size(kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes(-u) 29995 virtual memory(kbytes, -v) unlimited 3. Roger Medsker [EMAIL PROTECTED] I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? Ok. Thanks Roger. will give that a go next time it hangs... only prob is it's intermittent and we really can't have SQL logging on all the time will figure something out. 4. Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] one question how many records does your AR System Email Messages has??? 2,063,253 records... Delete Outgoing Messages is set to No. Will have to get that changed! Does this sound like a lot of rows to you? George On 4/11/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: one question how many records does your AR System Email
RES: Escalation will not run?
Have you already tried to change your Run If Qualification for: (1=1) OR ('Status' != $NULL$) Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Sokol, Brian Enviada: qua 9/4/2008 12:39 Para: arslist@ARSLIST.ORG Assunto: Escalation will not run? ** I have an escalation that is normally disabled. I enable it whenever I need it to run. It is very simple and updates two fields in a table. I had nothing in the Run If field and it always worked. Now today it will not run. The escalation log shows Failed Qualification? I tried changing the run if line to things that I know will work (1=1 or $STATUS$ != $NULL$) and same error message. Anyone have an idea why this is failing it's qualification? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2)
one question how many records does your AR System Email Messages has??? De: Action Request System discussion list(ARSList) em nome de Roger Medsker Enviada: qui 10/4/2008 11:45 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** George, I have seen this behavior in a situation we had where AR System was actually restarting. There is no indication in any of the logs that the server crashed or was manually stopped. You can detect this by having server side SQL logging on when this occurs. If you see lots of SQL transactions with no identified user associated to them, then the server process is starting up. This doesn't help identify the root cause but the question changes from Why does the server 'hang'? to Why is the server restarting? HTH Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Jungle Sent: Thursday, April 10, 2008 2:45 AM To: arslist@ARSLIST.ORG Subject: arserverd 'hangs' (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) ** Hey guys, We're getting a strange issue (seemingly intermittent) with the arserverd where it just seems to 'hang'. All existing and new clients receive a TimeOut error, but yet when you check : -the processes at the o/s -the error logs -db sessions there is no evidence that there is an issue. (i.e. all processes running, you get timeouts appearing due to Brie / SLM engine not being able to connect and db sessions are not 'locked' or taking an extensive amount of time to process). It seems that the only way to fix this is to do a restart of the AR Server. I was just wondering if anyone else has experienced anything remotely similar to this? Thanks. George (AR 7.0.1 patch 5 - Sol 10 - Ora 10g2) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: arserverd crash - signal 10
Hello, A few minutes ago I had the next error and this is my arerror.log... can anyone analyze this for me? thankx a lot! Wed Apr 9 10:49:08 2008 Dispatch : Timeout during data retrieval due to busy server -- retry the operation (brapk017) ARER R - 93 Wed Apr 9 10:52:08 2008 Dispatch : Timeout during data retrieval due to busy server -- retry the operation (brapk017) ARER R - 93 Wed Apr 9 10:55:08 2008 Dispatch : Timeout during data retrieval due to busy server -- retry the operation (brapk017) ARER R - 93 Wed Apr 9 10:56:43 2008: Server terminating, recursive signal received: 11, original signal: 15 Wed Apr 9 10:56:44 2008 Dispatch : AR System Application server terminated when a signal/exception was received by the serv er (ARAPPNOTE 4500) Wed Apr 9 10:56:44 2008 15 Wed Apr 9 10:57:08 2008 390600 : Safeguard mismatch - potentially corrupted container (ARERR 8842) Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Axton Enviada: qua 9/4/2008 10:41 Para: arslist@ARSLIST.ORG Assunto: Re: arserverd crash - signal 10 ** From /usr/include/sys/iso/signal_iso.h on sparc64/solaris 9: ... * The contents of this header is limited to identifiers specified in the * C Standard. Any new identifiers specified in future amendments to the ... #define SIGHUP 1 /* hangup */ #define SIGINT 2 /* interrupt (rubout) */ #define SIGQUIT 3 /* quit (ASCII FS) */ #define SIGILL 4 /* illegal instruction (not reset when caught) */ #define SIGTRAP 5 /* trace trap (not reset when caught) */ #define SIGIOT 6 /* IOT instruction */ #define SIGABRT 6 /* used by abort, replace SIGIOT in the future */ #define SIGEMT 7 /* EMT instruction */ #define SIGFPE 8 /* floating point exception */ #define SIGKILL 9 /* kill (cannot be caught or ignored) */ #define SIGBUS 10 /* bus error */ #define SIGSEGV 11 /* segmentation violation */ #define SIGSYS 12 /* bad argument to system call */ #define SIGPIPE 13 /* write on a pipe with no one to read it */ #define SIGALRM 14 /* alarm clock */ #define SIGTERM 15 /* software termination signal from kill */ #define SIGUSR1 16 /* user defined signal 1 */ #define SIGUSR2 17 /* user defined signal 2 */ #define SIGCLD 18 /* child status change */ #define SIGCHLD 18 /* child status change alias (POSIX) */ #define SIGPWR 19 /* power-fail restart */ #define SIGWINCH 20 /* window size change */ #define SIGURG 21 /* urgent socket condition */ #define SIGPOLL 22 /* pollable event occured */ #define SIGIO SIGPOLL /* socket I/O possible (SIGPOLL alias) */ #define SIGSTOP 23 /* stop (cannot be caught or ignored) */ #define SIGTSTP 24 /* user stop requested from tty */ #define SIGCONT 25 /* stopped process has been continued */ #define SIGTTIN 26 /* background tty read attempted */ #define SIGTTOU 27 /* background tty write attempted */ #define SIGVTALRM 28/* virtual timer expired */ #define SIGPROF 29 /* profiling timer expired */ #define SIGXCPU 30 /* exceeded cpu limit */ #define SIGXFSZ 31 /* exceeded file size limit */ #define SIGWAITING 32 /* process's lwps are blocked */ #define SIGLWP 33 /* special signal used by thread library */ #define SIGFREEZE 34/* special signal used by CPR */ #define SIGTHAW 35 /* special signal used by CPR */ #define SIGCANCEL 36/* thread cancellation signal used by libthread */ #define SIGLOST 37 /* resource lost (eg, record-lock lost) */ #define SIGXRES 38 /* resource control exceeded */ #define _SIGRTMIN 39/* first (highest-priority) realtime signal */ #define _SIGRTMAX 46/* last (lowest-priority) realtime signal */ Axton Grams On Wed, Apr 9, 2008 at 9:35 AM, Aaron Keller [EMAIL PROTECTED] wrote: ** Does anyone know what what the different signals (in arerror.log) mean when arserverd stops? Specifically, signal 10? The only one I know is the manual shutdown - 15. Thanks- -A Aaron Keller | Senior Application Developer | T-Mobile USA | *: (610) 722-4486 | *Fax: (610) 993-2689 | *: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
RES: How to know when a table is full ??
Hi John, Thanks for your reply... But I would like to create this in a AR Sytem Form... (like Alert Events, AR System Email Messages) Could I create new Fields in these kind of forms without any worry about modify AR System Forms??? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de john rosquist Enviada: seg 7/4/2008 11:24 Para: arslist@ARSLIST.ORG Assunto: Re: How to know when a table is full ?? ** On a test form create a filter or esc. select form name firing conditions ... if action-set fields-Read value-direct SQL select count(*) from t... Name field to put the result into - SQL result col 1 Good luck, John Rosquist Windward - Original Message From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, April 3, 2008 2:00:46 PM Subject: How to know when a table is full ?? ** Hi All. How could I execute a command to get the quantity of records in a table? Our test environment has not license ... and because of this we have a limit of 2k records for each table... I'd like to know when my table is full (i.e. if there is with 2k records) Is there some way for me obtain this feature through an workflow object (Filter , AL , etc...) ??? P.S.: I've thought in to execute a Direct SQL command ... but this action doesn't return nothing... Can somebody help me? Thankx-in-advance! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access http://us.rd.yahoo.com/evt=47523/*http://tc.deals.yahoo.com/tc/blockbuster/text5.com , No Cost. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Using 'Search Bar' with 'Create Date'
Hello, I'm trying to do this funcionallity ... When I put 'Create Date' this works very well But when I put 'Create Date' (withou blank spaces between 'Create Date' and ) this does not work... and, consequently, when I put another cause of condition that go out of my specific case (i.e. 'Create Date' ) this doesn't work fine ... Is there a way that I can create a condition that works fine? I've tried to put 'Create Date' + % + , but when I have another sentence after this, I am in trouble too ... because I can't write a sentence like this: 'Create Date' 01/01/2007 AND 'Status' 3 ... Any suggestion will be appreciated! Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Joe D'Souza Enviada: sex 4/4/2008 14:06 Para: arslist@ARSLIST.ORG Assunto: Re: Using 'Search Bar' with 'Create Date' ** Just a guess but by the time your statement is evaluated, maybe the ARS translates 'Create Date' to '3'?? Did you check the AL logs assuming your workflow is AL based? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto Sent: Friday, April 04, 2008 11:41 AM To: arslist@ARSLIST.ORG Subject: Using 'Search Bar' with 'Create Date' ** Hi for all, I'd like to know if there is a way to block users to do sentences like that: 'Create Date' 0404/2008 for example... I tried to do something like this... 'Search Bar' LIKE (( % + 'Create Date' ) + % ) using Active Link... But it does not work Thankx in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Using 'Search Bar' with 'Create Date'
Steve, I've already tried to do something like this... but I wanted to simplify the condition... I wouldn't like to use a code like these: ('Search Bar' LIKE (((% + 'Create Date') + %))) == with no blank spaces OR ('Search Bar' LIKE (((% + 'Create Date' ) + %))) == with one blank space OR ('Search Bar' LIKE (((% + 'Create Date' ) + %)))== with two blank space OR ('Search Bar' LIKE (((% + 'Create Date' ) + %))) == with three blank space and so on... I'd like to know if there is a way for me do this with a rule that is used for n blank spaces... Remember that I've tried to use % but this does not work because of this, for example: 'Create Date' 01/01/2007 AND 'Status' 3 Thankx for all... Yours Sincerelly, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Steven Pataray Enviada: seg 7/4/2008 12:43 Para: arslist@ARSLIST.ORG Assunto: Re: Using 'Search Bar' with 'Create Date' ** This looks almost like yours but it worked for me. 'Search Bar' LIKE (% + 'Create Date' + %) OR 'Search Bar' LIKE (% + 'Create Date' + %) Steve On 4/7/08, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: Hello, I'm trying to do this funcionallity ... When I put 'Create Date' this works very well But when I put 'Create Date' (withou blank spaces between 'Create Date' and ) this does not work... and, consequently, when I put another cause of condition that go out of my specific case (i.e. 'Create Date' ) this doesn't work fine ... Is there a way that I can create a condition that works fine? I've tried to put 'Create Date' + % + , but when I have another sentence after this, I am in trouble too ... because I can't write a sentence like this: 'Create Date' 01/01/2007 AND 'Status' 3 ... Any suggestion will be appreciated! Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Joe D'Souza Enviada: sex 4/4/2008 14:06 Para: arslist@ARSLIST.ORG Assunto: Re: Using 'Search Bar' with 'Create Date' ** Just a guess but by the time your statement is evaluated, maybe the ARS translates 'Create Date' to '3'?? Did you check the AL logs assuming your workflow is AL based? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Tadeu Augusto Dutra Pinto Sent: Friday, April 04, 2008 11:41 AM To: arslist@ARSLIST.ORG Subject: Using 'Search Bar' with 'Create Date' ** Hi for all, I'd like to know if there is a way to block users to do sentences like that: 'Create Date' 0404/2008 for example... I tried to do something like this... 'Search Bar' LIKE (( % + 'Create Date' ) + % ) using Active Link... But it does not work Thankx in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br http://www.cinq.com.br/ https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com
Monitoring AR Server - Crashing!
Hi people, I'm in troubles with environment production in these last week It's second time that our server crashes in a interval of one week and we don't have any idea of what is happening with our system... Our log files (API, SQL, Filter, Escalation, Thread, etc...) weren't turn on ... Recently we have made an upgrade of our system ... We migrated from AIX 5.1 to AIX 5.3, Oracle database 9i to 10g and ARS 5.1 to 7.0.01 Patch 4... Is there any suggestions about what could be happenin' with our system ... Maybe could be because Patch version (I don't know) Will be appreciated tips and suggestions that help us to discovery what can be happening and how we can monitor this kind of things... Thanks FYI: twice that server crashes the production environment was in rush hour (could it be hardware requirements?? like memory? I don't know) Att Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Using 'Search Bar' with 'Create Date'
I'm sorry... this work very well... De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: sex 4/4/2008 12:40 Para: arslist@ARSLIST.ORG Assunto: Using 'Search Bar' with 'Create Date' ** Hi for all, I'd like to know if there is a way to block users to do sentences like that: 'Create Date' 0404/2008 for example... I tried to do something like this... 'Search Bar' LIKE (( % + 'Create Date' ) + % ) using Active Link... But it does not work Thankx in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How to know when a table is full ??
Hi All. How could I execute a command to get the quantity of records in a table? Our test environment has not license ... and because of this we have a limit of 2k records for each table... I'd like to know when my table is full (i.e. if there is with 2k records) Is there some way for me obtain this feature through an workflow object (Filter , AL , etc...) ??? P.S.: I've thought in to execute a Direct SQL command ... but this action doesn't return nothing... Can somebody help me? Thankx-in-advance! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
What does it means :SYS_B_1 ?
Hi people, I need to check some queries... but I'm having some problems with them... How can I analyze this : SELECT T57.C1,T57.C1,C8,C7,C536870919,C536870915,C536870916,C3,C53687 0914 FROM T57 WHERE ((T57.C536870968 = :SYS_B_0) AND (T57.C536870941 = :SYS_B_1) AND (T57.C3 :SYS_B_2)) ORDER BY :SYS_B_3 ASC I know that the values C_something are my fields on my form ... But how Can I interpret values such as :SYS_B_1, :SYS_B_2, :SYS_B_3 ??? Any tips will be appreciated! P.S.: Thankx guys for reply on my other question.. Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OzZY: Remedy JAVA api question
Hey, Have you already resolve your problem with Java API ? I had an experience with this error ... My AR Server is AIX too ... but I was testing a batch process java on local system ... I'm using Windows XP... In this case, I did some like this: I searched for libarjni70.a in my Computer But I found libarjni70.dll (because I'm using Windows)... and I put this file in my System32 folder... When I tried to execute my java programm again ... I received another error message ... With other and other libs that were faulting ... I'll putting this libs on my System32 folder one by one and finally I achieve to execute my program very well... Try to do this and tell me, please! P.S.: I put OzZy in reply because I'm not believing that today I confirmed my passport to the show of madman! rs Yours Sincerelly, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Axton Enviada: ter 1/4/2008 15:04 Para: arslist@ARSLIST.ORG Assunto: Re: FW: Remedy JAVA api question ** If you run file against the java binary, what do you get back? e.g., [EMAIL PROTECTED] c]$ which java /usr/bin/java [EMAIL PROTECTED] c]$ file /usr/bin/java /usr/bin/java: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, stripped Axton Grams On Tue, Apr 1, 2008 at 11:29 AM, Matthew Kunkel [EMAIL PROTECTED] wrote: ** Correction: The first line should have read: We're getting the error below when trying to use the JAVA api on an AIX platform. I originally thought it was windows, so I keep getting the process confused. The whole app runs on a 64 bit AIX platform, no windows. Thanks, Matt From: Matthew Kunkel Sent: Tuesday, April 01, 2008 9:46 AM To: 'arslist@ARSLIST.ORG' Subject: Remedy JAVA api question List, We're getting the error below when trying to use the JAVA api on a windows platform. This particular program is running on AIX, whereas I'm most familiar with HP-UX. I've googled the error and can't seem to find anything. We get the same result on both the 6.3 and 7.0 versions of the API. Any help is appreciated. Caused by: java.lang.UnsatisfiedLinkError: /u/applic/Remedy/libarjni70.a (0509-022 Cannot load module /u/applic/Remedy/libarjni70.a. 0509-103 The module has an invalid magic number.) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469) Thanks, Matt ** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ** Wal-Mart Confidential ** __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
How do I Export Archive forms??
Good morning people! Is There a correct way to export (.def) archive files / forms ?? e.g. I have some forms that are with Archive option enabled... How can I make a .def file with of this forms with total security?? If I copy only the Original Form my Admin Tool already creates an Archive form too?? Or do I have to export (to def file) my Archive Form too?? Thanx for any reply! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Question: Filter Guide
Hello crazy people! Is it possible to create a Filter Guide that calls another Filter Guide?? What are the exceptions about this? P.S.: I wanna have a loop inside another loop I'm using: AR Server 7.0.01 Patch 4 AR Admin 7.0.00 Patch 1 DB Oracle 10g OS AIX 5.3 Thankx Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Modify one record, Update more than one! Is there a way to do this?
People, Is there a way to do this in ARS: Considere an interaction with User Form (from AR System forms) and another any other form customized (Form Employee for instance). - User form has Group List field... - Everytime that I create a new user on User Form, my Employee Form creates 'N' records based on number of groups that are on 'Group List' field. (This is already happening) For instance: If I've created a User with these datas: Login Name = tadeu Full Name = Tadeu Augusto Dutra Pinto Password = 123 Group List = Group_1 Group_2 Group_3 ... ... My Employee Form creates three new records, like these: # Record 1: LoginEmp = tadeu (value of 'Login Name') NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_1 (First value of 'Group List') # Record 2: LoginEmp = tadeu (value of 'Login Name' - Push Field: From User To Employee) NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_2 (Second value of 'Group List') # Record 3: LoginEmp = tadeu (value of 'Login Name' - Push Field: From User To Employee) NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_3 (Third value of 'Group List') Note: This values are received by Push Fields action (Push Field: From User To Employee) Ok, that's is runnin' well... very well... I'm in trouble with UPDATE of this values... (I'd to update 'Group List' in User Form and records in Employee Form is updated too) I didn't achieve to find a way to do this... Somebody else know a way that I can use for this case? Oh... I've already created a way to delete records on Employee Form when I delete related record on User Form... That's ok too.. Until the moment I used features like 'Push Fields', 'Set Fields' in Filters and 'Filters Guide' and Process 'Application-Delete-Entry' to delete records... I think that's is... I'm using: AR System Server Version 7.0.01 Patch 004 AR System Administrator Version 7.0.00 Patch 001 AR System User Version 7.0.01 Patch 005 Oracle Database 10g Operating System AIX 5.3 Thankx-in-advance... Any tips will be appreciated! Regards[ ] Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Modify one record, Update more than one! Is there a way to do this?
Mark (and other users too)... I've already tried by two ways... 1 - Delete all records on my second form (Employee Form) and then insert new records again... This would run ok unless system don't show me this error message: ARERR [302] Entry does not exist in database. obs: I know this message is because my application does not have records on tables H and B. But this is how my application runs... If there is a way to hide this kind of message, please tell me... 2 - Find out all existing records that are on Employee Form and modify then ... but I've received a message with duplicate entry error... ARERR [382] The value(s) for this entry violate a unique index that has been defined for this form : Employee entry:654 fields: 536870915 536870918 101 536870916 Tips will be very appreciated... Thankx so much! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Blankenship, Mark (Mark) Enviada: qui 13/3/2008 14:36 Para: arslist@ARSLIST.ORG Assunto: Re: Modify one record, Update more than one! Is there a way to do this? ** Not sure I entirely understand, but I'll give it a shot Easiest/Clumsiest way: Whenever the User Group list is updated; Push a Delete/Disable value to ALL of the existing records, then have you current workflow fire as normal. generating a new record for each group list entry. More Involved/I don't know enough about you situation to be sure: Whenever the group list is updated; some sort of lookup to look for only the existing records, which are no longer represented in the Group List...and push the Delete/Disable value to the existing records. Then only add new records for new group list values. Mark From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, March 13, 2008 12:24 PM To: arslist@ARSLIST.ORG Subject: Modify one record, Update more than one! Is there a way to do this? ** People, Is there a way to do this in ARS: Considere an interaction with User Form (from AR System forms) and another any other form customized (Form Employee for instance). - User form has Group List field... - Everytime that I create a new user on User Form, my Employee Form creates 'N' records based on number of groups that are on 'Group List' field. (This is already happening) For instance: If I've created a User with these datas: Login Name = tadeu Full Name = Tadeu Augusto Dutra Pinto Password = 123 Group List = Group_1 Group_2 Group_3 ... ... My Employee Form creates three new records, like these: # Record 1: LoginEmp = tadeu (value of 'Login Name') NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_1 (First value of 'Group List') # Record 2: LoginEmp = tadeu (value of 'Login Name' - Push Field: From User To Employee) NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_2 (Second value of 'Group List') # Record 3: LoginEmp = tadeu (value of 'Login Name' - Push Field: From User To Employee) NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_3 (Third value of 'Group List') Note: This values are received by Push Fields action (Push Field: From User To Employee) Ok, that's is runnin' well... very well... I'm in trouble with UPDATE of this values... (I'd to update 'Group List' in User Form and records in Employee Form is updated too) I didn't achieve to find a way to do this... Somebody else know a way that I can use for this case? Oh... I've already created a way to delete records on Employee Form when I delete related record on User Form... That's ok too.. Until the moment I used features like 'Push Fields', 'Set Fields' in Filters and 'Filters Guide' and Process 'Application-Delete-Entry' to delete records... I think that's is... I'm using: AR System Server Version 7.0.01 Patch 004 AR System Administrator Version 7.0.00 Patch 001 AR System User Version 7.0.01 Patch 005 Oracle Database 10g Operating System AIX 5.3 Thankx-in-advance... Any tips will be appreciated! Regards[ ] Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL
RES: Modify one record, Update more than one! Is there a way to do this?
Hi Joe, What's the functionality of Instance ID field? I tried to use this field but its value is always blank... after, I tried to use Object ID field, and this field don't have any value too... Is there an explanation for this? Thanks Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Joe D'Souza Enviada: qui 13/3/2008 15:30 Para: arslist@ARSLIST.ORG Assunto: Re: Modify one record, Update more than one! Is there a way to do this? ** Push the instance ID of the user record too.. Create new records only if the combination of the Instance Id and the Group name doesn't exist in the second form.. This should work.. and you wouldn't have to modify older ones, just have a delete functionality in place to delete a row there if you happen to take off a group from the group list.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ]On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, March 13, 2008 2:03 PM To: arslist@ARSLIST.ORG Subject: RES: Modify one record, Update more than one! Is there a way to do this? Mark (and other users too)... I've already tried by two ways... 1 - Delete all records on my second form (Employee Form) and then insert new records again... This would run ok unless system don't show me this error message: ARERR [302] Entry does not exist in database. obs: I know this message is because my application does not have records on tables H and B. But this is how my application runs... If there is a way to hide this kind of message, please tell me... 2 - Find out all existing records that are on Employee Form and modify then ... but I've received a message with duplicate entry error... ARERR [382] The value(s) for this entry violate a unique index that has been defined for this form : Employee entry:654 fields: 536870915 536870918 101 536870916 Tips will be very appreciated... Thankx so much! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Blankenship, Mark (Mark) Enviada: qui 13/3/2008 14:36 Para: arslist@ARSLIST.ORG Assunto: Re: Modify one record, Update more than one! Is there a way to do this? ** Not sure I entirely understand, but I'll give it a shot Easiest/Clumsiest way: Whenever the User Group list is updated; Push a Delete/Disable value to ALL of the existing records, then have you current workflow fire as normal. generating a new record for each group list entry. More Involved/I don't know enough about you situation to be sure: Whenever the group list is updated; some sort of lookup to look for only the existing records, which are no longer represented in the Group List...and push the Delete/Disable value to the existing records. Then only add new records for new group list values. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, March 13, 2008 12:24 PM To: arslist@ARSLIST.ORG Subject: Modify one record, Update more than one! Is there a way to do this? ** People, Is there a way to do this in ARS: Considere an interaction with User Form (from AR System forms) and another any other form customized (Form Employee for instance). - User form has Group List field... - Everytime that I create a new user on User Form, my Employee Form creates 'N' records based on number of groups that are on 'Group List' field. (This is already happening) For instance: If I've created a User with these datas: Login Name = tadeu Full Name = Tadeu Augusto Dutra Pinto Password = 123 Group List = Group_1 Group_2 Group_3 ... ... My Employee Form creates three new records, like these: # Record 1: LoginEmp = tadeu (value of 'Login Name') NameEmp = Tadeu Augusto Dutra Pinto (value of 'Full Name') GroupEmp = Group_1 (First value of 'Group List
Updating records w/ Push Fields
I'm trying on to update records in AR System forms. When I make a changes on FORM A (Modify) automatically another form (FORM B) is updated too... I've created a logic that I think is not so good... My workflow deletes data from FORM B and send it again (Push Fields Action) to my FORM B... Is there another way that I can really do an Update action in this case?? Thank you all Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Updating records w/ Push Fields
Hi, I've created a workflow that is executed everytime is Created/Modified/Deleted a record on User form (User Form from AR Sytem install)... I've created an Regular Form (Called DC-Emp). Workflow starts when I make changes on User Form. I'll show three possibilities for you: 1 - Creating a new user (record) on User Form: --- Object: Filter (Form Name: User) - Field values like Login Name, Full Name, Group List, Email Address and Creator are pushed to my DC-Emp Form (this form has appropriate fields to share this values); 2 - Deleting a user (record) on User Form: --- Object: Filter (Form Name: User) - I have a filter that is executed when 'Execute On' = Delete (), so I use 'Run Process' Action with Application-Delete-Entry to delete this record from my DC-Emp Form. Here's my problem: 3 - Modifying a user (record) on User Form: --- Object: Filter (Form Name: User) - I've created Filter that calls a Filter Guide Object that has the Filter above (filter that execute Delete command - item 2). - Then I've used the same Push Fields Action from item 1 that entry data on User Form... (i.e. My Modify/Update action is something like this: Firstly I verify if Login field, from DC-Emp Form, is equal Login Name, from User Form. If it were, I'll delete both records. And, after I'll insert again the modified record from User Form on my DC-Emp Form)... BUT, UNFORTUNATELLY, I THINK THAT IS NOT A GOOD IDEA... I'd like to know if there is another way for me create a new Modify step to my workflow... I'm using: AR Server 7.0.01 p4 ARS User 7.0.01 p5 Database Oracle 10g Any tips will be very appreciated! Thankx a lot, list! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Seth Wrye Enviada: qui 6/3/2008 14:13 Para: arslist@ARSLIST.ORG Assunto: Re: Updating records w/ Push Fields What's the purpose of your solution? What version of ARS are you running? Are your forms custom forms or OOTB forms? Seth Wrye From: Action Request System discussion list(ARSList) on behalf of Tadeu Augusto Dutra Pinto Sent: Thu 3/6/2008 7:33 AM To: arslist@ARSLIST.ORG Subject: Updating records w/ Push Fields ** I'm trying on to update records in AR System forms. When I make a changes on FORM A (Modify) automatically another form (FORM B) is updated too... I've created a logic that I think is not so good... My workflow deletes data from FORM B and send it again (Push Fields Action) to my FORM B... Is there another way that I can really do an Update action in this case?? Thank you all Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br https://owa.mailstreet2003.net/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/ [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Editing closed incidents
Hi, You can also create Active Links that use a Change Field Action to deny that determined users / groups cannot modify determined fields or even forms... Att. Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Joel Sender Enviada: qua 5/3/2008 00:15 Para: arslist@ARSLIST.ORG Assunto: Re: Editing closed incidents ** This is ARS, of course there's a way! Build a filter that runs on MODIFY and checks the Status (and $GROUP$ if some groups CAN modify) which issues an error message (i.e. You can't change this!). Be sure to name your filter in a way that separates it from the OOB filters, so you can keep it after an upgrade. HTH, Joel * Joel D. Sender Director of Western Operations QMX Support Services, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of SUBSCRIBE arslist Melissa Sent: Tuesday, March 04, 2008 3:34 PM To: arslist@ARSLIST.ORG Subject: Editing closed incidents ** Is there an easy way to stop the average user from editing an incident once the incident status is closed? ARS 7.01 ITSM 7.02 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARERR [302] Entry does not exist in database
Hi friends, Anybody knows how can I hide this message when I delete a record on database?? Is there any tip to do this? ARERR [302] Entry does not exist in database Thankx very much Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Callin' Goto Action (AL - Filter)
Anyone knows if can I call Goto Action from Active Link to a Filter?? (or from Filter to an Active Link)?? Thankx Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Action deffered in Filter/Active Link
Hi Carey, Thanks for attention, Here the details: For Possibility A) Run If: ( 'GRUPO_AUX1_CHAR' != $NULL$ ) AND ( 'GRUPO_AUX1_CHAR' !=) (Note: This is my vector of id's separated by ; that is incrementing by workflow according with loop) P.S.:In my workflow, Loop/Workflow finishes when this variable is equal NULL or . Push Fields If: $GRUPO_AUX3$ LIKE ( CRT + % ) (Note: This is my qualification for Push Fields Action, where, everytime that one determined field - $GRUPO_AUX3$ is started with CRT the record is created on another form) Tip: Between yesterday and today I thought in 2 possibilities... One: To do a variable that controls if a filter were or weren't created on loop (I think that is something like this that you're talkin' about)... Two: Call a Goto Action that calls an Active Link (this AL executes a Commit Changes Action and returns - Goto Action - to my Push Fields Filter everytime that loop is executed), But I don't know if will it execute... Well, For possibility 2 and 3 I also think that is less important than Possibility 1... Carey, with you or anybody else need Log Files tell me that I'll post here for you... Thankx for help... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Carey Matthew Black Enviada: qui 28/2/2008 10:03 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link Tadeu, You have found your problem. How to fix it depends on more details than you have disclosed so let me point out what I am fairly sure is the problem. A) The condition your using in your push action might need to change during the loop to get the results your after. And/OR B) The records your creating need to be more different to avoid an index on the target form And/Or C) The record your left with in the current transaction needs to be more different to avoid an index on the working form. (Assuming your if no match' = Create a new record) Condition 2 and 4 confirms that the Push If qualification your using does not match a record _initially_. But condition 3 indicates that it does match records that are created by the filter loop. So... For Possibility A) You may need to do an initial push (with the qualification) that you have, and use a different qualification for the 2nd through Nth loops through the vector of data. However you have not posted the qualifications/data details so it is impossible for me to give you advice on how you can make those alterations. For Possibility B) A record that the push action is making may be conflicting with a unique index on the target form. (Again it all depends on the exact data involved.) It might be that the first record is ok, but the second one is to much like the first. (Or something like that.) For Possibility C) It is possible that the workflow on the record that is spawing the target records is left in a state that violates an index on that record too. So after all of the looping is done, then the whole transaction is rolled back due to an inability to commit the spawing record to the DB. It is very hard to tell if B and/or C are the issue, but I seem them as definite possibilities. I really think A is your main problem. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 27, 2008 at 1:18 PM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: snip What I've noticed is that workflow behavior changes if I modify the opiton If Any Requests Match in my Filter that executes the Push Fields Action... Here are the occurrences: snip 2 - If I use Modify First Matching Request, the record is saved in my First form, but workflow is not completed... P.S.: I'm wishing to insert 3 records that are in a character field separated by blank space, and only the last record is created on my Second Form... Although, my Filter Guide Loop shows on log file that the Loop has been executed successfully (setting my auxiliar field with all the values of my vector*). Then, I've concluded that my Filter that creates a record on my Second Form is, on truth, modifying the record that was created in first run loop * vector - character field separated by blank space; 3 - If I use Modify All Matching Requests, I receive the following message: ARERR [382] The value(s) for this entry violate a unique index that has been defined for this form : User entry:003 4 - And finally, If I
RES: March 6 0CLA.RUG Meeting Reminder
One day I still will participate in a event like RUG... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Cindy Harrison Enviada: qui 28/2/2008 00:06 Para: arslist@ARSLIST.ORG Assunto: March 6 0CLA.RUG Meeting Reminder OCLA.RUG Members: Just one more week until the next OC.LA.RUG meeting! Our March 6 meeting will be held at Broadcom Corporation world headquarters in Irvine. The address for the office is: 5300 California Ave Irvine, Ca 92617 There is a guard shack at the entrance. Tell the guard that you are there for the OCLA Rug meeting. The conference room is called 'Doheney' and is located in building 2. The presenters for our upcoming meeting will be Alarmpoint Systems, Inc. AlarmPoint Systems, Inc provides automated event notification and resolution products and on-demand services to nearly 800 global organizations. The AlarmPoint products enable leading enterprises to reduce costs in IT operations while providing higher levels of service to business users. (Alarmpoint Systems Inc., Company. Retrieved January 29, 2008 from http://www.alarmpoint.com/?SID=company). Lunch and doorprizes to be provided! RSVP to [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Action deffered in Filter/Active Link
AND WHY EVERYTIME I CREATE RECORDS ON MY DESTINE FORM THROUGH 'PUSH FIELDS' ACTION, RECORD ON MY DESTINE FORM IS REPLACED (I.E. THE OLD RECORD IS DELETED AND MY ONLY NEW RECORD IS CREATED)??? Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 28/2/2008 10:48 Para: arslist@ARSLIST.ORG Assunto: RES: Action deffered in Filter/Active Link Hi Carey, Thanks for attention, Here the details: For Possibility A) Run If: ( 'GRUPO_AUX1_CHAR' != $NULL$ ) AND ( 'GRUPO_AUX1_CHAR' !=) (Note: This is my vector of id's separated by ; that is incrementing by workflow according with loop) P.S.:In my workflow, Loop/Workflow finishes when this variable is equal NULL or . Push Fields If: $GRUPO_AUX3$ LIKE ( CRT + % ) (Note: This is my qualification for Push Fields Action, where, everytime that one determined field - $GRUPO_AUX3$ is started with CRT the record is created on another form) Tip: Between yesterday and today I thought in 2 possibilities... One: To do a variable that controls if a filter were or weren't created on loop (I think that is something like this that you're talkin' about)... Two: Call a Goto Action that calls an Active Link (this AL executes a Commit Changes Action and returns - Goto Action - to my Push Fields Filter everytime that loop is executed), But I don't know if will it execute... Well, For possibility 2 and 3 I also think that is less important than Possibility 1... Carey, with you or anybody else need Log Files tell me that I'll post here for you... Thankx for help... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Carey Matthew Black Enviada: qui 28/2/2008 10:03 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link Tadeu, You have found your problem. How to fix it depends on more details than you have disclosed so let me point out what I am fairly sure is the problem. A) The condition your using in your push action might need to change during the loop to get the results your after. And/OR B) The records your creating need to be more different to avoid an index on the target form And/Or C) The record your left with in the current transaction needs to be more different to avoid an index on the working form. (Assuming your if no match' = Create a new record) Condition 2 and 4 confirms that the Push If qualification your using does not match a record _initially_. But condition 3 indicates that it does match records that are created by the filter loop. So... For Possibility A) You may need to do an initial push (with the qualification) that you have, and use a different qualification for the 2nd through Nth loops through the vector of data. However you have not posted the qualifications/data details so it is impossible for me to give you advice on how you can make those alterations. For Possibility B) A record that the push action is making may be conflicting with a unique index on the target form. (Again it all depends on the exact data involved.) It might be that the first record is ok, but the second one is to much like the first. (Or something like that.) For Possibility C) It is possible that the workflow on the record that is spawing the target records is left in a state that violates an index on that record too. So after all of the looping is done, then the whole transaction is rolled back due to an inability to commit the spawing record to the DB. It is very hard to tell if B and/or C are the issue, but I seem them as definite possibilities. I really think A is your main problem. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 27, 2008 at 1:18 PM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: snip What I've noticed is that workflow behavior changes if I modify the opiton If Any Requests Match in my Filter that executes the Push Fields Action... Here are the occurrences: snip 2 - If I use Modify First Matching Request, the record is saved in my First form, but workflow
RES: what does a push field do ?
Please put your full description for this AL or describe what your AL is really doing (workflow), and verify with your fields involved in it aren't really deleted by chance... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Remedy Maniac Enviada: qua 27/2/2008 06:50 Para: arslist@ARSLIST.ORG Assunto: what does a push field do ? dear listers, whenever I try to open one of the AL which contains a Push Field action, and I try to read the Push Field, I get a error message and I am not able to read what the Push field does because one or more fields have been deleted from the form ... I have a backup of the AL so I can read the following for that Push field action: action { push-field : [EMAIL PROTECTED] } My question is simple: what does all this mean? So TEST2 is my form and 536871161 one of the field. But what about the rest? Where to find the references? Thank you Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Migration from ARS 5.1.2 to 7.1
Hi Mário, We're finalizing our migration process .. At the moment, we tested only on Test Server ... We're migrating from [[ ARS 5.3, Oracle 9i, AIX 5.2 ]] to [[ ARS 7.0.01, Oracle 10g, AIX 5.3 ]] Firstly: we're separating our system... DB, OS and ARS (each one in each server) - Our first step was to create a new filesystem for new AIX 5.3 Server; - Second, we export only database filesystem from the old server to our new server (this new server is only for database); - Then, we did a copy of our database to our new server, and after, e did a restore at database... - Next Step: Install/config of ARS version 7.0.01 on its new server... - So, we import our def files that were updated; - Configuration of DNS, instance, etc... P.S.: you'll need to config var Lang to correct problems with special characters (i.e. ã, í, ç becomes ?) Then finally, test very well these We executed many test cases on our homologation/test server... Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Mario Roberto Porto Fº Enviada: ter 26/2/2008 19:54 Para: arslist@ARSLIST.ORG Assunto: Migration from ARS 5.1.2 to 7.1 ** Hi All, Is there anyone in the list who have migrated ARS from 5.1.2 directly to 7.1 ? I'd like to know if anybody faced any situation that requeries more atention or effort. In addition, i need to decide the best migration mode. i personally prefer the UPDATE mode using ar system installer. We did that when we migrated 4.5 to 5.1.2 and it was OK. The problem now envolves the migration of the OS ( AIX 4.3 to 5.2 ). Next, the script we are planning to do 1 - Copy ar system filesystem from AIX 4.3 to an AIX 5.2 machine 2 - Start ARS 5.1.2 on this new machine ( Is this really works ? ) 3 - Run installer on UPDATE mode Scenario From ARS 5.1.2 Patch 1389 AIX 4.3 , Oracle 9i To ARS 7.1 AIX 5.2, Oracle 10 Thanks Mário Roberto Porto Filho Analista de Tecnologia da Informação Tecnologia Bancária S/A (11) 4196-7883 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Action deffered in Filter/Active Link
Hi List.. Here we go again... I've seen the log file (arerror.log) as Dylan has suggested, but I didn't find any occurrence of errors about this... What I've noticed is that workflow behavior changes if I modify the opiton If Any Requests Match in my Filter that executes the Push Fields Action... Here are the occurrences: 1 - If I use Display 'Any Match' Error, then I receive the message below: ARERR [8029] One or more entries match filter conditions -- this operation has been defined so that any matches generate an error P.S.: Record is not saved (because is a Error Message), and consequently, workflow is not executed... 2 - If I use Modify First Matching Request, the record is saved in my First form, but workflow is not completed... P.S.: I'm wishing to insert 3 records that are in a character field separated by blank space, and only the last record is created on my Second Form... Although, my Filter Guide Loop shows on log file that the Loop has been executed successfully (setting my auxiliar field with all the values of my vector*). Then, I've concluded that my Filter that creates a record on my Second Form is, on truth, modifying the record that was created in first run loop * vector - character field separated by blank space; 3 - If I use Modify All Matching Requests, I receive the following message: ARERR [382] The value(s) for this entry violate a unique index that has been defined for this form : User entry:003 4 - And finally, If I use Take No Action, the workflow (Push Fields) is not executed... --- Can anyone help me ... I'll be very grateful... If anyone of you need the Filter Log File for one of these cases (1, 2, 3, 4) reply for me and I'll post them for you One more time, thanks a lot for any reply... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Wheeler, Dylan Enviada: ter 26/2/2008 18:48 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link It looks like there is another problem with your filter somewhere. It's not a problem with it deferring anymore, it looks like the qualification on SEC-Create_User_ARSLIST_FG`! is passing and it's trying to push right away, but it's not. I'd check your error log to see if there is an entry in there for something like incompatible data, data too long for a field, etc. - Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings Loan Association, F.A. Email: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, February 26, 2008 1:31 PM To: arslist@ARSLIST.ORG Subject: RES: Action deffered in Filter/Active Link it didn't resolve yet ... I changed the name ... I put `!, instead ´! This is my log: Checking SEC-Create_User_ARSLIST (502) FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo -- Passed -- perform actions FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo 0: Set Fields FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX2_INT (536870929) = 3000 FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo 1: Set Fields FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX3 (536870930) = CRT:Central_Atendimento FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo 2: Set Fields FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo GRUPO (536870920) = CRT:Administracao CRT:Central_Atendimento FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo 3: Set Fields FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX1_CHAR (536870928) = 3014; FLTR TID: 001543 RPC ID: 029866 Queue: Fast Client-RPC: 390620USER: Demo
Action deffered in Filter/Active Link
Good Morning for all of you... I'd like to know if can I do something like these: There is a Filter (or Active Link) that fires a sequency of 'Set Fields' action followed by a 'Push Fields' action, and after the workflow/object fires a 'Goto' action to redirect to another Filter... But I'm in trouble because the 'Goto' action is deffered... and, consequently, it isn't executed... By the way, it is executed, but only at the end of the Filter ... I would like that it ran on its real execution moment. My log file for this object looks like these: Checking SEC-Create_User_22-Fev_II (501) FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo -- Passed -- perform actions FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 0: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: DemoGRUPO_AUX2_INT (536870929) = 3006 FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 1: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX3 (536870930) = CRT:Adm_Risco FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 2: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO (536870920) = CRT:Adm_Risco FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 3: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX1_CHAR (536870928) = 3000;3014; FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 4: Push Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo deferred to phase 2 FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 5: Goto Action FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: DemoGoto Execution Order: 502 Thankx-in-advancE Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Action deffered in Filter/Active Link
Thank you, Gary... But it still doesn't help me.. My problem is that I would like to create one record (in other form) for each time that I read a value on my form... This iteration is done by 'Goto' Action... I have achieved to create only one record on my form2... with the last value read only (last iteration)... What can I do? My workflow is these: 1 - Set Fields (Get the first value from a list separated by ;) 2 - Push Fields (Creation of record in another form - form2) 3 - Goto (return to beginning of the workflow reading the next value from the list separated by ;) ... continue until my list separated by ; were NULL; Thankx again! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Opela, Gary L Contr OC-ALC/ITMA Enviada: ter 26/2/2008 10:16 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link Hey Augusto, have you tried forcing the filter to ignore phasing? You shouldn't have this problem with active links, as they are not processed in phases. If you suffix the name of the filter with `! then remedy will not phase that filter. For instance: HPD:Helpdesk-Filter would be HPD:Helpdesk-Filter`! For more information on this, you can read the Workflow Objects guide with version 7.x, or the Basic Guide (starting at page 576, pages 584 and 585 describe the naming convention mentioned above) with version 6.x. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, February 26, 2008 7:06 AM To: arslist@ARSLIST.ORG Subject: Action deffered in Filter/Active Link ** Good Morning for all of you... I'd like to know if can I do something like these: There is a Filter (or Active Link) that fires a sequency of 'Set Fields' action followed by a 'Push Fields' action, and after the workflow/object fires a 'Goto' action to redirect to another Filter... But I'm in trouble because the 'Goto' action is deffered... and, consequently, it isn't executed... By the way, it is executed, but only at the end of the Filter ... I would like that it ran on its real execution moment. My log file for this object looks like these: Checking SEC-Create_User_22-Fev_II (501) FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo -- Passed -- perform actions FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 0: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: DemoGRUPO_AUX2_INT (536870929) = 3006 FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 1: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX3 (536870930) = CRT:Adm_Risco FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 2: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO (536870920) = CRT:Adm_Risco FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 3: Set Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo GRUPO_AUX1_CHAR (536870928) = 3000;3014; FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 4: Push Fields FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo deferred to phase 2 FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: Demo 5: Goto Action FLTR TID: 001543 RPC ID: 024768 Queue: Fast Client-RPC: 390620USER: DemoGoto Execution Order: 502 Thankx-in-advancE Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
RES: Action deffered in Filter/Active Link
(536870929) = 3022 FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 1: Set Fields FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoGRUPO_AUX3 (536870930) = CRT:Docre_Cobranca FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 2: Set Fields FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoGRUPO (536870920) = CRT:Clube_De_Beneficios CRT:Central_Atendimento CRT:Docre_Cobranca FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 3: Set Fields FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoGRUPO_AUX1_CHAR (536870928) = Thanks for replies... Good afternoon! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Opela, Gary L Contr OC-ALC/ITMA Enviada: ter 26/2/2008 10:54 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link Interesting what you are experiencing there. It looks to me like you need to break your filter up into at least three others. I would suggest actions 1 - 3 be in one filter, the push fields be in another, and then the goto be in yet another filter action. If you are needing them to loop, just put them in a filter guide to cause them to loop, this might even allow you to avoid using the goto. Generally, gotos are not good to use if you can avoid them. If I understand what you are doing correctly, you would need the following: Filter 1: Set Field GRUPO_AUX2_INT (536870929) = 3006 Set Field GRUPO_AUX3 (536870930) = CRT:Adm_Risco Set Field GRUPO (536870920) = CRT:Adm_Risco Set Field GRUPO_AUX1_CHAR (536870928) = 3000;3014; Call Guide Guide: Filter 1: Push Field (might need to force phasing override with `! and this is assuming that you are parsing out the value which you are needing to push from GRUPO_AUX1_CHAR.) Filter 2: Set Field GRUPO_AUX1_CHAR = SUBSTRC($GRUPO_AUX1_CHAR$,(STRSTRC($GRUPO_AUX1_CHAR$, ;)+1)) Filter 3: IF GRUPO_AUX1_CHAR != ; AND GRUPO_AUX1_CHAR != $NULL$ Go to Guide Label START (Make sure you put this guide label in at the beginning of your guide) I hope I am understanding correctly what it is you are needing. If so, then the above should work, if not, then it probably won't :) Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, February 26, 2008 7:35 AM To: arslist@ARSLIST.ORG Subject: RES: Action deffered in Filter/Active Link Thank you, Gary... But it still doesn't help me.. My problem is that I would like to create one record (in other form) for each time that I read a value on my form... This iteration is done by 'Goto' Action... I have achieved to create only one record on my form2... with the last value read only (last iteration)... What can I do? My workflow is these: 1 - Set Fields (Get the first value from a list separated by ;) 2 - Push Fields (Creation of record in another form - form2) 3 - Goto (return to beginning of the workflow reading the next value from the list separated by ;) ... continue until my list separated by ; were NULL; Thankx again! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Opela, Gary L Contr OC-ALC/ITMA Enviada: ter 26/2/2008 10:16 Para: arslist@ARSLIST.ORG Assunto: Re: Action deffered in Filter/Active Link Hey Augusto, have you tried forcing the filter to ignore phasing? You shouldn't have this problem with active links, as they are not processed in phases. If you suffix the name of the filter with `! then remedy will not phase that filter. For instance: HPD:Helpdesk-Filter would be HPD:Helpdesk-Filter`! For more information on this, you can read the Workflow Objects guide
RES: Action deffered in Filter/Active Link
Analyst Principal IT Operations Downey Savings Loan Association, F.A. Email: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Tuesday, February 26, 2008 1:15 PM To: arslist@ARSLIST.ORG Subject: RES: Action deffered in Filter/Active Link Hi for all, again... I've tried to insert records to another form (Action: Push Fields, Filter: SEC-Create_User_ARSLIST_FG´! ), but my workflow always deffered on this... The rest of my workflow process is running succesfully... I've already tried to use others kind of logic ... Firstly, thank you so much for all of you that tried to help me before... Here's my workflow objects details and below my log generate on execution: Any suggestions out there? Workflow Objects: - SEC-Create_User_22-Fev_I (Execution Order 500)- Act on User Form ... Get the value from $GroupList$ field. (i.e. 3000;3001;3002) - SEC-Create_User_FG (Execution Order 501)- Call Guide Action (SEC-FILTER_GUIDE) - SEC-Create_User_ARSLIST (Execution Order 502)- Set Fields Action to get the String value of $GroupList$ returned in SEC-Create_User_22-Fev_I Filter - SEC-Create_User_ARSLIST_FG´!(Execution Order 503)- Push Fields Action - to input data where I want to create one record per loop (i.e. if $GroupList$ = 3000;3001;3002, it will create 3 new records) - SEC-Create_User_ARSLIST2_FG´! (Execution Order 504)- Go To Guide Label Action - goes to my RESTART Label - SEC-FILTER_GUIDE - Label: 1 - RESTART; Filters in Guide: 2 - SEC-Create_User_ARSLIST; 3 - SEC-Create_User_ARSLIST; 4 - SEC-Create_User_ARSLIST_FG´! Checking SEC-Create_User_22-Fev_I (500) FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo -- Passed -- perform actions FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 0: Notify FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demodeferred to phase 3 FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 1: Push Fields FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demodeferred to phase 2 FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo /* Tue Feb 26 2008 17:14:04.3710 */ End of filter processing (phase 1) FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo /* Tue Feb 26 2008 17:14:04.4086 */ Restart of filter processing (phase 2) FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo /* Tue Feb 26 2008 17:14:04.4091 */1: Push Fields FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demodeferred from filter SEC-Create_User_22-Fev_I FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoCriado Por (2) = Demo FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoDepartamento (8) = CRT - Central de Atendimento FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoEndereco Correio (103) = test_user FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoFull Name (536870915) = test_user FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoGRUPO_AUX1_CHAR (536870928) = 3014;3000;3022; FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoLogin (101) = test_user FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoNome (536870916) = test_user FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: DemoTelefone (536870917) = (41)2107- FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo /* Tue Feb 26 2008 17:14:04.4107 */Start filter processing -- Operation - CREATE FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo DC-Func_22-Fev - NULL FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo Checking SEC-Create_User_FG (501) FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo -- Passed -- perform actions FLTR TID: 001543 RPC ID: 029308 Queue: Fast Client-RPC: 390620USER: Demo 0: Call Guide FLTR TID
RES: How to copy the content of the field 112 into another field?
Hi Mark, Tell me about your problem... Are you trying to pick up the real names of the Group List field and put them to another field? If yes, I think that I can help you... (I did some like this last week) In the beginning I was in trouble with this problem too... My another field was receiving ID's from Groups of my Group List (Like these: 3000;3001;3002...)... Is it something like these that are happening with you?? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Rick Ponzo Enviada: seg 25/2/2008 10:31 Para: arslist@ARSLIST.ORG Assunto: Re: How to copy the content of the field 112 into another field? Hi Mark, One way is to have a filter pull the Group Name from the Group Form into a hidden field whenever the Assignee Group field is changed. Set this filter to execute AFTER the filter that copies the Group Name into the diary field. Set the diary field to pick up the name from this new field instead of the Assignee Group field when there is a change in Assignee Group. I know there are other ways to do this...but this works for me every time. Rick Ponzo Mark Milke wrote: Hello! I'm still using ARS 6.3. Is there a way to copy the groups names visible in the User Tool into another Tool via Workflow or do I really have to start a bunch of queries to the DB to figure out the Group name behind the ID? The backgroud of my question is: I have a regular form, where the user is allowed to set the Assignee Group field manually, i.e. via the attached menu. When he changes the value however, I have to put the old Assignee Group string into the Diary field. I was trying to do this with a filter, but I have a bunch of IDs instead of the real group names... Thanks in advance for your suggestions. Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: RES: How to copy the content of the field 112 into another field?
I did something like this: I read the value of Group List and put them to another field of another form... (Push Fields Action) Then I created one Filter that works on these field (with another two auxiliar fields)... The values that came from User form are separate by ; Then I have created a Set Fields Action (using functions like STRSTR, SUBSTR,...) that read the value until the ; charactere... and share this value on another auxiliar field (field zzTmpGroup, for example) ... Then I get the value of zzTmpGroup and, with this, I can get the Group Name value from the Group Form... For each value read, one id is deleted from id's list (field that received id's separated by ;)... These procedure is repeated until my first field (that received id's from Group List separated by ;) is NULL... This loop is executed by Go To Action (this action call itself) ... []Regards[] Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Mark Milke Enviada: seg 25/2/2008 12:17 Para: arslist@ARSLIST.ORG Assunto: Re: RES: How to copy the content of the field 112 into another field? Hi Tadeu, Are you trying to pick up the real names of the Group List field and put them to another field? Yes. But would prefer not to ask the Group form Group-ID after Group- ID what the group name is. I hope there is another solutions for this. Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Working with Group / GroupList / GroupID
Good Evening for all... I'd like to know if there is a possibility that I use a 'Set Field' or 'Push Field' action on this case: First, let's consider that I work with only one value on 'Group List' field (Form User).. I've created a Filter that work like this: Form Name: User Run If: 'Group List' != $NULL$ If Action: Push Field - Server Name: Current Server - Push Value To: MY_FORM -- Push Field If: ( $Request ID$ != 'Entry-Id') AND ( 'Entry-Id' = $NULL$ ) -- Fields: 'GROUP' = $Group List$ P.S. // Entry-Id and GROUP are from MY_FORM form. Well, what's happenin' ??? My field 'GROUP' (on MY_FORM form) is receiving the ID from the Group that was in $Group List$ field from Form User... I'd like to know if there is a choice that I put the Group Name of these ID in my field 'GROUP' (on MY_FORM form)? What have I done?? I have done an Active Link that makes a 'Set Field' action like this: Form Name: MY_FORM Run If: 'GROUP' != $NULL$ If Action: Set Fields - Server Name: Current Server - Read Value for Field From: Group -- Set Field If: 'Group ID' = $GROUP$ -- Fields: GROUP = $Group Name$ P.S. // Where: // - GROUP is from MY_FORM form; // - 'Group ID' and $Group Name$ are from Group form (Form of AR System) But this isn't running... I received the following message: ARERR [313] Data types are not appropriate for relational operation The preceding message occurred during the execution of active link MY_FORM -- action 1. (ARNOTE 1101) Can anybody help me??? I'm avaiable for question and answers... Thankx a lot in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Installing AR Filter Scripting Plug-in for JAVA
Hello ARS List, I have a big problem in my company, I'm trying to use this plugin (AR Filter Scripting Plug-in for Java) but I didn't know how to install these pulg-in... I'm only a developer, and the Administrator Staff of my company don't know how to do this too... =( I really need to do this... I need to receive a String with values to be comming to ARS from a Java App... Has anyone some manual about this plug-in's installation ??? I've already know how to use this plug-in in my application ... I only wanna see it in action ... running ... Thanks for all... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Installing AR Filter Scripting Plug-in for JAVA
I'm sorry list... I'm using.. AR Server - 7.0.01 patch 004 Operating System - AIX 5.3 Database - Oracle 10g Plug-in: AR System Scripting Plug-In for Java (Version 7.0) - file: arfjavascr[1]Unix.tar http://www.bmcdn.ws/jiveProd/bsdnDownload.jspa?categoryID=507externalID=992attachID=89593 De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 7/2/2008 11:01 Para: arslist@ARSLIST.ORG Assunto: Installing AR Filter Scripting Plug-in for JAVA ** Hello ARS List, I have a big problem in my company, I'm trying to use this plugin (AR Filter Scripting Plug-in for Java) but I didn't know how to install these pulg-in... I'm only a developer, and the Administrator Staff of my company don't know how to do this too... =( I really need to do this... I need to receive a String with values to be comming to ARS from a Java App... Has anyone some manual about this plug-in's installation ??? I've already know how to use this plug-in in my application ... I only wanna see it in action ... running ... Thanks for all... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Flashboards 6.3 - Compatibility
** ** Hello listeners... After Carnival in Brazil I have a doubt about Flashboards Compatibility... rs We're migrating our ARS Systems now... Does it cause some problems if I upgrade my AR Server (and client tools like AR User, AR Alert) from version 5.01 to 7.0.01 without upgrade my Flashboards - currently my Flashboards version is 6.3. I saw one Matrix Compatibility that seemed that I can't use Flashboards 6.3 with ARS (Server) 7.x ... Is it really true?? P.S.: It's stranger because we updated our system (Server and Client Tools) and the Flashboards doesn't showed nothing wrong... Thanks-in-Advance! Old Environment AR Server - 5.01.02 patch 1463 Operating System - AIX 5.1 Database - Oracle 9i New Environment AR Server - 7.0.01 patch 004 Operating System - AIX 5.3 Database - Oracle 10g Tadeu Augusto Dutra Pinto - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Mid-Tier - The following error(s) occurred while trying to process your request
Thanx Fred, But where Can I set authentication LDAP ?? How can I do it? Thanks a lot in advance! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Grooms, Frederick W Enviada: qua 23/1/2008 18:47 Para: arslist@ARSLIST.ORG Assunto: Re: Mid-Tier - The following error(s) occurred while trying to process your request ** So you created the user and then tried to log in as that new user... Do you have Active Directory (LDAP) authentication turned on? If so you have to remember that not having a password in Remedy is the trigger to go and authenticate the user with LDAP. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Wednesday, January 23, 2008 2:12 PM To: arslist@ARSLIST.ORG Subject: Mid-Tier - The following error(s) occurred while trying to process your request ** Hi people! I created a new User (accessing User form through AR User or even Mid-Tier). Like these: - Login Name: user_test - Group List: Administrator (and someone another group) - License Type: Read - Full Text License Type: None P.S.: The user doesn't have password. The screen show a information message (Note): Request number_xxx was successfully created (ARNOTE 9504). -- Until here it's alright. User created! But, when I try to access Mid-Tier through 'Login Page' the browser shows a message error. The following error(s) occurred while trying to process your request: ARERR [612] No such user is registered with this server Why Is this happening?? I'm using: Remedy AR Server 7.0.01 Patch 4 Remedy AR User 7.0.00 Patch 1 Remedy Mid-Tier 6.3 Operating System: AIX 5.3 Database Oracle 10g Thankx a lot Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Mid-Tier - The following error(s) occurred while trying to process your request
Hi people! I created a new User (accessing User form through AR User or even Mid-Tier). Like these: - Login Name: user_test - Group List: Administrator (and someone another group) - License Type: Read - Full Text License Type: None P.S.: The user doesn't have password. The screen show a information message (Note): Request number_xxx was successfully created (ARNOTE 9504). -- Until here it's alright. User created! But, when I try to access Mid-Tier through 'Login Page' the browser shows a message error. The following error(s) occurred while trying to process your request: ARERR [612] No such user is registered with this server Why Is this happening?? I'm using: Remedy AR Server 7.0.01 Patch 4 Remedy AR User 7.0.00 Patch 1 Remedy Mid-Tier 6.3 Operating System: AIX 5.3 Database Oracle 10g Thankx a lot Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Mid-Tier Performance Configuration
Hi-4-All Currently, my ARS Applications (5.1 and 7.0.01) are basicly accessed by AR User tool (5.1 and 7.0.01)... Now I'm trying to configure my Mid-Tier (6.3) to access my Forms. What happened is that in the Mid-Tier my access to the forms is very very slow... Is There how to configure better the Mid-Tier?? I wish that the access for Forms in Mid-Tier become quickly like I'm accessing by Remedy User tool... Thanx-in-advance! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Server Configuration Recommendations
Hi, I have a question about this subject... How can I measure the memory consumption of my environment production??? It's through ARS logs? Database logs? Or exist a specify tool for this?? Thanks-4-All! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Craig Carter Enviada: ter 15/1/2008 16:18 Para: arslist@ARSLIST.ORG Assunto: Re: Server Configuration Recommendations Thanks Misi. I've already read the whitepaper and verified all the normal stuff and our network guys verified the connection should be 1GB so I'm leaning towards bad code at this point. I'll check out your guide and start digging through the logs. Craig Carter -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Tuesday, January 15, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Server Configuration Recommendations Hi Craig, I would suggest looking at your applications and how they are designed before throwing more money at your hardware. As suggested, the API+SQL+FLTR+ESCL-logs will show where your server is spending it's energy. It may be a few really bad select-statements that fail to utilize your indexes, but it can just as well be a lot of semi-bad-statements. It is often easy to fix, but may sometimes require significant redesign of your applications. You will find a few key things to look for in the performance tuning presentation I did at UKRUG in 2006: http://rrr.se/doc/rrrukrug2006.pdf 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. We've ran over 600 concurrent users on a 2x1.4 GHz with 1 GB of memory without any issues. And that's a system with millions of tickets and over 50,000 emails sent each day on only 20 fast, 20 list, plus some private threads. We have two of these so one doesn't normally carry that load, but it has at times. So I don't think it's the size of your server. Ordinarily I would suggest you split the database out onto its own server. But given how big your current hardware is, and how small your current user base is, I see no need for that just yet. You seem to have plenty of hardware for that size of a system. I would use something like BMC Log Analyzer to analyze your API and SQL logs from a slowdown. That will tell you if you've got long running SQL or API calls, if you have little or no idle time on some threads (queuing), etc. It's available on the BMCDN last time I checked. I believe Misi has a log analysis tool as well at www.rrr.se http://www.rrr.se/ , but I haven't used it myself. If you see that your API calls are big, and your SQL calls are big, you've got a problem with your database. In that case, look at database metrics or hardware metrics to see if you have disk contention problems. Once we tuned our AR Server almost all of our bottlenecks were in the database, and mainly with disk contention. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Tuesday, January 15, 2008 8:41 AM To: arslist@ARSLIST.ORG Subject: Q: Server Configuration Recommendations All, We're running into some performance problems recently. I upgraded the server a few days ago (operating system, database, CPUs, memory, queues, etc, and it hasn't helped much. Basically, it takes longer to search and create tickets as more and more people log in (as expected) but the server has plenty of available CPU, plenty of memory, and plenty of bandwidth so it appears there is a bottleneck somewhere. 8 CPUs 16GB Memory Windows Server 2003 Enterprise SQL Server 2005 Enterprise ARS v7.0.1 P5 (CSS and custom apps-no ITSM) 24 Fast, 40 List It flies with about 40 people, becomes sluggish with 80, and gets real slow with 100. I would expect this system to be able to handle a much larger load. Since the running CPU usage and disk usage is fairly low, I'm looking for advice. Everything is currently installed on the same server and on the same drive (although these are raid drives). Is it possible we're seeing contention over disk resources and I/O? Any advice on determining where the bottleneck
RES: Archive's Names on Object List
Thank you, Misi! Regards! Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de Misi Mladoniczky Enviada: seg 14/1/2008 07:06 Para: arslist@ARSLIST.ORG Assunto: Re: Archive's Names on Object List Hi, Have you defined any name Aliases in the View Properties of the original form? These has probably been copied over to the Arvhive form, resulting in duplicate names. The object list should then show duplicates of your XYZ:Test-name. 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. Hi-4-All I have a doubt about Archives... That's it.. I've already created my Archive Form ... Tested it ... and it's alright... ok ... However, when I'm going to access my Archive Form, I can't see my the names of my forms correctly on Object List window... For example: If I have two forms: XYZ:Test and XYZ:Test_ARCHIVE. When I open my Object List window ... I see these two forms with the same name at list (XYZ:Test). Why my Archive Form doesn't appear with its Original name?? (XYZ:Test_ARCHIVE) It can be strange for the system's operators... Thanx-in-advancE Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Question: ITSM 7.0 - Business Hours
Hi T. Dee, I was interested in your application's workflow... My company, has a case seemed with that... but here, it doesn't work with holidays and weekend... I was thinking about to do Active Links/Filters to control my weekend based in seconds... But I don't know if its a good idea... I'd like to know if you can explain more about your system's workflow... What kind of form are you using... How do you control weekend/holidays in your application?? Do you created a separate form to control your holidays/weekend ? How can I implement this logic in my application?? Att, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. De: Action Request System discussion list(ARSList) em nome de T. Dee Enviada: sex 11/1/2008 17:17 Para: arslist@ARSLIST.ORG Assunto: Question: ITSM 7.0 - Business Hours I'm using ITSM 7.0 suite - I want to take a date/time field and add it to a number (integer field) to determine my new date/time based on business hours / holidays. For example - hours are monday to friday 9am to 5pm (closed on weekends and holidays) Date: 01/14/08 Added 72 (hours) - makes it 01/17/08 I'm looking at Buoyant Solutions for some help the Form 'Business Time Workdays', but that does not exist in ITSM 7.0. Would I use 'Business Time Segment' instead? THANKS! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Archive's Names on Object List
Hi-4-All I have a doubt about Archives... That's it.. I've already created my Archive Form ... Tested it ... and it's alright... ok ... However, when I'm going to access my Archive Form, I can't see my the names of my forms correctly on Object List window... For example: If I have two forms: XYZ:Test and XYZ:Test_ARCHIVE. When I open my Object List window ... I see these two forms with the same name at list (XYZ:Test). Why my Archive Form doesn't appear with its Original name?? (XYZ:Test_ARCHIVE) It can be strange for the system's operators... Thanx-in-advancE Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Delete Records of Alert Events
Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
RES: Delete Records of Alert Events
Complementing... I'm using: ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS 7.0.00 Patch 001 - Operation System: Windows XP Database: Oracle 9i De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 10/1/2008 10:59 Para: arslist@ARSLIST.ORG Assunto: Delete Records of Alert Events ** Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are