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"

Reply via email to