ORA-210000 Oracle error: ORA-00942: table or view does not exist | Community
Skip to main content
S
sachincs1991
Level 3
December 15, 2020
Solved

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

  • December 15, 2020
  • 5 replies
  • 3548 views

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

 

 

 

 

 

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 Sukrity_Wadhwa

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-error-ora-00942-table-or-view-does-not-exist/qaq-p/391242

5 replies

A
amritakedia_epsilon
Level 3
December 15, 2020

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.

S
sachincs1991Author
Level 3
December 15, 2020

Hi @amritakedia_epsilon 

 

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

 

Thanks,

Sachin

A
amritakedia_epsilon
Level 3
December 15, 2020
Is there any Custom typology rule on the Delivery?
S
sachincs1991Author
Level 3
December 15, 2020

Hi @amritakedia_epsilon ,

 

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

 

Thanks,

Sachin

S
sachincs1991Author
Level 3
December 17, 2020

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
Community Manager
Sukrity_WadhwaCommunity ManagerAccepted solution
Community Manager
December 22, 2020

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-error-ora-00942-table-or-view-does-not-exist/qaq-p/391242

Sukrity Wadhwa
Terms & ConditionsAccessibility statement

Loading footer...