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!
Originally Posted by fernandosantucci
