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

    Elastic to Postgres data migration fails in kettle

    Stack Overflow | 2 years ago | Marlon Abeykoon
    org.pentaho.di.core.exception.KettleException: The data structure is not the same inside the resource! We found 1000 values for json path [$..LoginSessionId], which is different that the number retourned for path [$.ResourceChangeInfo..ResourceCode] (9325 values). We MUST have the same number of values for all paths.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spoon PDI Data Validator Error

    Stack Overflow | 2 years ago | Paul
    org.pentaho.di.core.exception.KettleException: Correct Group/Dashboard Assignment Correct Group/Dashboard Assignment
  6. 0

    Error al realizar una transformacion con postgresql - Open Business Intelligence

    redopenbi.com | 1 year ago
    org.pentaho.di.core.exception.KettleException: 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error batch inserting rows into table [ejecmensual]. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Errors encountered (first 10): 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - ERROR: column "sec_ejec" of relation "ejecmensual" does not exist 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -   Position: 57 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Error updating batch 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - Batch entry 0 INSERT INTO transformationpentaho.ejecmensual (ano_eje, sec_ejec, pliego, ejecutora, sec_func, programa, prod_pry, act_ai_obra, funcion, division_func, grupo_func, meta, finalidad, unidad_medida, cantidad, departamento, provincia, distrito, origen, fuente_financ_agregada, fuente_financ, tipo_recurso, categ_gasto, tipo_transaccion, generica, subgenerica, subgenerica_det, especifica, especifica_det, presupuesto, modificacion, pim, m01, m02, m03, m04, m05, m06, m07, m08, m09, m10, m11, m12, total_prog, saldo, porcentaje) VALUES ( '2014',  '001309',  '050',  '001',  '0001',  '0035',  '3000603',  '5004399',  '17',  '054',  '0119',  '00001',  '0107477',  '00194',  '9.0',  '01',  '02',  '99',  NULL,  '1',  NULL,  NULL,  '5',  '2',  '3',  NULL,  NULL,  NULL,  NULL,  '3754.0',  '0.0',  '3754.0',  '190.0',  '600.0',  '0.0',  '630.0',  '77.5',  '658.5',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '0.0',  '2156.0',  '1598.0',  '57.43') was aborted.  Call getNextException to see the cause. 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 - 2014/07/24 11:34:02 - Ejecucion Mensual Table output.0 -

    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.processRow()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:122)
      2. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      2 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame