org.pentaho.di.core.exception.KettleException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Y2xpY2sgb24gdGhlIGxpbmsgcHJvdmlkZWQgYmVsb3cNCjxicj48YSBocmVmPSJodHRwOi8vd3d3 Mi5wcmludGFibGUuY29tL2xvZ2luLmFzcCI+DQoJaHR0cDovL3d3dzIucHJpbnRhYmxlLmNvbS9s b2dpbi5hc3ANCjwvYT4= ) A11 OK FETCH completed. A12 FETCH 1 (BODY.PEEK[HEADER.FIELDS (Mail Header(Name))]) A12 BAD Command Argument Error. 11 IMAP DEBUG: IMAPProtocol noop A13 NOOP A13 OK NOOP completed. ERROR 28-11 16:03:28,652 - Email messages input - Unexpected error ERROR 28-11 16:03:28,653 - Email messages input - org.pentaho.di.core.exception.KettleException: Error adding values to row! A12 BAD Command Argument Error. 11 at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:326) at org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:69) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) at java.lang.Thread.run(Thread.java:662) Caused by: javax.mail.MessagingException: A12 BAD Command Argument Error. 11; nested exception is: com.sun.mail.iap.BadCommandException: A12 BAD Command Argument Error. 11 at com.sun.mail.imap.IMAPMessage.getHeader(IMAPMessage.java:737) at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:306) ... 3 more Caused by: com.sun.mail.iap.BadCommandException: A12 BAD Command Argument Error. 11 at com.sun.mail.iap.Protocol.handleResult(Protocol.java:343) at com.sun.mail.imap.protocol.IMAPProtocol.fetchBody(IMAPProtocol.java:1055) at com.sun.mail.imap.protocol.IMAPProtocol.peekBody(IMAPProtocol.java:1025) at com.sun.mail.imap.IMAPMessage.getHeader(IMAPMessage.java:722) ... 4 more DEBUG 28-11 16:03:28,653 - Email messages input - Closing connection ... DEBUG 28-11 16:03:28,653 - dummy - Signaling 'output done' to 0 output rowsets. DEBUG 28-11 16:03:28,653 - Email messages input - Closing folder [INBOX] ... A14 CLOSE INFO 28-11 16:03:28,654 - dummy - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0) A14 OK CLOSE completed. DEBUG: added an Authenticated connection -- size: 1 DEBUG 28-11 16:03:28,655 - Email messages input - Folder [] was closed. A15 LOGOUT * BYE Microsoft Exchange Server 2010 IMAP4 server signing off. A15 OK LOGOUT completed. DEBUG: IMAPStore connection dead DEBUG: IMAPStore cleanup, force false DEBUG: IMAPStore cleanup done DEBUG 28-11 16:03:28,656 - Email messages input - Connection closed. INFO 28-11 16:03:28,656 - Email messages input - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) INFO 28-11 16:03:28,656 - /PrintabletestEmailScrape - /PrintabletestEmailScrape INFO 28-11 16:03:28,656 - /PrintabletestEmailScrape - /PrintabletestEmailScrape DEBUG 28-11 16:03:28,656 - /PrintabletestEmailScrape - Looking at step: Email messages input DEBUG 28-11 16:03:28,678 - /PrintabletestEmailScrape - Looking at step: dummy
    via by Philip Panelli,
  • 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
    via by Ashwin Baliga,
  • Running SPOON without logging, it execute these transformations: INFO 10-04 19:11:31,307 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,603 - ::: Read 236 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr INFO 10-04 19:11:31,606 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr INFO 10-04 19:11:31,636 - ::: Read 248 lines from /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_custom.ktr If I want to enable LOGGING for all my transformations and job I edit my kettle.properties file with the needed variables, for example: KETTLE_JOB_LOG_SCHEMA=etl KETTLE_PLUGIN_CLASSES= KETTLE_PERFORMANCE_LOGGING_SECS=10 KETTLE_CHANNEL_TIMEOUT_DAYS=100000 KETTLE_CORE_JOBENTRIES_FILE= KETTLE_ROWSET_GET_TIMEOUT=50 KETTLE_TRANS_LOG_DB=tpl KETTLE_CHANNEL_LOG_DB=tpl KETTLE_MAX_LOG_TIMEOUT_IN_MINUTES=1440 KETTLE_JOB_LOG_DB=tpl KETTLE_JOB_LOG_TABLE=job KETTLE_STEP_TIMEOUT_DAYS=100 KETTLE_TRANS_PAN_JVM_EXIT_CODE= KETTLE_TRANS_LOGGING_SECS=10 KETTLE_JOB_PERFORMANCE_LOG_TABLE=performance KETTLE_TRANS_PERFORMANCE_LOG_TABLE=performance KETTLE_ROWSET_PUT_TIMEOUT=50 KETTLE_MAX_JOB_ENTRIES_LOGGED=1000 [.....] But launching spoon again I get this error: INFO 10-04 19:18:34,228 - ::: Running transformation: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr ERROR 10-04 19:18:34,537 - ::: CsvReader.ERROR_0005 - Check error: /home/nicola/Scaricati/data-integration-4.4.0/plugins/spoon/agile-bi/platform/pentaho-solutions/system/pentaho-geo/dataimport/import_country.ktr, null ERROR 10-04 19:18:34,785 - import_country - import_country : Errore inatteso alla fine della trasformazione ERROR 10-04 19:18:34,786 - import_country - org.pentaho.di.core.exception.KettleException: Impossibile eseguire logging alla fine della trasformazione Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. at org.pentaho.di.trans.Trans$7.transFinished(Trans.java:1991) at org.pentaho.di.trans.Trans.fireTransFinishedListeners(Trans.java:1180) at org.pentaho.di.trans.Trans$1.stepFinished(Trans.java:999) at org.pentaho.di.trans.step.BaseStep.markStop(BaseStep.java:2640) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:98) at java.lang.Thread.run(Thread.java:662) Caused by: org.pentaho.di.core.exception.KettleException: Errore di scrittura dei record di log sulle performance del passo Error updating batch L'operazione «batch» 1 INSERT INTO etl.performance (ID_BATCH, SEQ_NR, LOGDATE, TRANSNAME, STEPNAME, STEP_COPY, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_OUTPUT, LINES_REJECTED, ERRORS, INPUT_BUFFER_ROWS, OUTPUT_BUFFER_ROWS) VALUES ( '0', '1', '2013-04-10 19:18:34.742000 +02:00:00', 'import_country', 'Output', '0', '236', '236', '0', '0', '0', '0', '0', '0', '0') è stata interrotta. Chiamare «getNextException» per scoprirne il motivo. [...] It seems that those unknowns transformations (import_country.ktr, import_customs.ktr) causes the error. Bye.
    via by Nicola Benaglia,
  • 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?
    via by Flavio Candian,
  • Regression in 5.1 (found in build # 692). It works fine in 5.0.7 Steps: 1. Open attached ktr in Spoon. 2. Update Cassandra Output step to point to valid server/port/keyspace. 3. Ensure that hop from Generate cards to Cassandra Output step is enabled, while hop from Dummy to Input is disabled. 4. Save ktr and run it => data has been loaded into database correctly. 5. Update Cassandra Input step to point to valid server/port/keyspace. 6. Ensure that hop from Generate cards to Cassandra Output step is disabled and hop from Dummy to Input is enabled. 7. Save ktr and run it. NOTE: transformation got failed with exception: 2014/06/09 13:37:59 - Cassandra Input.0 - ERROR (version 5.1-NIGHTLY.692, build 1 from 2014-05-25_21-14-11 by buildguy) : Unexpected error 2014/06/09 13:37:59 - Cassandra Input.0 - ERROR (version 5.1-NIGHTLY.692, build 1 from 2014-05-25_21-14-11 by buildguy) : org.pentaho.di.core.exception.KettleException: 2014/06/09 13:37:59 - Cassandra Input.0 - null 2014/06/09 13:37:59 - Cassandra Input.0 - 2014/06/09 13:37:59 - Cassandra Input.0 - at org.pentaho.di.trans.steps.cassandrainput.CassandraInput.processRow(CassandraInput.java:251) 2014/06/09 13:37:59 - Cassandra Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2014/06/09 13:37:59 - Cassandra Input.0 - at java.lang.Thread.run(Unknown Source) 2014/06/09 13:37:59 - Cassandra Input.0 - Caused by: java.lang.NullPointerException Failure occurs only if Thrift mode together with Output tuples is selected. If Thrift mode is unchecked and Output tuples selected - then it works fine.
    via by Antonina Doudkina,
    • org.pentaho.di.core.exception.KettleException: We can not find any data with path [$]! We can not find any data with path [$]! at org.pentaho.di.trans.steps.jsoninput.JsonReader.getPath(JsonReader.java:191) at org.pentaho.di.trans.steps.jsoninput.JsonInput.parseJson(JsonInput.java:281) at org.pentaho.di.trans.steps.jsoninput.JsonInput.readFileOrString(JsonInput.java:258) at org.pentaho.di.trans.steps.jsoninput.JsonInput.ReadNextString(JsonInput.java:165) at org.pentaho.di.trans.steps.jsoninput.JsonInput.getOneRow(JsonInput.java:396) at org.pentaho.di.trans.steps.jsoninput.JsonInput.processRow(JsonInput.java:344) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:745) Caused by: org.pentaho.di.core.exception.KettleException: We can not find any data with path [$]! at org.pentaho.di.trans.steps.jsoninput.JsonReader.getPath(JsonReader.java:187) ... 7 more
    No Bugmate found.