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. <sarcasm>I 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: 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)" <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 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 <http://www.sug.com/disclaimers/default.htm#Mail> here. If you cannot access hyperlink, please e-mail sender. __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.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<ATT00017.jpg>>
