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.