Re: ARWARN 70
Thad, That may be the case, but I wonder if some of those menus being referenced are changed by Active Links before you use them, or if they are back end forms that may not necessarily need the menus. It's still really bad, but I haven't seen any problems with things like building SLMs for Change Management, for example. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Wednesday, May 07, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 David, Apparently I'm in an SQL mood today. This Oracle SQL (yours should be similar) ought to help you track down which field is referencing a missing menu: //Character fields referencing menus that don't exist select s.name FormName, f.fieldid, f.fieldname, fc.charmenu, cm.charmenuid from arschema s, field f, field_char fc, char_menu cm where s.schemaid = f.schemaid and s.schemaid = fc.schemaid and f.fieldid = fc.fieldid and fc.charmenu is not null and fc.charmenu != '$NULL$' and fc.charmenu = cm.name (+) and cm.name is null //include the following line to limit to a specific form and s.name = 'AD3:SupportTech:AD3:HomePage' The scary part is I ran it on our mint install of 7.0.2 Service Desk and Change Management and came up with a bunch of missing menus: FORMNAMEFIELDID FIELDNAME CHARMENU CHARMENUID -- -- - - AST:AssetCost 26082 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 42100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 100970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 100972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 101271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 101272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 102268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) CTM:Login ID100909 Hostname AST:ACI-Hostname-CLI-Q(null) EIE:ARMappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) EIE:MappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) SRM:SLMSRM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Morrison, David A. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/07/2008 01:10 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ARWARN 70 ** Good day everyone, Can't seem to get rid of a pesky warning message. There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ***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.*** Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.jpg
Re: ARWARN 70
Thanks for all the ideas so far. Yes I have recently deleted some no longer needed fields. I am having to do this upgrade in about 1/6 the time I have allotted for it. :-) Sorry for the slow reply, to add complications, we have been removed from our building for network and power upgrades. I am trying to finish this upgrade from a remote location. Fun, Fun. :-) David East Tennessee State University From: Action Request System discussion list(ARSList) on behalf of Rick Cook Sent: Wed 5/7/2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 ** Have you removed any fields from that form recently? It could be that there is a menu that displays data FROM that form ON another form, and it's looking for a field that no longer exists. Or it could be that there is a problem with that menu related to the upgrade, which is a major jump in API functionality. Rick On Wed, May 7, 2008 at 1:10 PM, Morrison, David A. [EMAIL PROTECTED] wrote: ** Good day everyone, Can't seem to get rid of a pesky warning message. Error.JPG There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARWARN 70
I thought about that (the menus being changed by active links). There are a bunch of fields that have $NULL$ as the starting menu (I excluded those in the SQL), so I was thinking those were the ones that were being changed by active links. Also, since we don't have Asset Management or SLM installed, I half figured these were menus that might be pulling data from those apps. I did open a couple of the forms in the user tool and got the ARWARN 70 error. sarcasmI know BMC would never release something buggy like that,/sarcasm so you are probably right that they are back end forms. Cheers, Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Pierson, Shawn [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/08/2008 05:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARWARN 70 ** Thad, That may be the case, but I wonder if some of those menus being referenced are changed by Active Links before you use them, or if they are back end forms that may not necessarily need the menus. It?s still really bad, but I haven?t seen any problems with things like building SLMs for Change Management, for example. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Wednesday, May 07, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 David, Apparently I'm in an SQL mood today. This Oracle SQL (yours should be similar) ought to help you track down which field is referencing a missing menu: //Character fields referencing menus that don't exist select s.name FormName, f.fieldid, f.fieldname, fc.charmenu, cm.charmenuid from arschema s, field f, field_char fc, char_menu cm where s.schemaid = f.schemaid and s.schemaid = fc.schemaid and f.fieldid = fc.fieldid and fc.charmenu is not null and fc.charmenu != '$NULL$' and fc.charmenu = cm.name (+) and cm.name is null //include the following line to limit to a specific form and s.name = 'AD3:SupportTech:AD3:HomePage' The scary part is I ran it on our mint install of 7.0.2 Service Desk and Change Management and came up with a bunch of missing menus: FORMNAMEFIELDID FIELDNAME CHARMENU CHARMENUID -- -- - - AST:AssetCost 26082 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 42100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 100970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 100972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 101271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 101272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 102268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) CTM:Login ID100909 Hostname AST:ACI-Hostname-CLI-Q (null) EIE:ARMappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) EIE:MappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) SRM:SLMSRM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Morrison, David A. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/07/2008 01:10 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ARWARN 70 ** Good day everyone, Can?t seem to get rid of a pesky warning message. There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University
Re: ARWARN 70
Watch out Thad, you never turned off your sarcasm flag _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Thursday, May 08, 2008 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 I thought about that (the menus being changed by active links). There are a bunch of fields that have $NULL$ as the starting menu (I excluded those in the SQL), so I was thinking those were the ones that were being changed by active links. Also, since we don't have Asset Management or SLM installed, I half figured these were menus that might be pulling data from those apps. I did open a couple of the forms in the user tool and got the ARWARN 70 error. sarcasmI know BMC would never release something buggy like that,/sarcasm so you are probably right that they are back end forms. Cheers, Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Pierson, Shawn [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/08/2008 05:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARWARN 70 ** Thad, That may be the case, but I wonder if some of those menus being referenced are changed by Active Links before you use them, or if they are back end forms that may not necessarily need the menus. It's still really bad, but I haven't seen any problems with things like building SLMs for Change Management, for example. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Wednesday, May 07, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 David, Apparently I'm in an SQL mood today. This Oracle SQL (yours should be similar) ought to help you track down which field is referencing a missing menu: //Character fields referencing menus that don't exist select s.name FormName, f.fieldid, f.fieldname, fc.charmenu, cm.charmenuid from arschema s, field f, field_char fc, char_menu cm where s.schemaid = f.schemaid and s.schemaid = fc.schemaid and f.fieldid = fc.fieldid and fc.charmenu is not null and fc.charmenu != '$NULL$' and fc.charmenu = cm.name (+) and cm.name is null //include the following line to limit to a specific form and s.name = 'AD3:SupportTech:AD3:HomePage' The scary part is I ran it on our mint install of 7.0.2 Service Desk and Change Management and came up with a bunch of missing menus: FORMNAMEFIELDID FIELDNAME CHARMENU CHARMENUID -- -- - - AST:AssetCost 26082 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 42100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 100970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 100972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 101271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 101272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 102268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) CTM:Login ID100909 Hostname AST:ACI-Hostname-CLI-Q(null) EIE:ARMappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) EIE:MappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) SRM:SLMSRM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Morrison, David A. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/07/2008 01:10 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ARWARN 70 ** Good day everyone, Can't seem to get rid of a pesky warning message. Error.JPG There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2
Re: ARWARN 70
Its been a while since I've used HTML tags. Isn't that what the /sarcasm indicates (right after the ...like that, and before the so you...)? (My sarcasm flags flips on and off quite frequently however, and it sometimes get stuck on. I just jiggle the handle a little and that usually seems to fix it.) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach LJ Longwing [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/08/2008 09:20 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARWARN 70 ** Watch out Thad, you never turned off your sarcasm flag From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Thursday, May 08, 2008 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 I thought about that (the menus being changed by active links). There are a bunch of fields that have $NULL$ as the starting menu (I excluded those in the SQL), so I was thinking those were the ones that were being changed by active links. Also, since we don't have Asset Management or SLM installed, I half figured these were menus that might be pulling data from those apps. I did open a couple of the forms in the user tool and got the ARWARN 70 error. sarcasmI know BMC would never release something buggy like that,/sarcasm so you are probably right that they are back end forms. Cheers, Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Pierson, Shawn [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/08/2008 05:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARWARN 70 ** Thad, That may be the case, but I wonder if some of those menus being referenced are changed by Active Links before you use them, or if they are back end forms that may not necessarily need the menus. It?s still really bad, but I haven?t seen any problems with things like building SLMs for Change Management, for example. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Wednesday, May 07, 2008 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 David, Apparently I'm in an SQL mood today. This Oracle SQL (yours should be similar) ought to help you track down which field is referencing a missing menu: //Character fields referencing menus that don't exist select s.name FormName, f.fieldid, f.fieldname, fc.charmenu, cm.charmenuid from arschema s, field f, field_char fc, char_menu cm where s.schemaid = f.schemaid and s.schemaid = fc.schemaid and f.fieldid = fc.fieldid and fc.charmenu is not null and fc.charmenu != '$NULL$' and fc.charmenu = cm.name (+) and cm.name is null //include the following line to limit to a specific form and s.name = 'AD3:SupportTech:AD3:HomePage' The scary part is I ran it on our mint install of 7.0.2 Service Desk and Change Management and came up with a bunch of missing menus: FORMNAMEFIELDID FIELDNAME CHARMENU CHARMENUID -- -- - - AST:AssetCost 26082 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 42100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 100970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 100972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 101271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 101272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 102268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) CTM:Login ID100909 Hostname AST:ACI-Hostname-CLI-Q (null) EIE:ARMappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) EIE:MappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) SRM:SLMSRM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) Thad Esser Remedy Developer Argue for your
Re: ARWARN 70
My bad...I didn't see your closing tagI was looking at the end of the line...:) _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Thursday, May 08, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 Its been a while since I've used HTML tags. Isn't that what the /sarcasm indicates (right after the ...like that, and before the so you...)? (My sarcasm flags flips on and off quite frequently however, and it sometimes get stuck on. I just jiggle the handle a little and that usually seems to fix it.) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach LJ Longwing [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/08/2008 09:20 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARWARN 70 ** Watch out Thad, you never turned off your sarcasm flag _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Thursday, May 08, 2008 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 I thought about that (the menus being changed by active links). There are a bunch of fields that have $NULL$ as the starting menu (I excluded those in the SQL), so I was thinking those were the ones that were being changed by active links. Also, since we don't have Asset Management or SLM installed, I half figured these were menus that might be pulling data from those apps. I did open a couple of the forms in the user tool and got the ARWARN 70 error. sarcasmI know BMC would never release something buggy like that,/sarcasm so you are probably right that they are back end forms. Cheers, Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARWARN 70 - SOLVED
Thanks to all those that replied!! I did Joel's suggestion and found the names of two character menus. Like the error message says these menus do not exist. So I created the menu in the error message with one test item. The pesky warning message has gone away. I guess this is jury rigging, but I am under the standard rush upgrade. :-) This is the best support list I have ever used! Have a great day! David Morrison East Tennessee State University From: Action Request System discussion list(ARSList) on behalf of Joel Sender Sent: Wed 5/7/2008 9:52 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 70 ** ** Just a thought: export the form def and search the def file for the menu name. HTH Joel Joel D. Sender Director of Western Operations QMXS Support Services, Inc. www.QMXS.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Morrison, David A. Sent: Wednesday, May 07, 2008 1:10 PM To: arslist@ARSLIST.ORG Subject: ARWARN 70 Good day everyone, Can't seem to get rid of a pesky warning message. Error.JPGhttps://mail.etsu.edu/exchange/MORRISON/Drafts/image001.jpg There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARWARN 70
Just a thought, but you might check all the views for fields. Another thing, you might check to make sure there are not other forms that this form references for the field. Hope that helps. Thanks, Ron Smith Remedy/Web Developer Providence Health Services OR [EMAIL PROTECTED] 503-216-7866 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Morrison, David A. Sent: Wednesday, May 07, 2008 1:10 PM To: arslist@ARSLIST.ORG Subject: ARWARN 70 ** Good day everyone, Can't seem to get rid of a pesky warning message. There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image003.jpg
Re: ARWARN 70
Have you removed any fields from that form recently? It could be that there is a menu that displays data FROM that form ON another form, and it's looking for a field that no longer exists. Or it could be that there is a problem with that menu related to the upgrade, which is a major jump in API functionality. Rick On Wed, May 7, 2008 at 1:10 PM, Morrison, David A. [EMAIL PROTECTED] wrote: ** Good day everyone, Can't seem to get rid of a pesky warning message. [image: Error.JPG] There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARWARN 70
David, Apparently I'm in an SQL mood today. This Oracle SQL (yours should be similar) ought to help you track down which field is referencing a missing menu: //Character fields referencing menus that don't exist select s.name FormName, f.fieldid, f.fieldname, fc.charmenu, cm.charmenuid from arschema s, field f, field_char fc, char_menu cm where s.schemaid = f.schemaid and s.schemaid = fc.schemaid and f.fieldid = fc.fieldid and fc.charmenu is not null and fc.charmenu != '$NULL$' and fc.charmenu = cm.name (+) and cm.name is null //include the following line to limit to a specific form and s.name = 'AD3:SupportTech:AD3:HomePage' The scary part is I ran it on our mint install of 7.0.2 Service Desk and Change Management and came up with a bunch of missing menus: FORMNAMEFIELDID FIELDNAME CHARMENU CHARMENUID -- -- - - AST:AssetCost 26082 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 42100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 100970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 100972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 101271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 101272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 102268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) CTM:Login ID100909 Hostname AST:ACI-Hostname-CLI-Q (null) EIE:ARMappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) EIE:MappingInfo 460020001 Data Source EIE:DE-PopulateDataSourceNames(null) SRM:SLMSRM:Qualbuilder 103300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 103301 Department INT:CHGSLM:QBI:RequestedFor_Department(null) Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Morrison, David A. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 05/07/2008 01:10 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ARWARN 70 ** Good day everyone, Can?t seem to get rid of a pesky warning message. There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ***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.*** image/jpeg
Re: ARWARN 70
** Just a thought: export the form def and search the def file for the menu name. HTH Joel Joel D. Sender Director of Western Operations QMXS Support Services, Inc. www.QMXS.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Morrison, David A. Sent: Wednesday, May 07, 2008 1:10 PM To: arslist@ARSLIST.ORG Subject: ARWARN 70 Good day everyone, Can't seem to get rid of a pesky warning message. Error.JPG There are no fields with menus on this form?? The logs only mention ARGetListSchema, ARGetfield, ARValidateFormCache, and ARGetCharMenu. I have no clue about those. I am upgrading from 4.5.2 to 7.1 with a new install and importing data. Everything seems to work as it should (so far ;-) except I cannot find the cause of this warning. Any ideas would be Very appreciated. ARS 7.1 server Windows 2003 Server SQL 2005 Mid Tier 7.1 David Morrison East Tennessee State University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.jpg