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

Avatar

Avatar

sachincs1991

Avatar

sachincs1991

sachincs1991

15-12-2020

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

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

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

Answers (4)

Answers (4)

Avatar

Avatar

sachincs1991

Avatar

sachincs1991

sachincs1991

16-12-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

Avatar

Avatar

sachincs1991

Avatar

sachincs1991

sachincs1991

15-12-2020

Hi @amritakedia_epsilon ,

 

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

 

Thanks,

Sachin

Avatar

Avatar

sachincs1991

Avatar

sachincs1991

sachincs1991

15-12-2020

Hi @amritakedia_epsilon 

 

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

 

Thanks,

Sachin

Avatar

Avatar

amritakedia_epsilon

Avatar

amritakedia_epsilon

amritakedia_epsilon

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