SAS Visual Analytics 7.5 Sort Execution Failure | Cannot execute Visual Data Query in SAS VA

[vfarmak]

Greetings everyone,

We are experiencing the following problem: Our SAS LASR libraries were down so we performed the following steps:

1. Performed a restart on the linux machine
2. Cleared all the logs 
3. Start the SAS LASR Libraries (we have two: the public LASR and the LASR)
4. Executed a visual data query on a very large dataset
5. The below problem occurred

Sort execution failure. Do you have a guideline on how to process these types of errors?

Thank you very much for your time.

Vasileios

[sbxkoenk · Accepted solution]

Is this a VA Data Builder query?

I think the "Sort execution failure" error is caused by a resource issue, such as (disk) space in WORK or UTILLOC.

Can also be due to a lack of memory.

This SAS Note: http://support.sas.com/kb/39/705.html has some good information on how to trouble-shoot.

BR, Koen

[sbxkoenk]

You can also check:

• system quotas
• process limits

To check the process limits, ... please have the user (that runs into Sort Execution Failure) submit this code from their SAS session:

data _null_ ;
infile  "/proc/&sysjobid/limits";
input ;
put _infile_ ;
run ; 

This will print the effective process limits for the SAS session to the log.

One of the limits is for the largest file size the user can create, another is the maximum number of files the process can have open. Either one of these could lead to the error.

BR, Koen

[vfarmak]

Hi @sbxkoenk 

After long troubleshooting we have figured out the following:

The head node was restarted but the data nodes were not. Therefore we took the following actions:

1. Restarted the data nodes
2. Restarted the head node 

Afterwards everything went to normal.

Thank you for the article you shared.

Best Regards,

Vasileios