Insight Incremental ETL Fails To Complete With the Error "ORA-20010: ORA-20009: ORA-04030: out of process memory"
(Doc ID 1468023.1)
Last updated on JUNE 13, 2019
Applies to:Oracle Argus Insight - Version 220.127.116.11 and later
Information in this document applies to any platform.
***Checked for relevance on 25-OCT-2018***
***Checked for relevance on 10-MAY-2017***
***Checked for Relevance on 01-Oct-2014***
Observed following error every time we attempted to run incremental ETL in the TEST environment.
ORA-20010: ORA-20009: ORA-04030: out of process memory when trying to allocate 80 bytes (callheap,qerrmbv: qerrmObnd)
-- ERROR while processing scase_reg_reports
-- ERROR while processing p_call_air_incremental
MedDRA upgrade 15.0 is done after which it is not working.
Attempted the following effort in hoping to resolve issue:
1) Increase pga_aggregate_target from 3GB to 5GB
2) Remove exiting incremental ETL job process
3) Execute initial ETL to bring data over from Safety (this was successfully)
4) Re-start incremental ETL failed with above error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document