Job fails in runtime (NoSuchMethodError)

[Anonymous]

I've built a job and it fails every time in runtime.

It is a very simple job, that does the following after each other in several flows (OnSubJobOK):
    1) Set's up the context variable,

    2) Executes a query in hive (tHiveRow) and stores the result into a CSV

    3) Reads the CSV and loads it into Salesforce

Now, ... when I disable the step 2 OR 3, ... everything runs without any problems, but as soon as I enable both the job dies.

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.commons.lang3.reflect.TypeUtils.toString(Ljava/lang/reflect/TypeLjava/lang/String;
at org.talend.daikon.properties.property.Property.(Property.java:127)
at org.talend.daikon.properties.property.Property.(Property.java:152)
at org.talend.daikon.properties.property.Property.(Property.java:148)
at org.talend.daikon.properties.property.StringProperty.(StringProperty.java:32)
at org.talend.daikon.properties.property.PropertyFactory.newString(PropertyFactory.java:36)
at org.talend.components.api.component.ComponentDefinition.(ComponentDefinition.java:71)
at org.talend.components.api.component.AbstractComponentDefinition.(AbstractComponentDefinition.java:43)
at org.talend.components.salesforce.SalesforceDefinition.(SalesforceDefinition.java:26)
at org.talend.components.salesforce.tsalesforceconnection.TSalesforceConnectionDefinition.(TSalesforceConnectionDefinition.java:32)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.tSalesforceConnection_1Process(yl_sf_adSlot.java:5657)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.tHiveRow_3Process(yl_sf_adSlot.java:5439)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.tHiveConnection_1Process(yl_sf_adSlot.java:3895)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.tFileInputXML_1Process(yl_sf_adSlot.java:3509)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.runJobInTOS(yl_sf_adSlot.java:12626)
at yl.yl_sf_adslot_0_11.yl_sf_adSlot.main(yl_sf_adSlot.java:12285)

Another thing I noticed is that several versions are being loaded for Log4J

log4j:WARN No appenders could be found for logger (org.apache.hive.jdbc.Utils).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/sffacade/yl_sf_adSlot/vp_test/deploy/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/sffacade/yl_sf_adSlot/vp_test/deploy/lib/slf4j-log4j12-1.7.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

I had similar issues with Avro with the avro-1.7.6-cdh5.4.0 and avro-1.8.0.jar, but I also expirienced Issues with Log4J on several instances, where the project could sometimes not find Log4J at all.

Any suggestions?

I'm running Talend 6.3.1 on Win 10

[Anonymous]

Hi,

Would you mind sending your job (.zip file) to us by email for testing?

Best regards

Sabrina

[Anonymous]

Hello,

Or you can send a private message to me about your job.

Best regards

Sabrina

[Anonymous]

Is this issue resolved? I had the similar error when inserting to salesforce. As below

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.commons.lang3.reflect.TypeUtils.toString(Ljava/lang/reflect/TypeLjava/lang/String;
at org.talend.daikon.properties.property.Property.<init>(Property.java:127)
at org.talend.daikon.properties.property.Property.<init>(Property.java:152)
at org.talend.daikon.properties.property.Property.<init>(Property.java:148)
at org.talend.daikon.properties.property.StringProperty.<init>(StringProperty.java:32)
at org.talend.daikon.properties.property.PropertyFactory.newString(PropertyFactory.java:36)
at org.talend.components.api.component.ComponentDefinition.<clinit>(ComponentDefinition.java:71)
at org.talend.components.api.component.AbstractComponentDefinition.<init>(AbstractComponentDefinition.java:43)
at org.talend.components.salesforce.SalesforceDefinition.<init>(SalesforceDefinition.java:26)
at org.talend.components.salesforce.tsalesforceoutput.TSalesforceOutputDefinition.<init>(TSalesforceOutputDefinition.java:35)
......