There is a Pentaho Data Integration (Kettle) Job that I'm trying to run on a client's workstation. It yields the following error:
2012/05/21 11:38:21 - Update Case Capital.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Unable to commit Update connection [Voyager] :org.pentaho.di.core.exception.KettleDatabaseException:
2012/05/21 11:38:21 - Update Case Capital.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : Error closing prepared statement
2012/05/21 11:38:21 - Update Case Capital.0 - ERROR (version 4.3.0-GA, build 16753 from 2012-04-18 21.39.30 by buildguy) : This statement is already closed.
The Job runs fine on my computer on a test database, and it ran without any problems at the client as well. Other Kettle Jobs also fail with the same error at the client.
The error happens in an Update step (that runs SQL UPDATE statements) after an arbitrary number of updates had been done. The database used is Firebird 2.5.1.26351 (super classic).
Any advice as to why this happens?