0 Replies Latest reply: Sep 7, 2012 4:46 AM by 583359 RSS

    Error while import Database Objects in Oracle Module

    583359
      Hi All,

      I am getting dialog window saying below error when I click on Finish button on Import database objects wizard for oracle module.

      MMM 1034: Property ENCRYPT does not exist

      When clicked on detail button on error window it show below errors in detail

      MMM1034: Property ENCRYPT does not exist.
      MMM1034: Property ENCRYPT does not exist.
           at oracle.wh.repos.impl.extended.PropertyHelper.getProperty(PropertyHelper.java:741)
           at oracle.wh.repos.impl.extended.PropertyHelper.getScalarPropertyValue(PropertyHelper.java:833)
           at oracle.wh.repos.impl.extended.PropertyHelper.getScalarPropertyValue(PropertyHelper.java:828)
           at oracle.wh.repos.pdl.foundation.OWBRoot.getScalarPropertyValue(OWBRoot.java:5121)
           at oracle.wh.repos.impl.foundation.CMPElement.getScalarPropertyValue(CMPElement.java:1641)
           at oracle.wh.repos.impl.foundation.CMPElement.getBooleanProperty(CMPElement.java:1740)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.setColumnEncrypted(ImportEntityAlgorithm.java:4650)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.doImportColumns(ImportEntityAlgorithm.java:4400)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importColumns(ImportEntityAlgorithm.java:3487)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importTable(ImportEntityAlgorithm.java:1267)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.dispatchElement(ImportEntityAlgorithm.java:610)
           at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importElement(ImportEntityAlgorithm.java:435)
           at oracle.wh.ui.integrator.sdk.EntityAccessor.importElement(EntityAccessor.java:77)
           at oracle.wh.ui.integrator.common.ImportService.importElement(ImportService.java:1144)
           at oracle.wh.ui.integrator.common.wizards.ImportElementTransaction.run(ImportWizardDefinition.java:730)


      Please see below information and steps I followed

      1. My PC running on Windows 7 64 bit
      2. Installed Oracle Database Enterprise Edition 11.2.0.1.0 software
      3. Created a listner after insalling above database software
      4. Created data warehouse database and unlocked OWBSYS and OWBSYS_AUDIT accounts
      5. Set ORACLE_HOME=C:\oracle\product\11.2.0\dbhome_2\
      6. Set TNS_ADMIN=C:\oracle\product\11.2.0\dbhome_2\NETWORK\ADMIN
      7. After doing this I was able to connect all the source and data warehouse databases I am concerned with.
      7. Installed Oracle Warehouse Builder Client 11.2.0.3.0 64 bit
      8. Created repository using repository assistant insatlled duing database software.
      9. Created oracle database module for the schema created under data warehouse database.
      10. Tried to import database objects for the oracle module and got the error explained above when clicked on Finish

      Please someone reply to this thread since I searched lot on google and didn't get any solution and not understanding what this issue is.

      Thanks in advance
      Bhushan

      Edited by: Bhushan Bagul on Sep 7, 2012 2:46 AM