Results 1 to 4 of 4

Thread: Intermittent Bad Package message - ORA-12592

  1. #1
    willemt is offline Junior Member
    Join Date
    Jun 2010
    Posts
    2
    Rep Power
    0

    Default Intermittent Bad Package message - ORA-12592

    Our company built a datawarehouse on a Windows 2008 64 bit/SQL server 64 bit server. The ETL process is built using SSIS and it pulls data from an Oracle database. For the most part, the process works well but occasionally, we get the following error in the middle of executing an SSIS package -

    Beginning of package execution.
    OCI error encouneterd. ORA-12592: TNS:bad packet
    OCI error encouneterd. ORA-12592: TNS:bad packet
    SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ORA_SRC Xcelys" (182) returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
    End of package execution.


    We fix the problem be simply re-running the package, usually within 30 minutes of the original folder, and the package always executes successfully. The Oracle sysadmins don't see anything suspicious on their logs and our admins don't see anything suspicious on our logs.

    I'm at a bit of a loss as to how to proceed. Where do I start looking for the problem? Does anyone have any ideas on where to start looking for the root of the problem??

    Thanks for any clues you can provide.

    Willem

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    6

    Default

    Hi Willem,

    This error may be a network level problem between the Oracle client and the Oracle Database. So, maybe the network admins can find the issue.

    Otherwise, according to Oracle, you should contact their customer support if you get this error.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    willemt is offline Junior Member
    Join Date
    Jun 2010
    Posts
    2
    Rep Power
    0

    Default

    Gadi,

    I'm sorry that it took so long to reply but I'm back. As you suggested, I contacted the Network folks at the Oracle site and they report nothing out of the ordinary - it's become a bit of a dead-end.

    So I'm taking another tack. I was wondering if there is a configurable timeout setting for the Oracle Connectors. It does seem like the issue centers around losing connection because of network latency issues - you can often adjust timeout settings and I thought it was possible that the Attunity drivers might have such a setting. I'd like to experiment, if that's possible.

    Can you point me in the right direction?

    Willem

  4. #4
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    6

    Default

    Hi Willem,

    You can configure the timeout parameters in sqlnet.ora


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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