Unable To Delete/ Update Any Asset From Orchestrator

News Knowledge Base
,
1

How to troubleshoot when it is not possible to Delete/ Update any Asset from the Orchestrator?

The steps performed are,

  1. Checked the IIS configuration for the MIME settings
  2. Request filtering to understand if any Request was getting blocked
  3. Enabled all the Verbs and extension explicitly in IIS
  4. Created a new SQL user with SQL authentication with DB owner permissions and explicitly run the below to make sure the explicitly EXECUTE permissions were provided
  5. Use UiPath GO GRANT EXECUTE ON SCHEMA::dbo TO GO
  6. Created a HTTP binding to check the behavior, same issue was seen, could not delete assets
  7. There was no error recorded on Orchestrator User interface and the response code returned is 200
  8. Event Viewer captured could not be shared due to security reasons but as per the person onsite no error is captured in event viewer at the time the API request is made
  9. Tested the same from Swagger to delete the API but the API returned 200 response but nothing was deleted from the Orchestrator User interface
  10. IIS logs captured 200 response
  11. Checked Redis configuration but no configuration was enabled
  12. Created a new database and new installation was performed for Orchestrator but same behavior was seen that the 200 response code was 200 but the data was not actually removed
  13. Requested to enable SQL tracing as no logs were captured anywhere else with the errors.
To perform the above steps, suitable permissions need to be available on database.

Resolution:
  • RL scanning needs to be enabled to block the PUT and DELETE traffic
  • The file present in the below location,
    • C:\Windows\System32\inetsrv\urlscan needs to be modified
  • Change the Allow verbs in this file, by adding DELETE and PUT, which was missing earlier.