Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

sachincs1991
Level 3
Level 3

Hi Team,

 

In order to have the follow up and better solution to understand, from the following blog wanted to continue discussion.

 

Please help me to find the solution for this.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/ora-210000-oracle-...

 

Thanks,

Sachin

 

 

1 Accepted Solution
sachincs1991
Correct answer by
Level 3
Level 3

Hi @prasannakumarmarru ,

 

We could not find what is the exact issue?

But the issue is resolved now.

 

What we did is, Created new workflow and delivery and triggered the campiagn.

But still its question for us, what exactly caused this issue?

 

Thanks,

Sachin

View solution in original post

2 Replies
prasannakumarmarru
Level 4
Level 4

@sachincs1991  Have you tried enabling SQL logs on delivery analysis? This might help you understand when is that temp table gettign deleted.

prasannakumarmarru_0-1608439572771.png

 

If this is not happening any longer, this may not be useful to troubleshoot. 

 

sachincs1991
Correct answer by
Level 3
Level 3

Hi @prasannakumarmarru ,

 

We could not find what is the exact issue?

But the issue is resolved now.

 

What we did is, Created new workflow and delivery and triggered the campiagn.

But still its question for us, what exactly caused this issue?

 

Thanks,

Sachin