Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: "(CLOB) 2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-2

  1. #1
    Join Date
    Apr 2012
    Posts
    10

    Default "(CLOB) 2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-2

    Hello,

    Situation:
    In an Folder are more than 100 XML files (size close to 1,5MB )
    if i load 10 by 10 it works. but if i load teh data in one proces, i got the following error message:

    "(CLOB) 2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Because of an error, this step can't continue:
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error batch inserting rows into table [INT_T_TABLE_A].
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Errors encountered (first 10):
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Overflow Exception trying to bind -1010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Overflow Exception trying to bind -1010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error updating batch
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Overflow Exception trying to bind -1010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:404)
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:128)
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at java.lang.Thread.run(Unknown Source)
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Error updating batch
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Overflow Exception trying to bind -1010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:320)
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : ... 3 more
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Caused by: java.sql.BatchUpdateException: Overflow Exception trying to bind -1010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    2012/09/10 08:27:25 - ERROR (version 4.3.0-stable, buil..."


    does someone know:
    is it a DB- Error ? ( ORACLE 11g is in use)
    is it a PENTAHO error?
    is it a OS-error?

    thank you!

    Michael

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

    Default

    It's an Oracle or an Oracle driver error. There's probably some limit that requires you to not use batch processing, which is probably useless with large files anyway.

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

    Default

    That being said... check the length of the column and if it's set not set of lower than ten million, set it to 10M or more. That will cause Kettle to stream the data to Oracle.

  4. #4
    Join Date
    Nov 2008
    Posts
    777

    Default

    To me, it looks like something in your data is causing the database output to blow up. Can you redirect your output to a CSV file or a plain text file and see what data is trying to be written?
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  5. #5
    Join Date
    Apr 2012
    Posts
    10

    Default

    Hello thanks for all replys .. i belive that i've found the error.
    the DEV DB --> result_cache_max_size 16613376
    the Customer > result_cache_max_size 5898240


    in 2 weeks the DB-Admin is back.

    during the test-Scenario i load 10 by 10 XML files, and it works very well.

    i try to check your reply an then i will poste informations here

    bye

Tags for this Thread

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.