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
    Posts
    5

    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 com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
    at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:914)
    at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:1189)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.pentaho.di.core.database.Database.insertRow(Database.java:1233)

    I need help ti fix the issue ....

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

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    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.