Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Upgrade repository to 3.0.0 on Firebird

  1. #1
    Join Date
    Nov 2007
    Posts
    29

    Default Upgrade repository to 3.0.0 on Firebird

    Ciao,
    I try to upgrade repository from 2.5.0 to 3.0.0 GA on Firebird, but I have the error below:

    Unable to create or modify table R_REPOSITORY_LOG

    Couldn't execute SQL: ALTER TABLE R_REPOSITORY_LOG ALTER COLUMN OPERATION_DESC TYPE BLOB SUB_TYPE TEXT

    GDS Exception. 335544351. unsuccessful metadata update
    Cannot change datatype for column OPERATION_DESC. Changing datatype is not supported for BLOB or ARRAY columns.

    Thanks,
    Luca

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Luca,

    Please follow the upgrade guide: export the old repository, create a new one for V3 and import the data.

    Thanks,

    Matt

  3. #3
    Join Date
    Nov 2007
    Posts
    29

    Default

    Ciao,
    thanks for your answer.
    I try to export the repository in xml file, but I get this error:

    java.lang.NullPointerException

    Can you help me?

    Thanks,
    Luca

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    No! imagine that!

    Please give us the complete stack trace.

    Matt

  5. #5
    Join Date
    Nov 2007
    Posts
    29

    Default

    java.lang.reflect.InvocationTargetException
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:350)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:479)
    at be.ibridge.kettle.repository.dialog.RepositoryExportProgressDialog.open(RepositoryExportProgressDialog.java:71)
    at be.ibridge.kettle.repository.dialog.RepositoryExplorerDialog.exportAll(RepositoryExplorerDialog.java:2605)
    at be.ibridge.kettle.repository.dialog.RepositoryExplorerDialog$1.widgetSelected(RepositoryExplorerDialog.java:220)
    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.RepositoryExplorerDialog.open(RepositoryExplorerDialog.java:534)
    at be.ibridge.kettle.spoon.Spoon.exploreRepository(Spoon.java:3767)
    at be.ibridge.kettle.spoon.Spoon$26.handleEvent(Spoon.java:1214)
    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.spoon.Spoon.readAndDispatch(Spoon.java:964)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:7325)
    Caused by: java.lang.NullPointerException
    at be.ibridge.kettle.job.JobHopMeta.getXML(JobHopMeta.java:107)
    at be.ibridge.kettle.job.JobMeta.getXML(JobMeta.java:563)
    at be.ibridge.kettle.repository.Repository.exportJobs(Repository.java:5465)
    at be.ibridge.kettle.repository.Repository.exportAllObjects(Repository.java:5415)
    at be.ibridge.kettle.repository.dialog.RepositoryExportProgressDialog$1.run(RepositoryExportProgressDialog.java:58)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    What version are you on? 2.5.2?

    Thanks,

    Matt

  7. #7
    Join Date
    Nov 2007
    Posts
    29

    Default

    ---------------------------
    Spoon
    ---------------------------
    Kettle - Spoon version 2.5.0





    (c) 2001-2007 Pentaho Corporation

    www.pentaho.org







    Build version : 25003

    Build date : Fri Jun 08 14:31:22 CEST 2007


    ---------------------------
    OK
    ---------------------------

  8. #8
    Join Date
    Nov 2007
    Posts
    29

    Default

    Have any news? Can I do somethink to help you?

    Thanks,
    Luca

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.