Salesforce

WorldServer - How to delete Projects or Tasks from a Worldserver Database

« Go Back

Information

 
TitleWorldServer - How to delete Projects or Tasks from a Worldserver Database
URL Name000004484
SummarySometimes an 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. This article provides instructions. However, be very careful when working directly in the Database! Deletion queries are irreversible.
Scope/EnvironmentSDL WorldServer
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
Note: the SPDELETE stored procedures do not remove a project or a task completely from the Database. The Stored Procedure moves a project from the PROJECTS Table to the ARCHIVEPROJECTS table and/or a task from the TASKS to the ARCHIVETASKS table, similar to what is done when a project is archived by the Garbage Collector.
However, please be careful: deleting a project or a task from a Database is an irreversible action. A project cannot be made active and visible again after running the stored procedures mentioned below. Make sure you enter the correct data and you are really sure that you want to perform a deletion.

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:

User-added image
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 a parameter value. For instance:
 
exec spdeletetask 473914

Note: these stored procedure do not remove the project or task completely from the Database. It moves them from the PROJECTS Table to the ARCHIVEPROJECTS table and/or from the TASKS to the ARCHIVETASKS table, similar to what is done when a project is archived by the Garbage Collector.
Reference
Attachment 1 
Attachment 2 
Attachment 3 
Attachment 4 
Attachment 5 

Powered by