Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Facing "Invalid object name" Error in Email Delivery

Avatar

Level 3

Hi ,

I am facing the below error repeatedly while running email delivery.

08/05/2022 8:49:23 PM LL Src_W0 ON (Ext_W0.sValid_Email=Src_W0.sValid_Email)' could not be executed.
08/05/2022 8:49:23 PM N,Ext_W0.sValid_Email,Ext_W0.sLOB,Ext_W0.sName,Ext_W0.tsLoad,Ext_W0.sMOBILENO,Ext_W0.sPRIMARY_LOB,Ext_W0.sFULL_NAME,Ext_W0.sEMAILID,Ext_W0.sCITY,Ext_W0.sCII,Ext_W0.sLoadt,Src_W0.iTargetDataId FROM wkf451848699_349_1 Ext_W0 INNER JOIN wkf451848699_357_1_A
08/05/2022 8:49:23 PM WDB-200001 SQL statement 'INSERT INTO wkf451848699_357_2_ALL(iId,iBlackList,iId1,sCIIN,sValid_Email,sLOB,sName,tsLoad,sMOBILENO,sPRIMARY_LOB,sFULL_NAME,sEMAILID,sCITY,sCII,sLoadt,iTargetDataId ) SELECT Ext_W0.iId,Ext_W0.iBlackList,Ext_W0.iId1,Ext_W0.sCII
08/05/2022 8:49:23 PM ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'wkf451848699_349_1'. SQLState: S0002

Please help us understand the issue and provide us with a resolution.

Console: v7

Build Version: 9032

 

Thanks & Regards,

Neelam B.

1 Reply

Avatar

Employee

Hi Neelam,

 

Did the delivery was copied from some other workflow?

Have you tried creating the workflow from scratch and checking if the error appears?

 

Thanks,

Deepika