Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: creating a metadata repository in SQL DB

  1. #1

    Default creating a metadata repository in SQL DB

    Hi,
    I'm trying to create a repository in a postgres DB. I have configured the repository.properties file in the jdbc directory but I get the following

    org.pentaho.pms.core.exception.CWMException: CWM.ERROR_0002 - Error getting a handle on the repository.
    ...

    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:486)
    ... 13 more
    Caused by: org.netbeans.mdr.util.DebugException: Failed accessing storage factory.

    What am I doing wrong?

    Thanks in Advance.
    Doug

  2. #2

    Default found the problem

    I found my problem. typo in repository.properties.

  3. #3
    Join Date
    May 2006
    Posts
    104

    Default

    Hi Doug,
    I'm having the same errors while trying to implement the Derby DB. Could I ask you what the typo actually was?
    Thanks,
    Ralph

  4. #4
    Join Date
    May 2006
    Posts
    104

    Default

    I got around my problem.
    Ralph

  5. #5
    Join Date
    Jun 2008
    Posts
    4

    Default

    Hi there,

    I know this is old stuff but I had the same issues:
    - My metadata editor was opening on 'There are no models defined...' een though I created and saved some the day before, which I was able to view in the reporting web service client

    =- When trying to save new Connections/Models I was getting: 'CWM.ERROR_0002' Unbale to get a handle on the repository...

    Unable to delete mdr tree... That kind of stuff.

    My only problem was that when I had created my previous connections and models I was logged as root, and when I logged the next time on my pentaho machine it was as 'AUser'.

    The discrepancy hosed the metaeditor. It's probably trivial for many, but I tought I'd share this since it took me half a day to figure it out...

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.