Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Getting Error as [SQL0913] Row or object *** in *** type *FILE in use AS400

  1. #1
    Join Date
    Feb 2011

    Default Getting Error as [SQL0913] Row or object *** in *** type *FILE in use AS400

    Hi All,

    I am using Pentaho 6.0 to Insert/Updating AS400 Database(Using Native JDBC).

    PDI Job reads a file at a time(It is in a loop) and transformation doing the DB operation as below.

    **************** Multiple Thread

    ****************------------------> Table1(I/U)
    ****************------------------> Table2(I/U)
    Get XML Data Read ------------------> Table3(I/U) Make the transformation database Transactional
    ****************------------------> Table4(I/U) Option Selected in Transformation Property.
    ****************------------------> Table5(I/U)

    Read a XML from a file and doing DB operation(Insert/Update) - Table1,Table2,Table3,Table4 and Table5

    I am using Transformation Properties - Make the transformation database Transactional option. If any table operation insert/Update fails then I should not do any operation in any table. If all table insert/update then good then read the next file.

    But some time I am getting the below error and transformation getting abort.

    Caused by: java.sql.SQLException: [SQL0913] Row or object ***** in ***** type *FILE in use.
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
    at org.pentaho.di.core.database.Database.insertRow(

    I need help ti fix the issue ....

    Thanks in advance
    Last edited by kanags; 12-20-2016 at 11:21 AM. Reason: To Show the Data Flow

  2. #2
    Join Date
    Jun 2012


    Looks like a deadlock throwing an unhandled exception to me.
    So long, and thanks for all the fish.

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.