Table or view doesn't exist

Question

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 · Accepted Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded