Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: DI 5.0.1 Jackrabbit Repository Bug on Oracle Database

  1. #1

    Default DI 5.0.1 Jackrabbit Repository Bug on Oracle Database

    Pentaho Data Integration v5.0.1 Community Edition

    When creating the "Jackrabbit Repository" running "DI SQL Script" on Oracle Database 11g into JCR_USER Schema of PENTAHO Tablespace the index name IDX_R_JOBENTRY_ATTRIBUTE_LOOKUP has more the 30 characters. This is the limit of length of object names on Oracle Databases.

    STEPS TO ERROR:

    1. Run Spoon.bat
    2. Config the Database Connection of Oracle
    Connection Name: PentahoRepository
    Host Name: localhost
    Database Name: XE
    Port Number: 1521
    Tablespace for Data: <blank>
    Tablespace for Index: <blank>
    User Name: JCR_USER
    Password: *********
    3. Enter the Repository Information
    Database Connection: PentahoRepository
    ID: JCR_USER
    Name: PentahoRepository
    4. Click on [Create or Upgrade] button and ran the SQL Script

    RESULT:

    All objects are created fine, except that index.

    SOLUTION:

    1. Open the Oracle SQL Developer app or SQL*Plus console
    2. Connect to JCR_USER schema
    3. Open the SQL Script and edit the this line:
    -- Index name greater then 30 characters.
    -- CREATE UNIQUE INDEX IDX_R_JOBENTRY_ATTRIBUTE_LOOKUP ON R_JOBENTRY_ATTRIBUTE(ID_JOBENTRY_ATTRIBUTE, CODE, NR);
    CREATE UNIQUE INDEX IDX_R_JOBENTRY_ATTRIBUTELOOKUP ON R_JOBENTRY_ATTRIBUTE(ID_JOBENTRY_ATTRIBUTE, CODE, NR);
    4. Execute this code chunk.

    I wait that Data Integration Developer Team tailor this script to Oracle Database rules.

    Enjoy!

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Thanks for sharing your insight.

    Quote Originally Posted by fernandosantucci View Post
    I wait that Data Integration Developer Team tailor this script to Oracle Database rules.
    Changes are incorporated via bug tracking, in the forum your effort might largely go unnoticed.
    So long, and thanks for all the fish.

  3. #3

    Default

    Yeah, I report this bug on Jira before post here, thank you.

  4. #4

    Default can any one please provide document for how to create Oracle BA Repository Database

    can any one please provide document for how to create Oracle BA Repository Database for pentaho 5.2

  5. #5
    Join Date
    Nov 2009
    Posts
    688

    Default

    For the EE edition Pentaho already did
    http://infocenter.pentaho.com/help/nav/2_2

  6. #6

    Default

    I have followed the document and tried to configur oracle database repositary but still its is throwing errors "JVM_BInd" and "memory leak"


    can any one please help me on this
    Last edited by kishorebabu@123; 06-23-2015 at 01:03 AM.

Tags for this Thread

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.