Getting Internal Server Error in Get Transaction Item

Help
,
1

All,
We have installed Orchestrator 2016.2

We are able to add items to the queue but we are not able to get them via the Get Transaction Items as seen in the error below.

Get Transaction Item : Response status code does not indicate success: 500 (Internal Server Error).

Any ideas?

Marcin

2

Hi Marcin,

Did You solve this problem?
We have also similar problem when reading items from queue.
We receive error:

System.Exception: Response status code does not indicate success: 500 (Internal Server Error).
at System.Activities.Statements.Throw.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Any ideas how solve this?

Regards
Mateusz

3

The issue is the user that is used by Orchestrator to connect to the SQL Database does not have the EXECUTE PERMISSION on the SQL stored procedures.

The next item from the queue based on priority, due date and defer date is obtained by a stored procedure.

The user that is used for authentication to the SQL db needs to:
a) either be db_owner on the database
b) or have db_datareader, db_datawriter, db_ddladmin and EXECUTE permission on all the stored procedures from the UiPath database

4

Any steps on how to enable this execute permission? Is there any other way to address this issue?

5

Hi Ovidiu,

I have seen even if we have Execute permission, sometime this error occurs. Any specific root cause behind that ?