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

[gabras]

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

[SASKiwi]

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.

[gabras · Accepted solution]

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.