SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Library Paths - Concatenated Warning

Reply
Frequent Contributor
Posts: 89

Library Paths - Concatenated Warning

The following is a warning we get when we run DI Studio obs that reference tables we load for Visual Analytics reports:

 

"WARNING: One or more libraries specified in the concatenated library [libname] do not exist. These libraries were removed from the concatenation"

 

Here's what I think is happening...

This library has two paths 1) a path to the physical table and 2) a path to a folder in visual analytics.

 

That second path is prefaced "/mnt/..." and I understand that mount reference is used for VA's linux. So, what happens is, when we run a DI Studio jobs, DI Studio doesn't know what to make of that "/mnt/..." and we get the above warning. It can continue and process the table through the other path.

 

So, it seems to me we need maybe a 'VA' version of this library and not try to double use one.

 

Make any sense? Am I on the right path?

Community Manager
Posts: 2,771

Re: Library Paths - Concatenated Warning

Hi @jwhite,

 

If you're using a concatenated library to reference one path for Linux, and a different path for Windows, then you will always get this ERROR -- because one path will always be unavailable.

 

You can solve it with a simple macro to conditionally assign the proper path based on the OS you're on.  Here's the explanation, and some sample code follows.

 

Assign a SAS library to a different path depending on your OS

 

/* Use the IFC function as a shorthand for if-then, returning a character string */
%let tgtpath = %sysfunc(
  ifc(&SYSSCP. = WIN,
       \\sasprod\root\dept\mydept\project,
       /r/node/vol/vol01/mydept/project
    )
  );
 
libname tgt "&tgtpath.";
Frequent Contributor
Posts: 89

Re: Library Paths - Concatenated Warning

I understand the solution, but  I'm not clear on where this code is inserted.

 

Thanks for checking in on this issue!

 

Community Manager
Posts: 2,771

Re: Library Paths - Concatenated Warning

I took the liberty of peeking at your SAS Tech Support track on this, and here's my guess.  I think that you must have specified a list of paths for SAS Visual Analytics to use for autoload (LASR server), and there are two representations of the same path: one for Windows, and one for Linux.  

 

This then becomes part of some generated code in a startup script that assigns REPVA and REPLIB, and that's where the error occurs.  This construct is okay when at least one of those paths can resolve, but it's an error when no paths are found.

 

Example:

  libname REPLIB ('/mnt/foo/reports' 'S:\foo\reports');

 

 

When run on Linux, that /mnt path has to be mounted and available.  When run on Windows, the S: drive needs to be mapped.  These need to be in place when the library is assigned (at server startup, if in an AUTOEXEC) to avoid the error.  

Even when it works, you'll have a WARNING in the log:

 

WARNING: One or more libraries specified in the concatenated library REPLIB do not exist.  
These libraries were removed from the concatenation.

 

Ask a Question
Discussion stats
  • 3 replies
  • 318 views
  • 1 like
  • 2 in conversation