Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Help on Repository

  1. #1
    Join Date
    Jul 2007
    Posts
    11

    Default Help on Repository

    Does anyone have experience setting up the repository for Kettle ?

    Also, how can you post a transformation on Carte ?

    Thanks

    Cokey

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Quote Originally Posted by cokeyng
    Does anyone have experience setting up the repository for Kettle ?
    Press the new button on the logon screen. Press new again, enter the details for the database you want the repository to be in (you need a userid on the database before you start). Press Ok twice. Create or update. Et voila . Be sure to have backups of the data in your repository, there's still one bug that I'm aware of in 2.5 and if you accidentally hit that one your repository will be a little corrupt.

    Quote Originally Posted by cokeyng
    Also, how can you post a transformation on Carte ?
    Define a slave server in the tree on the left hand side. Run a transformation, and in that dialog at the top are of couple of checkboxes. Pick Execute remotely and select your slaveserver.

    Regards,
    Sven

  3. #3

    Default

    I have recently tried setting up Repository on AS400 but fails. I got the following error when creating the database... Could anyone knows why was that with this log?
    Thanks in advance,
    Alex


    2007-07-26 12:08:24,391 INFO [AS400 HK] AS400 HK - New database connection defined
    2007-07-26 12:08:24,561 INFO [AS400 HK] AS400 HK - Connected to database.
    2007-07-26 12:08:24,571 INFO [AS400 HK] AS400 HK - Auto commit off
    2007-07-26 12:08:32,082 INFO [KETTLE] KETTLE - Starting to create or modify the repository tables...
    2007-07-26 12:08:32,092 ERROR [AS400 HK] AS400 HK - Can't turn auto commit on
    2007-07-26 12:08:32,112 INFO [KETTLE] KETTLE - executing SQL statements:
    CREATE TABLE R_REPOSITORY_LOG
    (
    ID_REPOSITORY_LOG DECIMAL(9)
    , REP_VERSION VARCHAR(255)
    , LOG_DATE TIMESTAMP
    , LOG_USER VARCHAR(255)
    , OPERATION_DESC CLOB
    )

    2007-07-26 12:08:32,112 INFO [AS400 HK] AS400 HK - launch DDL statement:
    CREATE TABLE R_REPOSITORY_LOG
    (
    ID_REPOSITORY_LOG DECIMAL(9)
    , REP_VERSION VARCHAR(255)
    , LOG_DATE TIMESTAMP
    , LOG_USER VARCHAR(255)
    , OPERATION_DESC CLOB
    )
    2007-07-26 12:08:32,372 INFO [AS400 HK] AS400 HK - 1 statement executed
    2007-07-26 12:08:32,372 INFO [KETTLE] KETTLE - Created/altered table R_REPOSITORY_LOG
    2007-07-26 12:08:32,372 INFO [AS400 HK] AS400 HK - Preparing statement:
    INSERT INTO R_REPOSITORY_LOG(ID_REPOSITORY_LOG, REP_VERSION, LOG_DATE, LOG_USER, OPERATION_DESC) VALUES ( ?, ?, ?, ?, ?)
    2007-07-26 12:08:32,522 ERROR [be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog$1@caf6c1] be.ibridge.kettle.repository.dialog....ialog$1@caf6c1 - be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error inserting row
    [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1816)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1714)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1697)
    at be.ibridge.kettle.repository.Repository.insertLogEntry(Repository.java:1091)
    at be.ibridge.kettle.repository.Repository.createRepositorySchema(Repository.java:3542)
    at be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:69)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:479)
    at be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:82)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.create(RepositoryDialog.java:449)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.access$600(RepositoryDialog.java:64)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog$5.handleEvent(RepositoryDialog.java:267)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:291)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog$4.widgetSelected(RepositoriesDialog.java:325)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:413)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:7159)
    Caused by: java.sql.SQLException: [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
    at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:870)
    at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:1138)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1774)
    ... 25 more
    2007-07-26 12:08:32,572 ERROR [class be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog] class be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog - Error creating/updating repository: java.lang.reflect.InvocationTargetException: Error creating or upgrading repository:
    Error inserting row
    [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    2007-07-26 12:08:32,572 ERROR [be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog@10e35d5] be.ibridge.kettle.repository.dialog....Dialog@10e35d5 - java.lang.reflect.InvocationTargetException: Error creating or upgrading repository:
    Error inserting row
    [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    at be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:74)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:479)
    at be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:82)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.create(RepositoryDialog.java:449)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.access$600(RepositoryDialog.java:64)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog$5.handleEvent(RepositoryDialog.java:267)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:291)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog$4.widgetSelected(RepositoriesDialog.java:325)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3284)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:413)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:7159)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error inserting row
    [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1816)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1714)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1697)
    at be.ibridge.kettle.repository.Repository.insertLogEntry(Repository.java:1091)
    at be.ibridge.kettle.repository.Repository.createRepositorySchema(Repository.java:3542)
    at be.ibridge.kettle.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:69)
    ... 20 more
    Caused by: java.sql.SQLException: [SQL7008] R_REP00001 in ALEX_TEST2 not valid for operation.
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
    at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:870)
    at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:1138)
    at be.ibridge.kettle.core.database.Database.insertRow(Database.java:1774)
    ... 25 more
    2007-07-26 12:11:11,210 INFO [AS400 HK] AS400 HK - Connection to database closed!

  4. #4

    Default

    I am suspecting the name of the database table is too long for AS400...
    Does anyone got any idea how to get the repository to work on AS400??
    Thanks again,
    Alex

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.