Description:
Using the open source Tool PDI v4.2 below error occurred when we wre fetching the data from a View.
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error
2013/07/15 14:52:43 - Add sequence 31.0 - Finished processing (I=0, O=0, R=2403, W=2403, U=0, E=0)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : An error occurred executing SQL:
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : select ov.name,bat.name from campusorganizationsview ov
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : left join campusacdbatch bat on(bat.site_id=ov.entity_id and bat.site_dcnid=ov.dcnid) where bat.rowstate!=-1 and ov.entity_id=?
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Prepared statement needs to be re-prepared
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1912)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:225)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:133)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Thread.java:619)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1383)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:841)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2306)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1873)
2013/07/15 14:52:43 - Table input.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : ... 4 more
2013/07/15 14:52:43 - Select values 7.0 - Finished processing (I=0, O=0, R=8, W=8, U=0, E=0)
2013/07/15 14:52:43 - Add sequence 4.0 - Finished processing (I=0, O=0, R=10, W=10, U=0, E=0)
2013/07/15 14:52:43 - Select values 30.0 - Finished processing (I=0, O=0, R=4, W=4, U=0, E=0)
2013/07/15 14:52:43 - Select values 27.0 - Finished processing (I=0, O=0, R=8, W=8, U=0, E=0)
2013/07/15 14:52:43 - Add sequence 44.0 - Finished processing (I=0, O=0, R=6, W=6, U=0, E=0)
Kindly help.
How to repeat:
Use opensource Tool PDI 4.2.
Use databaselookup and try to fetch data from view.
Error will occur on runtime.