ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

UPDATE PRTEAM query running longer

book

Article ID: 239054

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The below query has been running for several hours and is not completing. 

UPDATE PRTEAM
SET ODF_NK_ALLOCCOST_CURVE = NUL

Cause

The query was initiated from the Update Earned Value Totals job which had been stuck in running status. This is because, the Prod DB was refreshed on to Test env and the processing job from Prod got carried over to TEST and got stuck. 

Resolution

Cancel the job and reschedule it. 

Ideally, it is recommended to pause all jobs before a DB back up or validate the refreshed environment for any long running jobs. Cancel and reschedule them.