Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

ODI mapping is stopped with errors

Hi,

I'm pretty new to ODI and Vertica. I'm trying to sync data between Oracle and Vertica using ODI studio. When I run mapping, it gives me the below error in "SERIAL-MAP_BEGIN" step.

When tries to drop a staging table :
ODI-1228: Task Drop staging (C$) table-LKM SQL to SQL (Built-In)- fails on the target connection Connect_Vertica_ODI.
Caused By: java.sql.SQLSyntaxErrorException: [Vertica]VJDBC ERROR: Syntax error at or near "EOL" at character 12


When tries to create a table with below query
create table
(
A_CONT_PART_TRAN_SRL_NUM VARCHAR2(4 CHAR),
A_ACCT_TRANSFER_FLG VARCHAR2(1 CHAR),
A_BNK_ID VARCHAR2(20 CHAR)
)
ODI-1228: Task Create staging (C$) table-LKM SQL to SQL (Built-In)- fails on the target connection Connect_Vertica_ODI.
Caused By: java.sql.SQLSyntaxErrorException: [Vertica]VJDBC ERROR: Syntax error at or near "(" at character 15

Maybe knowledge xml file is missing? I remember there was no LKM SQL Multi-Connect.GLOBAL xml file when importing knowledge modules.

Thanks,

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.