RPAS HSA/RDM: Failure During -EndBatch And Rulegroup Executions in Partitioned RDM (Doc ID 2107671.1)

Last updated on JULY 13, 2017

Applies to:

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

Goal

When running the Retail Predictive Application Server (RPAS) RPAS Data Mart (RDM) mace -endBatch, the following error is being encountered. Why is this happening?
  

For example:
Exception during 'mace -d -endBatch'
rpas::exception: OCI_ERROR - (14109):
ORA-14109: partition-extended object names may only be used with tables and editioning views
ORA-06512: at "RPAS_DATA_MART.RP_G_DATALOAD_API_PKG", line 1451
ORA-06512: at "RPAS_DATA_MART.RP_G_DATALOAD_API_PKG", line 1574
ORA-06512: at line 1

For statement:
begin rp_g_dataload_api_pkg.merge_up_staging_data( :domain_id, :source_table, :target_table, :target_part_name ); end;
throw at line 1564 of file 'rpas/private/SqlSession.cpp'
from line 1181 of file 'rpas/private/HSAGateWayImpl.cpp'.:

  
 

Solution

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