运行job 出现下面的错误java.net.SocketExceptionMESSAGE

发布于 2021-11-12 02:02:17 字数 61637 浏览 798 评论 2

pentaho data integration 3.2

当运行数据量比较大时出现下面的error，如果数据量较小时，Job是可以成功运行。

出现这种情况是什么原因？

2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Because of an error, this step can't continue:
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleException:
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error batch inserting rows into table [FACT_R077_PARTITION].
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors encountered (first 10):
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite0(Native Method)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.write(BufferedOutputStream.java:109)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2737)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:602)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error updating batch
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:383)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseBatchException:
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error updating batch
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:299)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.BatchUpdateException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:652)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error committing the database connection.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.NullPointerException
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:541)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1387)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:611)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2918)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Select values 2.0 - Finished processing (I=0, O=0, R=8168, W=8168, U=0, E=0)
2012/08/07 16:35:56 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=2099331, W=2099331, U=0, E=0)
2012/08/07 16:35:56 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=2112077, W=2112076, U=0, E=0)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.NullPointerException
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:541)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1387)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:611)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2918)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error rolling back the database connection.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error performing rollback on connection
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite0(Native Method)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite0(Native Method)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2757)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:667)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:661)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2918)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite0(Native Method)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite0(Native Method)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2739)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2757)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2650)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1581)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollbackNoChecks(Connection.java:4913)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4810)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:641)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:374)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:114)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableoutput.TableOutput.run(TableOutput.java:680)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :

** END NESTED EXCEPTION **

2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.checkClosed(Connection.java:1844)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.rollback(Connection.java:4800)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.rollback(PoolingDriver.java:348)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.rollback(Database.java:656)
2012/08/07 16:35:56 - Table output FACT_R077_PARTITION.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 4 more
2012/08/07 16:35:56 - Select values.0 - Finished processing (I=0, O=0, R=2099110, W=2099110, U=0, E=0)
2012/08/07 16:35:56 - Row Normaliser.0 - Finished processing (I=0, O=0, R=10052, W=2583237, U=0, E=0)
2012/08/07 16:35:56 - Dummy (do nothing) NULL.0 - Finished processing (I=0, O=0, R=464638, W=464638, U=0, E=0)
2012/08/07 16:35:56 - Table input FACT_R077.0 - Finished reading query, closing connection.
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error disconnecting from database:
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error comitting connection
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Communications link failure during commit(). Transaction resolution unknown.
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Error comitting connection
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Communications link failure during commit(). Transaction resolution unknown.
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) :
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:635)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:605)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.disconnect(Database.java:496)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:263)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2918)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.run(TableInput.java:345)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.sql.SQLException: Communications link failure during commit(). Transaction resolution unknown.
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at com.mysql.jdbc.Connection.commit(Connection.java:2171)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.commit(PoolingDriver.java:259)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.database.Database.commit(Database.java:625)
2012/08/07 16:35:56 - module_r077_dn2fisdev01 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 5 more
2012/08/07 16:35:56 - Table input FACT_R077.0 - Finished processing (I=20041, O=0, R=0, W=20040, U=0, E=0)
2012/08/07 16:35:56 - Transformation Test Filter Parameter using outlier - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
2012/08/07 16:35:56 - Transformation Test Filter Parameter using outlier - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
2012/08/07 16:35:56 - Stream lookup PARAMETER.0 - Stopped processing with empty row after 2116399 rows.