DI Studio 4.9
SAS 9.4
I'm working with several DI Studo jobs that seem to no longer recognize a library, where when they were run last year they did. Between then and now, we have migrated from 9.3 to 9.4 and moved to a new repository.
Most jobs in this process are working but there are a few that aren't.
Here's the behavior:
I'll open a job and I'm able to open the datasets referenced within no problem at all. All the Librefs seem to work fine. I'm opening the datasets and able to sort and filter the data.
However, once I run a node in the job (say, an extract) I get a message that all is successful. However, once I attempt to open the extract's work file, _or_ the tables that I could open, I get an error message:
"There was an error while initializing View Data. Details of the error are mentioned in the details section.
com.sas.workspace.WsAppServerLibraryException: Libref XXXXX is not assigned."
So, why were the tables and their data accessible prior to running any node and how do I resolve this besides rewritting all the jobs...
Thanks!
Don't know the answer, but some trouble shooting tips/questions:
The Transformation created a view while using the standard work library. I've rebuilt the job, but anticipating it happening again. When it does I'll try to grab more info from the log.
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.