Symptoms

Drop database user task failed with the error:

Provisioning request failed. IDispatch error #3092 [<response><errorContext description="Object 'xxxxx' does not exist or is not a valid object for this operation." code="0x80040e14" executeSeqNo="2"><errorSource namespace="SQL Provider" procedure="ExecSQL"/></errorContext></response>]

Cause

The drop database user task was initiated by deprovisioning of APS application instance.

The issue caused sometimes because APS application creates database schema by itself, on uninstallation configuration script does nothing, issue can be caused, for example, by temporary objects.

Resolution

  1. Cancel the task 'Drop database user xxx', this allows the next task 'Drop database xxx' to process.

  2. After successfull deletion of the database manually create database with the same name in MSSQL server (for example using Microsoft SQL Management Studio utility) and re-ran the task 'Drop database user xxx'.

  3. Delete manually created database

Internal content