Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GC overhead limit exceeded

RaviKRCJan 14 2016 — edited Jan 14 2016

Hi All,

Iam getting the below error message whem iam trying to load from MYSQL to Oracle. It works fine for smaller data sets, and when I start reading 6GB data i get the below message.

I have also set the following on setODIDomainEnv.sh and iam not sure where iam going wrong

ODI_INIT_HEAP = 2048m

ODI_MAX_HEAP = 8192m

ODI-1226: Step Physical_STEP fails after 1 attempt(s).

ODI-1240: Flow Physical_STEP fails while performing a Load SWITCHED_TRANSACTION_AP-LKM SQL to SQL (Built-In)- operation. This flow loads target table SWITCHED_TRANSACTION.

ODI-1298: Serial task "SERIAL-MAP_MAIN- (50)" failed because child task "SERIAL-EU-TANGO_DC_BATCH_UNIT (60)" is in error.

ODI-1298: Serial task "SERIAL-EU-TANGO_DC_BATCH_UNIT (60)" failed because child task "Load SWITCHED_TRANSACTION_AP-LKM SQL to SQL (Built-In)- (70)" is in error.

Caused By: java.lang.OutOfMemoryError: GC overhead limit exceeded

Any help and your expertise is greatly appreciated.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2016

Added on Jan 14 2016

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

2,136 views