topic Re: Error in SAS VA in SAS Visual Analytics

Error in SAS VA

DartRodrigo — Tue, 17 May 2016 18:51:54 GMT

Hi mates,

I'm trying to load a new table in Visual analytics and i'm getting the following errors:

-------------- Task Summary --------------
SUCCESS (SASJob PreCode)
ERRORS (Load Table)
----------------------------------------------
ERROR: The HDFS file has blocks stored on machines that are not included in this server.
ERROR: The HDFS file has blocks stored on machines that are not included in this server.
ERROR: Creation of the in-memory image for HDFS file '/vapublic/relatorio_relacionamento' failed. The file has not been added to
the LASR Analytic Server.

These errors started after they restarted the services.

Why is that happening ?

What is the solution for this issue ?

Thanks in advance

Re: Error in SAS VA

ballardw — Tue, 17 May 2016 23:27:14 GMT

@DartibaliRodrigo wrote:

These errors started after they restarted the services.

When something is "restarted" or similar check whether there were any errors reported related to drives not being available or if a configuration change was made that affects drive mappings and such.

My guess is someone forgot to include a previous setting when restarting.

Re: Error in SAS VA

gabras — Thu, 29 Dec 2016 14:21:53 GMT

Hi, i have the same problem. Any suggestion to solve this????

Re: Error in SAS VA

gabras — Thu, 29 Dec 2016 15:02:23 GMT

Specifically, while we are attempting to load the table from hadoop to lasr server whe have the following problem:

ERROR: Communication failure between LASR Analytic Server and client application.
ERROR: Creation of the in-memory image for HDFS file '/hps/table_va' failed. The file has not been added to the LASR
Analytic Server.

A different problem exists also when we try to unload the same table from hadoop:

ERROR: The table HPS.table_VA could not be located in the LASR Analytic Server image.

These problems happen not for all the tables we are loading.

We run each program by sh in a Linux distributed environment.

Re: Error in SAS VA

gabras — Thu, 29 Dec 2016 15:40:27 GMT

I made a mistake:

A different problem exists also when we try to unload the same table from ~~hadoop~~ Lasr Server:

ERROR: The table HPS.table_VA could not be located in the LASR Analytic Server image.

I read also this post about "trying to LOAD a table from ODBC Library" to LASR :

https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-LASR-Table-Loading-Error/m-p/265374#M3966

The solution is:

"This error is caused when the user is trying to load a table whose table structure is not identical to its earlier version".

If it is the solution, how can i unload this table forcedly?

Re: Error in SAS VA

DartRodrigo — Tue, 14 Feb 2017 17:59:45 GMT

Hi guys.

Sorry, forgot to answer this.

We still having troubles with this.

It is the cause of earlier version of table, cause we've updated the table in the metadata and in data builder.

Att

Re: Error in SAS VA

sasadmin000 — Fri, 04 Jan 2019 15:13:42 GMT

Just to add another possibility in case this issue is encountered - this can occur if the underlying HDFS cluster is in a compromised state. Check and possibly restart the HDFS cluster. It's not very clear from the error message but I experienced this. 2 VMs had failed and restarted. I had started the LASR server again but didn't think to check HDFS, and it turned out 2 datanodes were also down. Restarting HDFS fixed it.