topic Re: java.util.UnknownFormatConversionException: Conversion = '1' in Talend Studio

java.util.UnknownFormatConversionException: Conversion = '1'

javvaji — Thu, 21 Sep 2017 10:33:23 GMT

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.

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

Anonymous — Mon, 25 Sep 2017 07:32:08 GMT

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

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

javvaji — Wed, 27 Sep 2017 08:58:22 GMT

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.

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

Anonymous — Thu, 28 Sep 2017 07:24:34 GMT

Hello,

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

Best regards

Sabrina

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

javvaji — Fri, 29 Sep 2017 09:35:50 GMT

Ya you can treat it as resolved.

Thanks,
Bharath.