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 -

Pentaho BI Platform Tracking | Matt Tucker | 5 months ago
  1. 0

    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}

    Pentaho BI Platform Tracking | 5 months ago | Matt Tucker
    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 -
  2. 0

    Elastic to Postgres data migration fails in kettle

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

    Spoon PDI Data Validator Error

    Stack Overflow | 2 years ago | Paul
    org.pentaho.di.core.exception.KettleException: Correct Group/Dashboard Assignment Correct Group/Dashboard Assignment
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error al realizar una transformacion con postgresql - Open Business Intelligence

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

    Spoon cannot explore MSSQL 2008 - Error getting views from schema [null]

    pentaho.com | 7 months ago
    org.pentaho.di.core.exception.KettleException: Error batch inserting rows into table [S_LOG_DETECT_PT_U]. Errors encountered (first 10): Communications link failure Error updating batch Communications link failure

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

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

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

      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()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.salesforceinsert.SalesforceInsert.processRow(SalesforceInsert.java:115)
      2. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame