5 Replies Latest reply: Feb 19, 2013 12:04 PM by Nasar-Oracle RSS

    AWM Action BUILDDATABASE failed on object

    990272
      Hi all,

      I am running into a problem when i try to maintain any dimension or cube in Analytic Workspace Manager(version 11.2.0.3.0). I get the following error.


      oracle.AWXML.AWException: Action BUILDDATABASE failed on object RRR_DWH_OWNER.TEST
      at oracle.AWAction.BuildDatabase.Execute(Unknown Source)
      at oracle.olap.awm.wizard.awbuild.BuildWizardHelper$1.construct(BuildWizardHelper.java:167)
      at oracle.olap.awm.ui.SwingWorker$2.run(SwingWorker.java:109)
      at java.lang.Thread.run(Thread.java:619)
      Caused by: oracle.AWXML.AWException: ***Error Occured: Error Validating Dimension Mappings PRODUCTS.DIMENSION. Key Expression RRR_DWH_OWNER.RRR_PRODUCTS.ID for Mapping Group PRODUCTS.PRODUCTS_HIERARCHY.PRODUCT.MAPGROUP1.DIMENSIONMAPGROUP, Level PRODUCTS.PRODUCT.LEVEL, Hierarchy PRODUCTS.PRODUCTS_HIERARCHY.HIERARCHY is Incorrectly Mapped to RDBMS.
      +... 4 more+

      I tried everything but couldn't resolve it.
      Kindly help here.