topic Re: Stored Process in VA ends in ERROR: the same script from EG ends successfully in SAS Visual Analytics

Stored Process in VA ends in ERROR: the same script from EG ends successfully

gabras — Fri, 01 Mar 2019 10:26:07 GMT

Hi everyone,

i have a stored process that ends in error if it's executed by VA wich has a dedicated server. The query refers to a table that is in another server (back-end server) by a shared folder.

The error is:

ERROR: Sort execution failure

If i run the same sql query in the back-end server and it runs without any error.

The table is the same.

I really don't understand how is it possible.

See the attached log. Unfortunately the log is in italian 😞

Can anyone help me?

Thank you

Re: Stored Process in VA ends in ERROR: the same script from EG ends successfully

SASKiwi — Wed, 06 Mar 2019 07:10:42 GMT

The Stored Process server runs under a special service account, often sassrv, while EG workspace server sessions usually run under the account of the SAS user. So I suspect the service account you are using doesn't have the right permissions to complete the SAS script successfully. I suggest you check with your SAS administrator to get this sorted.

Re: Stored Process in VA ends in ERROR: the same script from EG ends successfully

gabras — Fri, 08 Mar 2019 10:11:08 GMT

It was a very generic ERROR indicating some sort of problem.

In my case was the disk which usage was 99%.

I solve it deleting a few log files.