search cancel

Receiving out of memory in scope

book

Article ID: 111185

calendar_today

Updated On:

Products

CA Business Service Insight

Issue/Introduction

Im trying to enable an script and Im receiving error message about low memory

Environment

Release:
Component: OBLCRE

Cause

Running out of RAM for the records being returned.

Resolution

You are receiving an out of memory error, so you can of course try to free up RAM. 
Alternatively I see that you are getting this when you run it in scope. 
In that situation you can try to limit your date range so you are not processing so many results at once. 
Or, go into sqldeveloper and run: 
update t_system_configurations set sys_config_value='50000' where sys_config_name like 'maxrecordsforscope'; 
commit; 
The default value is 100000. You can try lowering this until scope does not run out of memory.