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: [email protected] 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: FORMNAME FIELDID FIELDNAME CHARMENU CHARMENUID -------------------------- ---------- ----------------------------- ---------------------------------------- ------------- AST:AssetCost 260800002 Depreciation Frequency AST:ACF:AssetDepFrequency (null) AST:MenuItem_LT 400002100 Menu Name AST:AIL:MenuNameList (null) CFG:Pred/Succ Relationship 1000000970 Task Name 01 xCHG:TSK:TaskName-Q (null) CFG:Pred/Succ Relationship 1000000972 Task Name 02 xCHG:TSK:TaskName-Q (null) CHG:CHGSLM:Qualbuilder 1000001271 Product Categorization Tier 2 INT:CHGSLM:QBI:PDL:CHG-P2-Q (null) CHG:CHGSLM:Qualbuilder 1000001272 Product Categorization Tier 3 INT:CHGSLM:QBI:PDL:CHG-P3-Q (null) CHG:CHGSLM:Qualbuilder 1000002268 Product Name INT:CHGSLM:QBI:ProductName-Q (null) CHG:CHGSLM:Qualbuilder 1000003300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) CHG:CHGSLM:Qualbuilder 1000003301 Department INT:CHGSLM:QBI:RequestedFor_Department (null) CTM:Login ID 1000000909 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 1000003300 Organization INT:CHGSLM:QBI:RequestedFor_Organization (null) SRM:SLMSRM:Qualbuilder 1000003301 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)" <[email protected]> 05/07/2008 01:10 PM Please respond to [email protected] To [email protected] 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>>
