09-27-2015 10:21 AM
Getting this message intermittently on queries in SAS 9.4. SAS support was only able to say the oracle connection was lost, but we don't see anything in the Oracle logs and I'm getting it against two different Oracle databases, one 11g another 12c. Both are 12c oracle clients. Sometimes the program will hang, other times it completes and the data looks ok. Anyone ever seen the message:
ORACLE: Pipelined I/O thread did not timely terminate
ORACLE: Pipelined I/O thread terminated on 2nd attempt
09-27-2015 03:02 PM
What sort of SAS queries are you running on Oracle? SAS SQL, SQL passthru, DATA step, SAS procedure?
Have you tried running queries with SAS diagnostics switched on:
options sastrace = ',,,d' SASTRACELOC = SASLOG;
One possible explanation might be intermittent network issues. I suggest you get your IT network folks to run a network trace on your database connections to see if they can spot anything.
09-28-2015 02:21 PM
It's happening on a variety of proc sql statements, some are very simple. It's only happening during our heavy processing window overnight. The database server is under a heavy load at the time. But it's the same database server our 9.2 environment uses and doesn't produce the error.
09-28-2015 02:35 PM - edited 09-28-2015 02:39 PM
I suggest you try the diagnostics and also provide SAS Tech Support with this. I think a network trace might also be helpful as it may pick up the dropped connections and provide more evidence to SAS Tech Support as to where the problem lies.
09-28-2015 02:38 PM
Thanks. I forgot to mention I did the trace and it didn't add anything useful, we know it's not the particular queries and there was not new information on the oracle connection. I've asked our DBA to set up logging on the oracle client side. And he's going to look at network. I will also open a new Track.