RPAS RDM: Parallel Query Server Errors During mace -endBatch -- "Hash Join ran out of memory" (Doc ID 2111853.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Retail Predictive Application Server - Version 14.1.1.12 and later
Information in this document applies to any platform.

Symptoms

 When running mace -endBatch, the RPAS RDM is throwing errors indicating that the system is out of memory:

 

<B 2015Dec14 06:07:39.317> ORA-12801: error signaled in parallel query server P00A, instance ltb1dbadm03.customer-xyz.com:GGLTST_2 (2)
<B 2015Dec14 06:07:39.317> ORA-06580: Hash Join ran out of memory while keeping large rows in memory

<B 2015Dec14 05:56:01.411> ORA-12801: error signaled in parallel query server P018, instance ltb1dbadm03.customer-xyz.com:GGLTST_2 (2)
<B 2015Dec14 05:56:01.411> ORA-00600: internal error code, arguments: [kcblsltio_1], [0], [0], [], [], [], [], [], [], [], [], [

 

Cause

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