simple sql query on SAS VA library gives error

saspert — Wed, 09 Sep 2015 17:53:58 GMT

23 proc sql;
24 select * from lasrlib.bb_may2015;
ERROR: More than one LASR Analytic Server table with the provided host/port was found in metadata.
NOTE: The table LASRLIB.BB_MAY2015 does not exist in the SAS LASR Analytic Server on host 'localhost', port 10031.
ERROR: File LASRLIB.BB_MAY2015.DATA does not exist.
ERROR: The datasource table LASRLIB.BB_MAY2015 does not exist.

Any suggestions will be appreciated.

I am running SAS VA 7.1 on MS sql server db/ MS windows nt server.

I have 3 VA related libraries -

a)Visual analytics LASR library (VALIBLA)

b)Visual analytics public data provider (DPPUBLIC)

c)Visual Analytics Public LASR (LASRLIB)

Thanks,

saspert

Re: simple sql query on SAS VA library gives error

MichelleHomes — Thu, 10 Sep 2015 00:43:24 GMT

It seems that you may have your library registered more than once in metadata and the table isn't loaded into memory.

From the snippet, it appears you may be writing the code in SAS Enterprise Guide. Is that the case? If so, can you access the table directly in SAS Visual Analytics? Maybe the table is loaded into another VA library?

topic simple sql query on SAS VA library gives error in SAS Visual Analytics

simple sql query on SAS VA library gives error

Re: simple sql query on SAS VA library gives error