George, There is a similar bug with the OOB Change Approval Process. BMC knows about this and has a workaround, but the result is that one of the OOB approvals gives you a "No Matches Found" error from an AL. You're probably ok if you don't use the OOB approvals, but if you do, you have to be careful about how long the text in all of the fields are.
Shawn Pierson -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Tuesday, July 31, 2007 4:45 PM To: [email protected] Subject: ITSM 7.0 bug. Hey Gang, We're using ITSM 7.0 on ARS 7.0.01 with an Oracle 10g database. Trying to create a new Support Group, I guess I got a little too aggressive with the "Description"; I typed 141 characters and it threw the error below when I tried to save it. The field properties show it to be a 255 character field on the Support Group form, but the underlying field that the Description is being pushed to by workflow is apparently only 128 characters on the CTM:SYS-Access Permission Grps form. When I trimmed the Description to < 128 characters, it saved just fine. --- ARERR [552] Failure during SQL operation to the database : ORA-12899: value too large for column "ARADMIN"."T567"."C1000000000" (actual: 141, maximum: 128) ARERR [306] Value does not fall within the limits specified for the field : (Maximum length - 128) : CTM:SYS-Access Permission Grps : Description --- I didn't see this on the ARSWiki, so I guess I'll turn in a request to support. Gp George Payne Assistant Director, User Services Information Technology Services University of Texas at Austin 512.232.7513 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Private and confidential as detailed <a href="http://www.sug.com/disclaimers/default.htm#Mail";>here</a>. If you cannot access hyperlink, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
