Documentation

Error sending deliveries to recipients not in database

Last update: Tue Jul 23 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

This article addresses the Campaign Classic issue where errors are thrown during delivery preparation while attempting to send deliveries to recipients that aren’t stored in the database. The workaround is to load the recipients into a separate table on the database before using the table with specific mapping to send email messages.

Description 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 drop-down.

  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.

  7. Click the checkbox for Upload file on server. Click Update on the server. Select Transfer Ok. Click Next.

  8. In this screen, choose email in the address field from the drop-down. Then click Finish.

  9. Save the delivery.

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

    code language-none 
    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 resolution

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.

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

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