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.

  • In the Salesforce Upsert, Salesforce Update, and Salesforce Delete steps (and technically the Input step), if a connection fails to connect for some reason, the step still reports a successful init, allowing the transformation to begin processing rows of data. As the connection is being created during the init process, and that we capture the exception (and log it), we should return the proper return value to prevent the transformation from being executed, as it will fail anyways when the step receives its first row. {noformat} 2016/07/05 13:16:09 - Spoon - Transformation opened. 2016/07/05 13:16:09 - Spoon - Launching transformation [PDI-15478]... 2016/07/05 13:16:09 - Spoon - Started the transformation execution. 2016/07/05 13:16:09 - PDI-15478 - Dispatching started for transformation [PDI-15478] 2016/07/05 13:16:11 - Salesforce Insert.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Error occurred during initialization 2016/07/05 13:16:11 - Salesforce Insert.0 - Please be sure that you have a valid username and password. 2016/07/05 13:16:11 - Generate Rows.0 - Finished processing (I=0, O=0, R=0, W=10, U=0, E=0) 2016/07/05 13:16:11 - Salesforce Insert.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Unexpected error 2016/07/05 13:16:11 - Salesforce Insert.0 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2016/07/05 13:16:11 - Salesforce Insert.0 - Error while inserting data in Salesforce : org.pentaho.di.core.exception.KettleException: 2016/07/05 13:16:11 - Salesforce Insert.0 - Failed in writeToSalesForce: 2016/07/05 13:16:11 - Salesforce Insert.0 - Failed to insert object, error message was: 2016/07/05 13:16:11 - Salesforce Insert.0 - Error while doing insert operation, error message was: UNKNOWN_EXCEPTION: Destination URL not reset. The URL returned from login must be set in the SforceService 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - at org.pentaho.di.trans.steps.salesforceinsert.SalesforceInsert.processRow(SalesforceInsert.java:115) 2016/07/05 13:16:11 - Salesforce Insert.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2016/07/05 13:16:11 - Salesforce Insert.0 - at java.lang.Thread.run(Thread.java:745) 2016/07/05 13:16:11 - Salesforce Insert.0 - Finished processing (I=0, O=0, R=10, W=0, U=0, E=1) 2016/07/05 13:16:11 - PDI-15478 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/05 13:16:11 - Spoon - The transformation has finished!! 2016/07/05 13:16:11 - PDI-15478 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/05 13:16:11 - PDI-15478 - ERROR (version 6.1.0.3-223, build 1 from 2016-06-16 15.11.37 by buildguy) : Errors detected! 2016/07/05 13:16:11 - PDI-15478 - Transformation detected one or more steps with errors. 2016/07/05 13:16:11 - PDI-15478 - Transformation is killing the other steps! {noformat}
    via by Matt Tucker,
  • 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: 2016/07/05 13:16:11 - Salesforce Insert.0 - Failed in writeToSalesForce: 2016/07/05 13:16:11 - Salesforce Insert.0 - Failed to insert object, error message was: 2016/07/05 13:16:11 - Salesforce Insert.0 - Error while doing insert operation, error message was: UNKNOWN_EXCEPTION: Destination URL not reset. The URL returned from login must be set in the SforceService 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - 2016/07/05 13:16:11 - Salesforce Insert.0 - at org.pentaho.di.trans.steps.salesforceinsert.SalesforceInsert.processRow(SalesforceInsert.java:115) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) at java.lang.Thread.run(Thread.java:745)
    No Bugmate found.