Hitachi Vantara Pentaho Community Forums
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 33

Thread: 3.0.0RC1: Call getNextException to see the cause.

  1. #1

    Exclamation 3.0.0RC1: Call getNextException to see the cause.

    I created a transform and when I try to run it I am seeing this error:

    2007/10/07 20:31:28 - Table output.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Unexpected batch update error committing the database connection: org.pentaho.di.core.exception.KettleDatabaseBatchException:

    2007/10/07 20:31:28 - Table output.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Error updating batch

    2007/10/07 20:31:28 - Table output.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Batch entry 0 INSERT INTO mytable (name, id) VALUES ( SMITH, JOHN A , 588439455) was aborted. Call getNextException to see the cause.
    I set logging to row logging but still no help no further information is displayed. How can I see this getNextException?

    It looks like maybe it isn't quoting a comma in the INSERT name field. If that is true how can I get it to quote embedded comma's?

    Gerry
    Last edited by greno; 10-09-2007 at 04:38 PM.

  2. #2

    Default

    I found an option in the db conn under the Advanced tab that forces quotes around all identifiers so I tried this. It does quote the identifiers but it does not quote the VALUES which is where I think the problem lies. Is there any way to get the VALUES quoted?

    Gerry

  3. #3

    Default

    I just tried another of our databases and it too is getting this same problem with INSERT VALUES that are not quoted:

    INSERT ... VALUES ( , , , , , , , , , 0001-01-01 00:00:00.000000 -05:00:00, ...) Call getNextException to see the cause
    And I do not see any way to call getNextException to find out the exact error. This one is probably syntax error because all the strings with SPACES are unquoted and so it just looks like a bunch of commas strung together in the INSERT.

    How can I get all the VALUES quoted? I've been searching the forum and looking around the menues but I do not see any way to do this. This is a big showstopper.

    Gerry

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

    Default

    Quoting is not required for table output as parameters are used to pass data into a prepared statement. What you see as error is not what is being executed.

    Switch of batching mode (it sometimes eats the real error messages in the JDBC driver), run again and attach the resulting stack trace.

    Regards,
    Sven

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

    Default

    OR use error handling to send the offending rows to another step and preview on that.
    If you include the error text, you'll see what the problem was on a row-level.

  6. #6

    Default

    Ok, I added error handling and reran the transform and this time no exception. But the output is not complete.
    Last run the commit size was set to 1000 but this run I set it to 100.

    Code:
    Stepname    Copynr    Read    Written    Input    Output    Updated    Rejected    Errors    Active    Time    Speed (r/s)    input/output
    Table input    0    0    500    500    0    0    0    0    Finished    0.3    1577.2    -
    Select values    0    500    500    0    0    0    0    0    Finished    3.4    147.6    -
    Table output    0    500    384    0    384    0    0    0    Finished    3.4    224.1    -
    Text file output    0    0    0    0    0    0    0    0    Finished    3.4    0.0    -
    Here is what is in the actual table:
    =# select count(*) from mytable;
    count
    -------
    300
    (1 row)

    So 500 rows were processed but only 384 show as being output and only 300 actually ended up in the table. There were no errors and nothing is in the error handling file.

    ????

    Gerry

    And can someone tell me how to get a fixed font output with this forum. I've tried all the tags and the FixedSys font so far without success.
    Last edited by greno; 10-08-2007 at 08:35 AM.

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

    Default

    Hi Gerry,

    I tried a few things with Table Output and error handling, but I couldn't find a problem with it.
    Here is my test-case: Table output error handling.ktr

    The table "error_handling_test" on MySQL is created with:

    Code:
    create table error_handling_test(a int, primary key(a));
    Feel free to create a JIRA case for this or to post your transformation so that we can make sure this issue is fixed in RC2.

    And can someone tell me how to get a fixed font output with this forum. I've tried all the tags and the FixedSys font so far without success.
    The code tags you used do just that.

    Matt

  8. #8

    Default

    Matt,
    I think the error handling was fine. On my second Run there were no errors. My main concern now is that my source data has 500 rows and only 384 of these are showing as output to the target table and yet when I check the target table only 300 are actually in the table. This is not good. See the CODE section in my last post.


    Gerry

  9. #9

    Default

    Ok, I finally have all my field manipulations working in the transform and every step is now reading and writing 500 records (my test db size) EXCEPT for TABLE OUTPUT. It reads 500 records and writes 0 and there are no errors in the log and nothing is in the error file and nothing gets put into the db.

    2007/10/08 15:43:17 - Select values.0 - Finished processing (I=0, O=0, R=500, W=500, U=0, E=0)
    2007/10/08 15:43:17 - Table output.0 - Signaling 'output done' to 0 output rowsets.
    2007/10/08 15:43:17 - PostgreSQL_230_postgres_grpref - Connection to database closed!
    2007/10/08 15:43:17 - Table output.0 - Finished processing (I=0, O=0, R=500, W=0, U=0, E=0)
    Code:
    Stepname    Copynr    Read    Written    Input    Output    Updated    Rejected    Errors    Active    Time    Speed (r/s)    input/output
    Table input    0    0    500    500    0    0    0    0    Finished    1.0    519.7    -
    Add constants    0    500    500    0    0    0    0    0    Finished    9.3    53.9    -
    Modified Java Script Value    0    500    500    0    0    0    0    0    Finished    9.3    53.8    -
    Select values    0    500    500    0    0    0    0    0    Finished    11.2    44.7    -
    Table output    0    500    0    0    0    0    0    0    Finished    11.2    44.6    -
    Text file output    0    0    0    0    0    0    0    0    Finished    11.2    0.0    -

    ????

    Gerry

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

    Default

    Gerry, it's quite a busy time for us. Too busy to be chasing ghosts :-) Please try to understand this.

    Let me ask you again: feel free to create a JIRA case for this or to post your transformation so that we can make sure this issue is fixed in RC2.

    Thanks in advance.

    All the best,

    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.