Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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

 

 

 

 

sachincs1991_1-1608021847414.png

 

1 Accepted Solution

Avatar

Correct answer by
Administrator

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



Sukrity Wadhwa

View solution in original post

7 Replies

Avatar

Level 3

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.

Avatar

Level 3

Hi @amritakedia_epsilon 

 

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

 

Thanks,

Sachin

Avatar

Level 3

Hi @amritakedia_epsilon ,

 

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

 

Thanks,

Sachin

Avatar

Level 3

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

Avatar

Correct answer by
Administrator

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



Sukrity Wadhwa