My Oracle Support Banner

Error ORA-30371 Upon Dimensions Deployment (Doc ID 1439468.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Oracle Utilities Business Intelligence - Version 2.3.1 and later
Information in this document applies to any platform.

Goal


On Oracle Utilities Business Intelligence (OUBI) 2.3.1
The steps in the BI_DBA_Guide are being followed for OWB Dimensions deployment in OUBI Database configuration. External table deployment is successful. However, when deploying Dimensions, an error is generated.
Executing the below in dwadm schema on the target database show that all dimensions seem to have been deployed properly on the database:
select * from ALL_DIMENSIONS;
select * from ALL_DIM_LEVELS;

ERROR:




STEPS
1. Refresh DWADM schema with CDXDBA.exe script with option R.
2. Recreate repository
3. While deploying dimensions again, the error is obtained
OWB Control Center was used to deploy the dimensions.On the deployment context menu Create set action was used prior to deploying the dimension but deployment failed.
Dimension was redeployed using replace set action but it also failed. Finally, drop set action and deploy and create set action and deploy that also failed.


How to resolve this error?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.