- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.