I had this same problem a little while back and never found a solution. I will have to try this.
I wound up making the field display as a drop-down, which of course forces them to select from the menu, so as far as I can tell has the same effect. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, May 09, 2008 3:36 PM To: arslist@ARSLIST.ORG Subject: Re: (Pattern - $MENU$) Problem Nyall, that was it, thank you. Our dba did just do a patch. You gotta love the simple-easy fixes. Gary and Rick, thanks for the responses. Rick, I did start to look through the SQL file but I didn't really know where to begin. Drew On Fri, 9 May 2008, Nyall McCavitt wrote: > Hi, > > I recently got this error message when our Oracle 10g database was upgraded > to the latest patch level. > > I found that if you remove the $MENU$ key word from the field attributes, > save the form and then add the $MENU$ key word back again then the error > message will not appear again. > > Hope that this helps. > > Nyall > > Drew Shuller wrote: >> I'm saving a record in a form but I get this error message: ARERR [306] >> Value does not fall within the limits specified for the field : (Pattern - >> $MENU$) : 301107120 >> >> That field id represents a character field with a search menu attached. I >> ran that down and the contents of the field match the contents of the field >> that the search menu is pulling from. Nothing seems out of place. >> >> Not that this would make a difference, but what I'm doing is creating a >> Copy Dataset job in the CMDB Reconciliation manager. The error message >> appears when the Save button is pressed. The field that the error message >> is complaining about (there's actually two of them) is the Source Dataset >> and the Destination Dataset. Again, I'm not sure that this is relevant, but >> it might be. >> >> Since we have mutiple servers and this operation works on the other >> servers, I exported and then imported the form that ITSM uses to create the >> Copy Dataset job. This didn't help. >> >> I imagine that I could safely remove the $MENU$ field constraint as a >> workaround, but now I worried that something may be wrong with the server. >> >> Has anyone ever seen this kind of behavior? Thanks in advance for the help. >> >> Drew >> Tulsa >> >> ________________________________________________________________________ _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> >> > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
