Hello all,
Colleagues have reported an influx of errors in their DI Studio jobs which point to LIBREFs not assigning properly. There's a specific caveat I must point out which I am hoping someone has come across before.
These error messages are being produced BEFORE the BatchServer Autoexec parses. This normally means I could find an %include or 'options insert' statement written in precode either in the individual transform, or the overlying DI Job. In this case, I can't find anything. Users have no control over their autoexec files, so they're not inserting anything there.
The error messages are:
ERROR: ORACLE connection error: ORA-12545: Connect failed because target host or object does not exist.
ERROR: ORACLE connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
I don't "care" about the error message, that's a secondary issue. My concern is, where is this connection being attempted, because it's not in the config or autoexec files, and not a part of the user written code.
Finally, these error messages DO NOT cause Platform Process Manager jobs to exit as they are not deemed to be a part of the actual job. Even though the error message is in the log, they exist prior to the BatchServer actually doing anything, so PPM seems to ignore them. Like I say, this isn't the first time I have come across this issue, but I cannot for the life of me find where these assignments are stored. Maybe it's something in Management Console?
Thanks in advance,
Dan
For the benefit of anyone searching for a similar issue, the issue is due to two libraries being pre-assigned to this BatchServer which seem to have broken credentials. Check out the Data Library plugin in Management Console and have a look for libraries relevant to those you get an error for.
In my case I was lucky because they were the only two which began with a "P", but you may have difficulty if the LIBREF and Library Description don't match up properly.
For the benefit of anyone searching for a similar issue, the issue is due to two libraries being pre-assigned to this BatchServer which seem to have broken credentials. Check out the Data Library plugin in Management Console and have a look for libraries relevant to those you get an error for.
In my case I was lucky because they were the only two which began with a "P", but you may have difficulty if the LIBREF and Library Description don't match up properly.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.