org.pentaho.di.core.exception.KettleException: Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)

Pentaho BI Platform Tracking | Ashwin Baliga | 4 years ago
  1. 0

    Hi, I am trying to update some fields of a module Account in SalesForce. For it i am using step called "SalesForce Upsert". I am getting following error.... 2012/12/18 16:57:09 - Spoon - Logging goes to file:///C:/Users/rrai/AppData/Local/Temp/spoon_dc81948f-4905-11e2-8067-c76cb2b6fabd.log 2012/12/18 16:57:12 - Version checker - OK 2012/12/18 16:57:13 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2012/12/18 16:57:25 - RepositoriesMeta - Reading repositories XML file: C:\Users\rrai\.kettle\repositories.xml 2012/12/18 17:03:46 - Spoon - Transformation opened. 2012/12/18 17:03:46 - Spoon - Launching transformation [mis_sfdc]... 2012/12/18 17:03:46 - Spoon - Started the transformation execution. 2012/12/18 17:03:46 - mis_sfdc - Dispatching started for transformation [mis_sfdc] 2012/12/18 17:03:46 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while writing data to Salesforce : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:122) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce(SalesforceUpsert.java:170) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 2 more 2012/12/18 17:03:55 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1) 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - Table input.0 - Finished reading query, closing connection. 2012/12/18 17:03:56 - Table input.0 - Finished processing (I=131, O=0, R=0, W=129, U=0, E=0) 2012/12/18 17:03:56 - Spoon - The transformation has finished!! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! Here i have all the fields in one temperary table mis_sfdc and after that i am trying to update salesforce's module by using Salesforce upsert. Please help us to come out of it. Thanks Ashwin

    Pentaho BI Platform Tracking | 4 years ago | Ashwin Baliga
    org.pentaho.di.core.exception.KettleException: Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)
  2. 0

    Hi, I am trying to update some fields of a module Account in SalesForce. For it i am using step called "SalesForce Upsert". I am getting following error.... 2012/12/18 16:57:09 - Spoon - Logging goes to file:///C:/Users/rrai/AppData/Local/Temp/spoon_dc81948f-4905-11e2-8067-c76cb2b6fabd.log 2012/12/18 16:57:12 - Version checker - OK 2012/12/18 16:57:13 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2012/12/18 16:57:25 - RepositoriesMeta - Reading repositories XML file: C:\Users\rrai\.kettle\repositories.xml 2012/12/18 17:03:46 - Spoon - Transformation opened. 2012/12/18 17:03:46 - Spoon - Launching transformation [mis_sfdc]... 2012/12/18 17:03:46 - Spoon - Started the transformation execution. 2012/12/18 17:03:46 - mis_sfdc - Dispatching started for transformation [mis_sfdc] 2012/12/18 17:03:46 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while writing data to Salesforce : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:122) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce(SalesforceUpsert.java:170) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 2 more 2012/12/18 17:03:55 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1) 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - Table input.0 - Finished reading query, closing connection. 2012/12/18 17:03:56 - Table input.0 - Finished processing (I=131, O=0, R=0, W=129, U=0, E=0) 2012/12/18 17:03:56 - Spoon - The transformation has finished!! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! Here i have all the fields in one temperary table mis_sfdc and after that i am trying to update salesforce's module by using Salesforce upsert. Please help us to come out of it. Thanks Ashwin

    Pentaho BI Platform Tracking | 4 years ago | Ashwin Baliga
    org.pentaho.di.core.exception.KettleException: Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)
  3. 0

    Hi, I am trying to update some fields of a module Account in SalesForce. For it i am using step called "SalesForce Upsert". I am getting following error.... 2012/12/18 16:57:09 - Spoon - Logging goes to file:///C:/Users/rrai/AppData/Local/Temp/spoon_dc81948f-4905-11e2-8067-c76cb2b6fabd.log 2012/12/18 16:57:12 - Version checker - OK 2012/12/18 16:57:13 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2012/12/18 16:57:25 - RepositoriesMeta - Reading repositories XML file: C:\Users\rrai\.kettle\repositories.xml 2012/12/18 17:03:46 - Spoon - Transformation opened. 2012/12/18 17:03:46 - Spoon - Launching transformation [mis_sfdc]... 2012/12/18 17:03:46 - Spoon - Started the transformation execution. 2012/12/18 17:03:46 - mis_sfdc - Dispatching started for transformation [mis_sfdc] 2012/12/18 17:03:46 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while writing data to Salesforce : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:122) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce(SalesforceUpsert.java:170) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 2 more 2012/12/18 17:03:55 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1) 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - Table input.0 - Finished reading query, closing connection. 2012/12/18 17:03:56 - Table input.0 - Finished processing (I=131, O=0, R=0, W=129, U=0, E=0) 2012/12/18 17:03:56 - Spoon - The transformation has finished!! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! Here i have all the fields in one temperary table mis_sfdc and after that i am trying to update salesforce's module by using Salesforce upsert. Please help us to come out of it. Thanks Ashwin

    Pentaho BI Platform Tracking | 4 years ago | Ashwin Baliga
    org.pentaho.di.core.exception.KettleException: Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hi, I am trying to update some fields of a module Account in SalesForce. For it i am using step called "SalesForce Upsert". I am getting following error.... 2012/12/18 16:57:09 - Spoon - Logging goes to file:///C:/Users/rrai/AppData/Local/Temp/spoon_dc81948f-4905-11e2-8067-c76cb2b6fabd.log 2012/12/18 16:57:12 - Version checker - OK 2012/12/18 16:57:13 - class org.pentaho.agilebi.platform.JettyServer - WebServer.Log.CreateListener localhost:10000 2012/12/18 16:57:25 - RepositoriesMeta - Reading repositories XML file: C:\Users\rrai\.kettle\repositories.xml 2012/12/18 17:03:46 - Spoon - Transformation opened. 2012/12/18 17:03:46 - Spoon - Launching transformation [mis_sfdc]... 2012/12/18 17:03:46 - Spoon - Started the transformation execution. 2012/12/18 17:03:46 - mis_sfdc - Dispatching started for transformation [mis_sfdc] 2012/12/18 17:03:46 - Transformation metadata - Natural sort of steps executed in 0 ms (2 time previous steps calculated) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unexpected error 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while writing data to Salesforce : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:122) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run(Unknown Source) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed in writeToSalesForce: org.pentaho.di.core.exception.KettleException: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Failed to upsert object, error message was: 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error while doing upsert operation! 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Thread.run (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:1812) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2366) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2443) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invoke (Call.java:2767) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Method.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.Class.newInstance0 (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at java.lang.reflect.Constructor.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce(SalesforceUpsert.java:170) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:118) 2012/12/18 17:03:55 - Salesforce Upsert.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : ... 2 more 2012/12/18 17:03:55 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1) 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - mis_sfdc - mis_sfdc 2012/12/18 17:03:55 - Table input.0 - Finished reading query, closing connection. 2012/12/18 17:03:56 - Table input.0 - Finished processing (I=131, O=0, R=0, W=129, U=0, E=0) 2012/12/18 17:03:56 - Spoon - The transformation has finished!! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! 2012/12/18 17:03:56 - mis_sfdc - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Errors detected! Here i have all the fields in one temperary table mis_sfdc and after that i am trying to update salesforce's module by using Salesforce upsert. Please help us to come out of it. Thanks Ashwin

    Pentaho BI Platform Tracking | 4 years ago | Ashwin Baliga
    org.pentaho.di.core.exception.KettleException: Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)
  6. 0

    I have a lookup field in my Accoutn with User object. In the user object have a external Id field. I build a transformation with simple data grid and SalesForce Upsert step. In Data grid I have 3 fields: External Id from account, external ID from User and number for employers. The map in step SalesForce Upsert is below: Module field Stream Field Use external ID? NumberOfEmployees = NumeroFuncionarios N Id_Conta_Legado__c = IdExterno N User:Id_usuario_legado__c/Usuario_de_Inspecao__r = IdUsuario Y When I executed the transformation the error below occurred, highlighting the INVALID_FIELD error : 2014/02/11 09:24:07 - Spoon - Transformation opened. 2014/02/11 09:24:07 - Spoon - Launching transformation [TranformacaoTeste3]... 2014/02/11 09:24:07 - Spoon - Started the transformation execution. 2014/02/11 09:24:07 - TranformacaoTeste3 - Dispatching started for transformation [TranformacaoTeste3] 2014/02/11 09:24:13 - 151.0 - Finished processing (I=0, O=0, R=0, W=3, U=0, E=0) 2014/02/11 09:24:13 - Salesforce Upsert.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error 2014/02/11 09:24:13 - Salesforce Upsert.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/02/11 09:24:13 - Salesforce Upsert.0 - Error while doing upsert operation! 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Thread.run (Thread.java:695) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.step.RunThread.run (RunThread.java:60) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:77) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:186) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:655) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke (Call.java:1812) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke (Call.java:2366) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke (Call.java:2443) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke (Call.java:2767) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invokeEngine (Call.java:2784) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XMLParser.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.reflect.Method.invoke (Method.java:597) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Class.newInstance (Class.java:310) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Class.newInstance0 (Class.java:357) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.reflect.Constructor.newInstance (Constructor.java:513) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:27) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:39) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (NativeConstructorAccessorImpl.java:-2) 2014/02/11 09:24:13 - Salesforce Upsert.0 - 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert(SalesforceConnection.java:657) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers(SalesforceUpsert.java:186) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:77) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Thread.run(Thread.java:695) 2014/02/11 09:24:13 - Salesforce Upsert.0 - Caused by: INVALID_FIELD: No such column 'User:Id_usuario_legado__c/Usuario_de_Inspecao__r' on entity 'Account'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.reflect.Constructor.newInstance(Constructor.java:513) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Class.newInstance0(Class.java:357) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.Class.newInstance(Class.java:310) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:104) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BeanDeserializer.<init>(BeanDeserializer.java:90) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer(InvalidFieldFault.java:87) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at java.lang.reflect.Method.invoke(Method.java:597) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized(BaseDeserializerFactory.java:154) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs(BaseDeserializerFactory.java:84) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.getDeserializer(DeserializationContext.java:464) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.getDeserializerForType(DeserializationContext.java:547) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild(SOAPFaultDetailsBuilder.java:157) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.startElement(DeserializationContext.java:1035) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.Message.getSOAPEnvelope(Message.java:435) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invokeEngine(Call.java:2784) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke(Call.java:2767) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke(Call.java:2443) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke(Call.java:2366) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.apache.axis.client.Call.invoke(Call.java:1812) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at com.sforce.soap.partner.SoapBindingStub.upsert(SoapBindingStub.java:2759) 2014/02/11 09:24:13 - Salesforce Upsert.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert(SalesforceConnection.java:655) 2014/02/11 09:24:13 - Salesforce Upsert.0 - ... 4 more 2014/02/11 09:24:13 - Salesforce Upsert.0 - Finished processing (I=0, O=0, R=3, W=0, U=0, E=1) 2014/02/11 09:24:13 - TranformacaoTeste3 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/11 09:24:13 - Spoon - The transformation has finished!! 2014/02/11 09:24:13 - TranformacaoTeste3 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/11 09:24:13 - TranformacaoTeste3 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected! 2014/02/11 09:24:13 - TranformacaoTeste3 - TranformacaoTeste3 2014/02/11 09:24:13 - TranformacaoTeste3 - TranformacaoTeste3 Is there something wrong in my configuration map?

    Pentaho BI Platform Tracking | 3 years ago | Flavio Candian
    org.pentaho.di.core.exception.KettleException: Error while doing upsert operation! at java.lang.Thread.run (Thread.java:695) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:60) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:77) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:186) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:655) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (Method.java:597) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (Class.java:310) at java.lang.Class.newInstance0 (Class.java:357) at java.lang.reflect.Constructor.newInstance (Constructor.java:513) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:27) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:39) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (NativeConstructorAccessorImpl.java:-2)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettleException

      Failed to upsert object, error message was: Error while doing upsert operation! at java.lang.Thread.run (null:-1) at org.pentaho.di.trans.step.RunThread.run (RunThread.java:50) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow (SalesforceUpsert.java:118) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce (SalesforceUpsert.java:167) at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers (SalesforceUpsert.java:179) at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert (SalesforceConnection.java:579) at com.sforce.soap.partner.SoapBindingStub.upsert (SoapBindingStub.java:2759) at org.apache.axis.client.Call.invoke (Call.java:1812) at org.apache.axis.client.Call.invoke (Call.java:2366) at org.apache.axis.client.Call.invoke (Call.java:2443) at org.apache.axis.client.Call.invoke (Call.java:2767) at org.apache.axis.client.Call.invokeEngine (Call.java:2784) at org.apache.axis.client.AxisClient.invoke (AxisClient.java:206) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke (MustUnderstandChecker.java:62) at org.apache.axis.Message.getSOAPEnvelope (Message.java:435) at org.apache.axis.SOAPPart.getAsSOAPEnvelope (SOAPPart.java:696) at org.apache.axis.encoding.DeserializationContext.parse (DeserializationContext.java:227) at org.apache.xerces.jaxp.SAXParserImpl.parse (null:-1) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.parse (null:-1) at org.apache.xerces.parsers.XMLParser.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.parsers.XML11Configuration.parse (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument (null:-1) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch (null:-1) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement (null:-1) at org.apache.xerces.parsers.AbstractSAXParser.startElement (null:-1) at org.apache.axis.encoding.DeserializationContext.startElement (DeserializationContext.java:1035) at org.apache.axis.message.SOAPFaultDetailsBuilder.onStartChild (SOAPFaultDetailsBuilder.java:157) at org.apache.axis.encoding.DeserializationContext.getDeserializerForType (DeserializationContext.java:547) at org.apache.axis.encoding.DeserializationContext.getDeserializer (DeserializationContext.java:464) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getDeserializerAs (BaseDeserializerFactory.java:84) at org.apache.axis.encoding.ser.BaseDeserializerFactory.getSpecialized (BaseDeserializerFactory.java:154) at java.lang.reflect.Method.invoke (null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke (null:-1) at sun.reflect.NativeMethodAccessorImpl.invoke0 (null:-2) at com.sforce.soap.partner.fault.InvalidFieldFault.getDeserializer (InvalidFieldFault.java:87) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:90) at org.apache.axis.encoding.ser.BeanDeserializer.<init> (BeanDeserializer.java:104) at java.lang.Class.newInstance (null:-1) at java.lang.Class.newInstance0 (null:-1) at java.lang.reflect.Constructor.newInstance (null:-1) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance (null:-1) at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (null:-2)

      at org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce()
    2. org.pentaho.di
      SalesforceUpsert.processRow
      1. org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.writeToSalesForce(SalesforceUpsert.java:170)
      2. org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:118)
      2 frames