Question
6
Replies
502
Views
Ford Motor Company
Posted: January 22, 2019
Last activity: January 23, 2019
Marketing DB Table for Output DB Template is not inserting into existing table
Hi,
We have scenario, to write the campaign output into our own table.
We have created a DB template and mapped into our own table. After we run the campaign with those DB template using the "Generic Treatment" shape and mention the DB template name.
After we run the campaign getting below error.
Critical
Failed to create output table: TestDBTemplate
Review and update the campaign to resolve this issue and re-run the Seed Test.
Regards,
Anandh
Hi,
Can you clarify if you created the target table too ?
For DB templates, you should not / need not do that.
You should just define the list of fields in the DB template, give a name to the table in the template rule, and let the run time create the table for you based on the template definition.
The run time will create the table in the configured marketing schema before inserting the records.
If you have not created the table and still seeing the error, you need to contact support (by opening an SR) with full exception stack trace in the logs etc.
One hunch could be permission issues in the schema etc., but only detailed logs could explain that.