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

Avatar

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sachincs1991
Level 2

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
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

155 likes

Total Posts

913 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

155 likes

Total Posts

913 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
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
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sachincs1991
Level 2

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
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sachincs1991
Level 2

15-12-2020

Hi @amritakedia_epsilon ,

 

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

 

Thanks,

Sachin

Avatar

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sachincs1991
Level 2

15-12-2020

Hi @amritakedia_epsilon 

 

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

 

Thanks,

Sachin

Avatar

Avatar
Validate 1
Level 2
amritakedia_epsilon
Level 2

Likes

5 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Validate 1
Level 2
amritakedia_epsilon
Level 2

Likes

5 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
amritakedia_epsilon
Level 2

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.