Error sending deliveries to recipients not in database

Last update: 2023-10-02

Description

Environment
Adobe Campaign Classic v8

Issue
When attempting to send deliveries to recipients that aren’t stored in the database (DB) via an external file, an error is thrown during delivery preparation.

Steps to reproduce:

  1. Create a new delivery.

  2. Add Subject and add content as per business requirement.

  3. Click “To” and in the main target, choose “Defined in external File”.

  4. Change Target mapping to External file from the dropdown.

  5. Click the checkbox “Do not import the recipients in DB” in order to not import the recipient in the DB.

  6. Click File Format Definition. Choose a local file in .csv format. Click the checkbox for Upload file on server. Click Update on the server. Select Transfer Ok. Click Next.

  7. In this screen, choose email in the address field from the dropdown. Then click Finish.

  8. Save the delivery.

  9. Prepare the delivery, and then the following errors will be thrown:

    SOP-330011 Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'.
    WDB-200001 SQL statement 'DROP TABLE wkDlv_xxxx_Excl' could not be executed.
    ODB-240000 ODBC error: SQL compilation error: Table 'DB_NAME.PUBLIC.WKDLV_xxxx_EXCL' does not exist or not authorized. SQLState: 42S02
    WDB-200001 SQL statement 'ALTER TABLE wkDlv_xxxx RENAME TO wkDlv_xxxx' could not be executed.
    ODB-240000 ODBC error: SQL compilation error: Table 'DB_NAME.PUBLIC.WKDLV_xxxx' does not exist or not authorized. SQLState: 42S02
    DLV-491034 Cannot prepare delivery for tenant xxxx: mid-sourcing service is setup for Full FDA deliveries only.
    

Resolution

Workaround
Load the recipients into a separate table on the FFDA database before using this table with specific mapping to send the email messages.

There is no fix available at this time.

Related Reading
Sending Email Communication to emails not included in recipients schema but exists in external file || Campaign Classic in our KCS documentation.

On this page