Clear test orders from an installation before go-live

Use the following instruction to remove all ZervicePoint orders and workflows from an installation, for instance before going live.

Stop the ZervicePoint Windows services

This procedure requires the following ZervicePoint Windows services to be switched off - ZervicePoint Process System - ZervicePoint Provisioning System - ZervicePoint Provisioning Inventory System

Clear tasks

Run the following TSQL script in a query window against the ZervicePoint database in SQL Server Management Studio:

DELETE FROM TaskComponent.Delegations
DELETE FROM TaskComponent.TaskMetadata
DELETE FROM TaskComponent.TaskAssignments
DELETE FROM TaskComponent.TaskTranslations
DELETE FROM TaskComponent.TaskStatusTranslations
DELETE FROM TaskComponent.TaskStatus
DELETE FROM TaskComponent.TaskComments
DELETE FROM TaskComponent.Comments
DELETE FROM TaskComponent.Tasks
DELETE FROM TaskComponent.TaskParameters
DELETE FROM TaskComponent.Workflows

Clear orders

Run the following TSQL script in a query window against the ZervicePoint database in SQL Server Management Studio:

DELETE FROM OrderComponent.OrderStatusTranslations
DELETE FROM OrderComponent.OrderParameters
DELETE FROM OrderComponent.Orders
DELETE FROM OrderComponent.OrderEvents
DELETE FROM OrderComponent.OrderIds

Clear provisioning queue

Run the following TSQL script in a query window against the ZervicePoint database in SQL Server Management Studio:
```
DELETE FROM ProcessSystem.ProvisioningJobsQueue
```
Clear profiles

Run the following TSQL script in a query window against the ZervicePoint database in SQL Server Management Studio:
```
DELETE FROM SecuritySystem.FavoriteServices
DELETE FROM SecuritySystem.UserProfiles
```
The profiles will be re-created when users log in again, but their language, time zone and culture settings will be lost.
Remove the WorkflowManager scope for the "Store" store

Run the following command in a PowerShell session:
```
Remove-WFScope -ScopeUri https://<workflowhost>:12290/Store
```
The scope and all instances belonging to it will be removed. The ZervicePoint Process System will create the scope again when it processes an order.
Remove and re-create the ZervicePoint ServiceBus queue

Run the following command in a PowerShell session:
```
Get-SBNamespace -Name ZervicePoint
```
Take a note of the ManageUsers property and enter it below:
```
Remove-SBNamespace -Name ZervicePoint
New-SBNamespace -Name ZervicePoint -ManageUsers example@company.com
```
Please note, that you have to wait anywhere from 20 minutes to a couple of hours before executing "New-SBNamespace", otherwise you get the following error message

"A pending deletion is remaining for the namespace 'ZervicePoint'"
Restart the ZervicePoint Windows services

Start the following services:
- ZervicePoint Process System
- ZervicePoint Provisioning System
- ZervicePoint Provisioning Inventory System