The most common cause for large diary fields like this is caused when a form is opened in a dialog, the worklog is read back into the worklog field in the dialog, then the 'save' active link pushes the entire contents of the worklog back to the worklog. The growth rate in this scenario is exponential (grows by it's own size on each save).
If this is the case, it should be evident by the contents of the diary field. It will contain mostly the same data over and over. Axton Grams On 9/19/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
** Nyall: Look for Diary Editor. This may help. You may have to put those 'bad' entries in a separate form in order to work with them. I was able to export the diary field through the user tool and then work with them there. I exported them as .arx files. James McKenzie ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nyall McCavitt Sent: Tuesday, September 19, 2006 1:01 AM To: [email protected] Subject: Re: request crashing user tool - malloc failed ** Hi, Just thought that I would keep you up to date on this issue. In turns at that one of the tickets that was causing this problem had a diary field of over 900MB!! I have isolated the relevant tickets ( 5 other tickets with a diary field of around 300MB is size), exported the data at the db level and updated the diary fields at the db level to ensure that they have no data in them. The system works perfectly now. The only trick now is to analyse the data to try and figure out why it gone up to 900MB and get some of the original Work Log data back in. Thanks for your help. Nyall McKenzie, James J C-E LCMC HQISEC/L3 wrote: ** Nyall and Raido: I'm willing to state that the affected action has a very large diary or attachment associated with it. If you attempt to export the record from your database, Oracle can handle the data collection, but Remedy cannot. Thus, you see a large increase in memory usage and then the crash. If you care to explore, you can look at the CLOB storage for that record and find the record is very large. Don't know how this happens as the limit for a diary field under Oracle is 1MB of text. If you need help, I think that I can provide a little bit of it. James McKenzie L-3 GSI __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
