How to delete Projects or Tasks from a Worldserver Database

Scope/Environment:

WorldServer any version

Question:

Sometimes a project or task needs to be completed removed from a WorldServer environment to address an error - mostly due to a defect - and because there is no other workaround.

Which query should be run to delete a Project or a Task from a WorldServer Database?
 
Answer:
First, you need to determine which type of Database is running on the affected WorldServer environment: Oracle or SQL.

1- To remove a Project, refer to the Project ID (not the Project Group ID) displayed in the project page.

If you are working with an Oracle Database, use this stored procedure

exec spDeleteProject (projectID)

and make sure you (or the Database manager) does a commit; Here is an example:

exec spDeleteProject (224356)
commit;

If you work with an SQL Database, the query to delete the project would be:

exec spDeleteProject projectID

2- To remove a Task from the Database, first find the Task Id. This might be mentioned in an error message, or you can find that by hoovering with your mouse cursor on the Task number as explained in this screenshot:



1- To delete a Task in an Oracle hosted environment access the Database and then run this query
1- To delete a Task in an Oracle hosted environment access the Database and then run this query
exec spDeleteTask (taskID)
commit;
Replace taskID with the actual taskID, for instance
exec spDeleteTask (473914)
commit;

On SQL Servers you can execute the Stored Procedure spDeleteTask and pass Task ID as parameter value. For instance:
exec spdeletetask 473914
Reference