Re: request crashing user tool - malloc failed

Fri, 15 Sep 2006 07:25:14 -0700

** Can you select the same data from a SQL prompt - directly from the database?
Maybe there is a bad database block.

On 9/15/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
**

Raido:

Suggestion:

Get with your Oracle DBA and do the following:

Log into SQL*Plus as the Remedy login, usually aradmin with the default password being ar#admin#.
Select schemaid from arschema where name ='<form name>';
Select count (c1) from t<schemaid>;
Select count (c1) from h<schemaid>;
Select count (e1) from b<schemaid>;

If I remembered the column names correctly, the last may be c1, these numbers should match. If they do not, you have a missing entry in one of the tables.  I had a missing entry in the H<schemaid> or status history table once.  The result is that particular entry could not be displayed, not a malloc error.

I would suggest exporting the 'large' diary entry and if possible, remove it to a file, or trimming it using a Diary Editor.  I actually had someone dump a directory table into a diary entry.  The result was constant malloc errors and a diary field of over 3MB.

James McKenzie
 

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raido Oja
Sent: Friday, September 15, 2006 7:07 AM
To: [email protected]
Subject: Re: request crashing user tool - malloc failed

Thanks for the feedback. There's no attachment fields on my form, but there is quite a large diary field (but considerably less than 1mb).

Anyway.. I'm also going to check the tables for a missing record, my problem is only with the user-tool crashing, it does not affect the server. I'll post back how it turns out.

[EMAIL PROTECTED] wrote:
> **
> We had similar problem some years ago when importing arx files, crasch
> related to attachments. The workaround was to import without
> attachments, and add thoses later separate with the use of 'Update
> record'. Never got any further explaination, not a problem anymore as
> we now can migrate with data in the forms.
>
>     -----Original Message-----
>     *From:* Action Request System discussion list(ARSList)
>     [mailto:[email protected]]*On Behalf Of *McKenzie, James J C-E
>     LCMC HQISEC/L3
>     *Sent:* Friday, September 15, 2006 3:42 PM
>     *To:* [email protected]
>     *Subject:* Re: request crashing user tool - malloc failed
>
>     **
>
>     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
>     
>
>     -----Original Message-----
>     From: Action Request System discussion list(ARSList) __20060125_______________________This posting was submitted with HTML in it___

Reply via email to