java.util.UnknownFormatConversionException: Conversion = '1'

Eight Stars

java.util.UnknownFormatConversionException: Conversion = '1'

Hi,

 

I am trying to load data from mysql to vertica, here i am using tverticaoutputbulk and tverticabulkexe components.

while transferring data i am just converting the datatypes and loading. But i am getting the below error. Could any one please help me on this.

 

Exception in component tVerticaOutputBulk_1
java.util.UnknownFormatConversionException: Conversion = '1'
at java.util.Formatter.checkText(Unknown Source)
at java.util.Formatter.parse(Unknown Source)
at java.util.Formatter.format(Unknown Source)
at java.util.Formatter.format(Unknown Source)
at java.lang.String.format(Unknown Source)
at migarion_json.rv_blast_details_to_vertica_0_1.rv_blast_details_to_vertica.tMysqlInput_1Process(rv_blast_details_to_vertica.java:3381)
at migarion_json.rv_blast_details_to_vertica_0_1.rv_blast_details_to_vertica.tJava_1Process(rv_blast_details_to_vertica.java:707)
at migarion_json.rv_blast_details_to_vertica_0_1.rv_blast_details_to_vertica.tMysqlConnection_1Process(rv_blast_details_to_vertica.java:4132)
at migarion_json.rv_blast_details_to_vertica_0_1.rv_blast_details_to_vertica.tVerticaConnection_1Process(rv_blast_details_to_vertica.java:4374)
at migarion_json.rv_blast_details_to_vertica_0_1.rv_blast_details_to_vertica$2.run(rv_blast_details_to_vertica.java:4794)

 

Thanks,

Bharath.

 


Accepted Solutions
Eight Stars

Re: java.util.UnknownFormatConversionException: Conversion = '1'

Hi,

Thanks for your reply.

Sorry for the late reply.

The issue has been resolved. Here while loading to vertica DB there is miss match in schema we missed a column.

After adding the column in mapping we did't get the issue and data loaded successfully.

 

Thanks,

Bharath.


All Replies
Moderator

Re: java.util.UnknownFormatConversionException: Conversion = '1'

Hello,

Could you please post your current job design screenshots into forum which will be helpful for us to address your issue?

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.
Eight Stars

Re: java.util.UnknownFormatConversionException: Conversion = '1'

Hi,

Thanks for your reply.

Sorry for the late reply.

The issue has been resolved. Here while loading to vertica DB there is miss match in schema we missed a column.

After adding the column in mapping we did't get the issue and data loaded successfully.

 

Thanks,

Bharath.

Moderator

Re: java.util.UnknownFormatConversionException: Conversion = '1'

Hello,

Thanks for letting us know that your issue has been fixed. Can we consider this topic as resolved?

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.
Eight Stars

Re: java.util.UnknownFormatConversionException: Conversion = '1'

Ya you can treat it as resolved.


Thanks,
Bharath.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch