My Oracle Support Banner

RPAS Cloud: Registering Second Application to PDS Results in Error "Validation for dimension 'prod' failed, loading stopped. dimension prod not loaded. Please check the error logging table for erroneous records and take necessary action." (Doc ID 2782129.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Retail Assortment & Item Planning Fashion Soft Lines Cloud Service - Version 19.0 and later
Oracle Retail Merchandise Financial Planning Cloud Service - Version 19.0 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 19.0 and later
Oracle Retail Demand Forecasting Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

Attempting to register a second RPAS application to Planning Data Store (PDS) results in the following error:

OAT log shows this error:
Table "RPAS_DATA_MART_RDM"."RP_G_PROD_S":
184256 Rows successfully loaded

/rpasce/customer/rdm/output/prod.log
for more information about the load.
sqlldr completed successfully
Validating dimension 'prod'
Validation for dimension 'prod' failed, loading stopped.
dimension prod not loaded. Please check the error logging table for erroneous
records and take necessary action

loadDimData failed with error code 1.
ERROR: build rdm_bootstrap.ksh[448] - Planning Data Store build failed.
Existing script with code:1

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.