CMDB 7.5 Service Catalog Mapping
Hi All, In the 'BMC Atrium CMDB 7.5.00 Administrator's Guide', Chapter 4, you can see how to map business services to technical services in the Service Catalog. If I try this on CMDB 7.5 Patch 1 I can get the technical services mapped to business services in the Service Catalog of the CMDB UI. However, if I close the CMDB UI and re-open it then the technical services are no longer mapped. At no time during this process do I see any relationships created in the base relationship form. Has anyone tried this and got the mapping to work? WIN 2008 SQLServer 2008 CMDB 7.5 Patch 1 ARS 7.5 Patch 1 Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 7.5 Service Catalog Mapping
Peter Am assuming you are doing this in your personal sandbox? Are you promoting the changes to BMC.Asset at all? Matt Hi All, In the 'BMC Atrium CMDB 7.5.00 Administrator's Guide', Chapter 4, you can see how to map business services to technical services in the Service Catalog. If I try this on CMDB 7.5 Patch 1 I can get the technical services mapped to business services in the Service Catalog of the CMDB UI. However, if I close the CMDB UI and re-open it then the technical services are no longer mapped. At no time during this process do I see any relationships created in the base relationship form. Has anyone tried this and got the mapping to work? WIN 2008 SQLServer 2008 CMDB 7.5 Patch 1 ARS 7.5 Patch 1 Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 7.5 Service Catalog Mapping
Peter Also can you confirm you have a Provider Organisation specified? Matt Hi All, In the 'BMC Atrium CMDB 7.5.00 Administrator's Guide', Chapter 4, you can see how to map business services to technical services in the Service Catalog. If I try this on CMDB 7.5 Patch 1 I can get the technical services mapped to business services in the Service Catalog of the CMDB UI. However, if I close the CMDB UI and re-open it then the technical services are no longer mapped. At no time during this process do I see any relationships created in the base relationship form. Has anyone tried this and got the mapping to work? WIN 2008 SQLServer 2008 CMDB 7.5 Patch 1 ARS 7.5 Patch 1 Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Supported Versions / FD / Patches
Have a question: About support going back 2 versions right... 7.5.2 - minor 7.5.1 -- minor 7.5 --- Major 7.1 -- Major We are still here right? Put the X here. Why is it then that the FD 1.6.002 Patch that just came out only works with 7.5 ! because they are no longer patching FD in version 7.1 ! What is the deal here ! -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 7.5 Service Catalog Mapping
Matt, Thanks for the replies. I take it you can create the mappings and see them as relationship CIs?. Yes I'm doing this in my personal sandbox and have organisations specified. If I promote to the Asset dataset I can see the mapped technical services there. However, if I close the UI then re-open it the mappings are not there. I'm beginning to suspect a background issue with the UI. In the query console I can't pull down the drop-down arrow for a CI to create a relationship. Cheers Peter Peter Also can you confirm you have a Provider Organisation specified? Matt Hi All, In the 'BMC Atrium CMDB 7.5.00 Administrator's Guide', Chapter 4, you can see how to map business services to technical services in the Service Catalog. If I try this on CMDB 7.5 Patch 1 I can get the technical services mapped to business services in the Service Catalog of the CMDB UI. However, if I close the CMDB UI and re-open it then the technical services are no longer mapped. At no time during this process do I see any relationships created in the base relationship form. Has anyone tried this and got the mapping to work? WIN 2008 SQLServer 2008 CMDB 7.5 Patch 1 ARS 7.5 Patch 1 Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: CMDB 7.5 Service Catalog Mapping
Peter I've not tried it yet. I'm running Patch 1 so will have a go one evening, if you don't sort it in the interim. Matt Matt, Thanks for the replies. I take it you can create the mappings and see them as relationship CIs?. Yes I'm doing this in my personal sandbox and have organisations specified. If I promote to the Asset dataset I can see the mapped technical services there. However, if I close the UI then re-open it the mappings are not there. I'm beginning to suspect a background issue with the UI. In the query console I can't pull down the drop-down arrow for a CI to create a relationship. Cheers Peter Peter Also can you confirm you have a Provider Organisation specified? Matt Hi All, In the 'BMC Atrium CMDB 7.5.00 Administrator's Guide', Chapter 4, you can see how to map business services to technical services in the Service Catalog. If I try this on CMDB 7.5 Patch 1 I can get the technical services mapped to business services in the Service Catalog of the CMDB UI. However, if I close the CMDB UI and re-open it then the technical services are no longer mapped. At no time during this process do I see any relationships created in the base relationship form. Has anyone tried this and got the mapping to work? WIN 2008 SQLServer 2008 CMDB 7.5 Patch 1 ARS 7.5 Patch 1 Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
View Forms and Synoyms....
Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Need to make an error message more friendly.
Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
I use display forms to create more user friendly error messages. They look a lot nicer and are more user friendly Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: Wednesday, May 27, 2009 10:38 AM To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
This one is a bane to our society...but unfortunately no solution that I'm familiar with. Sorry. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: Wednesday, May 27, 2009 8:38 AM To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: View Forms and Synoyms....
I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms ** Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: View Forms and Synoyms....
Yes it does work from the SQL Client. Sorry, I should have specified that. Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms ** I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms ** Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
Hi Nyall, Assuming you are pushing the value of the field Menu on form A1 to the field Menu on form A2. First of all ask yourself is it necessary to have a pattern match of $MENU$ on the menu field on form A2. If it is, then ask yourself why the values for Menu in form A1 don’t match those in form A2. If there is a valid reason that 2008A can appear in form A1 but not in A2, then what do you want to happen? Logically you don’t want an entry to be created in form A2. So, if you don’t want an entry created in form A2 when the Menu value in form A1 is 2008A, you need to create some workflow that checks if the value in form A1 is also valid for form A2. If the check confirms it is valid, do the push, if it isn’t don’t do the push. If you get the workflow correct the user will not be aware that this decision action is happening and they will never get this obscure message again. If however you do want the entry to be created then you need to either replace, or remove, the menu value in form A1 prior to the push to form A2. The same workflow as above to check if it is valid but rather than not doing the push, do it with the 2008A replaced with a valid value or remove it. This will be decided by whether the field menu in form A2 is a required field or not. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 http://www.linkedin.com/in/brianpbishop Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: 27 May 2009 15:38 To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.40/2135 - Release Date: 05/27/09 07:50:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gif
Server name reference in ARTask file - can it be changed/configured
++ Please Read The Disclaimer At The Bottom Of This Email ++ Hi, I was wondering if anybody knows of a way to define the Server parameter value in ARTask files attached to email notifications. We are running in the server group configuration, but the Server value always gets set to the physical server name rather than group alias. As a result, users occasionally cannot access the referenced entry if the source server is not up. We are on Remedy/ITSM 7.0.1. Thanks Jiri Pospisil IT Services LCH.Clearnet * This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify postmas...@lchclearnet.com. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA.Recognised as a Clearing House under the Financial Services Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Asset Management 7.01
All, We have installed Asset Management Version 7.01. Does anyone know if their is any specific documentation on what fields are on each Asset form? We wanted to have a description and did not want to have to go through each Asset form. Thanks, Bala ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
My feeling is that system messages make for terrible error messages to display to end users - they're OK for administrators, but don't mean much to the person trying to do their work. As a result, I tend to favor manual data validation and popping up my own user-friendly messages. So, rather than using a pattern to limit input on a field, I would validate it using workflow and then pop up an appropriate error message that you have complete control over. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: Wednesday, May 27, 2009 8:38 AM To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: View Forms and Synoyms....
Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason) */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0325 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0574 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0575 */ Error - can't find table USER_VIEWS (owner = ARADMIN). Attempting to create a View Form on SYS.USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7696 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7699 */ SELECT column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7771 */OK Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, May 27, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Yes it does work from the SQL Client. Sorry, I should have specified that. Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: View Forms and Synoyms....
That won't work because ARAdmin is the owner of the synonym. --Original Message-- From: Lisa Kemes To: Arslist ReplyTo: Arslist Subject: Re: View Forms and Synoyms Sent: May 27, 2009 12:27 PM Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason) */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0325 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0574 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0575 */ Error --Original Message Truncated-- Dave - dave.shell...@tycoelectronics.com (Wireless)
Re: Server name reference in ARTask file - can it be changed/configured
Hi, A long time ago I created a Unix-script that took Server, Form and Request ID as input. It created filters to the Email Attachment form that called the script when a record was created with the correct ARTask-name, using $PROCESS$. The Perform-Action-Add-Attachment replaced the original ARTask-file with the newly created from the server disc. Maybe you should try to create an ARFILTER-plugin that performs something similar without the roundtrip to scripts and server disc? Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. ++ Please Read The Disclaimer At The Bottom Of This Email ++ Hi, I was wondering if anybody knows of a way to define the Server parameter value in ARTask files attached to email notifications. We are running in the server group configuration, but the Server value always gets set to the physical server name rather than group alias. As a result, users occasionally cannot access the referenced entry if the source server is not up. We are on Remedy/ITSM 7.0.1. Thanks Jiri Pospisil IT Services LCH.Clearnet * This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify postmas...@lchclearnet.com. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA.Recognised as a Clearing House under the Financial Services Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ERROR's in LOG-Approve : Some fields truncated...ARWARN 8911
Over and over in the log fileWe are also experiencing stability with Tomcat in a Wintel environment. Action Request System(R) Server Version 7.1.00 Patch 004 200808100630 Arerror.log: Tue Mar 17 15:06:53 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Tue Mar 17 15:10:18 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Tue Mar 17 15:13:23 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Any idea what is causing this? Thanks in advance, Digi -- View this message in context: http://www.nabble.com/ERROR%27s-in-LOG-Approve-%3A-Some-fields-truncated...ARWARN-8911-tp23745429p23745429.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ERROR's in LOG-Approve : Some fields truncated...ARWARN 8911
We were told by Support that this is a known issue but that since it doesn't negatively impact the application, a fix would not be coming for a while. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of DigiLife Sent: Wednesday, May 27, 2009 10:12 AM To: arslist@ARSLIST.ORG Subject: ERROR's in LOG-Approve : Some fields truncated...ARWARN 8911 --=_Part_128139_13885117.1243444294618 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Over and over in the log fileWe are also experiencing stability with Tomcat in a Wintel environment. Action Request System(R) Server Version 7.1.00 Patch 004 200808100630 Arerror.log: Tue Mar 17 15:06:53 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Tue Mar 17 15:10:18 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Tue Mar 17 15:13:23 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Any idea what is causing this? Thanks in advance, Digi -- View this message in context: http://www.nabble.com/ERROR%27s-in-LOG-Approve-%3A-Some-fields-truncated...ARWARN-8911-tp23745429p23745429.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are --=_Part_128139_13885117.1243444294618 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit ** Over and over in the log fileWe are also experiencing stability with bTomcat/b in a Wintel environment. Action Request System(R) Server bVersion 7.1.00 Patch 004 200808100630/b Arerror.log: Tue Mar 17 15:06:53 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (bARWARN 8911/b) Tue Mar 17 15:10:18 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Tue Mar 17 15:13:23 2009 Approve : Some of the fields have been truncated from the results list because the total length of the fields and separators is greater than the maximum allowed 0 (ARWARN 8911) Any idea what is causing this? Thanks in advance, Digi brhr align=left width=300 View this message in context: a href=http://www.nabble.com/ERROR%27s-in-LOG-Approve-%3A-Some-fields-truncated...ARWARN-8911-tp23745429p23745429.html;ERROR's in LOG-Approve : Some fields truncated...ARWARN 8911/abr Sent from the a href=http://www.nabble.com/ARS-%28Action-Request-System%29-f716.html;ARS (Action Request System) mailing list archive/a at Nabble.com.br _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ --=_Part_128139_13885117.1243444294618-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Supported Versions / FD / Patches
Pat, I was of the same understanding as you, until just now. After re-reading the FD patch 2 document, I don't think its referring to the CMDB. By deploying patch 1.6.00.02, you are not able to upgrade to BMC Atrium Discovery and Dependency Mapping (BMC Atrium Discovery) 7.5.00 or 7.5.01. Future releases of BMC Atrium Discovery and Dependency Mapping may support an upgrade from patch 1.6.00.02. Initially, like you, I understood that to say that we couldn't upgrade the CMDB until 7.5 p2 came out. But what it actually says, is that you can't upgrade from 1.6 patch 2 to the 7.5 version of the discovery tools (Atrium Discovery Dependency Mapping - ADDM) until patch 2 for that comes out. It doesn't put any limitations on the CMDB version. I think having the name Atrium in there is what tripped us up. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |patrick zandi remedy...@gmail.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |05/27/2009 06:00 AM | --| | | Subject: | | --| |Supported Versions / FD / Patches | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --| ** Have a question: About support going back 2 versions right... 7.5.2 - minor 7.5.1 -- minor 7.5 --- Major 7.1 -- Major We are still here right? Put the X here. Why is it then that the FD 1.6.002 Patch that just came out only works with 7.5 ! because they are no longer patching FD in version 7.1 ! What is the deal here ! -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
This is a multi-part message in MIME format. Hi Brian, Yes I have to have pattern matching on the second form as the second form can have entries created independently of the first form. For the same reason the pattern matching has to be on as this is a business requirement. In the real situation the same menu is used for both forms but this menu is based on a search of another form. The specific value of 2008A has been marked as inactive but some entries in the first form still have the 2008A value and only now are the entries in the second form being are being created from the first form. Ideally the value of 2008A should be made active again but currently this is not an option. Thanks for your comments on doing some more error checking before creation in the second form. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Brian Bishop Sent: Wed 27/05/2009 17:16 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Hi Nyall, Assuming you are pushing the value of the field Menu on form A1 to the field Menu on form A2. First of all ask yourself is it necessary to have a pattern match of $MENU$ on the menu field on form A2. If it is, then ask yourself why the values for Menu in form A1 don't match those in form A2. If there is a valid reason that 2008A can appear in form A1 but not in A2, then what do you want to happen? Logically you don't want an entry to be created in form A2. So, if you don't want an entry created in form A2 when the Menu value in form A1 is 2008A, you need to create some workflow that checks if the value in form A1 is also valid for form A2. If the check confirms it is valid, do the push, if it isn't don't do the push. If you get the workflow correct the user will not be aware that this decision action is happening and they will never get this obscure message again. If however you do want the entry to be created then you need to either replace, or remove, the menu value in form A1 prior to the push to form A2. The same workflow as above to check if it is valid but rather than not doing the push, do it with the 2008A replaced with a valid value or remove it. This will be decided by whether the field menu in form A2 is a required field or not. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 http://www.linkedin.com/in/brianpbishop Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: 27 May 2009 15:38 To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor:
Re: Need to make an error message more friendly.
Hi Joe, Unfortunately I cannot change the menu type as it is based on a search of another form. Thanks. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 27/05/2009 17:41 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
This approach only solves the problem if the underlying data that provides the menu values never changes. Axton Grams On Wed, May 27, 2009 at 12:29 PM, MCCAVITT Nyall nyall.mccav...@eurocontrol.int wrote: ** Hi Joe, Unfortunately I cannot change the menu type as it is based on a search of another form. Thanks. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 27/05/2009 17:41 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Job: Remedy Developer - Full Time - US Citizen - McClean, VA
Howdy List! Hope all had a great relaxing 3 day weekend... Don't give me too much rapp... I am the middle man... getting this info soon... I don't know versions, modules, databases, OS, app server, technologies How useful am I :)... Generic at this point. Just looking for a Sr Developer wanting to go perm in the McClean, VA area. Title: Remedy Application Developer Location: McClean, VA Type: Contract to Hire - 6 Months then convert perm with our client Authorization Status: US Citizen Clearance Required: No Years Experience: 7+ Years Responsibilities: Perform analysis, design, development, unit testing and debugging of complex business risk management and control systems which have significant tactical impacts on mitigating corporate operational risk and maintaining control standards. Provides implementation, integration, and operational services in support of the REMEDY application suite. Develop code in the REMEDY suite. Builds and executes unit test cases, developer guides, and support guides. Understands and adheres to system standards. Respectfully, Joshua Kitchen Recruiter Kforce Federal Staffing Two Prestige Place Suite 350 Miamisburg, Ohio 45342 937.449.1749 Office 937.461.6888 Fax 937.416.3456 Cell http://www.linkedin.com/in/joshkitchen Search Dayton, Ohio Jobs today! http://www.kforce.com/tech-jobs-Ohio http://www.kforce.com/Jobs/Search.aspx?Location=1039Specialty=Technolo gy-Jobsid=2189 Great People = Great Results(r) Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are att940e8.gifatt940f9.jpgatt940fa.gifatt940fb.jpg
Re: View Forms and Synoyms....
Take an SQL log and see what SQL the AR System throws to the database server at the time you get that error. Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 12:27:21 PM Subject: Re: View Forms and Synoyms Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason) */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0325 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0574 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0575 */ Error - can't find table USER_VIEWS (owner = ARADMIN). Attempting to create a View Form on SYS.USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7696 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7699 */ SELECT column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7771 */OK Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, May 27, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Yes it does work from the SQL Client. Sorry, I should have specified that. Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Values of FieldType and FBOption in the table field..
I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
You do not have to change the Menu type.. just the field property of the field that the menu is attached to. You will find this option in the first default tab of the field property in the mid upper right corner of the field property dialog.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 1:29:20 PM Subject: Re: Need to make an error message more friendly. ** Hi Joe, Unfortunately I cannot change the menu type as it is based on a search of another form. Thanks. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 27/05/2009 17:41 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: Values of FieldType and FBOption in the table field..
Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Values of FieldType and FBOption in the table field..
Actually I believe the FBOPTION in FIELD is: #define AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */ #define AR_FIELD_OPTION_OPTIONAL 2 #define AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */ /* NOTE that fields cannot be created */ /* with nor set to this option */ #define AR_FIELD_OPTION_DISPLAY4 /* display-only field; no data will be */ /* stored for this field in the DB*/ Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Remedy Developer Available SoCal/DC
All I'm currently looking for Remedy consulting position in Southern California or the Washington DC metro area. I would consider other locations for short term ( 3 months) projects. If you aware of any opportunities I would appreciate sending me an email offline at the address below and I will send you a copy of my resume. I would prefer direct business leads as apposed to dealing with of the many IT consulting firms posting positions. Thanks Kevin Thornley kevin.thorn...@hotmail.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AW: Values of FieldType and FBOption in the table field..
this is foption not fboption Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Grooms, Frederick W Gesendet: Mittwoch, 27. Mai 2009 21:32 An: arslist@ARSLIST.ORG Betreff: Re: Values of FieldType and FBOption in the table field.. ** Actually I believe the FBOPTION in FIELD is: #define AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */ #define AR_FIELD_OPTION_OPTIONAL 2 #define AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */ /* NOTE that fields cannot be created */ /* with nor set to this option */ #define AR_FIELD_OPTION_DISPLAY4 /* display-only field; no data will be */ /* stored for this field in the DB*/ Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Supported Versions / FD / Patches
That looks like it.. It is all that fancy talk, vice something a little straighter.. for us simple folk =8 - ) Thank you! On Wed, May 27, 2009 at 1:25 PM, Thad K Esser tkes...@regence.com wrote: Pat, I was of the same understanding as you, until just now. After re-reading the FD patch 2 document, I don't think its referring to the CMDB. By deploying patch 1.6.00.02, you are not able to upgrade to BMC Atrium Discovery and Dependency Mapping (BMC Atrium Discovery) 7.5.00 or 7.5.01. Future releases of BMC Atrium Discovery and Dependency Mapping may support an upgrade from patch 1.6.00.02. Initially, like you, I understood that to say that we couldn't upgrade the CMDB until 7.5 p2 came out. But what it actually says, is that you can't upgrade from 1.6 patch 2 to the 7.5 version of the discovery tools (Atrium Discovery Dependency Mapping - ADDM) until patch 2 for that comes out. It doesn't put any limitations on the CMDB version. I think having the name Atrium in there is what tripped us up. Thad Esser Remedy Developer Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky? - Pink Floyd | | From: | | --| |patrick zandi remedy...@gmail.com | --| | | To:| | --| |arslist@ARSLIST.ORG | --| | | Date: | | --| |05/27/2009 06:00 AM | --| | | Subject: | | --| |Supported Versions / FD / Patches | --| | | Sent by: | | --| |Action Request System discussion list(ARSList) arslist@ARSLIST.ORG | --| ** Have a question: About support going back 2 versions right... 7.5.2 - minor 7.5.1 -- minor 7.5 --- Major 7.1 -- Major We are still here right? Put the X here. Why is it then that the FD 1.6.002 Patch that just came out only works with 7.5 ! because they are no longer patching FD in version 7.1 ! What is the deal here ! -- Patrick Zandi _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
Hi Joe, Tried that but as the Pattern attribute is set to $MENU$ then this gives the same error. What I am trying to do is catch the error and displayed a more user-friendly error message. Thanks. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: mercredi 27 mai 2009 20:58 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. ** You do not have to change the Menu type.. just the field property of the field that the menu is attached to. You will find this option in the first default tab of the field property in the mid upper right corner of the field property dialog.. Joe _ From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 1:29:20 PM Subject: Re: Need to make an error message more friendly. ** Hi Joe, Unfortunately I cannot change the menu type as it is based on a search of another form. Thanks. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 27/05/2009 17:41 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This message and any files transmitted with it
Re: Need to make an error message more friendly.
Or if it changes from another configuration form, where you do not have the $MENU$ patterning on the field in question.. If the underlying values are just used from all other data forms you can safely use the display type of Drop-List and everyones happy. Thats what I had done to some of the fields such as the CTI or RSD fields in the OTB apps... Joe From: Axton axton.gr...@gmail.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 2:01:55 PM Subject: Re: Need to make an error message more friendly. This approach only solves the problem if the underlying data that provides the menu values never changes. Axton Grams On Wed, May 27, 2009 at 12:29 PM, MCCAVITT Nyall nyall.mccav...@eurocontrol.int wrote: ** Hi Joe, Unfortunately I cannot change the menu type as it is based on a search of another form. Thanks. Nyall -Original Message- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 27/05/2009 17:41 To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. Make the character menu's display type as drop list and you will never have to deal with that error.. Joe From: MCCAVITT Nyall nyall.mccav...@eurocontrol.int To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:38:25 AM Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
Nyall, The key here is that you are trying to trap a specific instance where this generic error message can come up and provide a message that you control to give better indication about this specific situation. The various suggestions about changing menu styles and such help control what can be entered, but do not allow you to specifically address the issue. Also, there seems to be a constraint about adding anything or doing any checking on the remote form. So, all the options here are adding things to the source form only. The only way to accomplish what you want with a special error message for the specific case you have is to do your own validation or trapping of the problem and displaying your own message. So, here are some options: Option 1 -- Easy, quick and dirty however is inflexible This works ONLY IF you know that there is a bad value -- say 2008A -- that is causing the problem. Simply add an active link that fires BEFORE the active link that does the push to the other form that fires on the same conditions that has a run if 'field' = 2008A and an action that says to display an error message and you can say that value 2008A is not allowed. You can be as specific as you want with the message. NOTE: This is easy but it is inflexible since you need to know the exact value that is wrong and need to keep up if there are other values that can be wrong. This is an option only if the menu is essentially static even though it is a lookup. Option 2 -- A bit more work, much more robust and flexible than Option 1 but still requires keeping definitions in sync Add (or use an available existing) temp field. It doesn't matter what the field is since you are really not going to be using it, you are just going to do a NULL test on it. Add two active links that run BEFORE the active link that does the push to the other form that fire on the same conditions #1 if the field in question has a value (no need to test if it is NULL), perform a set fields that has a qualifier that is the same as the qualifier for the menu that is on the other form with the following added on AND 'field on target form' = $field on current form$ This does the same search for a subset of records to display AND says to see if there is one that is the value I am supplying. Assign the field value you are looking up to the temp field you have arranged for with the option for what to do if there are no matches set to Assign a NULL value #2 runs at a higher execution order than #1 has a run if 'temp field' = $NULL$ and an action that is an error message that says exactly what you want to say. This adapts to any value and changing menus. However, it is dependent on the qualification. So, if the menu definition on the other form changes, you will have to change the active link set fields qualifier in #1 to adapt. Option 3 -- requires AR System 7.1 or later, is the most complete solution, but is also a bit more work Redo your logic to move the push fields to a filter that fires on Service. Then, change the active link that does the push to perform a Service action against your form (probably passing a code in some field to tell it that this is the operation you are performing in case there are multiple service conditions) and have the operation performed. At this point you have the IDENTICAL operation you have now but instead of the active link performing the operation, it calls an operation on the current form and a filter performs the operation. But, the error is the same and you still want it fixed. HOWEVER, this is where you can then use the second new feature of 7.1 -- error handling (available only for filters which is why I had to get you to move the operation to filters first). Define an error handler on the filter that does a push. If an error occurs during the push, the error handler will get called. The error handler would have a run if qualification of $ERRORNUMBER$ = 306 AND $ERRORMESSAGE$ LIKE %536870913% (note that the actual keywords are different strings, but you can look up the exact wording) This would be true ONLY for error 306 on the field of interest. Success, the error handler would not be called Any other error and the error handler would run the ELSE branch (which is empty) and return the error If it matches however, the error 306 would be suppressed completely. You would then have an action on your error handler filter that would be an error message of the text that you wanted to have. Essentially, you have trapped the error you don't want in this case and substituted your error. You could alternatively have kept running or whatever you wanted but you wanted an alternate error. This last one is the most work, but it works no matter what the values are today or change to, no matter what the menu in question is. I hope this shows the variety of types of things you can do to handle situations like the one you are describing and that
Re: Need to make an error message more friendly.
Nicely worded Doug. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug Sent: Wednesday, May 27, 2009 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Need to make an error message more friendly. ** Nyall, The key here is that you are trying to trap a specific instance where this generic error message can come up and provide a message that you control to give better indication about this specific situation. The various suggestions about changing menu styles and such help control what can be entered, but do not allow you to specifically address the issue. Also, there seems to be a constraint about adding anything or doing any checking on the remote form. So, all the options here are adding things to the source form only. The only way to accomplish what you want with a special error message for the specific case you have is to do your own validation or trapping of the problem and displaying your own message. So, here are some options: Option 1 -- Easy, quick and dirty however is inflexible This works ONLY IF you know that there is a bad value -- say 2008A -- that is causing the problem. Simply add an active link that fires BEFORE the active link that does the push to the other form that fires on the same conditions that has a run if 'field' = 2008A and an action that says to display an error message and you can say that value 2008A is not allowed. You can be as specific as you want with the message. NOTE: This is easy but it is inflexible since you need to know the exact value that is wrong and need to keep up if there are other values that can be wrong. This is an option only if the menu is essentially static even though it is a lookup. Option 2 -- A bit more work, much more robust and flexible than Option 1 but still requires keeping definitions in sync Add (or use an available existing) temp field. It doesn't matter what the field is since you are really not going to be using it, you are just going to do a NULL test on it. Add two active links that run BEFORE the active link that does the push to the other form that fire on the same conditions #1 if the field in question has a value (no need to test if it is NULL), perform a set fields that has a qualifier that is the same as the qualifier for the menu that is on the other form with the following added on AND 'field on target form' = $field on current form$ This does the same search for a subset of records to display AND says to see if there is one that is the value I am supplying. Assign the field value you are looking up to the temp field you have arranged for with the option for what to do if there are no matches set to Assign a NULL value #2 runs at a higher execution order than #1 has a run if 'temp field' = $NULL$ and an action that is an error message that says exactly what you want to say. This adapts to any value and changing menus. However, it is dependent on the qualification. So, if the menu definition on the other form changes, you will have to change the active link set fields qualifier in #1 to adapt. Option 3 -- requires AR System 7.1 or later, is the most complete solution, but is also a bit more work Redo your logic to move the push fields to a filter that fires on Service. Then, change the active link that does the push to perform a Service action against your form (probably passing a code in some field to tell it that this is the operation you are performing in case there are multiple service conditions) and have the operation performed. At this point you have the IDENTICAL operation you have now but instead of the active link performing the operation, it calls an operation on the current form and a filter performs the operation. But, the error is the same and you still want it fixed. HOWEVER, this is where you can then use the second new feature of 7.1 -- error handling (available only for filters which is why I had to get you to move the operation to filters first). Define an error handler on the filter that does a push. If an error occurs during the push, the error handler will get called. The error handler would have a run if qualification of $ERRORNUMBER$ = 306 AND $ERRORMESSAGE$ LIKE %536870913% (note that the actual keywords are different strings, but you can look up the exact wording) This would be true ONLY for error 306 on the field of interest. Success, the error handler would not be called Any other error and the error handler would run the ELSE branch (which is empty) and return the error If it matches however, the error 306 would be suppressed completely. You would then have an action on your error handler filter that would be an error message of the text that you wanted to have. Essentially, you have trapped the error you don't want in this case and substituted your error. You could alternatively have kept running or whatever you wanted but you wanted an alternate
Re: Values of FieldType and FBOption in the table field..
Thanks Fredrick, Martin, I think Fred is more accurate on the FBOPTION.. I did find that list too but was wondering what the other values greater than 4 signified.. The list of FBOPTION values found my my DB on doing a distinct select was 0, 1, 2, 3, 4, 5, 6, 8, 10 and 14 For FieldType I get a distinct list of 0, 1, 2, 3 and 4. I'll try combing the ar.h file later but in the meantime if someone out there already has this list - please do share.. Anyone? Cheers Joe From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 3:31:34 PM Subject: Re: Values of FieldType and FBOption in the table field.. ** Actually I believe the FBOPTION in FIELD is: #define AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */ #define AR_FIELD_OPTION_OPTIONAL 2 #define AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */ /* NOTE that fields cannot be created */ /* with nor set to this option */ #define AR_FIELD_OPTION_DISPLAY 4 /* display-only field; no data will be */ /* stored for this field in the DB */ Fred From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003 BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Values of FieldType and FBOption in the table field..
Oops ... Time to clean the glasses You are correct that there are 2 fields in the Field table... FOPTION and FBOPTION My bad Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:39 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** this is foption not fboption Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Grooms, Frederick W Gesendet: Mittwoch, 27. Mai 2009 21:32 An: arslist@ARSLIST.ORG Betreff: Re: Values of FieldType and FBOption in the table field.. ** Actually I believe the FBOPTION in FIELD is: #define AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */ #define AR_FIELD_OPTION_OPTIONAL 2 #define AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */ /* NOTE that fields cannot be created */ /* with nor set to this option */ #define AR_FIELD_OPTION_DISPLAY4 /* display-only field; no data will be */ /* stored for this field in the DB*/ Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Values of FieldType and FBOption in the table field..
To be honest I think its the FOption field I should have been writing about in the first place in my first mail.. Thanks for the catch Martin.. Joe From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 4:48:21 PM Subject: Re: Values of FieldType and FBOption in the table field.. ** Oops … Time to clean the glasses You are correct that there are 2 fields in the Field table… FOPTION and FBOPTION My bad Fred From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:39 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** this is foption not fboption Von:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Grooms, Frederick W Gesendet: Mittwoch, 27. Mai 2009 21:32 An: arslist@ARSLIST.ORG Betreff: Re: Values of FieldType and FBOption in the table field.. ** Actually I believe the FBOPTION in FIELD is: #define AR_FIELD_OPTION_REQUIRED 1 /* tags for field definition option */ #define AR_FIELD_OPTION_OPTIONAL 2 #define AR_FIELD_OPTION_SYSTEM 3 /* system field; read-only to ALL users */ /* NOTE that fields cannot be created */ /* with nor set to this option */ #define AR_FIELD_OPTION_DISPLAY 4 /* display-only field; no data will be */ /* stored for this field in the DB */ Fred From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, May 27, 2009 2:21 PM To: arslist@ARSLIST.ORG Subject: AW: Values of FieldType and FBOption in the table field.. ** Joe, from ar.h FBOption #define AR_FIELD_BITOPTION_NONE 0x /* no bit option */ #define AR_FIELD_BITOPTION_AUDIT 0x0001 /* BIT 0 - bit option to audit */ #define AR_FIELD_BITOPTION_COPY 0x0002 /* BIT 1 - bit option to copy when some field is being audited */ /* 0x0003 BIT 0 1 - indicates AUDIT + COPY */ #define AR_FIELD_BITOPTION_LOG_KEY1 0x0004 /* BIT 2 - bit option to indicate this field is log key 1 */ #define AR_FIELD_BITOPTION_LOG_KEY2 0x0008 /* BIT 3 - bit option to indicate this field is log key 2 */ #define AR_FIELD_BITOPTION_LOG_KEY3 0x000c /* BIT 2 3 - bit option to indicate this field is log key 3 */ #define AR_FIELD_BITOPTION_AUDIT_MASK 0x0003 /* mask to check if any audit option is set */ #define AR_FIELD_BITOPTION_AUDIT_LOG_KEY_MASK 0x000c /* mask to check if any audit log key is set */ FieldType #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ HTH Kind Regards Conny Von:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 27. Mai 2009 20:56 An: arslist@ARSLIST.ORG Betreff: Values of FieldType and FBOption in the table field.. ** I had a compiled a list of what these values meant. I don't seem to find where I kept that information.. Does anyone have it handy? I need to write a db script to change some value in a field and it would be nice to have this info. I looked up the ar.h file (which I usually do when looking for such info) but I sort of have forgotten what to grep for to return only that section for finding the map to these values.. I did find the data type though.. FieldType 0 - 1 - 2 - 3 - 4 - FBOption 0 - 1 - 2 - 3 - 4 - 5 - 6 - 8 - 10 - 14 - DataType 0 - NULL 1 - KEYWORD 2 - Integer Field 3 - Real Field 4 - Character Field 5 - Diary Field 6 - Enum (Drop Down) Field 7 - Time Field 10 - Decimal Field 11 - Attachment Field 12 - Currency Field 13 - Date Field 14 - Time of Day Field 31 - Visual Trim Field 32 - Control button, Menu Icon Field 33 - Table Field 34 - Table Column Field 35 - Page Field 36 - Page Holder Field 37 - Attachment Pool Field 40 - ULONG 41 - COORDS 42 - View Field 43 - Display Field Cheers Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need to make an error message more friendly.
Option 4 would be to not store a literal representation of a moving target (a text label) but instead store a constant reference to the value. This would require that you alter the way you think about storing data within your applications; to achieve this, things need to be normalized and you need to enforce constraints [1] to the extent the system allows. Consider the following design: - the character field (with the menu) where the user selects the value is a display only field - the value returned from the menu is a primary key from another form (a guid or entryid or some other value) - you have a separate optional/required field (hidden) that stores the foreign key - on menu select, you translate that foreign key the menu returns by retrieving the literal representation and placing it in the display-only field (active link) and moving the foreign key to the hidden field - you have filters that perform validation on the create of the record or modify of the foreign key to check the foreign key is valid Added advantages: 1. Native AR form searches work as you would like. 2. It is simply not possible to get a bad value into the field, so subsequent modify operations will not trigger an error. 3. Should you want to change a menu value at some point in the future, it is reflected everywhere without updating 'potentially' millions of values (think of values like login name or full name or email address). This has a potentially huge impact on (a) the consistency and reliability of your data and (b) the potential bottlenecks the system will run into should you need to modify these values 4. It's efficient (for updates, validity checks, ...) 5. It's reliable; bad data simply won't get in (through changes to the source data, changes to the referencing data, ...) Footnotes: 1. This means that once a key is defined, it can not be removed without cleaning up all references; this is typically achieved using a cascading delete. This could also be achieved by having mechanism that (a) update references to another key or (b) nulls all key references Axton Grams On Wed, May 27, 2009 at 3:25 PM, Mueller, Doug doug_muel...@bmc.com wrote: ** Nyall, The key here is that you are trying to trap a specific instance where this generic error message can come up and provide a message that you control to give better indication about this specific situation. The various suggestions about changing menu styles and such help control what can be entered, but do not allow you to specifically address the issue. Also, there seems to be a constraint about adding anything or doing any checking on the remote form. So, all the options here are adding things to the source form only. The only way to accomplish what you want with a special error message for the specific case you have is to do your own validation or trapping of the problem and displaying your own message. So, here are some options: Option 1 -- Easy, quick and dirty however is inflexible This works ONLY IF you know that there is a bad value -- say 2008A -- that is causing the problem. Simply add an active link that fires BEFORE the active link that does the push to the other form that fires on the same conditions that has a run if 'field' = 2008A and an action that says to display an error message and you can say that value 2008A is not allowed. You can be as specific as you want with the message. NOTE: This is easy but it is inflexible since you need to know the exact value that is wrong and need to keep up if there are other values that can be wrong. This is an option only if the menu is essentially static even though it is a lookup. Option 2 -- A bit more work, much more robust and flexible than Option 1 but still requires keeping definitions in sync Add (or use an available existing) temp field. It doesn't matter what the field is since you are really not going to be using it, you are just going to do a NULL test on it. Add two active links that run BEFORE the active link that does the push to the other form that fire on the same conditions #1 if the field in question has a value (no need to test if it is NULL), perform a set fields that has a qualifier that is the same as the qualifier for the menu that is on the other form with the following added on AND 'field on target form' = $field on current form$ This does the same search for a subset of records to display AND says to see if there is one that is the value I am supplying. Assign the field value you are looking up to the temp field you have arranged for with the option for what to do if there are no matches set to Assign a NULL value #2 runs at a higher execution order than #1 has a run if 'temp field' = $NULL$ and an action that is an error message that says exactly what you want to say. This adapts to any value and changing menus. However, it is dependent on the qualification. So, if the menu definition on the other form
Re: View Forms and Synoyms....
So what do the sql statements below return when run from your sql client? Are synonyms available in all_tab_columns? If they are not then you are probably out of luck using synonyms. Axton Grams On Wed, May 27, 2009 at 11:27 AM, Kemes, Lisa lisa.ke...@tycoelectronics.com wrote: Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason) */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0325 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0574 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:49:37.0575 */ Error - can't find table USER_VIEWS (owner = ARADMIN). Attempting to create a View Form on SYS.USER_VIEWS SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7696 */OK SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7699 */ SELECT column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' SQL Queue: Admin Client-RPC: 390600 USER: fwgrooms /* Wed May 27 2009 10:51:30.7771 */OK Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, May 27, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms Yes it does work from the SQL Client. Sorry, I should have specified that. Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe From: Kemes, Lisa lisa.ke...@tycoelectronics.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481. We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
