ORA-210000 Oracle error: ORA-00942: table or view does not exist

[sachincs1991]

Hi Team,

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)...

[amritakedia_epsilon]

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.

[sachincs1991]

Hi @amritakedia_epsilon 

This is still erroring out even after we execute for second and third time.

Thanks,

Sachin

[amritakedia_epsilon]

Is there any Custom typology rule on the Delivery?

[sachincs1991]

Hi @amritakedia_epsilon ,

Yes, but this is not the issue.

Thanks,

Sachin 

[sachincs1991]

Hi @amritakedia_epsilon ,

Yes, we have but these all did not create any issues till today.

Thanks,

Sachin

[sachincs1991]

Hi @amritakedia_epsilon ,

Yes, Custom typology is there and We have been executing this for about an year or so.

The problem is not with custom typology for sure.

Thanks,

Sachin

[Sukrity_Wadhwa · Accepted solution]

Please follow this thread for the solution as posted by the author of the question himself: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/ora-210000-oracle-...