AnsweredAssumed Answered

AAAR Extract Error Invalid layout detected in input streams, rows to append have to be of identical structure

Question asked by gatsu2811 on Nov 4, 2015
Latest reply on Nov 6, 2015 by fcorti
Hi everyone,

I'm having problem extracting data with this return error;

2015/11/04 17:18:09 - Append streams.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error
2015/11/04 17:18:09 - Append streams.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleException:
2015/11/04 17:18:09 - Append streams.0 - Invalid layout detected in input streams, rows to append have to be of identical structure
2015/11/04 17:18:09 - Append streams.0 -
2015/11/04 17:18:09 - Append streams.0 - The name of field number 26 is not the same as in the first row received: you're mixing rows with different layout. Field [owner_id Integer] does not have the same name as field [instance_id Integer].
2015/11/04 17:18:09 - Append streams.0 -
2015/11/04 17:18:09 - Append streams.0 -
2015/11/04 17:18:09 - Append streams.0 -    at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:95)
2015/11/04 17:18:09 - Append streams.0 -    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2015/11/04 17:18:09 - Append streams.0 -    at java.lang.Thread.run(Thread.java:745)
2015/11/04 17:18:09 - Append streams.0 - Caused by: org.pentaho.di.core.exception.KettleRowException:
2015/11/04 17:18:09 - Append streams.0 - The name of field number 26 is not the same as in the first row received: you're mixing rows with different layout. Field [owner_id Integer] does not have the same name as field [instance_id Integer].
2015/11/04 17:18:09 - Append streams.0 -
2015/11/04 17:18:09 - Append streams.0 -    at org.pentaho.di.trans.step.BaseStep.safeModeChecking(BaseStep.java:2054)
2015/11/04 17:18:09 - Append streams.0 -    at org.pentaho.di.trans.steps.append.Append.checkInputLayoutValid(Append.java:159)
2015/11/04 17:18:09 - Append streams.0 -    at org.pentaho.di.trans.steps.append.Append.processRow(Append.java:93)
2015/11/04 17:18:09 - Append streams.0 -    … 2 more
2015/11/04 17:18:09 - Append streams.0 - Finished processing (I=0, O=0, R=9, W=8, U=0, E=1)

Thank you for your kind help.

Outcomes