Re: Getting errors when creating a View Form
Hi Marc, We are using quite a few view forms although none of them are SQL Server only Oracle based tables with our Remedy also using an Oracle database. However your dba may be able to help set this up - have you tried creating a synonym in the remedy schema that points to the table you want to reference? We have done similar setup for other applications in the reverse direction with Oracle tables referenced as if they are part of SQL Server database this approach should work the other way around but may require some setup/work on the Oracle side for access to SQL Server as the Oracle methods for this are not as straightforward as the reverse with SQL Server access to Oracle objects. Take Care, Debra From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Monday, September 12, 2011 9:00 AM To: arslist@ARSLIST.ORG Subject: Getting errors when creating a View Form ** ARServer 7.1, patch 1 Admin Tool,, 7.1 patch 11 SQL 2008 We are attempting to create our first View Form, SQL database to a Oracle database, but we can not create the form. I am pretty sure our problem is the syntax of the table that I am putting in the field before I press Load. The Admin Tool appears to be looking for sysobjects, instead of the Linked Server. The examples in the documentation are poor. Admin Tool error message: Failure during SQL operation to the database : PAEHOWUD351.ASSETCENTER.AC_REMEDY_ASSETLOOKUP_VIEW (ARERR 552). SQL log error message: SQL TID: 003088 RPC ID: 002030 Queue: Admin Client-RPC: 390600USER: D065879 /* Mon Sep 12 2011 11:57:52.7910 */SELECT id from PAEHOWUD351.dbo.sysobjects where name = N'AC_REMEDY_ASSETLOOKUP_VIEW' SQL TID: 003088 RPC ID: 002030 Queue: Admin Client-RPC: 390600USER: D065879 /* Mon Sep 12 2011 11:57:52.7910 */*** ERROR *** Invalid object name 'PAEHOWUD351.dbo.sysobjects'. (SQL Server 208) We are able to query the Linked Server from SQL Studio. I am able to create a view on the SQL server that looks at the Linked Server and create the View Form using that view, but when I run a selection from the View Form, it takes 50+ seconds. Can anyone provide the syntax that should be put in as the table we want to be pointing to? Again, the documentation is not very clear. Thank you in advance. Marc _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Un-expected Filter/Filter Guide Processing when errors occur....
Thanks Thad! Actually I'm not using a specific error handler filter not sure what that would be. My next filter checks if the number of rows updated by the Push is 1 (via the LASTCOUNT value) if it is not 1 I do a Message action of type Error to alert the user. The filter log shows this error caused the current filter guide to stop processing steps and all my push changes are not applied to the database. However the next filter guide called gets called but only the Set fields and Run Process action actually does anything the other Push fields action is not applied. Below is excerpt from the filter log where this happens. Thanks Debra FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Check_Row_Update`! (505) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425 zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /tmp/report_error.sh 06/30/11 3:01:54 PM - Error Processing Device Update Transaction ID=0002070 Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Message FLTR TID: 07 RPC ID: 203425Error Processing Device Transaction #: 0002070 FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 2: Call Guide (this is the 2nd guide which I would expect not to be called at all) FLTR TID: 07 RPC ID: 203425 Checking PRN_CMS:LaneAuditReport_Verify_Updates`! (510) FLTR TID: 07 RPC ID: 203425 -- Failed qualification -- perform else actions FLTR TID: 07 RPC ID: 203425 0: Set Fields FLTR TID: 07 RPC ID: 203425 audit_error_message (536871633) = Processing records failed - Records prepared= 8 and Records Processed=6 FLTR TID: 07 RPC ID: 203425 audit_report_status (536871632) = ErrorX FLTR TID: 07 RPC ID: 203425 zTmp_TokenStr (536871643) = 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 1: Process FLTR TID: 07 RPC ID: 203425 /opt/ars/server/db/report_error.sh 06/30/11 3:01:54 PM - Error Processing Audit Report, Prepared Records != Processed Records. Report ID=294 FLTR TID: 07 RPC ID: 203425 2: Push Fields FLTR TID: 07 RPC ID: 203425 2: Push Fields (ARERR 73001) FLTR TID: 07 RPC ID: 203425 Error while performing filter action FLTR TID: 07 RPC ID: 203425 Error while performing filter action Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, July 01, 2011 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: Un-expected Filter/Filter Guide Processing when errors occur ** Debra, You say: If any of the push actions fail a subsequent filter does the following Are you using an Error Handler filter to process the fail condition? If so, once your error handler filter handles the error, the system considers the error handled and processing continues as if there were no error. Phasing is also affected. Check the Workflow Objects guide for details (I only 7.1 docs handy, so I don't have a page # for your version). Hope that helps, Thad On Thu, Jun 30, 2011 at 3:49 PM, Anderson Debra (PRN) debra_ander...@prn.com wrote: ** Hi Everyone! Hoping folks on the list with more experience might be able to explain unexpected filter processing behavior I am seeing. We are using 7.0 version Here is an overview of how my workflow is setup 1 - Filter 1A fires on Modify on Form_A - Note this filter name is using thte `! syntax for override filter phasing. Actions are in this: Set fields Call Guide 2A using
Un-expected Filter/Filter Guide Processing when errors occur....
Hi Everyone! Hoping folks on the list with more experience might be able to explain unexpected filter processing behavior I am seeing. We are using 7.0 version Here is an overview of how my workflow is setup 1 - Filter 1A fires on Modify on Form_A - Note this filter name is using thte `! syntax for override filter phasing. Actions are in this: Set fields Call Guide 2A using server-side table loop Call Guide 2B Filter 2A - seems to work as expected (based on review of filter log). It calls several filters that loop thru table entries again using `! syntax. Each entry in the table results in a Push field action to two forms B C. If any of the push actions fail a subsequent filter does the following 1 - Run Process command to run unix script to add entry to log server file 2 - Message action of type Error is reported to end-user As expected after this error occurs none of the push field changes are applied to the database - this is what I want to happen J However after the error occurs the top level filter still calls Guide 2B (I see this in the filter log after the error is logged) however the actions in the Guide are not fully executed but the one a Run Process action on a unix shell command does execute but after this runs the next actions which are Set/Push fields are not executed. Any ideas why my 2nd Call Guide action would execute after the first Guide called produces an error - my expectation was that if the first Guide produced an error the filter that called the guide would stop processing all together and the 2nd Guide would not be executed at all. Any thoughts? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Any experiences using Run Process Application-Release-Pending with Filters/Filter Guides and `!
Hi Everyone, I am working a new function in our custom app (ARS 7.0) that involves somewhat complex filter processing - at least for me J Basically when a user updates a record's status to a certain value a filter is run that calls a Filter Guide which has several filters some of these also call filter guides that are in most cases doing table loop processing. These filters will push new records into a new transaction form - these records will need to processed at the end of the filter guide. My approach was to have the final filters do the following steps to process the transactions added during the previous filter guide steps 1)Call Run Process Application-Release-Pending 2)Call a final Filter Guide which would do a table loop on a table based on the transaction form records just added. Does anyone have any experience using the Application-Release-Pending command? Any suggestions for how to use and/or best method to troubleshoot? Also I have named the filters in my guides that are doing the push fields to the transaction table with a `! prefix to try to ensure the pushed records are available later in the workflow of the filter guide. However not sure how the `! would work when it's a filter that is part of a fairly involved filter guide process. My results are unexpected - I would have expected either no rows to be processed from the table loop or all rows but instead the loop processed one row from the table when I added the Run Process Application-Release-Pending and also processed one row when I removed the Run Process action. Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Data validation checks when user uses the Modify All option in the client
Hi Everyone, We're using ARS 7.0 all custom code system. In the past I have pretty much not allowed user's to use the modify ALL option however I have a new feature where there is a strong request to allow this option. Unfortunately I am having some challenges getting workflow that would do data validation to work when more than one record is modified. I believe filters are probably the only option to that is workable (instead of active links) but even in this case some of my On Modify filters do not see to catch data validation issues in all cases. Part of the workflow involves setting some fields via queries to other forms to verify existing data. Does anyone have any suggested best practices for handling this type of process? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Data validation checks when user uses the Modify All option in the client
I agree with Fred filters really are the only option I can see working. However, has anyone ever seen a case where set fields doesn't seem to work across all records selected for Modify All. Do you know if any issue with how fields are set - via SQL query vs. regular form query? Thanks Debra -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 14, 2011 2:01 PM To: arslist@ARSLIST.ORG Subject: Re: Data validation checks when user uses the Modify All option in the client Filters are the only way to go to validate data during Modify All. All Set Fields used to pull in data (needed for validation) should also be in the Filters. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Anderson Debra (PRN) Sent: Tuesday, June 14, 2011 3:52 PM To: arslist@ARSLIST.ORG Subject: Data validation checks when user uses the Modify All option in the client ** Hi Everyone, We're using ARS 7.0 all custom code system. In the past I have pretty much not allowed user's to use the modify ALL option however I have a new feature where there is a strong request to allow this option. Unfortunately I am having some challenges getting workflow that would do data validation to work when more than one record is modified. I believe filters are probably the only option to that is workable (instead of active links) but even in this case some of my On Modify filters do not see to catch data validation issues in all cases. Part of the workflow involves setting some fields via queries to other forms to verify existing data. Does anyone have any suggested best practices for handling this type of process? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St . San Francisco, CA . 94107 PRN | media where when it matters ___ 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
Issues with Filter processing infinite looping - Please help!
Hi Everyone, I have been asked to implement a feature that has me stumped and wanted to see what others might do to implement the following workflow 1) Parent form has a status field and can have many child records 2)Child form also has a status field with similar options Part 1 - User wants to have child records' status updated if Parent is set to a certain status value. Since there are a couple intermediate tests to perform on this I implemented it using Filter that calls a Filter Guide. Part 2 - User wants Parent status updated if all the child records have been updated to a certain status value - so if the last child record is updated to status value then the parent should be updated. Again implemented via Filter that calls filter guide. Here is where there are problems if this workflow fires and updates the parent record the workflow for part 1 will fire and the loop begins. I tried to use the value of the $GUIDE$ property to prevent the loop but no success. Any suggestions? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Issues with Filter processing infinite looping - Please help!
Hi Everyone, I have been asked to implement a feature that has me stumped and wanted to see what others might do to implement the following workflow 1) Parent form has a status field and can have many child records 2)Child form also has a status field with similar options Part 1 - User wants to have child records' status updated if Parent is set to a certain status value. Since there are a couple intermediate tests to perform on this I implemented it using Filter that calls a Filter Guide. Part 2 - User wants Parent status updated if all the child records have been updated to a certain status value - so if the last child record is updated to status value then the parent should be updated. Again implemented via Filter that calls filter guide. Here is where there are problems if this workflow fires and updates the parent record the workflow for part 1 will fire and the loop begins. I tried to use the value of the $GUIDE$ property to prevent the loop but no success. Any suggestions? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Strange behavior using $GUIDE$ value in Filter Run If Condition
Hi Everyone, We are using ARS 7.0.01 I am attempting to use the $GUIDE$ key word for the first time in order to prevent circular looping on some filter guides I am developing. However when I use the test $GUIDE$ = $NULL$ in my filter's run if condition and there is no Guide involved the test fails when it should not!! If I replace the test with $GUIDE$= this seems to work but doesn't seem like most robust test! Has anyone else experienced this behavior - this seems like a simple test that should work so not sure what I am missing! Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Any way to remove clear option from search menus?
Hi Everyone, Using Remedy 7.0.01. Have a simple search style menu but do *not* want the clear option included in the menu which is used for a Required field. I checked the Docs and KB and didn't find any tips on how this might be done. Any tips on how to do this? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Any way to remove clear option from search menus?
Hi Everyone, Using Remedy 7.0.01. Have a simple search style menu but do *not* want the clear option included in the menu which is used for a Required field. I checked the Docs and KB and didn't find any tips on how this might be done. Any tips on how to do this? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Basic question on Web Services Setup and Submitter field
Hi Everyone, I am very new to Remedy Web Services doing a Proof-of-Concept for our department to see if we want to use this feature. Remedy 7.0.01 Solaris I have created some sample web-services on a test form and have successfully been able to create, set and get records using web-services calls to Remedy. However I have not figured out a good way to prevent the Submitter field from being included in the wsdl xml for create/set operations. I don't want external consumers of the web-service to see this field as it would be automatically set. I was able to make the field optional but whenever I try to delete it from the mapping for the web service it does not get removed. Any suggestions? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Any known workarounds for using Remedy ODBC driver on 64-bit windows platform?
Hi Everyone, We have a user group that is having issues trying to use the Remedy ODBC driver to query remedy forms via excel. They are running on a 64-bit windows platform which I know if not officially supported but was wondering if anyone knows of any workaround for using this platform. Here are some details I received from the user. We are using remedy version 7.0.01. 1. I'm using Windows 7 Ultimate 7600.16695.amd64fre.win7_gdr.101026-1503. 2. Remedy driver was installed per the installation instructions 3. On 64 bit Windows, using 64 bit ODBC, can't even configure the driver or add a datasource using it (it doesn't even show up on the add datasource list). Attempting to configure the driver produces error The specified DSN contains an architecture mismatch between the Driver and the Application 4. Using c:\windows\syswow64\odbcad32.exe, can configure the driver and even test it successfully, however, on 32-bit Office, get error unable to obtain list of tables from the datasource when trying to access Remedy AR ODBC. On 64-bit Office, get error The specified DSN contains an architecture mismatch between the Driver and the Application when trying to access the datasource. All of my users on 32-bit windows platforms have no issues using the driver to query remedy data from excel! Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Enabling Web Service in Remedy
I recently posted a similar question and was referred to a very useful KB article which allowed me to get Web Services running successfully. Look for KM-00024940 KB article while the topic says for Solaris I would expect that much of the steps would apply to AIX as well! Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Vinay Vermani Sent: Wednesday, January 26, 2011 6:44 AM To: arslist@ARSLIST.ORG Subject: Re: Enabling Web Service in Remedy ** This happens mostly when plugin is not installed properly or ARSystem configuration is missing information about this plugin Check ar.cfg file for Server-Plugin-Alias: ARSYS.ARF.WEBSERVICE ARSYS.ARF.WEBSERVICE ServerName:PortNo Check pluginsvr_config.xml file for plugin ARSYS.ARF.WEBSERVICE If its missing in both place, you would like to rerun the installer as Frank suggested. If you see it in pluginsvr_config.xml and not in ar.cfg, than add Server-Plugin-Alias: ARSYS.ARF.WEBSERVICE ARSYS.ARF.WEBSERVICE ServerName:PortNo to your ar.cfg file. Check AR intergeration Guide for more details about plugin configuration. I hope find this information useful for your troubleshooting. Thanks Vinay Vermani On Wed, Jan 26, 2011 at 9:04 AM, Frank Caruso caruso.fr...@gmail.com wrote: ** Rerun the installer and choose the WebServices options. Also, search the arslist for this topic as it has been recently discussed. On Wed, Jan 26, 2011 at 8:58 AM, Pavan Kumar pava...@adea.com wrote: ** Can any one help me with this please. Thanks Regards, Pavan Kumar From: Pavan Kumar Sent: Tuesday, January 25, 2011 3:42 PM To: 'arslist@ARSLIST.ORG' Subject: Enabling Web Service in Remedy Hi Team, We are trying to publish AR system functionality as a web service. This is for integrate Remedy to a web application (Aperture Vista). But we get the following error while we try to call the web service. ARERR [8755] The specified plug-in does not exist. : ARSYS.ARF.WEBSERVICE Can you please help us in activating the web service in the system? Below are the version details of our remedy: Product / Server p25n15e0 Operating System AIX 5.3 Database Oracle 10G AR System 7.0.01 AR Email Engine 7.0.1 JDK/JRE 1.4.0 Mid Tier 7.0.1 Java version 1.4.2 IIS 6 Servlet Exec 5.1.2 BMC Financial Management BMC Atrium CMDB 2.0.1 patch 003 BMC Incident Management 7.0.2 patch 4 BMC Problem Management 7.0.2 BMC Service Level Management 7.0.2 patch 4 BMC Asset Management 7.0.2 patch 4 BMC Change Management 7.0.2 patch 4 Remedy Approval Server 7.00.01 Remedy Assignment Engine 7.00.01 Please let me know if you need any further details. Any help is much appreciated. Thanks Regards, Pavan Kumar Team Lead __ | Error! Filename not specified. http://www.valtech.com/com/index.html | www.valtech.com http://www.valtech.com/ | Wire line: +91 80 6762 4134 | Mobile: +91 9880444885 | pava...@adea.com Adea...Now a Valtech company CONFIDENTIALITY CAUTION/DISCLAIMER Transmission of this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any action in reliance upon this information by the person or entity other than the intended recipient is prohibited and would be at their risk and responsibility. While Adea takes adequate protection against viruses, neither the sender of this mail nor Adea accepts any responsibility or liability for interception, corruption, delay or any virus introduced by this e-mail or any attachment. If you are not the intended recipient or if you have received this in error, please delete this email with attachments, if any, and inform the sender. Thank you for your understanding and co-operation _attend WWRUG11 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
Re: View of a View?
I would 2nd Ben's view on this - I also have created numerous views on our Remedy database to facilitate many kinds of features and reports. So far I have not seen any issues basing my view on the existing views. Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Tuesday, January 25, 2011 8:50 AM To: arslist@ARSLIST.ORG Subject: Re: View of a View? ** I do all my views on the ARS views exclusively. These can be quite complex and include SQL functions, queries, processing of those queries, unions, sub views, etc. I think it's a lot better than basing in on the Txxx ( Cxx) fields. The simple fact that your source SQL uses terms like T1982 and C91818165 makes it very ugly to maintain. A view on a view (especially the one that ARS creates) is NO problem and NO trouble. If there is any performance issues with a complex view there are lots of database things you could do (like instantiated views as a worst case, simple indexes as needed on the ARS tables through the ARS developer tool). That being said, you could make a complicated view where you derive the T number from arschema and the C number from arfield etc. But why bother? Again, the SQL source will be more complex and harder to maintain. The ARS view is one to one with the underlying T table. There is no performance penalty for using it and the large benefit of an understandable SQL source. Cheers Ben www.softwaretoolhouse.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: January-25-11 17:26 To: arslist@ARSLIST.ORG Subject: Re: View of a View? ** Thanks everyone for your input. The 3 columns were just to show what a view of the view looked like. I actually need the view to have about 20 columns. We are creating a DB Link so that this data can be imported into a Data Warehouse for heavy duty reporting capabilities. We usually don't like our DB links to go straight to the T tables, so we are creating a view. The reason why we are not using the AR SYSTEM created view is because we need to normalize some of the data and create new fields etc (that I don't want/need in an actual form). I guess I could still create a self-join form, but I think I like creating views better. But I will not be creating a view on top of a view. Sounds like trouble If we do a migration (which we are actually going to be doing in the next couple of months - we are getting a new production server), I'll just have to copy and recreate the views if the T # for the tables change correct? Thanks everyone! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, January 24, 2011 8:29 PM To: arslist@ARSLIST.ORG Subject: Re: View of a View? ** Also with regards to maintainability, if you are migrating code through various environments to get to production, the T# for that form isn't guaranteed to be the same. It most likely is, but it depends on how tortured your migration process is (or was, before you started working somewhere *sigh*). The schema id doesn't come along in a *.def file. Have you considered keeping it all in Remedy, and just creating a self-join form with only those three fields showing? You'll end up with an Oracle view anyway if you need it for outside integrations or whatever, and you don't have to worry about maintaining stuff at the DB level. Thad On Mon, Jan 24, 2011 at 2:44 PM, Axton axton.gr...@gmail.com wrote: ** It's measurably more maintainable to create the view against the table. Any time you modify a form, the views that ARS creates on top of the tables is dropped and recreated. This is because there is no way in the db to alter the view. When the view is dropped and recreated it may invalidate the view you have that is built on top of that view, esp if the owner of the view is not the ars db account. I've found that it's best not to create or alter objects in the ars schema. They tend to turn into something that resembles space debris after a while. On Mon, Jan 24, 2011 at 4:22 PM, Roberts, Chas crobe...@riversidecountyit.org wrote: Sort of depends if you want to
Question on using Email Subject Line text with Inbound Email processing
Hi Everyone, I am doing a POC for use of Remedy Inbound email for external customers to submit requests and have a question. We are using: Remedy 7.0.01 Solaris Oracle 10g I have successfully setup an MBOX on Solaris and have inbound emails being successfully parsed and submitting records into a test form. However I would like to be able to take the Subject line value of the user's email message and pass this value into one of my form fields. I have read over the Email Admin Guide and also searched BMC Remedy KB but didn't find any tips that would advise me how I might take values stored in the Email message form and have them passed to the destination form when a Submit action is parsed and processed. I am a complete newbie for this feature so any pointers are much appreciated. Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Setting up web serivces on ARS existing server
Hi Everyone, We are running ARS 7.0.01 on Solaris with Mid-tier and want to try out Remedy Web Services integration. However I believe when our server was installed (a few years back) the web-services plug-in was not installed. Two Questions 1 - How can I confirm the web-service plug-in is not installed. I don't see any of the expected forms in the system for web services and the ar.conf file doesn't list any web-service plug-in. 2 - The install documentation doesn't give a lot of help on adding a plug-in to an existing system. I have to be careful not to mess up our development server as its used by several teams. Does anyone have suggestions on how to install/add this plug-in with minimal risk to the existing system? Thanks Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Setting up web serivces on ARS existing server
Hi Fred,
Thanks for the tip. I tried this process but got an error on a missing class
file for the plug-in startup.
In searching thru the jar files in the ar server bin area didn't find any with
this class or class path included.
Is it possible the file that contains this class would be missing if the
plug-in was not selected during the original install?
Exception in thread main java.lang.NoClassDefFoundError:
com/remedy/arsys/api/Util
390695 : Can't locate the WebServiceSoapClient class (ARERR 9130)
Any idea where this class file might be located?
Thanks
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, December 28, 2010 12:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
If you have the line Plugin: {path_to_file}/libwebservice.so in your ar.conf
then the plugin is installed. There are no forms required for the plugin to
function.
To install the plugin do the following:
First Find the file libsebservice.so is on your system.
Second Add a line in the ar.cfg Plugin: {path_to_file}/libwebservice.so
Third Restart the arserver processes
To remove the plugin simply comment out the plugin line in the ar.conf and
restart the arserver processes.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Anderson Debra (PRN)
Sent: Tuesday, December 28, 2010 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Setting up web serivces on ARS existing server
**
Hi Everyone,
We are running ARS 7.0.01 on Solaris with Mid-tier and want to try out Remedy
Web Services integration.
However I believe when our server was installed (a few years back) the
web-services plug-in was not installed.
Two Questions
1 - How can I confirm the web-service plug-in is not installed. I don't see
any of the expected forms in the system for web services and the ar.conf file
doesn't list any web-service plug-in.
2 - The install documentation doesn't give a lot of help on adding a plug-in to
an existing system. I have to be careful not to mess up our development
server as its used by several teams. Does anyone have suggestions on how to
install/add this plug-in with minimal risk to the existing system?
Thanks
Debra
Debra Anderson
T 415.808.9118 | F 415.808.3535
600 Harrison St . San Francisco, CA . 94107
PRN | media where when it matters
___
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: Setting up web serivces on ARS existing server
Thanks Atul.
I'm trying to avoid a re-install if possible so as not to compromise the
existing system - prefer if there is an install option to add a
component without a complete re-install.
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Atul Vohra
Sent: Tuesday, December 28, 2010 1:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
You could reinstall ars and select the web service option
Atul Vohra
On Dec 28, 2010, at 4:39 PM, Anderson Debra (PRN)
debra_ander...@prn.com wrote:
Hi Fred,
Thanks for the tip. I tried this process but got an error on a
missing class file for the plug-in startup.
In searching thru the jar files in the ar server bin area didn't find
any with this class or class path included.
Is it possible the file that contains this class would be missing if
the plug-in was not selected during the original install?
Exception in thread main java.lang.NoClassDefFoundError:
com/remedy/arsys/api/Util
390695 : Can't locate the WebServiceSoapClient class (ARERR 9130)
Any idea where this class file might be located?
Thanks
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, December 28, 2010 12:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
If you have the line Plugin: {path_to_file}/libwebservice.so in your
ar.conf then the plugin is installed. There are no forms required for
the plugin to function.
To install the plugin do the following:
First Find the file libsebservice.so is on your system.
Second Add a line in the ar.cfg Plugin:
{path_to_file}/libwebservice.so
Third Restart the arserver processes
To remove the plugin simply comment out the plugin line in the ar.conf
and restart the arserver processes.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Anderson Debra (PRN)
Sent: Tuesday, December 28, 2010 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Setting up web serivces on ARS existing server
**
Hi Everyone,
We are running ARS 7.0.01 on Solaris with Mid-tier and want to try out
Remedy Web Services integration.
However I believe when our server was installed (a few years back) the
web-services plug-in was not installed.
Two Questions
1 - How can I confirm the web-service plug-in is not installed. I
don't see any of the expected forms in the system for web services and
the ar.conf file doesn't list any web-service plug-in.
2 - The install documentation doesn't give a lot of help on adding a
plug-in to an existing system. I have to be careful not to mess up our
development server as its used by several teams. Does anyone have
suggestions on how to install/add this plug-in with minimal risk to the
existing system?
Thanks
Debra
Debra Anderson
T 415.808.9118 | F 415.808.3535
600 Harrison St . San Francisco, CA . 94107
PRN | media where when it matters
___
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
___
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: Setting up web serivces on ARS existing server
I did check the websvc70.jar file located in my server bin but this file does
not contain the class that is reported in the error.
Also I don't have any of the settings or files you mention below
ARF-Java-Class-Path is not in my ar.conf file anywhere and I don't have a file
called pluginsvr_config.xml anywhere where my ars files are installed - perhaps
these items are only setup if you install specific plug-ins during the install
process.
Thanks again!
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, December 28, 2010 2:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
It is probably looking for websvc70.jar (since you are on ARS 7.0) and should
be defined on a ARF-Java-Class-Path line in the ar.conf. The file may be
there, just the line missing in the conf.
If you have the ar_install script look in it for ARF-Java-Class-Path. It
should tell you what needs to be on that line
i.e.
less ar_install
/ARF-Java-Class-Path
There is also a pluginsvr/pluginsvr_config.xml file that has a
ARSYS.ARF.WEBSERVICE section. Make sure the path in there is correct.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Anderson Debra (PRN)
Sent: Tuesday, December 28, 2010 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
Hi Fred,
Thanks for the tip. I tried this process but got an error on a missing class
file for the plug-in startup.
In searching thru the jar files in the ar server bin area didn't find any with
this class or class path included.
Is it possible the file that contains this class would be missing if the
plug-in was not selected during the original install?
Exception in thread main java.lang.NoClassDefFoundError:
com/remedy/arsys/api/Util
390695 : Can't locate the WebServiceSoapClient class (ARERR 9130)
Any idea where this class file might be located?
Thanks
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, December 28, 2010 12:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting up web serivces on ARS existing server
If you have the line Plugin: {path_to_file}/libwebservice.so in your ar.conf
then the plugin is installed. There are no forms required for the plugin to
function.
To install the plugin do the following:
First Find the file libsebservice.so is on your system.
Second Add a line in the ar.cfg Plugin: {path_to_file}/libwebservice.so
Third Restart the arserver processes
To remove the plugin simply comment out the plugin line in the ar.conf and
restart the arserver processes.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Anderson Debra (PRN)
Sent: Tuesday, December 28, 2010 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Setting up web serivces on ARS existing server
**
Hi Everyone,
We are running ARS 7.0.01 on Solaris with Mid-tier and want to try out Remedy
Web Services integration.
However I believe when our server was installed (a few years back) the
web-services plug-in was not installed.
Two Questions
1 - How can I confirm the web-service plug-in is not installed. I don't see
any of the expected forms in the system for web services and the ar.conf file
doesn't list any web-service plug-in.
2 - The install documentation doesn't give a lot of help on adding a plug-in to
an existing system. I have to be careful not to mess up our development
server as its used by several teams. Does anyone have suggestions on how to
install/add this plug-in with minimal risk to the existing system?
Thanks
Debra
Debra Anderson
T 415.808.9118 | F 415.808.3535
600 Harrison St . San Francisco, CA . 94107
PRN | media where when it matters
___
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: Upgrade AR server to 7.5P007 from 7.01
Hi Andrew, Please let me know how this goes. We're pretty much in the same spot running 7.0 with 100% custom app and looking to plan for an upgrade to 7.5 or 7.6. Good Luck! Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Andrew Fremont Sent: Tuesday, November 23, 2010 11:06 AM To: arslist@ARSLIST.ORG Subject: Upgrade AR server to 7.5P007 from 7.01 ** Hi, It seems the upgrading is straightforward, but I want to check with the list for sure. We're planning to do the upgrade our server from AR 7.01 to latest AR 7.5 P007 for our Remedy homegrown application. There is no CMDB or ITSM suites. Is it just a mater of running the installer 7.5 P007 on our server, or we have to do that in steps, first upgrade server to 7.1, then 7.5? Thanks, AF AR Server: 7.0.01 Patch 007 Windows 2003 Oracle: 10.2.0.4.0 - 64bit _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: Hidden Fields
Lisa, I think you are correct. I have struggled with this exact problem and have not found any other methods to hide this fields from users. Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, November 19, 2010 2:21 PM To: arslist@ARSLIST.ORG Subject: Hidden Fields ** Is there any way (other than creating a view or permissions) to not only hide a field via the field properties, but to hide these fields to keep people from adding them to reports as well. I have hidden temp fields and I don't want the customer to choose these fields when creating reports (there would be no reason for them to). I think the answer is that there is no other way, but just wanted to make sure. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-602-9460 cell lisa.ke...@te.com _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
Issues with Spanish Language Characters in ARS
Hi Everyone, We have recently added an office in Mexico and are having some issues with Spanish language characters not being displayed/saved correctly in our Remedy client/DB. Here is overview of system info: Remedy ARS 7.0.01 Oracle 10g Oracle NLS_CHARACTERSET is WE8MSWIN1252 Solaris OS I am able to manually insert Spanish characters into tables in the db and the data is correct. When a user types in data in a Remedy form the characters are shown correctly during entry but once the data is saved the characters become question marks and are not saved into the database as the correct value. I checked the ARS server settings and I don't think there is anything there to change for this. My experience with databases suggests changing the database client environment settings for the ARS server at startup but wanted to get confirmation that this would be the proper approach/best practice. Most likely the oracle NLS_LANG and etc environment settings would be the ones I would change! Thanks for your feedback. Debra Debra Anderson T 415.808.9118 | F 415.808.3535 600 Harrison St * San Francisco, CA * 94107 PRN | media where when it matters This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Advanced Query formulas on Date field types vs. Datetime types
Hi Everyone, We're on Remedy 7.0. A user came to be with a problem that I never really thought about before and I can't seem to find a good solution. We have some forms that use Date datatype for some fields instead of Datetime date types. For Datetime data type we have many users that do advanced search queries like this for example searching for anything 7 days or more in the future. Mydate = $TIMESTAMP$ + (24*7*60*60) For Date datatypes this type of syntax does not work no records are returned. You can use the constant value $TIMESTAMP$ or $DATE$ but not do any math with it. Does anyone have any ideas how this might be accomplished with an Advanced query? The other area where this might be needed/used is for a Table field qualification but I think if the advanced query can work so can the table qualification. Thanks for any tips you might have! Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are image001.gif
Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system
Hi Jase, Is there a way you can tell if your record is for Company B then you can say if the INC# provided is matched with a Company B record process that update otherwise report it as an error? Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, June 30, 2010 3:27 PM To: arslist@ARSLIST.ORG Subject: Re: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hi Kevin, Yes... Company B is a customer and they also use Remedy. So they want to be able to send us email updates to valid INC's on our side. The problem is they have a INC on their side for the same issue they created with us. So their Subject line says INC1234 - Update, etc. INC1234 on our side is a closed invalid INC totally unrelated to their company and their issue. My answer was We HAVE to have the correct INC number for Remedy to correctly find and update the valid INC on our side.We don't care what THEIR INC number is. As long as they send us invalid INC numbers, Remedy can't read their minds. If Company B can't send us the correct INC #, then I am stuck. GIGO - right? :-) Thanks, Jase On Wed, Jun 30, 2010 at 5:47 PM, Kevin Begosh kbeg...@gmail.com wrote: ** so Company B has a valid integration with your system to send you updates via INC # in the subject line? On Wed, Jun 30, 2010 at 5:27 PM, Jase Brandon jasebran...@gmail.com wrote: ** Hi Christie, Yes - but the real issue is they are trying to update INC's on our side with valid numbers. My problem is that if they continue to send us their INC numbers, their valid INC on our side is never going to get the proper work info update or proper attention. Thanks, Jase On Wed, Jun 30, 2010 at 3:59 PM, Pargeter, Christie :CO IS cparg...@lhs.org wrote: ** If they always use the same from address couldn't you use that in your filter to say don't process these? From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of Jase Brandon Sent: Wednesday, June 30, 2010 12:58 PM To: arslist@ARSLIST.ORG Subject: Email messages with Incident Numbers being sent to Remedy from another Remedy system ** Hello All, This is a weird one: I work for Company A, Company B also uses Remedy and sends us an email with Company B's INC number in the Subj Line. The Filter on AR System Email messages sees the INC number from Company B and goes and updates the worklog for Company A's Remedy INC which is incorrect. My answer was - Don't do that and mgmt says that is an unacceptable answer. :-) Remedy is working correctly, we are being sent bad data. Has anyone else run across this situation in the past? I am pulling my hair out on this one. Thanks, Jase _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are image001.gif
Methods to display PopUp window on mutliple user's client screen without using Remedy Alert client
Hi Everyone, We're using Remedy 7.0. I can't think of a way to do this but perhaps some of you Remedy Gurus may have a solution. My user's want to see a popup message window displayed for all members of their group when a new record is added to a specific form. We are not using Remedy Alert client (which could do this) does anyone know any other method to make this happen - I can't see any way to do this. My plan-B was to suggest an email notification but this is not really what they are asking for. Thanks Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are image001.gif
Re: time convert
Remedy datetime fields are in unix time. Date fields Julian date value. Debra -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Wednesday, June 23, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: time convert Here is an easy one for the list... I've been asked to find a change request from my old 6.3 system which has been decommissioned but the database is saved.. now the request is to find out when the change was done. I have gone into the db and found the request but the time is 1157724000... This means that this would be September 8, 2006, right??? My understanding is that ARS stores time in Unix time, correct? Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Difference between DATE and DATE/TIME
Eric,
Remedy Date fields are Julian date. I have used this oracle function to
cover this type of data to a date value. Just use the 'J' flag with
oracle TO_DATE function.
TO_DATE(REQUESTED_DATE,'J') AS REQ_DATE
Hope this helps!
Debra
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Eric Zhang
Sent: Monday, June 14, 2010 11:58 AM
To: arslist@ARSLIST.ORG
Subject: Difference between DATE and DATE/TIME
Hi, listers.
Does anyone know how DATE is stored in AR System database (Oracle)?
I understand DATE/TIME type filed is stored as seconds since 1/1/1970,
but
what about DATE type field?
I am trying to create a view in Oracle using the following formula:
new_time(to_date('01/01/1970 00:00:00','MM/DD/ HH24:MI:SS')+
(t_schemaid.c_column_num/(60*60*24)),'GMT','CDT') My_Date_Time
If the filed is of DATE/TIME data type, the formula works perfectly.
However, if the filed is of DATE data type, it gives the wrong Date.
Thanks,
Eric
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Using Remedy Keyword Constants with ARSPerl Module ars_MergeEntry API
Hi, I am new to using Remedy Perl ARSPerl Module and am trying to figure out how to pass in values equivalent to $TIMESTAMP$ or $SERVERTIMESTAMP$ keywords to a merge function. Here is a snippet of my code but the constants do not evaluate and I end up with invalid date values in the merged (updated) record. $ar_result = ars_MergeEntry($connection,$store_schema,4, $fldid_store_id,$store_id, $fldid_latitude,$latitude, $fldid_longitude,$longitude, $fldid_geocode_update_date,AR_KEYWORD_SERVERTIMESTAMP, $fldid_modified_date,AR_KEYWORD_SERVERTIMESTAMP, $fldid_modified_by, $modified_by); Any suggestions? Thanks Debra -- -- -- -- -- -- -- -- -- -- Debra Anderson 415 808 9118 direct | 600 Harrison St., 4th Floor, San Francisco CA 94107 Tomorrow's Network for Today's Shopper http://www.prn.com P Think Green- please do not print this email unless necessary This e-mail (including any attachments) is meant for only the intended recipient of the transmission, and may include confidential information. If you are not the intended recipient or you received this e-mail in error, any review, use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this message in error, please notify the sender immediately by telephone at (415) 808-3500 or by return e-mail and delete this e-mail, along with any attachments and copies, from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are image001.gif
