v8 DBMaint Client Reorganization task error

[Gordon Hester]

The maintenance workflow has worked for some time. Now the DBMaint Workflow is stopped with our Client1 Reorganization task failing. The Client 0 Reorg completes successfully just prior to the Client 1 failure.

Information from the Reorg Report : U0003525 ===> 'SELECT RH_AH_Idnr,RH_Type, RH_TimeStamp4, RH_ArchiveFlag, AH_OType, AH_SType, AH_Status, AH_Idnr, AH_OH_Idnr,AH_TimeStamp4 FROM RH, AH WHERE RH_AH_Idnr = AH_Idnr AND AH_Client = ? and AH_TimeStamp4 IS NOT NULL and AH_TimeStamp4 < ? and RH_DeleteFlag = 0'
20160320/204751.521 - U0033122 Error occurred in function <CollectRHAHIdnrAndType>
MsgNr: <3301> MsgInsert: <CollectRHAHIdnrAndType> Additional info: <>
20160320/204751.521 - U0003301 Could not allocate memory for 'CollectRHAHIdnrAndType'.

The SQL log doesn't show any entries related. My guess is that the recordset is just too large to handle. Has anyone seen this before?

[Luu_Le_185]

How many days are you trying to reorg for Client 1?  It may be as you suspect in which client 1 have a lot more record during the same timeframe and can't process it all.  Are you able to run the maintenance job at a smaller interval?

[Gordon Hester]

Thanks for the reply. I have narrowed this to a single day and for a specific date still receive the error above. I need either a smaller auto_reorg increment (hours, not days) or a way to bypass this date for reorg purposes!