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.***
<<image/jpeg>>
