Error while deliting rows? | Community

Level 6

Solved

Error while deliting rows?

Forum|Forum|2 years ago
September 24, 2023
1 reply
584 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

Hi @god_prophet ,

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

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

Community Advisor

Accepted solution

Community Advisor

Hi @god_prophet ,

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

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

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups