Re: Pushing data from character field to date field
You need to write a filter and update through DIRECT SQL, I have this experience with one of my API. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick Sent: Tuesday, March 26, 2013 3:00 AM To: arslist@ARSLIST.ORG Subject: Pushing data from character field to date field Hi all, We have third party application were the data comes to remedy stating form and the date/time will be captured in character field. When the datas are moved to main form the date are showing different. Ex. Staging form Character field . Date/Time field - mm/dd/ When the data is moved to main form it take dd as mm and mm as dd. Help me on this Our server timing is in Australia time zone Sent from my iPhone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Pushing data from character field to date field
Hi. It does not have to be that complicated... If the only problem is a swap of mm and dd, a simple FLTR Set-Fields should suffice. Insert this action before you use the data in what I presume is a Push-Fields action to the DateTime-field. Set-Fields: CharField = SUBSTR($CharField$, 3, 4) + / + SUBSTR($CharField$, 0, 1) + / + SUBSTR($CharField$, 6) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. You need to write a filter and update through DIRECT SQL, I have this experience with one of my API. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick Sent: Tuesday, March 26, 2013 3:00 AM To: arslist@ARSLIST.ORG Subject: Pushing data from character field to date field Hi all, We have third party application were the data comes to remedy stating form and the date/time will be captured in character field. When the datas are moved to main form the date are showing different. Ex. Staging form Character field . Date/Time field - mm/dd/ When the data is moved to main form it take dd as mm and mm as dd. Help me on this Our server timing is in Australia time zone Sent from my iPhone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Error while uploading Foundation Data (ver8.1.00)
Hi Carl, I used all short names for Pentaho Plugin (in ar.cfg, pluginsvr_config.xml, armonitor.cfg) and still getting the same error. Please mention if I missed something. Also, I noticed following error in javaplugin.log: 2013-03-26 03:06:27,641 ERROR [pool-4-thread-3] com.bmc.arsys.pdi.ardbc.ARPentahoPlugin (?:?) - Error while creating an entry on form UDM:Execution *org.apache.commons.httpclient.NoHttpResponseException: The server server-name with FQDN failed to respond * at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1835) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.pentaho.di.cluster.SlaveServer.sendXML(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstanceForJob(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.sendObjectToCarteServer(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstance(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.execute(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.execute(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createEntry(Unknown Source) at com.bmc.arsys.pluginsvr.plugins.a.ArdbcCreate(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcCreate_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcCreate_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) *Thanks and Regards,* *Abhishek Gupta* ** ** On Mon, Mar 25, 2013 at 9:33 PM, Carl Wilson carlbwil...@gmail.com wrote: ** Hi, Looks like you have a mixture of short name and FQDN in the configuration. This generally confuses the plugin server. Check the configuration in the AR config file and in the plugin server configuration and ensure that all references to the server for the Pentaho Plugin are the same (generally short name with no domain information) e.g. CIDCSWDREMAPP3. ** ** -- Kind Regards, *Carl Wilson* * * http://www.missingpiecessoftware.com/ ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Abhishek Gupta *Sent:* 25 March 2013 15:05 *To:* arslist@ARSLIST.ORG *Subject:* Re: Error while uploading Foundation Data (ver8.1.00) ** ** ** arcarte.log entries: INFO 25-03 03:27:24,718 - Carte - Created listener for webserver @ address : CIDCSWDREMAPP3:2 arjavaplugin.log entries: 2013-03-25 03:27:39,912 WARN [pool-4-thread-5] com.bmc.arsys.pluginsvr.d.b (?:?) - INFO: Java plug-in server has initialized plug-ins for all 5 core threads. The server is ready to receive RPC calls. 2013-03-25 03:50:06,116 ERROR [pool-4-thread-4] com.bmc.arsys.pdi.ardbc.ARPentahoPlugin (?:?) - Error while creating an entry on form UDM:Execution org.apache.commons.httpclient.NoHttpResponseException: The server CIDCSWDREMAPP3.ced.corp.cummins.comhttp://cidcswdremapp3.ced.corp.cummins.com/failed to respond at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1835) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.pentaho.di.cluster.SlaveServer.sendXML(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstanceForJob(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.sendObjectToCarteServer(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstance(Unknown Source) at
Re: Error while uploading Foundation Data (ver8.1.00)
Check the CLASSPATH of java #echo $CLASSPAT$ C:\echo %CLASSPATH% And see if apache or com.bmc (i.e. *.jar). From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Gupta Sent: Tuesday, March 26, 2013 1:43 PM To: arslist@ARSLIST.ORG Subject: Re: Error while uploading Foundation Data (ver8.1.00) ** Hi Carl, I used all short names for Pentaho Plugin (in ar.cfg, pluginsvr_config.xml, armonitor.cfg) and still getting the same error. Please mention if I missed something. Also, I noticed following error in javaplugin.log: 2013-03-26 03:06:27,641 ERROR [pool-4-thread-3] com.bmc.arsys.pdi.ardbc.ARPentahoPlugin (?:?) - Error while creating an entry on form UDM:Execution org.apache.commons.httpclient.NoHttpResponseException: The server server-name with FQDN failed to respond at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1835) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.pentaho.di.cluster.SlaveServer.sendXML(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstanceForJob(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.sendObjectToCarteServer(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createExecutionInstance(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.execute(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.execute(Unknown Source) at com.bmc.arsys.pdi.ardbc.ARPentahoPlugin.createEntry(Unknown Source) at com.bmc.arsys.pluginsvr.plugins.a.ArdbcCreate(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcCreate_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsArdbcCreate_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Thanks and Regards, Abhishek Gupta On Mon, Mar 25, 2013 at 9:33 PM, Carl Wilson carlbwil...@gmail.commailto:carlbwil...@gmail.com wrote: ** Hi, Looks like you have a mixture of short name and FQDN in the configuration. This generally confuses the plugin server. Check the configuration in the AR config file and in the plugin server configuration and ensure that all references to the server for the Pentaho Plugin are the same (generally short name with no domain information) e.g. CIDCSWDREMAPP3. Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Gupta Sent: 25 March 2013 15:05 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Error while uploading Foundation Data (ver8.1.00) ** arcarte.log entries: INFO 25-03 03:27:24,718 - Carte - Created listener for webserver @ address : CIDCSWDREMAPP3:2 arjavaplugin.log entries: 2013-03-25 03:27:39,912 WARN [pool-4-thread-5] com.bmc.arsys.pluginsvr.d.b (?:?) - INFO: Java plug-in server has initialized plug-ins for all 5 core threads. The server is ready to receive RPC calls. 2013-03-25 03:50:06,116 ERROR [pool-4-thread-4] com.bmc.arsys.pdi.ardbc.ARPentahoPlugin (?:?) - Error while creating an entry on form UDM:Execution org.apache.commons.httpclient.NoHttpResponseException: The server CIDCSWDREMAPP3.ced.corp.cummins.comhttp://cidcswdremapp3.ced.corp.cummins.com/ failed to respond at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1835) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.pentaho.di.cluster.SlaveServer.sendXML(Unknown Source) at
EXTERNAL in a menu qualification
(Not sure if this message made through) All, I am trying to use EXTERNAL in a select menu qualification - is this possible? If so can I get an example of where it made sense. Thanks Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: EXTERNAL in a menu qualification
I've never tried that. I have done Menus based on specific field values in the parent form (and for that you just use the Field ID) i.e. You have a form with 3 fields Activity1 536870923, Activity2 536870924, and Activity3 536870925. You are pulling menu data from a form with fields of MenuLevel1, MenuLevel2, MenuLevel3. You want the menu on Activity 2 to only show the records corresponding to what the user picks for Activity 1. The menu on Activity 2 would have in it ... AND ('MenuLevel1' = $536870923$) ... Fred --Original Message-- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Atul Vohra Sent: Tuesday, March 26, 2013 8:41 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL in a menu qualification ** (Not sure if this message made through) All, I am trying to use EXTERNAL in a select menu qualification - is this possible? If so can I get an example of where it made sense. Thanks Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Pushing data from character field to date field
It sounds like the date format in your character field does not match the format of your date field. Your third party app is using mm/dd/ and your ARS system is using dd/mm/ Misi's set fields should take care of the issue, although you probably should make sure all systems agree on the same definition of fields when integrating applications. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick Sent: Monday, March 25, 2013 7:00 PM To: arslist@ARSLIST.ORG Subject: Pushing data from character field to date field Hi all, We have third party application were the data comes to remedy stating form and the date/time will be captured in character field. When the datas are moved to main form the date are showing different. Ex. Staging form Character field . Date/Time field - mm/dd/ When the data is moved to main form it take dd as mm and mm as dd. Help me on this Our server timing is in Australia time zone Sent from my iPhone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Dev Studio 7.6.04 Question
Hello Fellow Listers, We are in the process of learning the Dev Studio 7.6.04 for the first time. We are now upgrading from 7.1 to 7.6.04 and one of the developers asked the following questions that we really don't know the answers to. I was hoping someone on this list would be able to provide some insight here. We have been looking through all the guides and it never really talks about this. Here are the questions: What happens if you modify an in-house custom built form or object in Best Practice mode and it creates an overlay? How do you recover from that and remove the overlay? Is there a way to prevent this from happening? Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.comhttp://www.hp.com/ Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: Picture (Device Independent Bitmap) 1.jpg
Integrating availability monitoring
Hi listers, I have a problem that is forcing me to develop a lot of code. I'm sure that there is an easier way to solve it, so I call for your knowledge about it. Surely I'm not the first to face this situation. I have a monitoring tool that send events to ARS when some situations are found. The event is received through a Web service that stores the event in a custom form. We have a lot of code to process this event, to determine if we need to create an incident, a comment, change something, ... One of the possible events is the detection of a CI unavailable. Then my code checks the status of the CI at the CMDB, to see if it is unavailable for some reason (like a planned shutdown or an end-of-life). If it is marked as available, then we need to start an unavailability request, and create a related incident. Using the HPD:Help Desk form is like creating a new incident, relate it to the CI and go to the relationships tab, quick actions and create an unavailability record. But I see that most of the code used to process this situation is at the Active Link side, so I can't use it from my custom form. I started to reproduce all the code so at the end I will finish with: - The CI avalability status = Down - The CI has an unavailabilty request. The assignment method is crossed reference. - A new incident is created related to the CI and the unavailability request. I getting mad with the amount of code to be created. Any of you have an easier solution? The rationale behind this is that we want to capture the availability status of CI's, in order to control them through the SLM; and we want to warm the support staff so they can solve the unavailability as soon as possible. May be my approach is not the best. What's your opinion? Regards, Jose Manuel Huerta http://theremedyforit.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Dev Studio 7.6.04 Question
Hi Christopher, If you try to delete an object with an overlay, it will delete the overlay and return you to the Out-Of-Box object. There's no benefit to modifying the base OOB object. Besides not having an undo... When you do an upgrade, the base object will be replaced. If you have an overlay, that overlay will stay in place and your customization will remain (assuming there are no changes to the OOB object. If there are, you'll have to test your customization). Hope that helps. Thanks, Jon _ Jon Slaven | Amway | 616-787-7132 | jon.sla...@amway.com From: Pruitt, Christopher (Bank of America Account) christopher.pru...@hp.com To: arslist@ARSLIST.ORG, Date: 03/26/2013 10:37 AM Subject:Dev Studio 7.6.04 Question Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Hello Fellow Listers, We are in the process of learning the Dev Studio 7.6.04 for the first time. We are now upgrading from 7.1 to 7.6.04 and one of the developers asked the following questions that we really don’t know the answers to. I was hoping someone on this list would be able to provide some insight here. We have been looking through all the guides and it never really talks about this. Here are the questions: What happens if you modify an in-house custom built form or object in Best Practice mode and it creates an overlay? How do you recover from that and remove the overlay? Is there a way to prevent this from happening? Christopher Pruitt Business Consulting III Remedy Developer BMC Certified Administrator: BMC Remedy AR System 7.6.04 HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _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 image/jpeg
Remedy 7.6.04 -Corrupt Cache / Corrupt Fields
All, We are experiencing issues with cache corruption in Remedy 7.6.04. For example, certain fields become corrupt, such as the Assignee Field in Incident Management. The field becomes collapsed and non-functional. The only work-around we have found is to delete the mid-tier caches during mid-tier recycles and delete the user's browser cache. The issues are mainly occurring on the Assignee Field, however, we have noticed other anomolies in the Notes field and other random fields. The work-around of deleting the mid-tier caches / clearing the users' browser cache only seems to work for about a week and then the issue returns. Has anyone else experienced this issue? Thank you, Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy 7.6.04 -Corrupt Cache / Corrupt Fields
Upgrade to sp4 On Mar 26, 2013 8:27 PM, Chris Wilson christopher.j.wil...@stls.frb.org wrote: All, We are experiencing issues with cache corruption in Remedy 7.6.04. For example, certain fields become corrupt, such as the Assignee Field in Incident Management. The field becomes collapsed and non-functional. The only work-around we have found is to delete the mid-tier caches during mid-tier recycles and delete the user's browser cache. The issues are mainly occurring on the Assignee Field, however, we have noticed other anomolies in the Notes field and other random fields. The work-around of deleting the mid-tier caches / clearing the users' browser cache only seems to work for about a week and then the issue returns. Has anyone else experienced this issue? Thank you, Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Remedy 7.6.04 -Corrupt Cache / Corrupt Fields
Jayesh - Did you see issues like this prior to SP4? From: jayesh panchal jhpancha...@gmail.com To: arslist@ARSLIST.ORG, Date: 03/26/2013 10:03 AM Subject:Re: Remedy 7.6.04 -Corrupt Cache / Corrupt Fields Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Upgrade to sp4 On Mar 26, 2013 8:27 PM, Chris Wilson christopher.j.wil...@stls.frb.org wrote: All, We are experiencing issues with cache corruption in Remedy 7.6.04. For example, certain fields become corrupt, such as the Assignee Field in Incident Management. The field becomes collapsed and non-functional. The only work-around we have found is to delete the mid-tier caches during mid-tier recycles and delete the user's browser cache. The issues are mainly occurring on the Assignee Field, however, we have noticed other anomolies in the Notes field and other random fields. The work-around of deleting the mid-tier caches / clearing the users' browser cache only seems to work for about a week and then the issue returns. Has anyone else experienced this issue? Thank you, Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _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
Re: Remedy 7.6.04 -Corrupt Cache / Corrupt Fields
Yes..cache curruption we faced in sp2 same like u ... We upgraded to sp3 as per bmc But because of sp3 we faced cache rebuilding and long time to rebuild.. Now all the cache related issues are sorted out after SP4 and latest hotfix On Mar 26, 2013 8:38 PM, Melissa reed melissa.r...@stls.frb.org wrote: ** Jayesh - Did you see issues like this prior to SP4? From:jayesh panchal jhpancha...@gmail.com To:arslist@ARSLIST.ORG, Date:03/26/2013 10:03 AM Subject:Re: Remedy 7.6.04 -Corrupt Cache / Corrupt Fields Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG -- ** Upgrade to sp4 On Mar 26, 2013 8:27 PM, Chris Wilson * christopher.j.wil...@stls.frb.org* christopher.j.wil...@stls.frb.org wrote: All, We are experiencing issues with cache corruption in Remedy 7.6.04. For example, certain fields become corrupt, such as the Assignee Field in Incident Management. The field becomes collapsed and non-functional. The only work-around we have found is to delete the mid-tier caches during mid-tier recycles and delete the user's browser cache. The issues are mainly occurring on the Assignee Field, however, we have noticed other anomolies in the Notes field and other random fields. The work-around of deleting the mid-tier caches / clearing the users' browser cache only seems to work for about a week and then the issue returns. Has anyone else experienced this issue? Thank you, Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at *www.arslist.org*http://www.arslist.org/ Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _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
Missing solutions
Hi all, I'm updating some contacts and I seem to remember that there's a vendor on here with a name something like Missing Solutions or ??? but I can't remember/find the name. The idea of the name is that they have add-ons/packages that probably should have been included in main product but weren't. Can someone remind me of the name? Thanks, Ron ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Missing solutions
Hi Ron, It is Missing Pieces Software Solutions. http://www.missingpiecessoftware.com/ _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: 26 March 2013 15:42 To: arslist@ARSLIST.ORG Subject: Missing solutions ** Hi all, I'm updating some contacts and I seem to remember that there's a vendor on here with a name something like Missing Solutions or ??? but I can't remember/find the name. The idea of the name is that they have add-ons/packages that probably should have been included in main product but weren't. Can someone remind me of the name? Thanks, Ron _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
Re: Disable Resize of Display Only Form
On window open, can you use a run process action and perform these actions using JavaScript? I remember doing stuff like this sometime back but not sure if I had done it using run process. Regards, Karthik On Mar 26, 2013 8:51 AM, Mohamed Abdelaziz moe.abdela...@gmail.com wrote: ** Is there a way to prevent a display only form “Dialog” mode from being resized? Is there a way to just keep the “x” button to close the form and disable the minimize and maximize buttons as well as disableling the ability to resize the form? I looked at the properties of the form as well as the menu access and I don’t think I came across any property that may achieve this. ** ** ARS 7.6.04 environment ** ** Thanks, Moe _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
Re: Installing SSL Certificate on AR Server running on UNIX
No I didn’t have to import any libs as they were already in place. If you are registering the certificate for the 1st time then you will need to copy the libs to the arsystem/bin directory. Yes LDAP is working fine. From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of laurent matheo Sent: Tuesday, March 19, 2013 5:54 PM To: arslist@arslist.org Subject: Re: Installing SSL Certificate on AR Server running on UNIX ** Cool :) Did you have to copy some libs In /arsystem/bin/ ? Is ldaps working fine? Mobilis in Mobile. Le 19 mars 2013 à 22:33, MIZELL, MICHELE mm3...@att.commailto:mm3...@att.com a écrit : ** Thank you so much. This solution worked. I just had to find the certutil on my server. I am on unix and it was located in /usr/sfw/bin directory. But the key was to find the utility and then I followed the steps in the KB article KA312819 From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of vaibhav wadekar Sent: Tuesday, March 19, 2013 11:34 AM To: arslist@arslist.orgmailto:arslist@arslist.org Subject: Re: Installing SSL Certificate on AR Server running on UNIX ** Linux has a certutil package in /usr/bin/certutil. ls -l certu* -rwxr-xr-x 1 root root 172168 Dec 10 2008 certutil You just need to copy the nss libraries to ARSystem/bin folder and follow KA # KA312819 Hope this helps. ~ Vaibhav On Mon, Mar 18, 2013 at 2:55 PM, MIZELL, MICHELE mm3...@att.commailto:mm3...@att.com wrote: ** Has anyone installed an SSL Certificate on a unix server using the certutil utility or any other utility. I am trying to configure SSL LDAP Authentication on a unix server but am not able to run the certutil commands successfully as outlined in the document: https://kb.bmc.com/infocenter/index?page=contentid=KA319087actp=searchviewlocale=en_USsearchid=1363373386788 I downloaded the nss files for Linux instead of windows and copied the seamonkey dlls from my laptop to the unix server. When I try to create the certificate store I get the error : “ksh: certutil: cannot execute” Has anyone installed an SSL Certificate on the AR Server in a unix environment? Regards, Michele Mizell Sr. Remedy Developer ATT04 Tech Mahindra mm3...@att.commailto:mm3...@att.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _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
ITSM - Time Spent Mandatory
Hi All, In 6.3 we had a custom Trouble Ticket and Change Request forms. On these form any time a user made an update, it was required to make an entry in the Work Log and the Time Spent fields. These two fields were next to each other so the follow of motion was natural. Moving to 7.6 ITSM Incidents and Changes, I am not sure how to make these field mandatory and maintain a nice flow of motion. The incident uses a dialog and the change has the Time Spent field on the Date/System tab. I suppose on the Incident I could move the Time Spent field to the Date/System tab but would be clumsy. Another thought would be to place these fields to the right of the (Work Info) Notes field but have not figured out the panel layout and which panels I will need to make wider to accommodate. All thoughts and suggestions welcome. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 [cid:image001.gif@01CE2A20.D6158E20] 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 Where the Answers Are, and have been for 20 years inline: image001.gif
Re: ITSM - Time Spent Mandatory
You could use sla's to do this for you that way it happens automatically behind the scenes with no need for assignee to do anything. You can trigger sla's on a lot of different fields. On Mar 26, 2013, at 1:06 PM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi All, In 6.3 we had a custom Trouble Ticket and Change Request forms. On these form any time a user made an update, it was required to make an entry in the Work Log and the Time Spent fields. These two fields were next to each other so the follow of motion was natural. Moving to 7.6 ITSM Incidents and Changes, I am not sure how to make these field mandatory and maintain a nice flow of motion. The incident uses a dialog and the change has the Time Spent field on the Date/System tab. I suppose on the Incident I could move the Time Spent field to the Date/System tab but would be clumsy. Another thought would be to place these fields to the right of the (Work Info) Notes field but have not figured out the panel layout and which panels I will need to make wider to accommodate. All thoughts and suggestions welcome. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 image001.gif 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. _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
Re: Pushing data from character field to date field
As others have stated, the system is doing a conversion from a character field to a date field. It has to assume the format of the character field is the format it is using. Your system must have the date format for the server set to a different format than the data is flowing into the system. This is a MAJOR challenge with dates in general -- what is your context. For example, if you just have 5/10/12 as the value, what date is it? The answer is really that it is NOT ABLE TO BE DETERMINED with certainty. You can guess at the meaning based on context and ASSUME that the date is formatted as you are going to interpret it -- but that is all you can do, make a guess. This is why we store all dates in the AR System as an integer. There is no issue with interpretation and the value can be reinterpreted in a character manner as the reader wants it interpreted so that they are making the right assumptions about its format. Since you are getting dates in a different format than what the system is processing them in, you need to do one of the following: 1) Get the source to change the formatting -- probably not possible 2) Get the AR System to change the formatting it is expecting. This changes the format of displayed dates everywhere so is likely not what you want as you seem to want the AR System server formatting not the formatting of the data coming in 3) Manipulate the date in the character field before assigning to the date (as has been discussed) to change the order of things and get it into the order you want. BUT, be careful because THIS data source has the data in the format you need to switch the order. Other instances may not have it in a different order so your switching would break things in those cases. Something to be aware of. I hope this helps, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, March 26, 2013 7:07 AM To: arslist@ARSLIST.ORG Subject: Re: Pushing data from character field to date field It sounds like the date format in your character field does not match the format of your date field. Your third party app is using mm/dd/ and your ARS system is using dd/mm/ Misi's set fields should take care of the issue, although you probably should make sure all systems agree on the same definition of fields when integrating applications. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Karthick Sent: Monday, March 25, 2013 7:00 PM To: arslist@ARSLIST.ORG Subject: Pushing data from character field to date field Hi all, We have third party application were the data comes to remedy stating form and the date/time will be captured in character field. When the datas are moved to main form the date are showing different. Ex. Staging form Character field . Date/Time field - mm/dd/ When the data is moved to main form it take dd as mm and mm as dd. Help me on this Our server timing is in Australia time zone Sent from my iPhone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Installing SSL Certificate on AR Server running on UNIX
** I see :)So in your case those libs were already there (the ones from the kb).Thanks a lot :)On 26 Mar, 2013,at 05:50 PM, "MIZELL, MICHELE" mm3...@att.com wrote:No I didn’t have to import any libs as they were already in place. If you are registering the certificate for the 1st time then you will need to copy the libs to the arsystem/bin directory. Yes LDAP is working fine.From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of laurent matheo Sent: Tuesday, March 19, 2013 5:54 PM To: arslist@arslist.org Subject: Re: Installing SSL Certificate on AR Server running on UNIX**Cool :)Did you have to copy some libs In /arsystem/bin/ ?Is ldaps working fine? Mobilis in Mobile. Le 19 mars 2013 à 22:33, "MIZELL, MICHELE" mm3...@att.com a écrit:**Thank you so much. This solution worked. I just had to find the certutil on my server.I am on unix and it was located in /usr/sfw/bin directory. But the key was to find the utility and then I followed the steps in the KB article KA312819From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of vaibhav wadekar Sent: Tuesday, March 19, 2013 11:34 AM To: arslist@arslist.org Subject: Re: Installing SSL Certificate on AR Server running on UNIX**Linux has a certutil package in /usr/bin/certutil. ls -l certu* -rwxr-xr-x 1 root root 172168 Dec 10 2008 certutil You just need to copy the nss libraries to ARSystem/bin folder and follow KA # KA312819Hope this helps.~ Vaibhav On Mon, Mar 18, 2013 at 2:55 PM, MIZELL, MICHELE mm3...@att.com wrote:**Has anyone installed an SSL Certificate on a unix server using the certutil utility or any other utility. I am trying to configure SSL LDAP Authentication on a unix server but am not able to run the certutil commands successfully as outlined in the document:https://kb.bmc.com/infocenter/index?page=contentid=KA319087actp=searchviewlocale=en_USsearchid=1363373386788I downloaded the nss files for Linux instead of windows and copied the seamonkey dlls from my laptop to the unix server.When I try to create the certificate store I get the error : “ksh: certutil: cannot execute”Has anyone installed an SSL Certificate on the AR Server in a unix environment?Regards,Michele MizellSr. Remedy DeveloperATT04 Tech Mahindramm3...@att.com_ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_**_ARSlist: "Where the Answers Are" and have been for 20 years_
Re: EXTERNAL: Re: License considerations for custom approval process
Axton, I've found that the best way to handle something like this is to have the approver create a record in a supporting form that uses a GUID or the Request ID of the Request that needed approval. Then a Join form is updated by a licensed user to close out the request/approval chain. Perfectly legal because the Licensed user is aggregating the data from a pool of information submitted by the read only users. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, March 25, 2013 2:15 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: License considerations for custom approval process ** Technically you can work around the license issue by using a display only form that accepts records from the approvers and uses filters to perform the actions on the back-end. Conceptually, this allows writes to data by a user that is not licensed, but technically a hand-off occurs that takes the transaction outside the scope of the end user, thus avoiding the license check. Legally, this may be a violation, and I am certain it can be argued both ways, but in the end such a thing is at BMC's discretion to state whether this would be considered a license violation. Ask your support provider if this is a violation; send them a sample def that executes according to the model outlined; let them hash it out and get back to you. Axton Grams On Fri, Mar 22, 2013 at 3:37 AM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, Legal stuff is tricky. David says that BMC are discussing an exception for the approval process... As this is an approval process, I would probably create Filters that immediately tells the main record to continue the process. Would this be considered illegal or not, who knows!? I try to think of the intent of READ licenses when doing something like this. My normal rule of thumb is that the request or something, the end user, should be able to update his/her records with a READ licenses. The Approver is not the Requesting End User, but as someone said an Approver could be anyone, and you are not supposed to have to buy FIXED/FLOAT licenses to every employee. Why not give them a FLOAT license? The problem is that they might do READ-type stuff 99% of the time, but giving them a FLOAT would tie that license 100% of the time because of the 1% needed for the occasional Approval... Maybe you could have some FLTR:s in place that changes your Approvers to FLOAT in the User-form whenever they have an active Approval, and then back to READ again when they have done the Approval/Rejection? Please don't refer to this posting in any legal dispute with BMC, I am just sharing my thoughts and ideas on the subject ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. True, and I could display them in a table in a master record by linking them with a common id. I didn't know if that might be considered cheating or not. Maybe not as long as I don't actually update that master record with their input. David -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, March 21, 2013 3:20 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: License considerations for custom approval process Hi, If you have a home-grown solution for approvals, why not create one record per approver, with the approvers user-name in the submitter-field. When the approver then updates this record with a read-licenses, you can then have FLTR:s and/or ESCL:s that forwards the process. For example creating a new approval record for the next approver, or notifies someone of a reject. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Ø approval engine is an exception to the normal write license requirements. Clarification. Currently, that exception is only granted when Approval is utilized within a BMC provided solution (e.g. Incident, Change, SLM, etc.). When used with custom / bespoke applications, the exception is not
(Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies?
After nearly 2 years of banging my head against a wall trying to decipher data, I've decided to give up and ask the experts. Are there any best practices forums or cheat sheets out there to assist HelpDesk managers better utilize the Remedy system? Lorraine Sanner AOC Support Services Supervisor (602) 452-3223 AOC Support: (602) 452-3900 or (855) 229-3900 NEW! Please share your feedback with us -- Support Center Surveyhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dEVtazN5RlRyWDVOYkdac2M2Z3dzUHc6MQ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
ADDM
Hi Question - if ADDM in Prod scans 50 subnets, and QA ADDM scans 4 subnets. A business was telling me they want to copy Prod to QA to see all of the assets, reconcile the assets and normalize the assets into the CMDB in QA. They believe everything will work fine. Is there some licensing issue with this? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies?
What metrics do you use to evaluate your people? Or are you looking for something more on the system side of data? Are you using Out of the Box BMC applications, or is this custom built? What version of the remedy server are you on, and do you use a web browser, or do you use the native client? Lots of questions here. Darrell Reading Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanner, Lorraine Sent: Tuesday, March 26, 2013 1:51 PM To: arslist@ARSLIST.ORG Subject: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** After nearly 2 years of banging my head against a wall trying to decipher data, I've decided to give up and ask the experts. Are there any best practices forums or cheat sheets out there to assist HelpDesk managers better utilize the Remedy system? Lorraine Sanner AOC Support Services Supervisor (602) 452-3223 AOC Support: (602) 452-3900 or (855) 229-3900 NEW! Please share your feedback with us -- Support Center Surveyhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dEVtazN5RlRyWDVOYkdac2M2Z3dzUHc6MQ _ARSlist: Where the Answers Are and have been for 20 years_ 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. *** Walmart Confidential *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Splitware client for mobile devices..
Has anyone attempted to use this on home grown applications? From the description, it doesn't appear to be designed for anything other than the ITSM applications. https://itunes.apple.com/us/app/mobile-reach-splitware/id465769933?mt=8 Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
SSO/CAC on 7.5
Good afternoon everyone. I've been looking on the BMC website for compatibility information for Atrium SSO. That's why I'm here now, asking this question. :-) Can SSO run on ARS 7.5, or does it start on 7.6.04? Thanks a million. Drew Shuller JTF-Bravo Honduras ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: SSO/CAC on 7.5
7.6.04. Sent from my iPhone On Mar 26, 2013, at 3:30 PM, Drew Shuller drew.shul...@gmail.com wrote: ** Good afternoon everyone. I've been looking on the BMC website for compatibility information for Atrium SSO. That's why I'm here now, asking this question. :-) Can SSO run on ARS 7.5, or does it start on 7.6.04? Thanks a million. Drew Shuller JTF-Bravo Honduras _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
Re: Splitware client for mobile devices..
I don't know if I would call Mobile Reach home grown. http://mobilereach.com/ Jason On Tue, Mar 26, 2013 at 12:26 PM, Joe D'Souza jdso...@shyle.net wrote: ** Has anyone attempted to use this on home grown applications? ** ** From the description, it doesn’t appear to be designed for anything other than the ITSM applications. ** ** https://itunes.apple.com/us/app/mobile-reach-splitware/id465769933?mt=8*** * ** ** Joe _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
Re: Splitware client for mobile devices..
I have used it for other applications within Remedy space and also another application out of the remedy space. It also works with ITSM applications. You have the option for ITSM apps, to either use their OOTB solution or you can have the wizard so you can customize and bring in any information/field you want. Thanks, Brandi From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Tuesday, March 26, 2013 2:26 PM To: arslist@ARSLIST.ORG Subject: Splitware client for mobile devices.. ** Has anyone attempted to use this on home grown applications? From the description, it doesn't appear to be designed for anything other than the ITSM applications. https://itunes.apple.com/us/app/mobile-reach-splitware/id465769933?mt=8 Joe _ARSlist: Where the Answers Are and have been for 20 years_ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: SSO/CAC on 7.5
Thank you Rjust. On Tue, Mar 26, 2013 at 1:36 PM, Rjust rjust2...@aol.com wrote: 7.6.04. Sent from my iPhone On Mar 26, 2013, at 3:30 PM, Drew Shuller drew.shul...@gmail.com wrote: ** Good afternoon everyone. I've been looking on the BMC website for compatibility information for Atrium SSO. That's why I'm here now, asking this question. :-) Can SSO run on ARS 7.5, or does it start on 7.6.04? Thanks a million. Drew Shuller JTF-Bravo Honduras _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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Row Count of Table Field
Has anyone found a way to get the current row count of a table field? My goal is to display this on the form below the table field for the user to see. I know the row count functionality is supported using the web browser...I am still using the Windows user tool. I am looking for some configuration setting on the table field to do this or create an Active Link where I could do a set fields on a character display field and assign it the table field rowcount property (as if I was doing VB). Thanks for the help! Bruce Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Row Count of Table Field
I believe you just need to do a set fields using the function COLCOUNT COLCOUNT (column) or (table) For a list view, tree view, or results list table field, returns the total number of rows. For a column field, returns the total number of non-NULL rows in a given column. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wilson, Bruce B Sent: Tuesday, March 26, 2013 3:04 PM To: arslist@ARSLIST.ORG Subject: Row Count of Table Field ** Has anyone found a way to get the current row count of a table field? My goal is to display this on the form below the table field for the user to see. I know the row count functionality is supported using the web browser...I am still using the Windows user tool. I am looking for some configuration setting on the table field to do this or create an Active Link where I could do a set fields on a character display field and assign it the table field rowcount property (as if I was doing VB). Thanks for the help! Bruce Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Row Count of Table Field
Hi, The COLCOUNT($TableField$) function should return the number of rows. Or do you mean the number of the selected row? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Has anyone found a way to get the current row count of a table field? My goal is to display this on the form below the table field for the user to see. I know the row count functionality is supported using the web browser...I am still using the Windows user tool. I am looking for some configuration setting on the table field to do this or create an Active Link where I could do a set fields on a character display field and assign it the table field rowcount property (as if I was doing VB). Thanks for the help! Bruce Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Error while getting records from LDAP
HI I am working on a task to sync LDAP records with People form. So in that process i created a Vendor form to retrieve records from LDAP table and its throwing me following error while doing search for records but when i search for single record its retrieving. I have gone through the Error document but it didn't help me. Can you please give me your valuable suggestion to overcome this problem. 8760 Error Cannot establish a network connection to the AR System Plug-In server. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Mobility Service Desk supports customized workflow?
Hi everyone, Does anyone here have experience with BMC Mobility Service Desk? I have a customer that have an ITSM environment with several customizations and I'm trying to discover if Mobility supports those customizations. For example: there is customized workflows that make almost all fields in Resolution tab to be required on Incident resolution. Does anyone know if in this example, these fields would also be required on mobile? Best regards, Oswaldo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies?
In addition to call handling metrics, I evaluate performance based on Created Tickets, Work Logs, First Call Resolution, Tickets Meeting SLA, Resolved 30 days (we get a large volume of 'request' tickets), and Updating Tickets within 14 days. This last one is quite a challenge to find without running the search reports every single day, so I currently only capture a snapshot of the end of each month. We're using a partially-custom built 7.6.04 using the native desktop client. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Darrell Reading Sent: Tuesday, March 26, 2013 12:05 PM To: arslist@ARSLIST.ORG Subject: Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** What metrics do you use to evaluate your people? Or are you looking for something more on the system side of data? Are you using Out of the Box BMC applications, or is this custom built? What version of the remedy server are you on, and do you use a web browser, or do you use the native client? Lots of questions here. Darrell Reading Phone 479.204.5739 dere...@wal-mart.commailto:dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanner, Lorraine Sent: Tuesday, March 26, 2013 1:51 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** After nearly 2 years of banging my head against a wall trying to decipher data, I've decided to give up and ask the experts. Are there any best practices forums or cheat sheets out there to assist HelpDesk managers better utilize the Remedy system? Lorraine Sanner AOC Support Services Supervisor (602) 452-3223 AOC Support: (602) 452-3900 or (855) 229-3900 NEW! Please share your feedback with us -- Support Center Surveyhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dEVtazN5RlRyWDVOYkdac2M2Z3dzUHc6MQ _ARSlist: Where the Answers Are and have been for 20 years_ 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. *** Walmart Confidential *** _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
Long running query
Have seen a post similar this, but since i could not find this out i am posting this again. We are facing performance issue and while going throught the DB log we can see following query run and it is taking log time to execute Allow unqualified search is checked T1141 :- SLM measurement and the Field C300411500 is an indexed field. SELECT * FROM ( SELECT T1411.C1, C300314700, C300411500, C300426800, C300365100, C300411700, C490008000, C301721300, C490009000, C300905300 FROM T1411 WHERE ((T1411.C300411500 LIKE :SYS_B_00) AND ((T1411.C112 LIKE :SYS_B_01) OR (T1411.C112 LIKE :SYS_B_02) OR (T1411.C112 LIKE :SYS_B_03) OR (T1411.C112 LIKE :SYS_B_04) OR (T1411.C112 LIKE :SYS_B_05) OR (T1411.C112 LIKE :SYS_B_06) OR (T1411.C112 LIKE :SYS_B_07) OR (T1411.C112 LIKE :SYS_B_08) OR (T1411.C112 LIKE :SYS_B_09) OR (T1411.C112 LIKE :SYS_B_10) OR (T1411.C112 LIKE :SYS_B_11) OR (T1411.C112 LIKE :SYS_B_12) OR (T1411.C112 LIKE :SYS_B_13) OR (T1411.C112 LIKE :SYS_B_14) OR (T1411.C112 LIKE :SYS_B_15) OR (T1411.C112 LIKE :SYS_B_16) OR (T1411.C112 LIKE :SYS_B_17) OR (T1411.C112 LIKE :SYS_B_18) OR (T1411.C112 LIKE :SYS_B_19) OR (T1411.C112 LIKE :SYS_B_20) OR (T1411.C112 LIKE :SYS_B_21) OR (T1411.C112 LIKE :SYS_B_22) OR (T1411.C112 LIKE :SYS_B_23) OR (T1411.C112 LIKE :SYS_B_24) OR (T1411.C112 LIKE :SYS_B_25) OR (T1411.C112 LIKE :SYS_B_26) OR (T1411.C112 LIKE :SYS_B_27) OR (T1411.C112 LIKE :SYS_B_28) OR (T1411.C112 LIKE :SYS_B_29) OR (T1411.C112 LIKE :SYS_B_30) OR (T1411.C112 LIKE :SYS_B_31) OR (T1411.C112 LIKE :SYS_B_32) OR (T1411.C112 LIKE :SYS_B_33) OR (T1411.C112 LIKE :SYS_B_34) OR (T1411.C112 LIKE :SYS_B_35) OR (T1411.C112 LIKE :SYS_B_36) OR (T1411.C112 LIKE :SYS_B_37) OR (T1411.C112 LIKE :SYS_B_38) OR (T1411.C112 LIKE :SYS_B_39) OR (T1411.C112 L IKE :SYS_B_40) OR (T1411.C112 LIKE :SYS_B_41) OR (T1411.C112 LIKE :SYS_B_42) OR (T1411.C112 LIKE :SYS_B_43) OR (T1411.C112 LIKE :SYS_B_44) OR (T1411.C112 LIKE :SYS_B_45) OR (T1411.C112 LIKE :SYS_B_46) OR (T1411.C112 LIKE :SYS_B_47))) ORDER BY :SYS_B_48 DESC ) WHERE ROWNUM = :SYS_B_49 Query going for FTS on ARADMIN.T1161 (Helpdesk Form) -- SELECT COUNT (*) FROM T1161 WHERE ( ( ( ( (T1161.C100079 = :SYS_B_00) OR (T1161.C100079 = :SYS_B_01) OR (T1161.C100079 = :SYS_B_02) OR (T1161.C100079 = :SYS_B_03) OR (T1161.C100079 = :SYS_B_04))AND (:SYS_B_05 != :SYS_B_06)) OR ( (:SYS_B_07 = :SYS_B_08) AND (:SYS_B_09 = :SYS_B_10))) AND (T1161.C7 = :SYS_B_11)AND (T1161.C7 = :SYS_B_12) AND ( (T1161.C100560 = :SYS_B_13) OR (:SYS_B_14 = :SYS_B_15)) AND ( (T1161.C100560 = :SYS_B_16) OR (:SYS_B_17 = :SYS_B_18)) AND ( (T1161.C11 = :SYS_B_19) OR (:SYS_B_20 = :SYS_B_21)) AND ( (T1161.C103009 IS NULL) OR (:SYS_B_22 = :SYS_B_23)) AND (:SYS_B_24 = :SYS_B_25)AND ( (T1161.C112 LIKE :SYS_B_26) OR (T1161.C112 LIKE :SYS_B_27) OR (T1161.C112 LIKE :SYS_B_28) OR (T1161.C112 LIKE :SYS_B_29) OR (T1161.C112 LIKE :SYS_B_30) OR (T1161.C112 LIKE :SYS_B_31) OR (T1161.C112 LIKE :SYS_B_32) OR (T1161.C112 LIKE :SYS_B_33) OR (T1161.C112 LIKE :SYS_B_34) OR (T1161.C112 LIKE :SYS_B_35) OR (T1161.C112 LIKE :SYS_B_36) OR (T1161.C112 LIKE :SYS_B_37) OR (T1161.C112 LIKE :SYS_B_38) OR (T1161.C112 LIKE :SYS_B_39) OR (T1161.C112 LIKE :SYS_B_40) OR (T1161.C112 LIKE :SYS_B_41) OR (T1161.C112 LIKE :SYS_B_42) OR (T1161.C112 LIKE :SYS_B_43) OR (T1161.C112 LIKE :SYS_B_44) OR (T1161.C112 LIKE :SYS_B_45) OR (T1161.C112 LIKE :SYS_B_46) OR (T1161.C112 LIKE :SYS_B_47) OR (T1161.C112 LIKE :SYS_B_48) OR (T1161.C112 LIKE :SYS_B_49) OR (T1161.C112 LIKE :SYS_B_50) OR (T1161.C112 LIKE :SYS_B_51) OR (T1161.C112 LIKE :SYS_B_52) OR (T1161.C112 LIKE :SYS_B_53) OR (T1161.C112 LIKE :SYS_B_54) OR (T1161.C112 LIKE :SYS_B_55) OR (T1161.C112 LIKE :SYS_B_56) OR (T1161.C112 LIKE :SYS_B_57))) ARYSTEM 7.1 patch 11 OS Sun 5.10 Oracle 10.2.0.3.0 - 64bi Can anyone let me know what exactly this query is about? Regards Rajesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ADDM
Hi, I do not believe there are licensing implications as each ADDM environment is its own instance, as is the ARS system. This is common practise to use a scanning/consolidation device(s) from one environment to populate another ARS environment. I have seen this technique used at a number of clients to populate the various ARS environment data. _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: 26 March 2013 19:00 To: arslist@ARSLIST.ORG Subject: ADDM ** Hi Question - if ADDM in Prod scans 50 subnets, and QA ADDM scans 4 subnets. A business was telling me they want to copy Prod to QA to see all of the assets, reconcile the assets and normalize the assets into the CMDB in QA. They believe everything will work fine. Is there some licensing issue with this? _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
Re: [EXTERNAL] Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies?
Lorraine: Ummm...If we are talking about ITSM as your application for working tickets, it doesn't work with the native desktop client anymore once you get somewhere around version 7.5ish. We run ITSM 7.6.04 SP2 at our site, and I know our user community *has to* use a browser to work their tickets, though we on the development team still use the desktop client for certain tasks. Or are you talking about a partially customized app other than ITSM running on AR System Server 7.6.04? (It's not like BMC makes these questions especially easy to answer... :\ ) I'm still feeling a bit vague about what you need. Would you say that there are cases where you are having difficulty making sense of your data? Or is it more a case that are you struggling over what the right questions are to even be asking? Each of those questions has different answers, and if I can, I'd like to provide one that's reasonably helpful. Thanks, Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanner, Lorraine Sent: Tuesday, March 26, 2013 3:59 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** In addition to call handling metrics, I evaluate performance based on Created Tickets, Work Logs, First Call Resolution, Tickets Meeting SLA, Resolved 30 days (we get a large volume of 'request' tickets), and Updating Tickets within 14 days. This last one is quite a challenge to find without running the search reports every single day, so I currently only capture a snapshot of the end of each month. We're using a partially-custom built 7.6.04 using the native desktop client. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Darrell Reading Sent: Tuesday, March 26, 2013 12:05 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** What metrics do you use to evaluate your people? Or are you looking for something more on the system side of data? Are you using Out of the Box BMC applications, or is this custom built? What version of the remedy server are you on, and do you use a web browser, or do you use the native client? Lots of questions here. Darrell Reading Phone 479.204.5739 dere...@wal-mart.commailto:dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanner, Lorraine Sent: Tuesday, March 26, 2013 1:51 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: (Noob alert!) Cheat sheets? Remedy 7.6.04 for Dummies? ** After nearly 2 years of banging my head against a wall trying to decipher data, I've decided to give up and ask the experts. Are there any best practices forums or cheat sheets out there to assist HelpDesk managers better utilize the Remedy system? Lorraine Sanner AOC Support Services Supervisor (602) 452-3223 AOC Support: (602) 452-3900 or (855) 229-3900 NEW! Please share your feedback with us -- Support Center Surveyhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dEVtazN5RlRyWDVOYkdac2M2Z3dzUHc6MQ _ARSlist: Where the Answers Are and have been for 20 years_ 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. *** Walmart Confidential *** _ARSlist: Where the Answers Are and have been for 20 years_ _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
Re: WebServices - Access-Control-Allow-Origin.
Hello, Does anyone know anything about this? Regards, Michael Benz Holcim Australia Shared Services www.holcim.com.auhttp://www.holcim.com.au/ From: Benz, Michael Sent: Tuesday, 26 March 2013 8:27 AM To: 'arslist@ARSLIST.ORG' Subject: WebServices - Access-Control-Allow-Origin. Hello World Recently, I've been trying to use web services to display information from change requests, and I get the following error from Chrome Debug console.. XMLHttpRequest cannot load http://Midtier/arsys/WSDL/public/AR Server/CHG_ChangeInterface_WShttp://%3cMidtier%3e/arsys/WSDL/public/%3cAR%20Server%3e/CHG_ChangeInterface_WS. Origin Webhttp://ossc-dev-swb01.devoc.local/ Server is not allowed by Access-Control-Allow-Origin. Now when I run chrome with disabled security, it works. But obviously that's not best practise. From what I read, this means I have to put the following somewhere in the midtier application. Response.setHeader(Access-Control-Allow-Origin,*); But I can't find it anywhere. Has anyone else had this problem, can someone shed some light on it for me? I'm not very good at tomcat configuration so any help would be great Regards, Michael Benz Holcim Australia Shared Services Holcim (Australia) Pty Ltd Suite 201, Level 2, 7-9 Irvine Place Norwest Business Park, Baulkham Hills, NSW 2153 Phone: +61 2 8867 2326 Mobile: +61 429 790 513 www.holcim.com.auhttp://www.holcim.com.au/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while getting records from LDAP
Hello Raj, Can you confirm the below ARSystem Version? OS? If it is 7.6.04, it appears that C based ardbcldap.so did not get load with start of C Plugin server? If it is 8.0 or later version, Java plugin server did not started? Also check the Server-Plugin-Alias entry for ARDBC to confirm whether correct server is configured for the plugin to use. Hope this helps. Regards/Vaibhav Regards/Vaibhav On Tue, Mar 26, 2013 at 1:49 PM, rajkiran Alle rajkiran...@yahoo.comwrote: HI I am working on a task to sync LDAP records with People form. So in that process i created a Vendor form to retrieve records from LDAP table and its throwing me following error while doing search for records but when i search for single record its retrieving. I have gone through the Error document but it didn't help me. Can you please give me your valuable suggestion to overcome this problem. 8760 Error Cannot establish a network connection to the AR System Plug-In server. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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
Re: Splitware client for mobile devices..
Official Mobile Reach Statement: Mobile Reach provides mobile applications for ITSM apps as well as completely home grown AR apps. We would welcome the opportunity to showcase this fact. Mike McKee | mmc...@mobilereach.com | 919-371-2188 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Long running query
Check the column included in where and ensured they are indexed WHERE ((T1411.C300411500 LIKE :SYS_B_00) AND ((T1411.C112 LIKE :SYS_B_01) OR (T1411.C112 LIKE :SYS_B_02) OR (T1411.C112 LIKE :SYS_B_03) OR (T1411.C112 LIKE :SYS_B_04) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Sent: Wednesday, March 27, 2013 1:09 AM To: arslist@ARSLIST.ORG Subject: Long running query Have seen a post similar this, but since i could not find this out i am posting this again. We are facing performance issue and while going throught the DB log we can see following query run and it is taking log time to execute Allow unqualified search is checked T1141 :- SLM measurement and the Field C300411500 is an indexed field. SELECT * FROM ( SELECT T1411.C1, C300314700, C300411500, C300426800, C300365100, C300411700, C490008000, C301721300, C490009000, C300905300 FROM T1411 WHERE ((T1411.C300411500 LIKE :SYS_B_00) AND ((T1411.C112 LIKE :SYS_B_01) OR (T1411.C112 LIKE :SYS_B_02) OR (T1411.C112 LIKE :SYS_B_03) OR (T1411.C112 LIKE :SYS_B_04) OR (T1411.C112 LIKE :SYS_B_05) OR (T1411.C112 LIKE :SYS_B_06) OR (T1411.C112 LIKE :SYS_B_07) OR (T1411.C112 LIKE :SYS_B_08) OR (T1411.C112 LIKE :SYS_B_09) OR (T1411.C112 LIKE :SYS_B_10) OR (T1411.C112 LIKE :SYS_B_11) OR (T1411.C112 LIKE :SYS_B_12) OR (T1411.C112 LIKE :SYS_B_13) OR (T1411.C112 LIKE :SYS_B_14) OR (T1411.C112 LIKE :SYS_B_15) OR (T1411.C112 LIKE :SYS_B_16) OR (T1411.C112 LIKE :SYS_B_17) OR (T1411.C112 LIKE :SYS_B_18) OR (T1411.C112 LIKE :SYS_B_19) OR (T1411.C112 LIKE :SYS_B_20) OR (T1411.C112 LIKE :SYS_B_21) OR (T1411.C112 LIKE :SYS_B_22) OR (T1411.C112 LIKE :SYS_B_23) OR (T1411.C112 LIKE :SYS_B_24) OR (T1411.C112 LIKE :SYS_B_25) OR (T1411.C112 LIKE :SYS_B_26) OR (T1411.C112 LIKE :SYS_B_27) OR (T1411.C112 LIKE :SYS_B_28) OR (T1411.C112 LIKE :SYS_B_29) OR (T1411.C112 LIKE :SYS_B_30) OR (T1411.C112 LIKE :SYS_B_31) OR (T1411.C112 LIKE :SYS_B_32) OR (T1411.C112 LIKE :SYS_B_33) OR (T1411.C112 LIKE :SYS_B_34) OR (T1411.C112 LIKE :SYS_B_35) OR (T1411.C112 LIKE :SYS_B_36) OR (T1411.C112 LIKE :SYS_B_37) OR (T1411.C112 LIKE :SYS_B_38) OR (T1411.C112 LIKE :SYS_B_39) OR (T1411.C112 L IKE :SYS_B_40) OR (T1411.C112 LIKE :SYS_B_41) OR (T1411.C112 LIKE :SYS_B_42) OR (T1411.C112 LIKE :SYS_B_43) OR (T1411.C112 LIKE :SYS_B_44) OR (T1411.C112 LIKE :SYS_B_45) OR (T1411.C112 LIKE :SYS_B_46) OR (T1411.C112 LIKE :SYS_B_47))) ORDER BY :SYS_B_48 DESC ) WHERE ROWNUM = :SYS_B_49 Query going for FTS on ARADMIN.T1161 (Helpdesk Form) -- SELECT COUNT (*) FROM T1161 WHERE ( ( ( ( (T1161.C100079 = :SYS_B_00) OR (T1161.C100079 = :SYS_B_01) OR (T1161.C100079 = :SYS_B_02) OR (T1161.C100079 = :SYS_B_03) OR (T1161.C100079 = :SYS_B_04))AND (:SYS_B_05 != :SYS_B_06)) OR ( (:SYS_B_07 = :SYS_B_08) AND (:SYS_B_09 = :SYS_B_10))) AND (T1161.C7 = :SYS_B_11)AND (T1161.C7 = :SYS_B_12) AND ( (T1161.C100560 = :SYS_B_13) OR (:SYS_B_14 = :SYS_B_15)) AND ( (T1161.C100560 = :SYS_B_16) OR (:SYS_B_17 = :SYS_B_18)) AND ( (T1161.C11 = :SYS_B_19) OR (:SYS_B_20 = :SYS_B_21)) AND ( (T1161.C103009 IS NULL) OR (:SYS_B_22 = :SYS_B_23)) AND (:SYS_B_24 = :SYS_B_25)AND ( (T1161.C112 LIKE :SYS_B_26) OR (T1161.C112 LIKE :SYS_B_27) OR (T1161.C112 LIKE :SYS_B_28) OR (T1161.C112 LIKE :SYS_B_29) OR (T1161.C112 LIKE :SYS_B_30) OR (T1161.C112 LIKE :SYS_B_31) OR (T1161.C112 LIKE :SYS_B_32) OR (T1161.C112 LIKE :SYS_B_33) OR (T1161.C112 LIKE :SYS_B_34) OR (T1161.C112 LIKE :SYS_B_35) OR (T1161.C112 LIKE :SYS_B_36) OR (T1161.C112 LIKE :SYS_B_37) OR (T1161.C112 LIKE :SYS_B_38) OR (T1161.C112 LIKE :SYS_B_39) OR (T1161.C112 LIKE :SYS_B_40) OR (T1161.C112 LIKE :SYS_B_41) OR (T1161.C112 LIKE :SYS_B_42) OR (T1161.C112 LIKE :SYS_B_43) OR (T1161.C112 LIKE :SYS_B_44) OR (T1161.C112 LIKE :SYS_B_45) OR (T1161.C112 LIKE :SYS_B_46) OR (T1161.C112 LIKE :SYS_B_47) OR (T1161.C112 LIKE :SYS_B_48) OR (T1161.C112 LIKE :SYS_B_49) OR (T1161.C112 LIKE :SYS_B_50) OR (T1161.C112 LIKE :SYS_B_51) OR (T1161.C112 LIKE :SYS_B_52) OR (T1161.C112 LIKE :SYS_B_53) OR (T1161.C112 LIKE :SYS_B_54) OR (T1161.C112 LIKE :SYS_B_55) OR (T1161.C112 LIKE :SYS_B_56) OR (T1161.C112 LIKE :SYS_B_57))) ARYSTEM 7.1 patch 11 OS Sun 5.10 Oracle 10.2.0.3.0 - 64bi Can anyone let me know what exactly this query is about? Regards
Re: WebServices - Access-Control-Allow-Origin.
Check the internet connection setup on your IE: Tools -- Internet options -- Connection From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Benz, Michael Sent: Wednesday, March 27, 2013 3:36 AM To: arslist@ARSLIST.ORG Subject: Re: WebServices - Access-Control-Allow-Origin. ** Hello, Does anyone know anything about this? Regards, Michael Benz Holcim Australia Shared Services www.holcim.com.auhttp://www.holcim.com.au/ From: Benz, Michael Sent: Tuesday, 26 March 2013 8:27 AM To: 'arslist@ARSLIST.ORG' Subject: WebServices - Access-Control-Allow-Origin. Hello World Recently, I've been trying to use web services to display information from change requests, and I get the following error from Chrome Debug console.. XMLHttpRequest cannot load http://Midtier/arsys/WSDL/public/AR Server/CHG_ChangeInterface_WShttp://%3cMidtier%3e/arsys/WSDL/public/%3cAR%20Server%3e/CHG_ChangeInterface_WS. Origin Webhttp://ossc-dev-swb01.devoc.local/ Server is not allowed by Access-Control-Allow-Origin. Now when I run chrome with disabled security, it works. But obviously that's not best practise. From what I read, this means I have to put the following somewhere in the midtier application. Response.setHeader(Access-Control-Allow-Origin,*); But I can't find it anywhere. Has anyone else had this problem, can someone shed some light on it for me? I'm not very good at tomcat configuration so any help would be great Regards, Michael Benz Holcim Australia Shared Services Holcim (Australia) Pty Ltd Suite 201, Level 2, 7-9 Irvine Place Norwest Business Park, Baulkham Hills, NSW 2153 Phone: +61 2 8867 2326 Mobile: +61 429 790 513 www.holcim.com.auhttp://www.holcim.com.au/ _ARSlist: Where the Answers Are and have been for 20 years_ The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years