Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table Input getting Hungup..

  1. #1
    Join Date
    Sep 2007
    Posts
    12

    Default Table Input getting Hungup..

    Hello we are using PDI 3.2.0 version and Oracle 11

    we have a transformation with loads 30million records from table1 of DB1 to table2 of DB2.Commit size we gave is 2000.
    Table input getting hungup for hours and not getting back.

    What might be the problem?.

    Thanks
    Padmakar

  2. #2
    Join Date
    Nov 2008
    Posts
    777

    Default

    Low commit size?
    Wide data records?
    High data volume?
    Low network bandwidth?
    Underpowered computer(s)?
    Retired version of PDI?
    Oracle configuration?
    Java VM configuration?
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  3. #3
    Join Date
    Nov 2008
    Posts
    271

    Default

    Also double check if the issue is with the input step. Disable the hop to table2, use a dummy step and execute.
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

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.