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)].

Pentaho BI Platform Tracking | Jimmy Skaria Abraham | 4 years ago
  1. 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)].
  2. 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)].
  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

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

    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

      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()
    2. org.pentaho.di
      Append.run
      1. org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:1717)
      2. org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:155)
      3. org.pentaho.di.trans.steps.append.Append.processRow(Append.java:87)
      4. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
      5. org.pentaho.di.trans.steps.append.Append.run(Append.java:163)
      5 frames