Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Unexpected error

  1. #1

    Default Unexpected error

    I am using Kettle 3.003. When I run my transformation it only says "unexpected error", does not give any other clue about the error.
    Is there anyway I can catch the error?

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

    Default

    Run the transformation with logging set to row-level and attach the part where you see "unexpected error" ... if the log file is too big attach about 100 lines in front and after the error.

    Regards,
    Sven

  3. #3

    Default

    Here are the lines:
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Got row from previous step: [Ljava.lang.Object;@1473608
    2008/06/01 20:33:13 - campaign name => campaign_id.0 - Got row from previous step: [Ljava.lang.Object;@1576f39
    2008/06/01 20:33:13 - Select values.0 - Got row from previous step: [Ljava.lang.Object;@16d857f
    2008/06/01 20:33:13 - Insert / Update Fact.0 - Found row for update: ![77738], [56], [525], [1789], [25], [(GMT+05:30) India Standard Time], [ 0], [ 0], [null], [null], [ 2.416666667], [ 0.0], [ 50000.0], [ 0], [ 50000.0], [ 24], [ 0.0], [USD], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0], [ 0]
    2008/06/01 20:33:13 - Select values.0 - Wrote row to next step: [Ljava.lang.Object;@16d857f
    2008/06/01 20:33:13 - campaign name => campaign_id.0 - Wrote row to next step: [Ljava.lang.Object;@1576f39
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Wrote row to next step: [Ljava.lang.Object;@1473608
    2008/06/01 20:33:13 - keyword lookup/update.0 - Cache store: key=[1796], [canon digital slr cameras], [Exact] key=78190
    2008/06/01 20:33:13 - adgroup name => adgroup_id.0 - Wrote row to next step: [Ljava.lang.Object;@2c6ccd
    2008/06/01 20:33:13 - account name => account_id.0 - Got row from previous step: [Ljava.lang.Object;@12622d7
    2008/06/01 20:33:13 - Keyword update.0 - Values set for lookup: [308123]
    2008/06/01 20:33:13 - Account id lookup.0 - Found result after database lookup: [Ljava.lang.Object;@9b3915
    2008/06/01 20:33:13 - Keyword update.0 - Found row for update: ![ 0], [ 0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [USD], [7308158988], [2008-05-28], [ 0.0], [ 32], [Crystals], [ 80000.0], [default URL], [Active], [Exact], [ 0], [ 120000.0], [ 0.0], [ 5.59375], [null], [null], [ 0], [ 0], [(GMT+05:30) India Standard Time], [25], [526], [3021], [308123]
    2008/06/01 20:33:13 - Keyword update.0 - Update row with: ![308123]
    2008/06/01 20:33:13 - account name => account_id.0 - Wrote row to next step: [Ljava.lang.Object;@12622d7
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Got row from previous step: [Ljava.lang.Object;@1e086a8
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Wrote row to next step: [Ljava.lang.Object;@1e086a8
    2008/06/01 20:33:13 - Select values.0 - Got row from previous step: [Ljava.lang.Object;@5b7315
    2008/06/01 20:33:13 - Select values.0 - Wrote row to next step: [Ljava.lang.Object;@5b7315
    2008/06/01 20:33:13 - campaign name => campaign_id.0 - Got row from previous step: [Ljava.lang.Object;@17b2775
    2008/06/01 20:33:13 - campaign name => campaign_id.0 - Wrote row to next step: [Ljava.lang.Object;@17b2775
    2008/06/01 20:33:13 - Insert / Update Fact.0 - Update row with: ![25], [525], [1789], [77738], [56]
    2008/06/01 20:33:13 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Got row from previous step: [Ljava.lang.Object;@74db5c
    2008/06/01 20:33:13 - account name => account_id.0 - Got row from previous step: [Ljava.lang.Object;@b5197f
    2008/06/01 20:33:13 - account name => account_id.0 - Wrote row to next step: [Ljava.lang.Object;@b5197f
    2008/06/01 20:33:13 - adgroup name => adgroup_id.0 - Got row from previous step: [Ljava.lang.Object;@1a88bd7
    2008/06/01 20:33:13 - Keyword update.0 - Values set for lookup: [308125]
    2008/06/01 20:33:13 - Account id lookup.0 - Wrote row to next step: [Ljava.lang.Object;@d97694
    2008/06/01 20:33:14 - Account id lookup.0 - Got row from previous step: [Ljava.lang.Object;@13ea80a
    2008/06/01 20:33:14 - Account id lookup.0 - Added 2 values to lookup row: [Indiaplaza.in], [google]
    2008/06/01 20:33:14 - Keyword update.0 - Found row for update: ![ 0], [ 0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [USD], [7308158988], [2008-05-28], [ 0.0], [ 1], [Data Analysis With Excel], [ 400000.0], [default URL], [Active], [Exact], [ 0], [ 400000.0], [ 0.0], [ 6.0], [null], [null], [ 0], [ 0], [(GMT+05:30) India Standard Time], [25], [526], [3021], [308125]
    2008/06/01 20:33:14 - keyword lookup/update.0 - Cache store: key=[1796], [canon eos 20d], [Broad] key=78194
    2008/06/01 20:33:14 - Select values.0 - Got row from previous step: [Ljava.lang.Object;@1270708
    2008/06/01 20:33:14 - Select values.0 - Wrote row to next step: [Ljava.lang.Object;@1270708
    2008/06/01 20:33:14 - account name => account_id.0 - Got row from previous step: [Ljava.lang.Object;@1f12fc7
    2008/06/01 20:33:14 - campaign name => campaign_id.0 - Got row from previous step: [Ljava.lang.Object;@e17a57
    2008/06/01 20:33:14 - campaign name => campaign_id.0 - Wrote row to next step: [Ljava.lang.Object;@e17a57
    2008/06/01 20:33:13 - adgroup name => adgroup_id.0 - Wrote row to next step: [Ljava.lang.Object;@1a88bd7
    2008/06/01 20:33:13 - keyword => keyword_id.0 - Wrote row to next step: [Ljava.lang.Object;@74db5c
    2008/06/01 20:33:13 - Select values 3.0 - Got row from previous step: [Ljava.lang.Object;@1edaca4
    2008/06/01 20:33:13 - Insert / Update Fact.0 - Values set for lookup: [25], [525], [1789], [77740], [56]
    2008/06/01 20:33:14 - Select values 3.0 - Wrote row to next step: [Ljava.lang.Object;@1edaca4
    2008/06/01 20:33:14 - Select values.0 - Got row from previous step: [Ljava.lang.Object;@1ff16b7
    2008/06/01 20:33:14 - Select values.0 - Wrote row to next step: [Ljava.lang.Object;@1ff16b7
    2008/06/01 20:33:14 - account name => account_id.0 - Wrote row to next step: [Ljava.lang.Object;@1f12fc7
    2008/06/01 20:33:14 - Keyword update.0 - Update row with: ![308125]
    2008/06/01 20:33:14 - Account id lookup.0 - Found result after database lookup: [Ljava.lang.Object;@8a5d7a
    2008/06/01 20:33:14 - Account id lookup.0 - Wrote row to next step: [Ljava.lang.Object;@13ea80a
    2008/06/01 20:33:14 - Account id lookup.0 - Got row from previous step: [Ljava.lang.Object;@e307fa
    2008/06/01 20:33:14 - Account id lookup.0 - Added 2 values to lookup row: [Indiaplaza.in], [google]
    2008/06/01 20:33:14 - Keyword update.0 - Values set for lookup: [308127]
    2008/06/01 20:33:14 - keyword => keyword_id.0 - Got row from previous step: [Ljava.lang.Object;@dbde5a
    2008/06/01 20:33:14 - keyword => keyword_id.0 - Wrote row to next step: [Ljava.lang.Object;@dbde5a
    2008/06/01 20:33:14 - adgroup name => adgroup_id.0 - Got row from previous step: [Ljava.lang.Object;@947632
    2008/06/01 20:33:14 - campaign name => campaign_id.0 - Got row from previous step: [Ljava.lang.Object;@2c4d81
    2008/06/01 20:33:14 - Insert / Update Fact.0 - Found row for update: ![77740], [56], [525], [1789], [25], [(GMT+05:30) India Standard Time], [ 0], [ 0], [null], [null], [ 1.944444444], [ 0.0], [ 100000.0], [ 0], [ 50000.0], [ 36], [ 0.0], [USD], [ 0.111111111], [ 7500000.0], [ 67500.0], [ 0.0], [ 270000.0], [ 0.0], [ 270000.0], [ 0], [ 4]
    2008/06/01 20:33:19 - Insert / Update Fact.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:21 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:23 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:16 - keyword => keyword_id.0 - Got row from previous step: [Ljava.lang.Object;@1613efb
    2008/06/01 20:33:16 - campaign name => campaign_id.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:14 - keyword lookup/update.0 - Cache store: key=[1796], [canon eos 20d], [Exact] key=78196
    2008/06/01 20:33:32 - keyword lookup/update.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:34 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:36 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:14 - adgroup name => adgroup_id.0 - Wrote row to next step: [Ljava.lang.Object;@947632
    2008/06/01 20:33:14 - Select values.0 - Got row from previous step: [Ljava.lang.Object;@11beafb
    2008/06/01 20:33:14 - account name => account_id.0 - Got row from previous step: [Ljava.lang.Object;@461fda
    2008/06/01 20:33:45 - account name => account_id.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:14 - Keyword update.0 - Found row for update: ![ 0], [ 0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [ 0.0], [USD], [7308158988], [2008-05-28], [ 0.0], [ 6], [Data Structures And Algorithms Using C#], [ 2000000.0], [default URL], [Active], [Exact], [ 0], [ 2000000.0], [ 0.0], [ 1.833333333], [null], [null], [ 0], [ 0], [(GMT+05:30) India Standard Time], [25], [526], [3021], [308127]
    2008/06/01 20:33:49 - Keyword update.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:51 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:14 - Account id lookup.0 - Found result after database lookup: [Ljava.lang.Object;@120bffa
    2008/06/01 20:33:53 - Kettle - Commit on database connection [Kettle]
    2008/06/01 20:33:47 - account name => account_id.0 - Finished processing (I=0, O=0, R=44832, W=44831, U=0, E=0)
    2008/06/01 20:33:42 - Select values.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:33:40 - adgroup name => adgroup_id.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:34:04 - adgroup name => adgroup_id.0 - Finished processing (I=0, O=0, R=44762, W=44762, U=0, E=0)
    2008/06/01 20:33:30 - campaign name => campaign_id.0 - Finished processing (I=0, O=0, R=44792, W=44791, U=0, E=0)
    2008/06/01 20:33:28 - keyword => keyword_id.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:34:10 - keyword => keyword_id.0 - Finished processing (I=0, O=0, R=44599, W=44598, U=0, E=0)
    2008/06/01 20:34:02 - Select values.0 - Finished processing (I=0, O=0, R=44598, W=44597, U=0, E=0)
    2008/06/01 20:33:55 - Account id lookup.0 - ERROR (version 3.0.3, build 569 from 2008/04/25 12:30:04) : Unexpected error :
    2008/06/01 20:34:17 - Kettle - Commit on database connection [Kettle]


    and then it just doesn't run, but the job doesn't end.

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

    Default

    Your commits seem to fail, what kind of database do you write to?

    Regards,
    Sven

  5. #5

    Default

    Its MySQL 5.0.15-nt.

  6. #6

    Default

    let me just describe the current scenario.

    Configuration:

    XP running on windows
    3GB RAM
    Intel Core2 Duo 2.21GHz

    If I try to run the Kettle by double clicking the 'Kettle.exe' file it shows 'Unable to access jarfile E:\pentaho\launcher\launcher-1.0.0.jar'. But there is no folder called 'launcher' in pentaho. So I am running it by 'Spoon.bat'.

    When I am running the transformation for less then 30MB files, its working ok. But after the job is finished if I clicked on the 'Show error lines' button it shows 'i18n - org.pentaho.di.core.exception.KettleException:' twice. But the job runs perfectly.

    And if I try to transform a XML file more then 30MB in size it gives me the error as 'Unexpected error' and the job fails.

    I increased the memory in all .bat files. Those are as follows:
    Kettle.l4j.ini - '-Xmx3999M'
    Kichen.bat - '-Xmx3000m'
    Pan.bat - '-Xmx2500M'
    Spoon.bat - '-Xmx1024m' [If I increase the value in Spoon.bat and try to run it shows 'Unable to create java virtual machine'

    Now the problem is generally my files will be more than 30MB in size, and I thought that its not too big to handle for Kettle. So does anybody has some idea what is wrong for me.
    I am really stuck at this point and finding no solutions. I tried to search the forum about this error and tried all the possible options.

    Thanks

  7. #7

    Default

    you can get the launcher here though: http://source.pentaho.org/svnkettler...runk/launcher/
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  8. #8

    Default

    thanks for it, but how do solve my other problems?

  9. #9

    Default

    any help ??
    I am really stuck here

  10. #10

    Default

    at least let me know if you guys are working in this matter.
    I cant go live without solving this error and I cant transform my current data.

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.