...
| Code Block |
|---|
DELETE FROM WorkflowTargetFSSs WHERE workflowId NOT LIKE 'MC:%' AND workflowId NOT LIKE 'MC_:%' |
Deletion of a faulty task
When a task in the database has a malformed taskProperties configuration, this will disturb the TaskManager and the constructing the tasks cache. In that case it is advised to first check which taskId belongs to the faulty task and then manually remove it.
E.g. taskId 'MC00:000000752_12' is a singe task that is missing a time0 object.
| Code Block |
|---|
SELECT taskId, taskProperties FROM Tasks WHERE taskId='MC00:000000752_12'
--no longer available in 2017.02
DELETE FROM CurrentModuleInstanceRuns WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM ArchiveMetaData WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM Reports WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM ModuleInstanceRuns WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM ModuleRunTables WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM TaskRunCompletions WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM TimeSeries WHERE creatorTaskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM ArchiveMetaData WHERE taskRunId IN (SELECT taskRunId FROM TaskRuns WHERE taskId='MC00:000000752_12')
DELETE FROM TaskRuns WHERE taskId='MC00:000000752_12'
DELETE FROM Tasks WHERE taskId='MC00:000000752_12' |