Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Package Hanging

  1. #11
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Rep Power
    Hi Colton,

    As you are running multiple packages loading the table in parallel, the problems seem related to locking issues. Did you drop down also the Transaction size parameter?


    To Find Out more About Attunity Technology:
    Contact Us

  2. #12
    colton is offline Junior Member
    Join Date
    Oct 2009
    Rep Power
    Well, that isn't exactly true. I do have multiple sources but each Data Load is running once another completes, so it is currently not in parrallel. I have any package that runs multiple sources in parallel as well but has no effect, and no locking. Batch and Transaction sizes were both dropped to 100.

    Also, I had stated before that all we see on Oracle is, "SQL*Net more data from client". Oracle is not doing anything. It just seems that the issue is on the SSIS possibly. We haven't had much time to look at it lately, but we plan to do a full test against a staging environment and track the network traffic.
    Last edited by colton; 10-18-2009 at 09:30 AM.

  3. #13
    vijay.kumar.kvk is offline Junior Member
    Join Date
    Feb 2018
    Rep Power

    SSIS Pakage with Attinuty connectors to Orace database is Hanging

    We have an SSIS Package with Attinuty connectors for Oraclae Database.
    The PAckage is being stalled and is long running without any progress.
    The package is mostly stalled when there is an INSERT statements.I am doing a normal load just disabling foreign keys while running the package.

    I checked with my Admin and he says, could not find anything from the logs. We tried the above Package execution on a newly built server as well,but the package is stalled and running longer without any progress.

    Appreciate your inputs if anyone has faced a similar issue.


Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts