org.pentaho.di.core.exception.KettleException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Invalid layout detected in input streams, rows to append have to be of identical structure 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) :

Pentaho BI Platform Tracking | Michael Willig | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Append Streams doesn't work with Input Table and generate Rows mixed. Error-Message: The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. Both columns have the same layout (Date). 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Unexpected error : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : org.pentaho.di.core.exception.KettleException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Invalid layout detected in input streams, rows to append have to be of identical structure 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:91) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.run(Append.java:157) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Caused by: org.pentaho.di.core.exception.KettleRowException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1648) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:149) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : ... 2 more 2008/12/16 11:04:07 - Append streams.0 - Finished processing (I=0, O=0, R=5, W=4, U=4, E=1) 2008/12/16 11:04:07 - standingdata - Transformation detected one or more steps with errors. 2

    Pentaho BI Platform Tracking | 8 years ago | Michael Willig
    org.pentaho.di.core.exception.KettleException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Invalid layout detected in input streams, rows to append have to be of identical structure 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) :
  2. 0

    Append Streams doesn't work with Input Table and generate Rows mixed. Error-Message: The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. Both columns have the same layout (Date). 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Unexpected error : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : org.pentaho.di.core.exception.KettleException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Invalid layout detected in input streams, rows to append have to be of identical structure 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:91) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.run(Append.java:157) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : Caused by: org.pentaho.di.core.exception.KettleRowException: 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1648) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:149) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87) 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : ... 2 more 2008/12/16 11:04:07 - Append streams.0 - Finished processing (I=0, O=0, R=5, W=4, U=4, E=1) 2008/12/16 11:04:07 - standingdata - Transformation detected one or more steps with errors. 2

    Pentaho BI Platform Tracking | 8 years ago | Michael Willig
    org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date].
  3. 0

    INFO 06-05 14:40:45,799 - Contacts - Starting entry [Contacts - Add Contact Owner] INFO 06-05 14:40:45,801 - Contacts - Add Contact Owner - Loading transformation from repository [Contacts - Add Contact Owner] in directory [/Ticoon/V42/Import/Contacts] INFO 06-05 14:40:46,197 - Contacts - Add Contact Owner - Dispatching started for transformation [Contacts - Add Contact Owner] INFO 06-05 14:40:46,208 - Contacts - Add Contact Owner - This transformation can be replayed with replay date: 2013/05/06 14:40:46 INFO 06-05 14:40:46,296 - Table output.CONTACT_OWNER.0 - Connected to database [TicoonDB] (commit=1000) INFO 06-05 14:40:46,307 - Table input.CONTACT.Split.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,284 - Table input.CAIBNA.ADVISOR.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,285 - Table input.CAICIF.ADVISOR.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,286 - Table input.CAICIF.ADVISOR.0 - Finished processing (I=115, O=0, R=0, W=115, U=0, E=0) INFO 06-05 14:47:49,587 - Append streams.CAIBNA.CAICIF.ADVISOR.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) ERROR 06-05 15:06:40,119 - Append streams.0 - Unexpected error : ERROR 06-05 15:06:40,120 - Append streams.0 - org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:91) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) at org.pentaho.di.trans.steps.append.Append.run(Append.java:163) Caused by: org.pentaho.di.core.exception.KettleRowException: The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1717) at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:155) at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87) ... 2 more ERROR 06-05 15:06:40,121 - Contacts - Add Contact Owner - Errors detected! INFO 06-05 15:06:40,122 - Constants.CreateUser.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) INFO 06-05 15:06:40,123 - SysInfo.CREATE_DT.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) ERROR 06-05 15:06:40,123 - Contacts - Add Contact Owner - Errors detected! INFO 06-05 15:06:40,321 - existing Contacts with no Contact_Owner.0 - Finished reading query, closing connection. INFO 06-05 15:06:40,323 - Append streams.0 - Finished processing (I=0, O=0, R=116, W=115, U=0, E=1) INFO 06-05 15:06:40,323 - SQL.Log.Upd.0 - Finished reading query, closing connection. INFO 06-05 15:06:40,323 - DBLookup.CreateByUser.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=0) INFO 06-05 15:06:40,323 - existing Contacts with no Contact_Owner.0 - Finished processing (I=21, O=0, R=0, W=19, U=0, E=0) INFO 06-05 15:06:40,324 - Contacts - Add Contact Owner - Transformation detected one or more steps with errors. INFO 06-05 15:06:40,325 - Contacts - Add Contact Owner - Transformation is killing the other steps! INFO 06-05 15:06:40,421 - Append.CONTACT.Split.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0)

    Pentaho BI Platform Tracking | 4 years ago | Jimmy Skaria Abraham
    org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)].
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ERROR 06-05 15:06:40,119 - Append streams.0 - Unexpected error : ERROR 06-05 15:06:40,120 - Append streams.0 - org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:91) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) at org.pentaho.di.trans.steps.append.Append.run(Append.java:163) Caused by: org.pentaho.di.core.exception.KettleRowException: The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1717) at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:155) at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87) ... 2 more ERROR 06-05 15:06:40,121 - Contacts - Add Contact Owner - Errors detected! INFO 06-05 15:06:40,122 - Constants.CreateUser.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) INFO 06-05 15:06:40,123 - SysInfo.CREATE_DT.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) ERROR 06-05 15:06:40,123 - Contacts - Add Contact Owner - Errors detected!

    Pentaho BI Platform Tracking | 4 years ago | Jimmy Skaria Abraham
    org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)].
  6. 0

    INFO 06-05 14:40:45,799 - Contacts - Starting entry [Contacts - Add Contact Owner] INFO 06-05 14:40:45,801 - Contacts - Add Contact Owner - Loading transformation from repository [Contacts - Add Contact Owner] in directory [/Ticoon/V42/Import/Contacts] INFO 06-05 14:40:46,197 - Contacts - Add Contact Owner - Dispatching started for transformation [Contacts - Add Contact Owner] INFO 06-05 14:40:46,208 - Contacts - Add Contact Owner - This transformation can be replayed with replay date: 2013/05/06 14:40:46 INFO 06-05 14:40:46,296 - Table output.CONTACT_OWNER.0 - Connected to database [TicoonDB] (commit=1000) INFO 06-05 14:40:46,307 - Table input.CONTACT.Split.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,284 - Table input.CAIBNA.ADVISOR.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,285 - Table input.CAICIF.ADVISOR.0 - Finished reading query, closing connection. INFO 06-05 14:47:49,286 - Table input.CAICIF.ADVISOR.0 - Finished processing (I=115, O=0, R=0, W=115, U=0, E=0) INFO 06-05 14:47:49,587 - Append streams.CAIBNA.CAICIF.ADVISOR.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) ERROR 06-05 15:06:40,119 - Append streams.0 - Unexpected error : ERROR 06-05 15:06:40,120 - Append streams.0 - org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:91) at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) at org.pentaho.di.trans.steps.append.Append.run(Append.java:163) Caused by: org.pentaho.di.core.exception.KettleRowException: The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)]. at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1717) at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:155) at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87) ... 2 more ERROR 06-05 15:06:40,121 - Contacts - Add Contact Owner - Errors detected! INFO 06-05 15:06:40,122 - Constants.CreateUser.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) INFO 06-05 15:06:40,123 - SysInfo.CREATE_DT.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0) ERROR 06-05 15:06:40,123 - Contacts - Add Contact Owner - Errors detected! INFO 06-05 15:06:40,321 - existing Contacts with no Contact_Owner.0 - Finished reading query, closing connection. INFO 06-05 15:06:40,323 - Append streams.0 - Finished processing (I=0, O=0, R=116, W=115, U=0, E=1) INFO 06-05 15:06:40,323 - SQL.Log.Upd.0 - Finished reading query, closing connection. INFO 06-05 15:06:40,323 - DBLookup.CreateByUser.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=0) INFO 06-05 15:06:40,323 - existing Contacts with no Contact_Owner.0 - Finished processing (I=21, O=0, R=0, W=19, U=0, E=0) INFO 06-05 15:06:40,324 - Contacts - Add Contact Owner - Transformation detected one or more steps with errors. INFO 06-05 15:06:40,325 - Contacts - Add Contact Owner - Transformation is killing the other steps! INFO 06-05 15:06:40,421 - Append.CONTACT.Split.0 - Finished processing (I=0, O=0, R=115, W=115, U=0, E=0)

    Pentaho BI Platform Tracking | 4 years ago | Jimmy Skaria Abraham
    org.pentaho.di.core.exception.KettleException: Invalid layout detected in input streams, rows to append have to be of identical structure The data type of field #1 is not the same as the first row received: you're mixing rows with different layout. Field [CONTACT_OWNER_ID Number] does not have the same data type as field [CONTACT_OWNER_ID Integer(10)].

    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.KettleRowException

      2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) : The name of field number 6 is not the same as in the first row received: you're mixing rows with different layout. Field [AUDIT_CREATIONDATE Date] does not have the same name as field [AUDIT_CREATIONDATE Date]. 2008/12/16 11:04:07 - Append streams.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:29:00) :

      at org.pentaho.di.trans.step.BaseStep.safeModeChecking()
    2. org.pentaho.di
      Append.run
      1. org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1648)
      2. org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:149)
      3. org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87)
      4. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
      5. org.pentaho.di.trans.steps.append.Append.run(Append.java:157)
      5 frames