org.pentaho.di.core.exception.KettleException: Error adding values to row! A12 BAD Command Argument Error. 11

Pentaho BI Platform Tracking | Philip Panelli | 4 years ago
  1. 0

    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

    Pentaho BI Platform Tracking | 4 years ago | Philip Panelli
    org.pentaho.di.core.exception.KettleException: Error adding values to row! A12 BAD Command Argument Error. 11
  2. 0

    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

    Pentaho BI Platform Tracking | 4 years ago | Philip Panelli
    org.pentaho.di.core.exception.KettleException: Error adding values to row! A12 BAD Command Argument Error. 11
  3. 0

    Elastic to Postgres data migration fails in kettle

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

    Automated exception search integrated into your IDE

  5. 0

    Spoon PDI Data Validator Error

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

    Error al realizar una transformacion con postgresql - Open Business Intelligence

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

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

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

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

      Error adding values to row! A12 BAD Command Argument Error. 11

      at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:326)
      2. org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:69)
      3. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      3 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame