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)

Pentaho BI Platform Tracking | Flavio Candian | 3 years ago
  1. 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)
  2. 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)
  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

      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)

      at org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.salesforceinput.SalesforceConnection.upsert(SalesforceConnection.java:657)
      2. org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.flushBuffers(SalesforceUpsert.java:186)
      3. org.pentaho.di.trans.steps.salesforceupsert.SalesforceUpsert.processRow(SalesforceUpsert.java:77)
      4. org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
      4 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:695)
      1 frame