Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: be.ibridge.kettle.core.exception.KettleDatabaseExc eption:java.sql.SQLException: 未执行语

  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Question be.ibridge.kettle.core.exception.KettleDatabaseExc eption:java.sql.SQLException: 未执行语

    Here is a error while truning.
    i don't knonw why and how to resolve it ...
    please help me ....

    2009-07-16 18:07:47,406 ERROR [COLLECT_TRADING_HALFHOUR] COLLECT_TRADING_HALFHOUR - 一个数据库错误发生在从资源库文件读取转换时
    be.ibridge.kettle.core.exception.KettleDatabaseException:
    An error occurred executing SQL:
    SELECT ID_NOTE FROM R_TRANS_NOTE WHERE ID_TRANSFORMATION = 8
    未执行语句句柄
    2009-07-16 18:07:47,406 ERROR [B_BAS_CASE_RECORD] B_BAS_CASE_RECORD - There was an error while reading the shared objects (continuing load) : java.lang.IndexOutOfBoundsException: Index: 0, Size: 1
    2009-07-16 18:07:47,406 ERROR [Thread[V_RT_TRADING_halfhour (V_RT_TRADING_halfhour (Thread-24370)),5,main]] Thread[V_RT_TRADING_halfhour (V_RT_TRADING_halfhour (Thread-24370)),5,main] - be.ibridge.kettle.core.exception.KettleException:
    一个数据库错误发生在从资源库文件读取转换时
    An error occurred executing SQL:
    SELECT ID_NOTE FROM R_TRANS_NOTE WHERE ID_TRANSFORMATION = 8
    未执行语句句柄

    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2296)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2104)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:744)
    at be.ibridge.kettle.job.entry.trans.JobEntryTrans.execute(JobEntryTrans.java:406)
    at be.ibridge.kettle.job.Job.execute(Job.java:303)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:231)
    at be.ibridge.kettle.job.Job.run(Job.java:202)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    An error occurred executing SQL:
    SELECT ID_NOTE FROM R_TRANS_NOTE WHERE ID_TRANSFORMATION = 8
    未执行语句句柄
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:2218)
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:2142)
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:2130)
    at be.ibridge.kettle.repository.Repository.getIDs(Repository.java:2319)
    at be.ibridge.kettle.repository.Repository.getTransNoteIDs(Repository.java:2249)
    at be.ibridge.kettle.trans.TransMeta.<init>(TransMeta.java:2164)
    ... 11 more
    Caused by: java.sql.SQLException: 未执行语句句柄
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
    at oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:714)
    at oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3458)
    at oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:57)
    at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:138)
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:2211)
    ... 16 more
    2009-07-16 18:07:47,406 ERROR [B_BAS_CASE_RECORD] B_BAS_CASE_RECORD - java.lang.IndexOutOfBoundsException: Index: 0, Size: 1
    at java.util.ArrayList.RangeCheck(ArrayList.java:547)
    at java.util.ArrayList.get(ArrayList.java:322)
    at be.ibridge.kettle.core.Row.getValue(Row.java:93)
    at be.ibridge.kettle.core.database.Database.getRow(Database.java:3082)
    at be.ibridge.kettle.core.database.Database.getRow(Database.java:3059)
    at be.ibridge.kettle.repository.Repository.getIDs(Repository.java:2322)
    at be.ibridge.kettle.repository.Repository.getDatabaseAttributeIDs(Repository.java:2275)
    at be.ibridge.kettle.core.database.DatabaseMeta.<init>(DatabaseMeta.java:404)
    at be.ibridge.kettle.job.JobMeta.readDatabases(JobMeta.java:838)
    at be.ibridge.kettle.job.JobMeta.readSharedObjects(JobMeta.java:886)
    at be.ibridge.kettle.job.JobMeta.<init>(JobMeta.java:1128)
    at be.ibridge.kettle.job.JobMeta.<init>(JobMeta.java:1053)
    at be.ibridge.kettle.job.entry.job.JobEntryJob.execute(JobEntryJob.java:367)
    at be.ibridge.kettle.job.Job.execute(Job.java:303)
    at be.ibridge.kettle.job.Job.execute(Job.java:360)
    at be.ibridge.kettle.job.Job.execute(Job.java:231)
    at be.ibridge.kettle.job.Job.run(Job.java:202)

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

    Default

    What's truning... it's all chinese to me

    We should probably have followed the Oracle way and include some number in the error messages, can you rerun in english locale? And tell us which database you're using for repository.

    For the moment it looks like the retrieval of the notes of a transformation fails... and the fact that you use a very very old version of PDI.

    Regards,
    Sven

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.