Error while deliting rows?

[ogonzalesdiaz]

I tried deleting 5M records where TIPVENTA column is equal to 23, but got this error: 

24/09/2023 17:53:46 WDB-200001 SQL statement 'UPDATE BcpLEAD SET FROM wkf58347283_273_1 OutTbl WHERE BcpLEAD.iLEADId=OutTbl.iPKey_1 AND OutTbl.iRecProcState>:#(1)# AND OutTbl.iRecProcState<=:#(2)# AND OutTbl.iPKey_1<>0' could not be executed. Param(0)=100 Param(1)=101

[ParthaSarathy · Accepted solution]

Hi @ogonzalesdiaz ,

In update data activity, select operation type as 'Delete'.

(And make sure, in your query, targeting dimension is 'Lead' table)