BulkExec component with no schema set

One Star

BulkExec component with no schema set

Hi,
I am using tVerticaBulkExec to copy a file into a vertica database, I would like it to be neutral to schema going in.
I have tested the same component/setup with a tMySqlBulkExec, and that works fine, however with tVerticaBulkExec I get the error
java.sql.SQLException: (4856) ERROR: Syntax error at or near "null"
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.jdbc.VerticaCopyStream.start(Unknown Source)
at dw_2_0.writetables_0_1.WriteTables.tVerticaBulkExec_2Process(WriteTables.java:344)
at dw_2_0.writetables_0_1.WriteTables.runJobInTOS(WriteTables.java:603)
at dw_2_0.writetables_0_1.WriteTables.main(WriteTables.java:449)
Caused by: com.vertica.util.ServerException: (4856) ERROR: Syntax error at or near "null"
... 7 more

If I set the schema in the BulkExec component, then the job runs fine, however I need the job to run with a variety of different schemas, without having to manually set it. The input file is just a .txt delimited by ; and the tables have been pre-created in Vertica correctly. What's odd is that it works for tMySQLBulkExec with no built in schema fine.
Thanks for your help!
Moderator

Re: BulkExec component with no schema set

Hi,
What the build version are you using? Could you give us your job design screenshot so that we can take a testing for that.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog