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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download