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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.