The ffdaUnicity workflow fails with ODB-240000 error

The workflow ffdaUnicity fails with the following error:

ODB-240000 Error ODBC : SQL compilation error: Object ‘XXXXX’ does not exist or not authorized. SQLState: 42S02

Description description

Environment

Adobe Campaign Classic v8

Issue/Symptoms

The audit logs show that the workflow ffdaUnicity fails with an error on the JavaScript activity – check for all custom schemas AND "nms:recipient".

Error:

ODB-240000 Error ODBC : SQL compilation error: Object ‘XXXXX’ does not exist or not authorized. SQLState: 42S02

Resolution resolution

Depending on whether you want the table to be created or not, you can apply either of these solutions:

  • Run the  Update Database Structure wizard to create the table.
  • Delete the schema if you don’t want to create the table.

Cause

The error occurs because a schema is created in ACC, but the Update Database Structure wizard hasn’t been run for it, so the table of the schema doesn’t exist in the database.

Ask Questions In Our Experience League Campaign Community
If you have any questions you’d like answered about this topic, or read previous answered-questions, we invite you to view our Experience League Community blog post that includes this article, send us your questions and comments, and join our Experience League Campaign Community!

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f