Solution ID: prim80446
Log DbaAddTimesheetTask error. . Error: IDispatch error #3092 , Desc: LDV Integrity Error. Cannot insert/restore rsrchour 30475714 because taskrsrc 1420918 is deleted
Status: Reviewed
Version(s): 6.1, 6.2, 6.2.1

Problem:

Log DbaAddTimesheetTask error. . Error:  IDispatch error #3092 , Desc:  LDV Integrity Error. Cannot insert/restore rsrchour 30475714 because taskrsrc 1420918 is deleted

Problem: Exception error

File:SkippyDS.cpp, Line:6033, Error:80040e14, Description:LDV Integrity Error. Cannot insert/restore rsrchour 30475714 because taskrsrc 1420918 is deleted


Context:Resource Name=XXXXXX


Resource ID=xxxxx
Change: Database upgraded from 5.0 to 6.1
Cause: User opens timesheets. 

A new row is being added to the RSRCHOUR table (rsrc_hr_id 30475714) with the value from the TASKRSRC (taskrsrc_id 1420918)  The row in the TASKRSRC table (taskrsrc_id 1420918) is maked to be deleted. 

Fix: Manually Pruge deletes and make sure the backgroud jobs are running. 

How to manually run PURGE DELETES via scripts