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
    246
    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
    246
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257