12/14/2020 3:37:16 PM Applying rule 'Wave scheduling check'.
12/14/2020 3:38:00 PM Uploading tracking information on server 'redcross-mid-prod3.campaign.adobe.com'...
12/14/2020 3:38:13 PM DLV-490119 Analysis completed in 30m 48s with warnings (1898819 message(s) waiting).
12/14/2020 3:38:27 PM Cleaning data from previous analysis...
12/14/2020 3:41:43 PM Deletion of 1898819 record(s) from table 'ArcBroadLogPERD' completed in 3m 17.0s and 190 step(s)
12/14/2020 3:41:44 PM Creation of 48 tracking URL(s) completed in 0.0s.
12/14/2020 3:41:44 PM Loading typology rules (step: sql/preMessage)...
12/14/2020 3:41:44 PM Loading typology rules (step: businessRanking/preMessage)...
12/14/2020 3:41:44 PM XSV-350122 An error occurred and the process has been stopped.
12/14/2020 3:41:44 PM ORA-210000 Oracle error: ORA-00942: table or view does not exist
12/14/2020 3:41:44 PM WDB-200001 SQL statement 'UPDATE wkDlv_398955867 SET iFailureReason=8, iMsgId = 347364256 WHERE (3 = (SELECT A.iStatus FROM NmsAddress A WHERE A.sAddress = wkDlv_398955867.sAddress AND A.iType = 0) OR wkDlv_398955867.iBlackList = 1) AND wkDlv_398955867.iFailureReason = 0' could not be executed.
12/14/2020 3:41:44 PM SOP-330011 Error while executing the method 'PrepareMessageImpl' of service 'nms:delivery'.
12/14/2020 3:41:44 PM DLV-490026 An error occurred when applying rules for the identifier '' associated delivery.
12/14/2020 3:41:44 PM Deletion of 21103 record(s) from table 'ArcExcludeLogPERD' completed in 1.0s and 3 step(s)
12/14/2020 3:41:44 PM Loading typology rules (step: volume/preMessage)...
Solved! Go to Solution.
Looks like the workflow temp table used in the campaign was deleted may be by the database cleanup job . If you rerun the workflow this issue should get resolved.