org.pentaho.di.core.exception.KettleException: Can not read data from Salesforce! Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015-03-23T15:36:28.000Z

Pentaho BI Platform Tracking | Pedro Morales | 1 year ago
  1. 0

    Salesforce Input default field format (yyyy-MM-dd'T'HH:mm:ss'.000'Z) fails for Date/Time fields. The default format is, yyyy-MM-dd'T'HH:mm:ss'.000'Z which causes the input to fail. This looks like a regression bug, PDI-5595. I'm able to work around it by specifying the following format , (yyyy-MM-dd'T'HH:mm:ss'.000Z'), instead of (yyyy-MM-dd'T'HH:mm:ss'.000'Z). (note - the Z at the end has to be inside the quotes for it to work). ------------------ Engineering notes: This was introduced after the fix for PDI-5595. We cannot simply revert this change. We need to figure out why SalesForce is different. One possible outcome would be a different list of default formats for the SFIS. ---------------- h4. STACK TRACE: {noformat} 2015/10/29 18:52:00 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Dispatching started for transformation [/Users/pedro/Downloads/test-account-extract.ktr : test-account-extract] 2015/10/29 18:52:20 - Salesforce Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Error while reading data from Salesforce : 2015/10/29 18:52:20 - Salesforce Input.0 - Can not read data from Salesforce! 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - ! 2015/10/29 18:52:20 - Salesforce Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : org.pentaho.di.core.exception.KettleException: 2015/10/29 18:52:20 - Salesforce Input.0 - Can not read data from Salesforce! 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.getOneRow(SalesforceInput.java:261) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.processRow(SalesforceInput.java:92) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/29 18:52:20 - Salesforce Input.0 - at java.lang.Thread.run(Thread.java:745) 2015/10/29 18:52:20 - Salesforce Input.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:709) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getDate(ValueMetaBase.java:1957) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3544) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.getOneRow(SalesforceInput.java:215) 2015/10/29 18:52:20 - Salesforce Input.0 - ... 3 more 2015/10/29 18:52:20 - Salesforce Input.0 - Caused by: java.text.ParseException: 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:701) 2015/10/29 18:52:20 - Salesforce Input.0 - ... 6 more 2015/10/29 18:52:20 - Salesforce Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2015/10/29 18:52:20 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Transformation detected one or more steps with errors. 2015/10/29 18:52:20 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Transformation is killing the other steps! {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Pedro Morales
    org.pentaho.di.core.exception.KettleException: Can not read data from Salesforce! Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015-03-23T15:36:28.000Z
  2. 0

    Salesforce Input default field format (yyyy-MM-dd'T'HH:mm:ss'.000'Z) fails for Date/Time fields. The default format is, yyyy-MM-dd'T'HH:mm:ss'.000'Z which causes the input to fail. This looks like a regression bug, PDI-5595. I'm able to work around it by specifying the following format , (yyyy-MM-dd'T'HH:mm:ss'.000Z'), instead of (yyyy-MM-dd'T'HH:mm:ss'.000'Z). (note - the Z at the end has to be inside the quotes for it to work). ------------------ Engineering notes: This was introduced after the fix for PDI-5595. We cannot simply revert this change. We need to figure out why SalesForce is different. One possible outcome would be a different list of default formats for the SFIS. ---------------- h4. STACK TRACE: {noformat} 2015/10/29 18:52:00 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Dispatching started for transformation [/Users/pedro/Downloads/test-account-extract.ktr : test-account-extract] 2015/10/29 18:52:20 - Salesforce Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : Error while reading data from Salesforce : 2015/10/29 18:52:20 - Salesforce Input.0 - Can not read data from Salesforce! 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - ! 2015/10/29 18:52:20 - Salesforce Input.0 - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : org.pentaho.di.core.exception.KettleException: 2015/10/29 18:52:20 - Salesforce Input.0 - Can not read data from Salesforce! 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.getOneRow(SalesforceInput.java:261) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.processRow(SalesforceInput.java:92) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/29 18:52:20 - Salesforce Input.0 - at java.lang.Thread.run(Thread.java:745) 2015/10/29 18:52:20 - Salesforce Input.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2015/10/29 18:52:20 - Salesforce Input.0 - Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015/10/29 18:52:20 - Salesforce Input.0 - 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:709) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getDate(ValueMetaBase.java:1957) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3544) 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.getOneRow(SalesforceInput.java:215) 2015/10/29 18:52:20 - Salesforce Input.0 - ... 3 more 2015/10/29 18:52:20 - Salesforce Input.0 - Caused by: java.text.ParseException: 2015-03-23T15:36:28.000Z 2015/10/29 18:52:20 - Salesforce Input.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:701) 2015/10/29 18:52:20 - Salesforce Input.0 - ... 6 more 2015/10/29 18:52:20 - Salesforce Input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1) 2015/10/29 18:52:20 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Transformation detected one or more steps with errors. 2015/10/29 18:52:20 - /Users/pedro/Downloads/test-account-extract.ktr : test-account-extract - Transformation is killing the other steps! {noformat}

    Pentaho BI Platform Tracking | 1 year ago | Pedro Morales
    org.pentaho.di.core.exception.KettleException: Can not read data from Salesforce! Created Date String : couldn't convert string [2015-03-23T15:36:28.000Z] to a date using format [yyyy-MM-dd'T'HH:mm:ss'.000'Z] on offset location 0 2015-03-23T15:36:28.000Z
  3. 0

    Elastic to Postgres data migration fails in kettle

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

    Automated exception search integrated into your IDE

  5. 0

    Spoon PDI Data Validator Error

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

    Error al realizar una transformacion con postgresql - Open Business Intelligence

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

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

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.text.ParseException

      2015-03-23T15:36:28.000Z

      at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.value.ValueMetaBase.convertStringToDate(ValueMetaBase.java:701)
      2. org.pentaho.di.core.row.value.ValueMetaBase.getDate(ValueMetaBase.java:1957)
      3. org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3544)
      4. org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.getOneRow(SalesforceInput.java:215)
      5. org.pentaho.di.trans.steps.salesforceinput.SalesforceInput.processRow(SalesforceInput.java:92)
      6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      6 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame