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

[vaungt]

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.

[zarnold]

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

[andrewchantz]

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

[ltorok]

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