While deleting a Robot, we are getting "An error occurred" message in the Orchestrator. Furthermore, we could not see any logs in the Event Viewer.
Step 1: Update Registry entry to view Orchestrator log message by creating a new key(EventLogMessages) under - Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Orchestrator
EventMessageFile(Name) ==> REG_EXPAND_SZ ==> C:\Windows\Microsoft.NET\Framework64\v4.0.30319\EventLogMessages.dll
After doing above changes, recreate the issue and check for error message as below, if it matches then follow step 2:
Step 2: Grant dbo schema access to a user:
GRANT EXECUTE ON SCHEMA::dbo TO [sql_user]