Insight Incremental ETL Fails To Complete With the Error "ORA-20010: ORA-20009: ORA-04030: out of process memory"
Last updated on MAY 10, 2017
Applies to:Oracle Argus Insight - Version 126.96.36.199 and later
Information in this document applies to any platform.
***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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms