Hitachi Vantara Pentaho Community Forums
Results 1 to 21 of 21

Thread: 3.0.0.GA: Error with Insert/update

  1. #1
    Join Date
    Nov 2007
    Posts
    29

    Default 3.0.0.GA: Error with Insert/update

    Ciao,
    using the step "Insert/update", if in the list of update fields, the first filed have the combo box "Update" set on value "N" the trasformation don't work.
    The error is the following:
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Unexpected error :
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : org.pentaho.di.core.exception.KettleStepException:
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Error in step, asking everyone to stop because of:
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) :
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Error inserting row
    2007/11/28 16:47:16 - Insert / Update hgdd_subject11.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : Riga 2: sintassi non corretta in prossimità di ','.

    because the sql update statement is wrong create.

    Thanks,
    Luca

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

    Default

    Hi Luca,

    Please post your transformation and if possible also the layout of the target table.

    Thanks,
    Matt

  3. #3
    Join Date
    Nov 2007
    Posts
    29

    Default

    This trasformation works correctly in 2.5.

    Thanks,
    Luca
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 2007
    Posts
    29

    Default

    Sorry, I forgot the script.

  5. #5
    Join Date
    Nov 2007
    Posts
    29

    Default

    I don't know why I can't send you the file I have attached. So, I have paste it....

    CREATE TABLE TMP_SOGGETTI1(
    COD_AMBIENTE varchar(50) NULL,
    COD_AZIENDA varchar(50) NULL,
    COD_SOGGETTO varchar(50) NULL,
    DATA_INIZIO datetime NULL,
    DATA_FINE datetime NULL,
    COGNOME_NOME varchar(100) NULL,
    COD_TITOLO_STUDIO_GEN varchar(50) NULL,
    COD_TITOLO_STUDIO_SPE varchar(50) NULL,
    COD_TIPO_TIT_STUDIO varchar(50) NULL,
    STATO_CIVILE varchar(50) NULL,
    LIV_ORGANIZZATIVO varchar(50) NULL,
    SOGGETTO_ATTIVO varchar(50) NULL,
    NATURA_GIURIDICA varchar(50) NULL,
    SESSO varchar(50) NULL,
    DATA_NASCITA datetime NULL,
    CITTA_NASCITA varchar(50) NULL,
    COD_FISC varchar(50) NULL,
    INDIRIZZO1_RS varchar(100) NULL,
    INDIRIZZO2_RS varchar(100) NULL,
    COD_CITTA_RS varchar(50) NULL,
    TEL_RS varchar(50) NULL,
    FAX_RS varchar(50) NULL,
    MAIL_RS varchar(100) NULL,
    WEB_RS varchar(50) NULL,
    CELL_RS varchar(50) NULL,
    INDIRIZZO1_DM varchar(100) NULL,
    INDIRIZZO2_DM varchar(100) NULL,
    COD_CITTA_DM varchar(50) NULL,
    TEL_DM varchar(50) NULL,
    FAX_DM varchar(50) NULL,
    COD_RUOLO varchar(50) NULL,
    RUOLO_OCC DECIMAL(6,2) NULL,
    COD_UO varchar(50) NULL,
    UO_OCC DECIMAL(6,2) NULL,
    DF int NULL,
    TABLE_PROV varchar(50) NULL
    )

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

    Default

    Even then it's hard for me since I don't know the data types for query

    select
    COD_AMBIENTE,
    COD_AZIENDA,
    COD_SOGGETTO,
    DATA_INIZIO,
    COD_TITOLO_STUDIO_GEN,
    STATO_CIVILE,
    0 AS DF,
    'hgdd_subject11' TABLE_PROV
    from TMP_hgdd_subject11

    Matt

  7. #7
    Join Date
    Nov 2007
    Posts
    29

    Default

    Sorry!

    CREATE TABLE TMP_hgdd_subject11(
    COD_AMBIENTE varchar(50) NULL,
    COD_AZIENDA varchar(50) NULL,
    COD_SOGGETTO varchar(50) NULL,
    DATA_INIZIO datetime NULL,
    DATA_FINE datetime NULL,
    COD_TITOLO_STUDIO_GEN varchar(50) NULL,
    STATO_CIVILE varchar(50) NULL
    )

    Thanks,
    Luca

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

    Default

    Thanks, I'm onto it.

    http://jira.pentaho.org/browse/PDI-521

    Matt

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

    Default

    Can you download these jar files and place them in the lib/ directory:

    http://kettle3.s3.amazonaws.com/kettle-ui-swt-3.0.jar
    http://kettle3.s3.amazonaws.com/kettle-engine-3.0.jar

    I'm sure this will fix this issue. Let me know if you agree, either here on the forum or in the bug report.

    Thanks in advance!

    All the best,

    Matt

  10. #10
    Join Date
    Nov 2007
    Posts
    29

    Default

    It works very good.

    Thanks a lot,
    Luca

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

    Default

    You are welcome. Feel free to try the Italian translation as well.
    Edit / Options / Look and feel tab --> Preferred Language --> Italian (Italy)

    :-)

    All the best,
    Matt

  12. #12
    Join Date
    Jul 2007
    Posts
    247

    Default

    Just for reference, using the jars below will fail when trying to create a new repository:

    Code:
    java.lang.reflect.InvocationTargetException: Error creating or upgrading repository:
    
    
    Couldn't get field info from [SELECT /*+FIRST_ROWS*/ * FROM R_TRANS_SLAVE WHERE ROWNUM < 1]
    
    
    
    Anweisungs-Handle nicht ausgeführt: getMetaData
    
    
    
        at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:88)
    
        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:495)
    
        at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog.open(UpgradeRepositoryProgressDialog.java:96)
    
        at org.pentaho.di.ui.repository.dialog.RepositoryDialog.create(RepositoryDialog.java:455)
    
        at org.pentaho.di.ui.repository.dialog.RepositoryDialog.access$600(RepositoryDialog.java:64)
    
        at org.pentaho.di.ui.repository.dialog.RepositoryDialog$5.handleEvent(RepositoryDialog.java:268)
    
        at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    
        at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    
        at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    
        at org.pentaho.di.ui.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:292)
    
        at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$4.widgetSelected(RepositoriesDialog.java:330)
    
        at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    
        at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    
        at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    
        at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    
        at org.pentaho.di.ui.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:425)
    
        at org.pentaho.di.ui.spoon.Spoon.openRepositoryDialog(Spoon.java:5337)
    
        at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:5401)
    
        at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5563)
    
        at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5675)
    
        at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)
    
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
    
    Couldn't get field info from [SELECT /*+FIRST_ROWS*/ * FROM R_TRANS_SLAVE WHERE ROWNUM < 1]
    
    
    
    Anweisungs-Handle nicht ausgeführt: getMetaData
    
    
    
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2285)
    
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1827)
    
        at org.pentaho.di.core.database.Database.getTableFields(Database.java:1822)
    
        at org.pentaho.di.core.database.Database.getAlterTableStatement(Database.java:3162)
    
        at org.pentaho.di.core.database.Database.getDDL(Database.java:3092)
    
        at org.pentaho.di.repository.Repository.createRepositorySchema(Repository.java:4689)
    
        at org.pentaho.di.ui.repository.dialog.UpgradeRepositoryProgressDialog$1.run(UpgradeRepositoryProgressDialog.java:83)
    
        ... 24 more
    
    Caused by: java.sql.SQLException: Anweisungs-Handle nicht ausgeführt: getMetaData
    
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    
        at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:135)
    
        at oracle.jdbc.driver.OraclePreparedStatement.getMetaData(OraclePreparedStatement.java:4026)
    
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2217)
    
        ... 30 more
    I'm using JAVA
    Code:
    java version "1.6.0_03"
    Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
    Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode, sharing)
    You may want to fix that before it gets included in the 3.0.1 release

    Regards,
    Ben

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

    Default

    Aaah! We had that fix in test. It's actually a fix to speed up with the determination of the output field layout when you have a big query in the Table Input step.

    I checked and it's the Oracle JDBC driver that has a problem with it. It's a JDBC 2.0 specification, but Oracle simply chose not to implement it.
    Oh well, too bad for the Oracle users I guess.

    I've uploaded new libraries, can you test the fix I made for your issue?
    It's part of this bug tracker: http://jira.pentaho.org/browse/PDI-481

    Thanks,

    Matt

  14. #14
    Join Date
    Nov 2007
    Posts
    29

    Default

    It works very well!
    The only one error that I have noticed is when I test any connection; but if I push explorer button, it runs very well.

    Thank you very much for your support.

    PS: Traslation will be very useful for me... That's the best...now remain manuals traslation.

    Regards,
    Luca

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

    Default

    Luca,

    We're inserting a factory to do the testing. It's related to the PALO plug-ins that are on their way.
    The connections should work fine though. It will be fixed in a few days.

    Please note that if you write documentation in Italian (how-to, getting started, etc), we will include it in the distribution.

    ;-)

    Matt

  16. #16
    Join Date
    Nov 2007
    Posts
    29

    Default

    Sorry, I have not test the .jar very well.

    With the version 3.0.1 I can't save any trasformation, because the SQL statement generate is wrong

    Couldn't execute SQL: DELETE FROM R_TRANS_PARTITION_SCHEMA WHERE ID_TRANSFORMATION = 94

    Il nome di colonna 'ID_TRANSFORMATION' non è valido.

    The field on R_TRANS_PARTITION_SCHEMA is TRANSFORMATION, not ID_TRANSFORMATION.

    The job, instead, I can save it normally.

    Thanks,
    Luca

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

    Default

    Luca, you need to upgrade your transformation. It's not the 3.0.1 image that is wrong, it's a 3.0.0 problem.

    Matt

  18. #18
    Join Date
    Nov 2007
    Posts
    29

    Default

    Sorry, I don't understand.
    With the .jar contained with the zip of 3.0.0.GA I can save trasformation.
    Then, I had downloaded the .jar from the links below and I overwritten them.
    Now I can not save the trasformation.

    How can I upgrade my trasformation?


    Thanks,
    Luca

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

    Default

    OK, so I made a typo.
    Just upgrade your repository smart-ass.

    Matt

  20. #20
    Join Date
    Nov 2007
    Posts
    29

    Default

    I am sorry, I have upgrade the repository and now all work very well.

    Thanks,
    Luca

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

    Default

    OK, so now all we have to do is make sure everyone upgrades their 3.0.1 repository ;-)

    Matt

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.