Table or view doesn't exist

[kquintin]

Hi,

I am experiencing a problem with my deliveries.

The workflow stops, pauses, and the logs show the message ‘table or view does not exist’.

A delivery was made on a test environment, with a single workflow running, and the error appears on the first execution of the workflow.

What could be causing this error?

To my knowledge, Adobe Campaign deletes its temporary tables once the workflow has completed.

However, in my case, the problem occurred during the execution of the workflow.

I need to know what could be causing this Oracle error: ‘ORA-00942: Table or view does not exist’, and the various possibilities.

Kind regards,

[ccg1706]

Hi @kquintin, 

The error means Adobe Campaign is trying to query a table that doesn't exist or can't be accessed. I would recommend you to check  the exact table in the logs and verify that exists in Oracle and that you as a Campaign user has rights to it.

Hope it helps, and if not don't doubt on coming back. 

Best, 

Celia