topic Re: Connection to MapR from SAS Visual Data Builder: Libref is not assigned error in SAS Visual Analytics

Connection to MapR from SAS Visual Data Builder: Libref is not assigned error

Mahis — Fri, 26 Jan 2024 16:23:55 GMT

Hello everyone,

When we tried to connect to MapR from SAS Visual Data builder we got this error:

Libref DB_HADP is not assigned.

LIBNAME db_hadp HADOOP PRESERVE_COL_NAMES=YES
PRESERVE_TAB_NAMES=YES SERVER="maprserver" PORT=10000 USER=mapruser ;

ERROR: The product with which the engine HADOOP is associated is either not licensed for your system or the product license has
expired. Please contact your SAS installation representative.
ERROR: Error in the LIBNAME statement.
options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;

But when we tested the connection to MapR using the same code in the logs:

LIBNAME db_hadp HADOOP PRESERVE_COL_NAMES=YES
PRESERVE_TAB_NAMES=YES SERVER="maprserver" PORT=10000 USER=mapruser ;

the DB_HADP was assigned successfully.

Could this issue be related to a missed configuration in the SAS VA server?

Re: Connection to MapR from SAS Visual Data Builder: Libref is not assigned error

Madelyn_SAS — Fri, 26 Jan 2024 16:43:53 GMT

If you run a PROC SETINIT for the license that includes Visual Analytics, does it also include SAS/ACCESS for Hadoop? When you submitted the LIBNAME statement and it was successful, which workspace server was it running on?

Re: Connection to MapR from SAS Visual Data Builder: Libref is not assigned error

Mahis — Fri, 26 Jan 2024 17:56:27 GMT

We have SAS/ACCESS Interface to Hadoop included in the license. The successful LIBNAME statement was executed in the workspace server of the compute server, while the MapR connection was using the workspace server of the VA server

Re: Connection to MapR from SAS Visual Data Builder: Libref is not assigned error

Madelyn_SAS — Fri, 26 Jan 2024 18:20:18 GMT

If you run PROC SETINIT inside of Data Builder by opening the Code window for a new query, and clearing out all of the auto-generated code, like this:

Do you see SAS/ACCESS for Hadoop along with the Visual Analytics products?

If so, then I'd suggest opening a ticket with SAS Technical Support at https://service.sas.com/csm?id=sc_category&sys_id=1b8611d5c3921200b0449f2974d3ae12