Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Cannot open xmi file or save, create domain in Metadata Editor

  1. #1
    Join Date
    Oct 2012
    Posts
    1

    Default Cannot open xmi file or save, create domain in Metadata Editor

    hi all,
    Im getting errors in trying to open xmi file or save, create domain in Metadata Editor

    The Errors is:
    org.pentaho.pms.core.exception.CWMException: CWM.ERROR_0002 - Error getting a handle on the repository.
    at org.pentaho.pms.core.CWM.getRepository(CWM.java:464)
    at org.pentaho.pms.core.CWM.getRepositoryInstance(CWM.java:449)
    at org.pentaho.pms.core.CWM.exists(CWM.java:555)
    at org.pentaho.pms.ui.MetaEditor.saveFileAs(MetaEditor.java:2928)
    at org.pentaho.pms.ui.MetaEditor.saveFile(MetaEditor.java:2913)
    at org.pentaho.pms.ui.MetaEditor$13.handleEvent(MetaEditor.java:525)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851)
    at org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589)
    Caused by: org.pentaho.pms.core.exception.CWMException: CWM.ERROR_0002 - Error getting a handle on the repository.
    at org.pentaho.pms.core.CWM.getRepository(CWM.java:506)
    at org.pentaho.pms.core.CWM.getRepository(CWM.java:459)
    ... 11 more
    Caused by: org.pentaho.pms.core.exception.CWMException: CWM.ERROR_0003 - Unable to get repository implementation for class [org.netbeans.mdr.persistence.jdbcimpl.JdbcStorageFactory].
    at org.pentaho.pms.core.CWM.getRepository(CWM.java:501)
    ... 12 more
    Caused by: org.netbeans.mdr.util.DebugException: Fatal error: Repository boot/initialization failed with message: Specified key was too long; max key length is 767 bytes
    at org.netbeans.mdr.NBMDRepositoryImpl.initCheck(NBMDRepositoryImpl.java:768)
    at org.netbeans.mdr.NBMDRepositoryImpl.getExtent(NBMDRepositoryImpl.java:308)
    at org.pentaho.pms.core.CWM.getRepository(CWM.java:488)
    ... 12 more



    I want to connect to mysql data and database named "nt4_dwh". Here is my repository.properties:



    # Class name of MDR storage plugin factory
    org.netbeans.mdr.storagemodel.StorageFactoryClassName=org.netbeans.mdr.persistence.jdbcimpl.JdbcStorageFactory

    # JDBC driver for MySQL
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.driverClassName=org.gjt.mm.mysql.Driver

    # URL for database storage
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.url=jdbc:mysql://localhost:3306/nt4_dwh

    # user name
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.userName=root

    # password
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.password=nt4@123

    # schema name (used as a table prefix)
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.schemaName=MDR

    # turn on debugging!
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.debugPrint=false

    # data type mappings...
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.datatype.mofid=BIGINT
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.datatype.streamable=BLOB
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.datatype.string=VARCHAR(750)
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.datatype.int=INT

    # Query for duplicates to prevent transaction aborts
    # This can be disabled for some future PostgreSQL version with real subtransaction support
    MDRStorageProperty.org.netbeans.mdr.persistence.jdbcimpl.queryDuplicates=true



    Anyone cannot show me what i have done incorrectly
    Any susgestion is appreciated!

    Rgds
    NT4.
    Last edited by vaungt; 12-06-2012 at 05:52 AM.

  2. #2
    Join Date
    Feb 2013
    Posts
    1

    Default

    What is the solution for this error, I'm having the same problem.

  3. #3

    Default

    I was wondering whether there was a solution to this problem? I'm running into this issue at the moment.

  4. #4

    Default

    Hi All!

    My response not a new news and I need also technical help.
    I have to work with pme 4.8 (and biserver-ce 4.8 + WAQR) and my datamodell too large to work efficiently file based MDR repository.

    I tried Hipersonic,MySQL,Postgresql databases for repository.
    I added suggested line to metadata-editor.bat (set PATH=c:\Program Files\Java\jdk1.7.0_60\bin\;.;%PATH%).
    I'have read i must not create MDR schema which is defined in the relational database repository, but I got the same error like above.

    Is there any other suggest?

    Please help me!
    Thanks,
    ltorok

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.