topic Re: Loading data into LASR for first time in Administration and Deployment

Loading data into LASR for first time

titan31 — Thu, 17 Oct 2019 07:27:35 GMT

Hi,

I'm currently on a project that is migrating our SAS environment from Windows non distributed VA to Linux distributed VA.

I'm having an issue with loading the tables into LASR for the first time, as it won't allow me to do it via the administration page on VA (either reload, or delete and load). The partner we're working with has said to import them via the data builder tool, and I've done that, but it seems kind of crazy that that's the option as whilst we have a lot of datasets, I'd imagine some companies have hundreds so to do each dataset manually like that would take forever.

It's also after creating a load of Visual Data Query files in the folder which we never have had on the Windows environment.

Can anyone tell me is this the correct way to do have done this for a first time load, or was there a proper automated way of doing it?

Thanks,

Re: Loading data into LASR for first time

AnandVyas — Thu, 17 Oct 2019 08:48:08 GMT

Hi @titan31

You can use SAS Visual Analytics Administrator to load or reload tables to the SAS LASR Analytic Server, or to unload tables.

What is the issue you are facing when you load?

Re: Loading data into LASR for first time

titan31 — Thu, 17 Oct 2019 08:55:01 GMT

Hi,

Atm, if I try to unload data, it tells me

ERROR: Failed to load analytic extension for the distributed computing environment.
ERROR: Unable to send machine list to

If I try to reload, it tells me data is already loaded.

When I was trying to load originally, it just said couldn't find data source, so I was told by the externals we're working with to import via the VA data builder, however that took a long time and I'm not sure it's worked correctly, as can't view a lot of reports, and it's after creating a load of Visual Data Query objects in the folder that when I try to delete, I get Exception occurred deleting Visual Data Query '' Reason: 404 null.

Re: Loading data into LASR for first time

AnandVyas — Thu, 17 Oct 2019 08:59:32 GMT

ERROR: Failed to load analytic extension for the distributed computing environment.
ERROR: Unable to send machine list to

The Error you have shared looks exactly similar like example 2 in the KB link which is problem with passwordless SSH setup for the LASR server nodes. The shared KB link also have the solution to this problem, which I think you should try.

Re: Loading data into LASR for first time

titan31 — Thu, 17 Oct 2019 09:38:09 GMT

Hi,

So I managed to delete them by using a different account, but still getting an issue on reloading or loading them.

If I try and reload, I get Not processed(not reloadable), and if I try and load in I get Load table failed, library.tablename.DATA does not exist.
-