Re: Relate a change to a change error
** Hi, For Oracle Database following information may help you:- 1Character with a maximum length of 4000 or fewer bytes = varchar for DB2 Oracle DB 2Character with an unlimited length or a maximum length of more than 4000 bytes=clob for Db2 Oracle DB 3If you set the Input Length to more than the maximum for varchar, the character field is created as a clob database table column and storage is allocated in blocks that average between 1K to 2K bytes (depending on the database). A full block is allocated for the first byte. When that block is filled with the field contents, another full block is allocated. 4CLOB (character large object) data is stored: In Row:- If the length of the character data, including the LOB locator, is less than or equal to 4000 bytes, store the data "in row." If the length of the character data, including the LOB locator, is greater than 4000 bytes, store the LOB locator "in row" and the data "out row." you expect to store unusually large amounts of data in CLOBs, set this option to TRUE before installing AR System applications so that all database tables for applications are created in-row. In-row CLOBs can degrade CPU performance. If a field contains more than 4000 characters, the CLOB is stored out row no matter which value is specified for this server setting. Out Row Store the data "out row." Out-row CLOBs can cause the database to grow rapidly. Regards, Trupti Thorave On 4/30/2013 8:24 PM, Brittain, Mark wrote: ** HI All, I have an interesting situation that was reported to me. If a user using an existing Change selects Create Related Request Infrastructure Change sometimes it works and sometimes it does not. Specifically the new Change is displayed and if there is a small amount of data in the Notes/Detailed Description, the new Change is saved. If the Notes/Detailed Description is like 4,000 characters, on save the user gets an error Required field cannot be blank.: Request ID (ARERR 326) I would think if the issue was the size of the Notes was too big, it would generate max limit. Has anyone encountered this issue? ITSM 7.6.04 SP3 Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite A Time Warner Cable Company mbritt...@navisite.com Office:315-453-2912 x5335 Mobile: 315-882.5360 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_
Relate a change to a change error
HI All, I have an interesting situation that was reported to me. If a user using an existing Change selects Create Related Request Infrastructure Change sometimes it works and sometimes it does not. Specifically the new Change is displayed and if there is a small amount of data in the Notes/Detailed Description, the new Change is saved. If the Notes/Detailed Description is like 4,000 characters, on save the user gets an error Required field cannot be blank.: Request ID (ARERR 326) I would think if the issue was the size of the Notes was too big, it would generate max limit. Has anyone encountered this issue? ITSM 7.6.04 SP3 Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 [cid:image001.gif@01CE4590.95252610] This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.gif
Re: [EXTERNAL] Relate a change to a change error
Mark: We don't get an error on the Request ID, but rather on the Submitter, and we get it when trying to create ANY type of related ticket (at least of the ones we've implemented so far, which include change, incident, problem investigation, known error, and knowledge). What happens in our case is that there is a double-quote, usually in the Summary. Remove the double-quote or replace it with a single quote, and then you can cancel out and try creating the related request again, and it usually works. That's also why the problem is intermittent - not all requests have the double-quote in the Summary. The problem is that is ITSM sees the double-quote as a SQL delimiter and not as part of the Summary, so it doesn't carry over all of the fields to the related ticket. I'm not sure if that's the same thing you're seeing or not, but we've seen that problem with all versions of 7.6.0x. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Tuesday, April 30, 2013 8:54 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Relate a change to a change error ** HI All, I have an interesting situation that was reported to me. If a user using an existing Change selects Create Related Request Infrastructure Change sometimes it works and sometimes it does not. Specifically the new Change is displayed and if there is a small amount of data in the Notes/Detailed Description, the new Change is saved. If the Notes/Detailed Description is like 4,000 characters, on save the user gets an error Required field cannot be blank.: Request ID (ARERR 326) I would think if the issue was the size of the Notes was too big, it would generate max limit. Has anyone encountered this issue? ITSM 7.6.04 SP3 Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 [email-Logo-031813] This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.gif