Re: Creating view form - only data type decimal and int visible
Mark, Spot on! I worked on it last night where I identified this issue. Thanks, Terje From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Walters, Mark [mark_walt...@bmc.com] Sent: 19 September 2011 16:16 To: arslist@ARSLIST.ORG Subject: Re: Creating view form - only data type decimal and int visible ** Unicode AR server? If so, then the columns in the table will need to be nchar and so on. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue Sent: 19 September 2011 15:32 To: arslist@ARSLIST.ORG Subject: Creating view form - only data type decimal and int visible ** I am having some problems creating simple view form on MS SQL 2005. When I load the table only data type decimal and integer are available. Columns of Char, Text are not accessible. I have tried to connect to a few other tables and only data types decimal and integer are visible. I am connecting as database owner. This is not remote. The table holds plenty of columns. Where only data type int and decimal is visible in Developer Studio. Any tips? ARS 7.6.04, Windows Server 2008, MS SQL 2005. ~ Terje _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Software load balancer with AR Server and Mistier
Thanks Ken. We have search all articles and also went through documentation related to this. [We found that in 7.6.04 Midtier there are few additional configuration parameters available in which may not require stickiness to be set on load balancer. I have not tried those options yet though.] We have finalized on crossroads after careful review of all three. I will post my comments once we complete our testing. On Tue, Sep 20, 2011 at 7:10 AM, Cecil, Ken kce...@hubbell.com wrote: ** I have not done any testing but do recall seeing several Mistier related BMC knowledge base articles where the cause of the issues were related to Load Balancer use and settings like stickiness. Make sure you do a search on the support sight for load balancer and review them… ** ** Ken Cecil Hubbell Incorporated ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *debug ars *Sent:* Monday, September 19, 2011 5:56 AM *To:* arslist@ARSLIST.ORG *Subject:* Software load balancer with AR Server and Midtier ** ** ** We are exploring various options to setup our test environment in server group with load balancer. Does anyone tried to use software load balancer for AR Server Group and Midtier? If yes, can you share details like, which software, version, configuration parameters like stickiness, timeout etc? [We have identified three with which we will be experimenting - crossroads, balanceAG and haproxy] -- Cheers Amen _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses.www.Hubbell.com - Hubbell Incorporated** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Cheers DA -- On seventh day almighty started debugging ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: SDE versus ARS
As far as the revenue figure is concerned, we are a government installation. We will have about 370 end users, 4-6 help desk personnel and one admin. To answer one other comment out there, we have been in discussion with the BMC sales team from day one and they are the ones that recommended SDE from a budget standpoint. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Cecil, Ken Sent: Monday, September 19, 2011 11:02 PM To: arslist@ARSLIST.ORG Subject: Re: SDE versus ARS If you don't mind, what size is the company? (users, annual revenue)... I have often wondered what size company it takes to make ARS feasible without having to skimp too much and cut too many corners. It would be interesting to see some sort of Gartner like report on typical how much money companies are spending per user supported on ITSM related apps. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Spangler Robert C CIV USSTRATCOM/JWAC Sent: Wednesday, September 14, 2011 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: SDE versus ARS There was a 3 month window where we moved from version 4.5 (Yes you are reading the version correctly) to 7.6. The admin that was working 4.5 was a little :-) resistant to move to a new version. Right after we went live, there was a budget reduction and a RIF. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Wednesday, September 14, 2011 4:33 PM To: arslist@ARSLIST.ORG Subject: Re: SDE versus ARS ** Robert, Am I reading this right that you were in production less than a year before the decision was made to move away from the full suite? Can you share how long it took to get into production? It sounds like a very short lived implementation. Jason On Wed, Sep 14, 2011 at 1:29 PM, Spangler Robert C CIV USSTRATCOM/JWAC rspan...@jwac.mil wrote: Thanks for all the info. We only have one external integration, no import/update jobs, no tables that have been exported and very few reports and no reporting server. All of our end users are using the web interface at this point. We only have 3 support people that are using the UT. We are basically only using ARS as a ticketing and assets management platform. We haven't been live long enough to get involved in Change, SRM and some of the other modules we wanted to use. Yes, we have to migrate the data. We have had ARS version 7.5 up for almost one year at this point and management has told us that with our budget restrictions we can no longer afford ARS, no matter how long it takes to migrate. We have to find a new, read less expensive, solution. Given that we still have maintenance, we can get issues resolved in ARS while we work to identify, purchase and stand up a new system. SDE was one option for us. I have also looked at some of the other players in the help desk arena along with open source solutions. It sounds like it will be no easy task, but I figure at this point there is no easy solution out there. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William H. Du Chene Sent: Wednesday, September 14, 2011 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: SDE versus ARS ** I have worked with both of them over the years and have a fair amount of experience with both products. There are a number of things that you should know and prepare for. I guess the first question is going to be: how deep down the rabbit hole do you want to go? Do you have any external integrations which make use of your ARSystem database? Do you have any import/update jobs (or the like) that make use of DTS/SSIS (or similar technology) which update records directly? Do you have any tables that have been exported for use in your database (with vendor forms) from external sources? Do you have a significant number of reports that query the database for data, or are you using a reporting server? Have you developed any applications which use the API to process data - outside of the normal workflow (active link, filter, guide) paradigm? And the big question: Are you planning on migrating your existing data? Depending on how you have your installation set up and what your requirements are, a migration may well be a nightmare. If you switch platforms, the glaringly obvious stuff would be that all of your reports have to change, you'll have to recreate all of your user accounts (or your integration to the LDAP/AD), any packages for moving and updating data that your DBA might have set up, any custom views, database objects (SPs, UDFs), or API
WWRUG Twitter tag
If you are interested in following the tweets for WWRUG11 the hashtag is #wwrug. There are a number if people tweeting. Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Software load balancer with AR Server and Mistier
I believe you still need session persistence with the mid-tier in 7.6. You do not (and have not really) required session persistence with the ARServer. A whitepaper available for 7.6 details this. The timeout on the load balancer needs to match or exceed the session timeout of your mid-tier application. If you are using a single sign on solution the mid-tier session timeout needs to be less than or equal to the SSO session timeout. So this would be a valid combination: Mid-tier Session Timeout: 60 minutes SSO Session Timeout: 120 minutes Load Balancer Session Persistence Expiration: 60 minutes In order for a J2EE application to not require session persistence a number of things have to be in place: - all objects in the container must be serializable - the container nodes in the farm must be configured as a cluster (session information must be serialized) There are some things that make me believe this is not possible with the midtier. Some information that is session specific is written to disk. I doubt these can be properly replicated between the J2EE containers. Axton On Tue, Sep 20, 2011 at 4:53 AM, debug ars debug@gmail.com wrote: ** Thanks Ken. We have search all articles and also went through documentation related to this. [We found that in 7.6.04 Midtier there are few additional configuration parameters available in which may not require stickiness to be set on load balancer. I have not tried those options yet though.] We have finalized on crossroads after careful review of all three. I will post my comments once we complete our testing. On Tue, Sep 20, 2011 at 7:10 AM, Cecil, Ken kce...@hubbell.com wrote: ** I have not done any testing but do recall seeing several Mistier related BMC knowledge base articles where the cause of the issues were related to Load Balancer use and settings like stickiness. Make sure you do a search on the support sight for load balancer and review them… ** ** Ken Cecil Hubbell Incorporated ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *debug ars *Sent:* Monday, September 19, 2011 5:56 AM *To:* arslist@ARSLIST.ORG *Subject:* Software load balancer with AR Server and Midtier ** ** ** We are exploring various options to setup our test environment in server group with load balancer. Does anyone tried to use software load balancer for AR Server Group and Midtier? If yes, can you share details like, which software, version, configuration parameters like stickiness, timeout etc? [We have identified three with which we will be experimenting - crossroads, balanceAG and haproxy] -- Cheers Amen _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses.www.Hubbell.com - Hubbell Incorporated** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Cheers DA -- On seventh day almighty started debugging _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Software load balancer with AR Server and Mistier
How can I get a copy of the whitepaper? Thanks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, September 20, 2011 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: Software load balancer with AR Server and Mistier ** I believe you still need session persistence with the mid-tier in 7.6. You do not (and have not really) required session persistence with the ARServer. A whitepaper available for 7.6 details this. The timeout on the load balancer needs to match or exceed the session timeout of your mid-tier application. If you are using a single sign on solution the mid-tier session timeout needs to be less than or equal to the SSO session timeout. So this would be a valid combination: Mid-tier Session Timeout: 60 minutes SSO Session Timeout: 120 minutes Load Balancer Session Persistence Expiration: 60 minutes In order for a J2EE application to not require session persistence a number of things have to be in place: - all objects in the container must be serializable - the container nodes in the farm must be configured as a cluster (session information must be serialized) There are some things that make me believe this is not possible with the midtier. Some information that is session specific is written to disk. I doubt these can be properly replicated between the J2EE containers. Axton On Tue, Sep 20, 2011 at 4:53 AM, debug ars debug@gmail.commailto:debug@gmail.com wrote: ** Thanks Ken. We have search all articles and also went through documentation related to this. [We found that in 7.6.04 Midtier there are few additional configuration parameters available in which may not require stickiness to be set on load balancer. I have not tried those options yet though.] We have finalized on crossroads after careful review of all three. I will post my comments once we complete our testing. On Tue, Sep 20, 2011 at 7:10 AM, Cecil, Ken kce...@hubbell.commailto:kce...@hubbell.com wrote: ** I have not done any testing but do recall seeing several Mistier related BMC knowledge base articles where the cause of the issues were related to Load Balancer use and settings like stickiness. Make sure you do a search on the support sight for load balancer and review them... Ken Cecil Hubbell Incorporated From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of debug ars Sent: Monday, September 19, 2011 5:56 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Software load balancer with AR Server and Midtier ** We are exploring various options to setup our test environment in server group with load balancer. Does anyone tried to use software load balancer for AR Server Group and Midtier? If yes, can you share details like, which software, version, configuration parameters like stickiness, timeout etc? [We have identified three with which we will be experimenting - crossroads, balanceAG and haproxy] -- Cheers Amen _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.comhttp://www.Hubbell.com - Hubbell Incorporated** _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ -- Cheers DA -- On seventh day almighty started debugging _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Blocking Users from PRD Server for Testing After Upgrade
Hi All: ARS 7.1 SQL2005 Win2003 on VMWare Virtual Environment We’re doing a PRD upgrade next week (ARS 7.1 to 7.6.04 SP1) and we’d like to block users from connecting while we perform some testing of custom apps. Problem is – we can’t leave the AR Server in Admin mode because we need users from specific Assignee Groups to perform the tests. I’m throwing the question at our network and security admins – but thought I’d ask the ARSLIST group the question first. Any insight into the best way to blocks all but a specific group of test users? Thanks, Trez Moreland Remedy Administrator Maryland Department of Information Technology ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Software load balancer with AR Server and Mistier
http://documents.bmc.com/supportu/documents/61/98/186198/186198.pdf The information is a bit vague in regards to load balancer configuration in front of the midtier/web servers, but note that in the whitepaper, everywhere it says that session persistence is not required, it refers to it as the load balancer between the midtier and arservers or in front of the arservers. The release notes make the following statement: http://documents.bmc.com/supportu/documents/43/74/184374/184374.pdf New load balancer configuration options If your AR System uses a hardware load balancer between the mid tier servers and AR System servers, BMC recommends configuring that load balancer without using a sticky bit by using the Connection Settings page in the BMC Remedy Mid Tier Configuration tool. Note that it does not state to turn it off for the load balancer in front of the mid-tier. You might be able to get away without setting up session persistence with the later versions of the midtier since the API does not have a native library dependency (assuming they implemented the serializable interface for all the non-native session specific things), but there is extra configuration you need to do with your J2EE container. For Tomcat, see here: http://tomcat.apache.org/tomcat-6.0-doc/cluster-howto.html To run session replication in your Tomcat 6.0 container, the following steps should be completed: - All your session attributes must implement java.io.Serializable - Uncomment the Cluster element in server.xml - If you have defined custom cluster valves, make sure you have the ReplicationValve defined as well under the Cluster element in server.xml - If your Tomcat instances are running on the same machine, make sure the tcpListenPort attribute is unique for each instance, in most cases Tomcat is smart enough to resolve this on it's own by autodetecting available ports in the range 4000-4100 - Make sure your web.xml has the distributable/ element - If you are using mod_jk, make sure that jvmRoute attribute is set at your Engine Engine name=Catalina jvmRoute=node01 and that the jvmRoute attribute value matches your worker name in workers.properties - Make sure that all nodes have the same time and sync with NTP service! - Make sure that your loadbalancer is configured for sticky session mode. So even with Tomcat cluster configurations the load balancer must have session persistence. I imagine the strategy with the above statements is to support a session moving from one node to another node in the event a node fails, not to simply allow any random request to go to any node. Again, the J2EE container cluster configuration may or may not work. I can't find anything stating experimentation either way. Axton On Tue, Sep 20, 2011 at 9:21 AM, Richard Copits richard@bwc.state.oh.us wrote: ** How can I get a copy of the whitepaper? Thanks. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Axton *Sent:* Tuesday, September 20, 2011 10:18 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Software load balancer with AR Server and Mistier ** ** ** I believe you still need session persistence with the mid-tier in 7.6. You do not (and have not really) required session persistence with the ARServer. A whitepaper available for 7.6 details this. ** ** The timeout on the load balancer needs to match or exceed the session timeout of your mid-tier application. If you are using a single sign on solution the mid-tier session timeout needs to be less than or equal to the SSO session timeout. ** ** So this would be a valid combination: Mid-tier Session Timeout: 60 minutes SSO Session Timeout: 120 minutes Load Balancer Session Persistence Expiration: 60 minutes ** ** In order for a J2EE application to not require session persistence a number of things have to be in place: - all objects in the container must be serializable - the container nodes in the farm must be configured as a cluster (session information must be serialized) ** ** There are some things that make me believe this is not possible with the midtier. Some information that is session specific is written to disk. I doubt these can be properly replicated between the J2EE containers. ** ** Axton ** ** On Tue, Sep 20, 2011 at 4:53 AM, debug ars debug@gmail.com wrote:*** * ** Thanks Ken. We have search all articles and also went through documentation related to this. [We found that in 7.6.04 Midtier there are few additional configuration parameters available in which may not require stickiness to be set on load balancer. I have not tried those options yet though.] We have finalized on crossroads after careful review of all three. I will post my comments once we complete our testing. ** ** On Tue, Sep 20, 2011 at 7:10 AM, Cecil, Ken kce...@hubbell.com wrote:*** * ** I have not done
Re: Blocking Users from PRD Server for Testing After Upgrade
If you are using AREA authentication (where you leave the password in Remedy blank) you can simply put in a dummy password in Remedy for the users you don't want to have access. When you want them to have access just remove the password in Remedy and it will use the AREA authentication to authenticate against your LDAP (Active Directory) server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Trez Moreland Sent: Tuesday, September 20, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Blocking Users from PRD Server for Testing After Upgrade Hi All: ARS 7.1 SQL2005 Win2003 on VMWare Virtual Environment Were doing a PRD upgrade next week (ARS 7.1 to 7.6.04 SP1) and wed like to block users from connecting while we perform some testing of custom apps. Problem is we cant leave the AR Server in Admin mode because we need users from specific Assignee Groups to perform the tests. Im throwing the question at our network and security admins but thought Id ask the ARSLIST group the question first. Any insight into the best way to blocks all but a specific group of test users? Thanks, Trez Moreland Remedy Administrator Maryland Department of Information Technology ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Triger a Filter using an Active link.
Hi All, we want to provide the end user search access where they can search for user info like phone no. email add etc.. I have created a view form of CTM:People form and added the required fields. I also want to add Manager's email address. When the user searches the form it will will populate manager's login name and with that login name i want to search the people form again and populate managers email id in display only field on the view form.. I tried the interval option on the active link to re-fire it after 3sec it works fine but only on user client but not on web.. Could any one suggest me how I can achieve it on web too.. any better development suggestion would help.. Is it possible to triger a setfield action using a filter which can be triggered by an active link so that it will work on mid tier too .. Thank You .. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Triger a Filter using an Active link.
You can use the Service action in an Active Link to trigger the firing of Filters. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Adarsh Padwalkar Sent: Tuesday, September 20, 2011 10:30 AM To: arslist@ARSLIST.ORG Subject: Triger a Filter using an Active link. Hi All, we want to provide the end user search access where they can search for user info like phone no. email add etc.. I have created a view form of CTM:People form and added the required fields. I also want to add Manager's email address. When the user searches the form it will will populate manager's login name and with that login name i want to search the people form again and populate managers email id in display only field on the view form.. I tried the interval option on the active link to re-fire it after 3sec it works fine but only on user client but not on web.. Could any one suggest me how I can achieve it on web too.. any better development suggestion would help.. Is it possible to triger a setfield action using a filter which can be triggered by an active link so that it will work on mid tier too .. Thank You .. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: ITSM 7.6.4 Developer Studio and the Class Manager and Field IDs
I added my fields to the CMDB Core forms via the class manager. I ran the Sync via the Application Console and the fields are still not moving over with the correct field ID. Does it matter if I give them my own ID when I put them on the AST form? They have the correct ID on the CMDB form. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: Monday, September 19, 2011 6:24 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.4 Developer Studio and the Class Manager and Field IDs If your adding custom fields to the CMDB core forms via the class manager, are you manually adding these same fields to the AST forms via the developer studio? If so, your doing it wrong. Your suppose to use the Sync feature which moves the fields from the CMDB classes to the AST classes for you. When adding fields manually to a form, you can change the default value to pretty much any value you want. Once you save though, you can't change the ID. Sent from my iPhone On Sep 19, 2011, at 2:47 PM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: When I added a field to the Asset forms/CMDB via the Class Manager in the old 6.3.0 version and then added the field to my Join Form, it kept the field ID I gave it - 95000. When I add a field to the Asset forms/CMDB via the Class Manager in the ITSM 7.6.4 version and then add the field to my Join Form, it gives it a generic field ID like - 536870919. I am adding the fields to the BMC.CORE:BMC_ComputerSystem form via the Class Manager and then adding the fields to the AST:ComputerSystem via the Developer Suite. Is there a way to keep my numbers rather than the generic ones? It makes reporting and developing much easier. Thank you! Claire ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Triger a Filter using an Active link.
If you're running ARS 7.5/7.6, the active link service action calls filters with the execute on set to Service. Jason Sent from iPhone On Sep 20, 2011, at 11:29 AM, Adarsh Padwalkar adarsh.padwal...@gmail.com wrote: Hi All, we want to provide the end user search access where they can search for user info like phone no. email add etc.. I have created a view form of CTM:People form and added the required fields. I also want to add Manager's email address. When the user searches the form it will will populate manager's login name and with that login name i want to search the people form again and populate managers email id in display only field on the view form.. I tried the interval option on the active link to re-fire it after 3sec it works fine but only on user client but not on web.. Could any one suggest me how I can achieve it on web too.. any better development suggestion would help.. Is it possible to triger a setfield action using a filter which can be triggered by an active link so that it will work on mid tier too .. Thank You .. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Software load balancer with AR Server and Mistier
Great! Thank you! From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, September 20, 2011 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Software load balancer with AR Server and Mistier ** http://documents.bmc.com/supportu/documents/61/98/186198/186198.pdf The information is a bit vague in regards to load balancer configuration in front of the midtier/web servers, but note that in the whitepaper, everywhere it says that session persistence is not required, it refers to it as the load balancer between the midtier and arservers or in front of the arservers. The release notes make the following statement: http://documents.bmc.com/supportu/documents/43/74/184374/184374.pdf New load balancer configuration options If your AR System uses a hardware load balancer between the mid tier servers and AR System servers, BMC recommends configuring that load balancer without using a sticky bit by using the Connection Settings page in the BMC Remedy Mid Tier Configuration tool. Note that it does not state to turn it off for the load balancer in front of the mid-tier. You might be able to get away without setting up session persistence with the later versions of the midtier since the API does not have a native library dependency (assuming they implemented the serializable interface for all the non-native session specific things), but there is extra configuration you need to do with your J2EE container. For Tomcat, see here: http://tomcat.apache.org/tomcat-6.0-doc/cluster-howto.html To run session replication in your Tomcat 6.0 container, the following steps should be completed: - All your session attributes must implement java.io.Serializable - Uncomment the Cluster element in server.xml - If you have defined custom cluster valves, make sure you have the ReplicationValve defined as well under the Cluster element in server.xml - If your Tomcat instances are running on the same machine, make sure the tcpListenPort attribute is unique for each instance, in most cases Tomcat is smart enough to resolve this on it's own by autodetecting available ports in the range 4000-4100 - Make sure your web.xml has the distributable/ element - If you are using mod_jk, make sure that jvmRoute attribute is set at your Engine Engine name=Catalina jvmRoute=node01 and that the jvmRoute attribute value matches your worker name in workers.properties - Make sure that all nodes have the same time and sync with NTP service! - Make sure that your loadbalancer is configured for sticky session mode. So even with Tomcat cluster configurations the load balancer must have session persistence. I imagine the strategy with the above statements is to support a session moving from one node to another node in the event a node fails, not to simply allow any random request to go to any node. Again, the J2EE container cluster configuration may or may not work. I can't find anything stating experimentation either way. Axton On Tue, Sep 20, 2011 at 9:21 AM, Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us wrote: ** How can I get a copy of the whitepaper? Thanks. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, September 20, 2011 10:18 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Software load balancer with AR Server and Mistier ** I believe you still need session persistence with the mid-tier in 7.6. You do not (and have not really) required session persistence with the ARServer. A whitepaper available for 7.6 details this. The timeout on the load balancer needs to match or exceed the session timeout of your mid-tier application. If you are using a single sign on solution the mid-tier session timeout needs to be less than or equal to the SSO session timeout. So this would be a valid combination: Mid-tier Session Timeout: 60 minutes SSO Session Timeout: 120 minutes Load Balancer Session Persistence Expiration: 60 minutes In order for a J2EE application to not require session persistence a number of things have to be in place: - all objects in the container must be serializable - the container nodes in the farm must be configured as a cluster (session information must be serialized) There are some things that make me believe this is not possible with the midtier. Some information that is session specific is written to disk. I doubt these can be properly replicated between the J2EE containers. Axton On Tue, Sep 20, 2011 at 4:53 AM, debug ars debug@gmail.commailto:debug@gmail.com wrote: ** Thanks Ken. We have search all articles and also went through documentation related to this. [We found that in 7.6.04 Midtier there are few additional configuration parameters available in which may not require stickiness to be set on load balancer. I have not tried those options yet though.] We have finalized
Mid Tier problems with AIE service
Hi, I'm running an ARS 7.6.04 as well Atrium CMDB suite with AIE 7.6.04 on Windows 2003, all services are running with local admin. rights. My mid tier is running on Fedora 15, there is no firewalls between these servers. The problem I have is this: Everytime I try and stop an AIE instance using the Mid Tier service, I get the following error message (I can stop the services via the user tool): A failure occurred in the process used by the Set Fields action. (ARERR 9281) The Mid Tier log provide me the following (in debug mode): Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: url=http://192.168.44.14:8080/arsys/BackChannel/?param=493%2FServerRunProcess%2F1%2F013%2F192.168.44.1031%2FEIE%3ACD-I_StopInstanceClicked-301%2F31%2F09%2F46006010315%2F3%2F2%2F-12%2F-63%2F-2826%2F3%2F4%2Froot13%2F192.168.44.100%2F11%2F3%2F1%2F41%2F41%2F046%2F4%2F9%2F4600601279%2F5368709719%2F5369400999%2F300034200275%2F4%2F71%2FANDERS-43B3B635%2CARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001%3B120%2FObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi%2BT1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl%2BK5DtFZ9se7hz9Q3VVO7yQ%3D%3D15%2FANDERS-43B3B63554%2FARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_00114%2F4%2F1%2F41%2F41%2F41%2F4 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : cookie=G=9069ca78e7450a28:5f829c38:1328616dd62:-8000; JSESSIONID=E397D8E127191DCCA4050909AD909461; P=1; st=5400; lt=60; GKW=%7B14%3A%7Bn%3A%22LASTID%22%2Ct%3A6%2Cv%3A%22026%22%7D%2C15%3A%7Bn%3A%22LASTCOUNT%22%2Ct%3A7%2Cv%3A1%7D%7D; wARRoot1316539478899=1; T=1 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: SessionID=E397D8E127191DCCA4050909AD909461 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.PERFORMANCE) : Backchannel start: ServerRunProcess Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : -- ServerRunProcess Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mWindowId=0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mServer=192.168.44.10 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mAlName=EIE:CD-I_StopInstanceClicked-30 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mActIdx=3 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mTs=0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFid=460060103 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordIds=-1,-6,-28 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordVals=root,192.168.44.10, Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordTypes=4,4,0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldIds=460060127,536870971,536940099,300034200 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldVals=ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001;,ObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi+T1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl+K5DtFZ9se7hz9Q3VVO7yQ==,ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldTypes=4,4,4,4 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.PERFORMANCE) : API executeprocess time = 34 Sep 20, 2011 7:59:58 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/013/192.168.44.1031/EIE:CD-I_StopInstanceClicked-301/31/09/46006010315/3/2/-12/-63/-2826/3/4/root13/192.168.44.100/11/3/1/41/41/046/4/9/4600601279/5368709719/5369400999/300034200275/4/71/ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001;120/ObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi+T1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl+K5DtFZ9se7hz9Q3VVO7yQ==15/ANDERS-43B3B63554/ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_00114/4/1/41/41/41/4 = ARERR [9281] A failure occurred in the process used by the Set Fields action. at com.remedy.arsys.backchannel.ServerRunProcessAgent.process(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.processRequest(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXServerRunProcess.init(Unknown Source) at com.remedy.arsys.backchannel.ServerRunProcessAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at
Re: Blocking Users from PRD Server for Testing After Upgrade
Depending on the size of your testing group it may be quicker to use Frederick's idea but in reverse... In other words disable the LDAP authentication altogether and give the test users a local remedy password. Ken -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, September 20, 2011 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: Blocking Users from PRD Server for Testing After Upgrade If you are using AREA authentication (where you leave the password in Remedy blank) you can simply put in a dummy password in Remedy for the users you don't want to have access. When you want them to have access just remove the password in Remedy and it will use the AREA authentication to authenticate against your LDAP (Active Directory) server. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Trez Moreland Sent: Tuesday, September 20, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Blocking Users from PRD Server for Testing After Upgrade Hi All: ARS 7.1 SQL2005 Win2003 on VMWare Virtual Environment Were doing a PRD upgrade next week (ARS 7.1 to 7.6.04 SP1) and wed like to block users from connecting while we perform some testing of custom apps. Problem is we cant leave the AR Server in Admin mode because we need users from specific Assignee Groups to perform the tests. Im throwing the question at our network and security admins but thought Id ask the ARSLIST group the question first. Any insight into the best way to blocks all but a specific group of test users? Thanks, Trez Moreland Remedy Administrator Maryland Department of Information Technology ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Triger a Filter using an Active link.
Can't you do this with an active link using the Window Loaded execute on condition. Then have an active link that does the set field? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Adarsh Padwalkar Sent: Tuesday, September 20, 2011 11:30 AM To: arslist@ARSLIST.ORG Subject: Triger a Filter using an Active link. Hi All, we want to provide the end user search access where they can search for user info like phone no. email add etc.. I have created a view form of CTM:People form and added the required fields. I also want to add Manager's email address. When the user searches the form it will will populate manager's login name and with that login name i want to search the people form again and populate managers email id in display only field on the view form.. I tried the interval option on the active link to re-fire it after 3sec it works fine but only on user client but not on web.. Could any one suggest me how I can achieve it on web too.. any better development suggestion would help.. Is it possible to triger a setfield action using a filter which can be triggered by an active link so that it will work on mid tier too .. Thank You .. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Mid Tier problems with AIE service
Turn on the arfork, filter, and client side active link logs. They will tell you more. Basically you have a set fields action in a piece of workflow that runs a server side process. That process is not returning the expected exit code, hence the error. Log it when you receive the error through the midtier, get the logs; do the same through the user tool and collect the logs. Compare the server side process that is executed and see what's different between the two. Axton Grams On Tue, Sep 20, 2011 at 1:10 PM, Anders Lauri olleba...@gmail.com wrote: Hi, I'm running an ARS 7.6.04 as well Atrium CMDB suite with AIE 7.6.04 on Windows 2003, all services are running with local admin. rights. My mid tier is running on Fedora 15, there is no firewalls between these servers. The problem I have is this: Everytime I try and stop an AIE instance using the Mid Tier service, I get the following error message (I can stop the services via the user tool): A failure occurred in the process used by the Set Fields action. (ARERR 9281) The Mid Tier log provide me the following (in debug mode): Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: url= http://192.168.44.14:8080/arsys/BackChannel/?param=493%2FServerRunProcess%2F1%2F013%2F192.168.44.1031%2FEIE%3ACD-I_StopInstanceClicked-301%2F31%2F09%2F46006010315%2F3%2F2%2F-12%2F-63%2F-2826%2F3%2F4%2Froot13%2F192.168.44.100%2F11%2F3%2F1%2F41%2F41%2F046%2F4%2F9%2F4600601279%2F5368709719%2F5369400999%2F300034200275%2F4%2F71%2FANDERS-43B3B635%2CARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001%3B120%2FObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi%2BT1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl%2BK5DtFZ9se7hz9Q3VVO7yQ%3D%3D15%2FANDERS-43B3B63554%2FARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_00114%2F4%2F1%2F41%2F41%2F41%2F4 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : cookie=G=9069ca78e7450a28:5f829c38:1328616dd62:-8000; JSESSIONID=E397D8E127191DCCA4050909AD909461; P=1; st=5400; lt=60; GKW=%7B14%3A%7Bn%3A%22LASTID%22%2Ct%3A6%2Cv%3A%22026%22%7D%2C15%3A%7Bn%3A%22LASTCOUNT%22%2Ct%3A7%2Cv%3A1%7D%7D; wARRoot1316539478899=1; T=1 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: SessionID=E397D8E127191DCCA4050909AD909461 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.PERFORMANCE) : Backchannel start: ServerRunProcess Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : -- ServerRunProcess Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mWindowId=0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mServer=192.168.44.10 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mAlName=EIE:CD-I_StopInstanceClicked-30 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mActIdx=3 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mTs=0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFid=460060103 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordIds=-1,-6,-28 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordVals=root,192.168.44.10, Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mKeywordTypes=4,4,0 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldIds=460060127,536870971,536940099,300034200 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldVals=ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001;,ObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi+T1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl+K5DtFZ9se7hz9Q3VVO7yQ==,ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.SERVLET) : mFieldTypes=4,4,4,4 Sep 20, 2011 7:59:58 PM - FINE (com.remedy.log.PERFORMANCE) : API executeprocess time = 34 Sep 20, 2011 7:59:58 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/013/192.168.44.1031/EIE:CD-I_StopInstanceClicked-301/31/09/46006010315/3/2/-12/-63/-2826/3/4/root13/ 192.168.44.100/11/3/1/41/41/046/4/9/4600601279/5368709719/5369400999/300034200275/4/71/ANDERS-43B3B635,ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_001;120/ObcagHlFW5rt1nu6tAk5XCZExFvZ5HUqKz3tdB1P3rmA4Mgi+T1vKheA9k8dDINrTEQSkY6AmVDp2eH3xCyg1EYPw0z3TnNl+K5DtFZ9se7hz9Q3VVO7yQ==15/ANDERS-43B3B63554/ARS_ANDERS-43B3B635(5000)_EIE_ANDERS-43B3B635_Inst_00114/4/1/41/41/41/4 = ARERR [9281] A failure occurred in the process used by the Set Fields action. at com.remedy.arsys.backchannel.ServerRunProcessAgent.process(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.processRequest(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXServerRunProcess.init(Unknown Source) at com.remedy.arsys.backchannel.ServerRunProcessAgent.init(Unknown Source) at
can I have a table field with a temp dataset?
I'm not sure how to put a succinct title on this...I'll try to explain I want 2 tables on a display form with add and remove buttons where I can: 1. Add item 1 from Table A to Table B, but then also remove from Table A so it does not show up as an available selection again - since user just added it. 2. Remove item 1 from Table B and add back to Table A. At the end of the Add / Remove process then I will process that data in Table B. I can get 90% for what I'm looking for using real forms associated with the tables, however in this design the issue I have is that all the original available selections are always listed- I do not really want to delete the record from Table A only hide it from selection view again. So far it looks like I can only associate a table to a form and I'm not able to add custom columns to the table outside of that form. This is so easy to do in .Net with temp datasets :-( Currently, I'm thinking the only way I can do this is if I append to an External qualification for Table A - where not like items in table B. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ /prefont face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.brpre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Mid Tier problems with AIE service
Thanks for the reply, what type of information should I be looking for? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Error encountered while executing a Web Service : ; nested exception is: java.net.ConnectException: A remote host refused an attempted connect operation. (ARERR 9130)
Please help, The firewall team sees no traffic being dropped or even getting to to firewall. Port 8080 is open, i'm able to telnet 8080 (the firewall team see that traffic) Server port mapped 59200. URL: http://test1:8080/schange/webservices?wsdl When I authenticate local and run the above url, able to mapping in browser, but on the dev studio on reload .. I don't see this. UNIX 6.1 ARS 7.5 P4 ORA 10g MT 7.4 P4 Websphere 6.1 Java 1.5 arjavaplugin.log 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:85) - NSPush (32) 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(register00) 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:472) - register 'soapenv' - 'http://www.w3.org/2003/05/soap-envelope' 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(register00) 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:472) - register 'xsd' - 'http://www.w3.org/2001/XMLSchema' 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:85) - NSPush (32) 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(register00) 2011-09-20 16:29:05,000 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:472) - register 'xsi' - 'http://www.w3.org/2001/XMLSchema-instance' 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:85) - NSPush (32) 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(startElem00) 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:1098) - Start element [http://www.w3.org/2003/05/soap-envelope]:Envelope 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(startElem00) 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:1098) - Start element [http://www.w3.org/2003/05/soap-envelope]:Body 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:85) - NSPush (32) 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(endElem00) 2011-09-20 16:29:05,001 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:1208) - End element soapenv:Body 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:119) - NSPop (32) 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(endElem00) 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:1208) - End element soapenv:Envelope 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(empty00) 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:113) - NSPop (empty) 2011-09-20 16:29:05,002 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(addBody00) 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.message.SOAPBody (SOAPBody.java:168) - Adding body element to message... 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(addBody00) 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.message.SOAPBody (SOAPBody.java:168) - Adding body element to message... 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.i18n.ProjectResourceBundle (ProjectResourceBundle.java:72) - org.apache.axis.i18n.resource::handleGetObject(register00) 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.encoding.SerializationContext (SerializationContext.java:472) - register 'soapenv' - 'http://schemas.xmlsoap.org/soap/envelope/' 2011-09-20 16:29:05,003 DEBUG [pool-2-thread-3] org.apache.axis.utils.NSStack (NSStack.java:85) - NSPush (32) 2011-09-20
Re: can I have a table field with a temp dataset?
Andrew, This is actually easier than you think, see below. The key is to reverse your thinking about how a LIKE operator could be used. Read through the entire setup before focusing too hard on the qualifications. Also, you may want to add other clauses to your qualfications, such as a check on a status field. Real life example: : ( 'Status' = Enabled) AND ( $RequestedList$ LIKE (( %; + 'Request ID') + ;% )) FIELDS: Button: Add Button: Remove - Temp char field: tmp_SelectedList - Table A - list of options Column: col_A_ID Qualification: NOT(tmp_SelectedList LIKE %; + col_A_SelectedID + ;%) - Table B - list of selected options Column: col_B_ID Qualification: tmp_SelectedList LIKE %; + col_B_SelectedID + ;% WORKFLOW Active link: Add Fire on Click of Add button or double click on Table A: Action 1: set tmp_SelectedList = tmp_SelectedList + ; + col_A_ID + ; (note: this adds the selected record to the list, including delimiters) Action 2: Call TableRefreshGuide - Active link: Remove Fire on Click of Remove button or double click on Table B: Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,col_B_Selected_ID,) (note: this removes the selected record from the list) - ActiveLink Guide: RefreshTableGuide ActiveLink (put in guide): RefreshTable Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,;;,;) (note: this gets rid of double semi-colons) Action 2: Refresh Table A Action 3: Refresh table B Action x: anything else you want done on a table refresh, perhaps updating count indicators. - Hopefully that helps, Thad Esser Remedy Developer On Tue, Sep 20, 2011 at 1:54 PM, Andrew C Goodall ago...@jcpenney.comwrote: ** I’m not sure how to put a succinct title on this…I’ll try to explain ** ** I want 2 tables on a display form with “add” and “remove” buttons where I can: ** ** 1. Add item 1 from Table A to Table B, but then also remove from Table A so it does not show up as an available selection again – since user just added it. 2. Remove item 1 from Table B and add back to Table A. ** ** At the end of the Add / Remove process then I will process that data in Table B. ** ** I can get 90% for what I’m looking for using real forms associated with the tables, however in this design the issue I have is that all the original available selections are always listed– I do not really want to delete the record from Table A only hide it from selection view again. ** ** So far it looks like I can only associate a table to a form and I’m not able to add custom columns to the table outside of that form. ** ** This is so easy to do in .Net with temp datasets L Currently, I’m thinking the only way I can do this is if I append to an External qualification for Table A - where not like items in table B. ** ** ** ** Regards, *Andrew Goodall* Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ ** ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: can I have a table field with a temp dataset?
Thanks so much - I'll read over your example. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Tuesday, September 20, 2011 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: can I have a table field with a temp dataset? ** Andrew, This is actually easier than you think, see below. The key is to reverse your thinking about how a LIKE operator could be used. Read through the entire setup before focusing too hard on the qualifications. Also, you may want to add other clauses to your qualfications, such as a check on a status field. Real life example: : ( 'Status' = Enabled) AND ( $RequestedList$ LIKE (( %; + 'Request ID') + ;% )) FIELDS: Button: Add Button: Remove - Temp char field: tmp_SelectedList - Table A - list of options Column: col_A_ID Qualification: NOT(tmp_SelectedList LIKE %; + col_A_SelectedID + ;%) - Table B - list of selected options Column: col_B_ID Qualification: tmp_SelectedList LIKE %; + col_B_SelectedID + ;% WORKFLOW Active link: Add Fire on Click of Add button or double click on Table A: Action 1: set tmp_SelectedList = tmp_SelectedList + ; + col_A_ID + ; (note: this adds the selected record to the list, including delimiters) Action 2: Call TableRefreshGuide - Active link: Remove Fire on Click of Remove button or double click on Table B: Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,col_B_Selected_ID,) (note: this removes the selected record from the list) - ActiveLink Guide: RefreshTableGuide ActiveLink (put in guide): RefreshTable Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,;;,;) (note: this gets rid of double semi-colons) Action 2: Refresh Table A Action 3: Refresh table B Action x: anything else you want done on a table refresh, perhaps updating count indicators. - Hopefully that helps, Thad Esser Remedy Developer On Tue, Sep 20, 2011 at 1:54 PM, Andrew C Goodall ago...@jcpenney.com wrote: ** I'm not sure how to put a succinct title on this...I'll try to explain I want 2 tables on a display form with add and remove buttons where I can: 1. Add item 1 from Table A to Table B, but then also remove from Table A so it does not show up as an available selection again - since user just added it. 2. Remove item 1 from Table B and add back to Table A. At the end of the Add / Remove process then I will process that data in Table B. I can get 90% for what I'm looking for using real forms associated with the tables, however in this design the issue I have is that all the original available selections are always listed- I do not really want to delete the record from Table A only hide it from selection view again. So far it looks like I can only associate a table to a form and I'm not able to add custom columns to the table outside of that form. This is so easy to do in .Net with temp datasets :-( Currently, I'm thinking the only way I can do this is if I append to an External qualification for Table A - where not like items in table B. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG11 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: can I have a table field with a temp dataset?
Andrew, I forgot to mention - Table A and Table B both use the same underlying form for their data. No temporary dataset/form is needed. Thad On Tue, Sep 20, 2011 at 2:50 PM, Thad Esser thad.es...@gmail.com wrote: Andrew, This is actually easier than you think, see below. The key is to reverse your thinking about how a LIKE operator could be used. Read through the entire setup before focusing too hard on the qualifications. Also, you may want to add other clauses to your qualfications, such as a check on a status field. Real life example: : ( 'Status' = Enabled) AND ( $RequestedList$ LIKE (( %; + 'Request ID') + ;% )) FIELDS: Button: Add Button: Remove - Temp char field: tmp_SelectedList - Table A - list of options Column: col_A_ID Qualification: NOT(tmp_SelectedList LIKE %; + col_A_SelectedID + ;%) - Table B - list of selected options Column: col_B_ID Qualification: tmp_SelectedList LIKE %; + col_B_SelectedID + ;% WORKFLOW Active link: Add Fire on Click of Add button or double click on Table A: Action 1: set tmp_SelectedList = tmp_SelectedList + ; + col_A_ID + ; (note: this adds the selected record to the list, including delimiters) Action 2: Call TableRefreshGuide - Active link: Remove Fire on Click of Remove button or double click on Table B: Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,col_B_Selected_ID,) (note: this removes the selected record from the list) - ActiveLink Guide: RefreshTableGuide ActiveLink (put in guide): RefreshTable Action 1: set tmp_SelectedList = REPLACE(tmp_SelectedList,;;,;) (note: this gets rid of double semi-colons) Action 2: Refresh Table A Action 3: Refresh table B Action x: anything else you want done on a table refresh, perhaps updating count indicators. - Hopefully that helps, Thad Esser Remedy Developer On Tue, Sep 20, 2011 at 1:54 PM, Andrew C Goodall ago...@jcpenney.comwrote: ** I’m not sure how to put a succinct title on this…I’ll try to explain ** ** I want 2 tables on a display form with “add” and “remove” buttons where I can: ** ** 1. Add item 1 from Table A to Table B, but then also remove from Table A so it does not show up as an available selection again – since user just added it. 2. Remove item 1 from Table B and add back to Table A. ** ** At the end of the Add / Remove process then I will process that data in Table B. ** ** I can get 90% for what I’m looking for using real forms associated with the tables, however in this design the issue I have is that all the original available selections are always listed– I do not really want to delete the record from Table A only hide it from selection view again. ** ** So far it looks like I can only associate a table to a form and I’m not able to add custom columns to the table outside of that form. ** ** This is so easy to do in .Net with temp datasets L Currently, I’m thinking the only way I can do this is if I append to an External qualification for Table A - where not like items in table B. ** ** ** ** Regards, *Andrew Goodall* Software Engineer 2 | Development Services | jcpenney . www.jcp.com http://www.jcp.com/ ** ** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: can I have a table field with a temp dataset?
Your idea sounds like it would work. Alternatively, when adding an item to B you could do a push fields and set a flag field on the original A item source record. Then refresh A. Your qualification for table A would exclude items where the flag is set. -Original message- From: Andrew C Goodall ago...@jcpenney.com To: arslist@ARSLIST.ORG Sent: Tue, Sep 20, 2011 20:54:04 GMT+00:00 Subject: can I have a table field with a temp dataset? *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Release Notice: Seamless Technologies HP uCMDB Integration to BMC Atrium CMDB
Seamless is releasing their *BMC atrium CMDB and HP uCMDB Peer Data Pump™* AKA, HP uCMDB to BMC Atrium CMDB connector”. The integration and product is based on the Seamless Universal Data Pump Platform using API’s and multithreaded technology. It provides synchronization of the CIs, CI attributes and relationships between the HP Universal Configuration Management Database (UCMDB) and BMC Atrium CMDB systems. The cross platform integration enables exciting end-to-end use cases for Service Impact Management using BMC’s BEM/SIM/PNET/BPPM and HP’s OMi, NMI software. For service desks, this evolutionary product allows a new level of integration for service management environments which are shared between different organizations *cloud*; providing real-time visibility and traceability from IT operations (Service Desk, Asset Mgt, Change Mgt, BSM, CLM, Service Impact Management, App Release Mgt, DevOps, ALM etc). This integration product shows *ROI value 45 minutes after installation*, and is easy to implement. Best of all, as with all of the Seamless products www.seamlessti.com/products.htmlhttp://www.seamlessti.com/products.html, it runs in real-time (gates on reconciliation), comes with a preconfigured mapping, transformation, normalization, and a GUI for fast changes, so your CMDB/CMS data is accurate, across all operational service management systems. Product supports customers who are on BMC Remedy ITSMv7, Force, SaaS ITSM 7.x+ and CMDB 7.x/2.x+ customers and HP Universal CMDB 7.x. For more information, please email emel...@seamlessti.commailto:emel...@seamlessti.com, or see us at *our booth at BMC Remedy user-group RUG this week in Washington* DC Event https://communities.bmc.com/communities/message/187051 : wwRUG11 in Washington DC for more information. Or reach out to us at sa...@seamlessti.commailto:sa...@seamlessti.com or www.seamlessti.comhttp://www.seamlessti.com +1 703.232.1552 CONFIDENTIALITY NOTICE: This email communication is intended only for the personal and confidential use of the recipient(s) designated above and may contain information which is subject to Federal and/or State privacy laws. In the event that you are not the intended recipient or the agent of the intended recipient, you are hereby notified that any review, disclosure, or use of the information contained herein is strictly prohibited. Do not copy or use the information contained within this communication, or allow it to be read, copied or utilized in any manner by any other person(s). If you have received this communication in error, please notify the sender immediately, either by response e-mail or by phone, and permanently delete the original e-mail, any attachment(s), and copies. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Inquiry - Performance Metrics External Presentation Layers
I've asked BMC for some references, white papers, etc about the following scenario - and have not received much of a response as of yet, so I'll ask the people that know :) I have a customer that has created a 'web content' (read presentation layer / portal) that allows them to create, query and update incidents. This portal simply consumes the Web Services for doing this. While this is quite functional - they do have some performance concerns - while the times they are experiencing are 'acceptable' - they feel they can be improved, and thus have reached out to see what we can find out. So, does anyone else have created their own portal, and have utilized Web Services, or native Java API, etc..?? What are your experiences, etc?? Are there any pros/cons of web-services over java api? Next - does anyone have any performance statistics they can share with regards to Incident Create, Incident Query and Incident Modify web-services? To be fare with my fellow friends here - below are some of the numbers the customer is currently experiencing... The system(s) are well tuned and architected, load balanced and separated traffic across segments, it is ARS7.5 and Oracle for your reference... Search Incident - 4.7 Sec (see results list) View Incident - 10.9 Sec Update Incident without attachment - 11.5 Sec Submit Incident without attachment - 20.4 Sec Submit Incident with 3MB attachment - 25.4 Sec So honestly - these numbers do not appear all that bad - but they are asking for comparisons - so I figured I'd ask :) Thanks - and hope everyone is have a great time at RUG (wish I could have attended this year to ask this question in person) Robert Molenda robert_mole...@infosys.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Mid Tier problems with AIE service
I don't see the ARERR 9281 in the logs provided. On Tue, Sep 20, 2011 at 4:36 PM, Anders Lauri olleba...@gmail.com wrote: Hi, I have attached a log below, this me merely navigating into AIE console and trying to stop an AIE instance via Mid Tier. What I can see from, my very new pair of eyes, is an ARERR early and a couple of Failed qualification, is there anything here that you could say Ah this might be it!? Anyway, very greatful for any help. Thanks, Anders ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
User Tool Script Error
Hi, Has anyone encountered the following script error when using the Remedy 7.6 User Tool? Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are Outlook.jpg