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

于 2021-02-27 19:08:38 发布
阅读量294 收藏
点赞数
文章标签： java row socket
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_32528123/article/details/114829057
版权

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:

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) :  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:

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) :  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:

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) :  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.

桑夷
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java项目遇到的常见问题
高精尖发展
05-03 3982
问题一、 Description Resource Path Location Type Java compiler level does not match the version of the instal 解决： 一、设置jdk版本， windows---proferences---java--compiler，设置编译出来的文件使用的格式是1.7（团队统一） 二、项目右击-
kettle6.0 连接oracle11g,Kettle表输出报关闭的连接问题的解决方法
weixin_39949506的博客
04-11 1512
最近在使用Kettle的时候表输出有时候会报一个错误 关闭的连接在网上查了半天都没有找到解决办法现在记录一下解决过程以备后用。1.软件环境-Oracle 11g R2 RAC-Kettle6.0.1.0-JDK 1.68-Oracle Driver OJDBC14.jar2.报错如下2016/06/23 16:53:30 - 表输出 2.0 - ERROR (version 6.0.1.0-3...
Kettle 文本输入步骤读取异常 DOS format was specified
真正的错误是，当你知道应该如何去提高时仍然选择做一名初学者！
10-23 8055
DOS format was specified but only a single line feed character was found, not 2 在使用KETTLE抽取文本文件数据到数据库，出现了一个错误： 2013/10/23 10:34:34 - Trans - 这项转换可以被回放 回放日期是: 2013/10/23 10:34:33 2013/10/23 10:3
数据库连接异常java.net_连接数据库时 java.net.SocketException MESSAGE: java.net.NoRouteToHostException: No route t...
weixin_39562327的博客
02-25 239
**BEGINNESTEDEXCEPTION**java.net.SocketExceptionMESSAGE:java.net.NoRouteToHostException:NoroutetohostSTACKTRACE:java.net.SocketException:java.net.NoRouteToHostException:N...** BEGIN NESTED EXCEPTION *...
使用DBCP连接池时出现过一段时间断开连接的解决方法
我思故我在
01-10 2923
问题： ** BEGIN NESTED EXCEPTION **   java.net.SocketException    MESSAGE: Broken pipe      STACKTRACE:   java.net.SocketException: Broken pipe   at java.net.SocketOutputStream.socketWrite0(Native Met...
Java_Excel_API_jxl_.rar_excel java_java excel
09-24
Cell cell = row.createCell(0); cell.setCellValue("Hello, Excel!"); ``` 4. 保存工作簿：调用Workbook的write()方法，将工作簿写入文件，最后关闭工作簿。 ```java workbook.write(); workbook.close(); ``` ...
ooxml-java.zip_ooxml java
09-14
XSSFCell cell = row.getCell(0); cell.setCellValue("新内容"); ``` 5. **保存更改**：完成修改后，使用`Workbook`对象的`write`方法将更改写入文件，并记得关闭流。 ```java FileOutputStream out = new ...
java_Excel_import.rar_excel 导入_java 导入 excel
09-19
在Java开发中，处理Excel数据是一项常见的任务，特别是在数据处理、报表生成或系统集成场景下。本主题将深入探讨如何使用Java实现Excel数据的读取和导入。主要涉及的工具有Apache POI库，它是Java中处理Microsoft ...
read-Excel-with-JAVA.zip_java excel
09-20
Cell cell = row.getCell(0); // 获取第一列的单元格 if (cell != null) { String value = cell.getStringCellValue(); System.out.println("First cell value: " + value); } } workbook.close(); } catch ...
UDP-client-server.rar_The First_row socket
09-14
Editor to work with two strings (string concatenation, for equality of strings for equality lengths, insert the second row in a predetermined position of the first) Server application retrieves data...
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
qq_42554949的博客
10-09 3148
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown. 这个问题当时是发生在我们软件使用人数突然激增的一个时间段,前面一个链接还没有执行完毕,后面的链接又来了,导致一个线程堵塞.导致一些链接超时掉了.数据库连接超时断开连接,但是服务层面这个链接还是存在的导致这个问题,如
mysql报错 Communications link failure during rollback(). Transaction resolution unknown.解决方式
weixin_41905537的博客
11-21 1万+
springboot中引入的dataSource，没有设置最大连接时间。默认是30000，改为60000；
kettle 内存设置_Kettle大数据量转换报错ora-04030: 在尝试分配484字节时进程内存不足...
weixin_39577964的博客
12-20 677
最近在帮香港地铁在做一个数据转换，老的系统的表数据量都在几千万级别的，转换到700万左右就会出现以下错误：2011/06/23 06:14:20 - PM_MEASUREMENT_READING.0 - linenr 75500002011/06/23 06:14:20 - Update.0 - linenr 75500002011/06/23 06:14:27 - BU_ID.0 - LineN...
Communications link failure during commit(). Transaction resolution unknown.
cihuan0804的博客
07-06 1万+
13:37:06.443 [pool-10-thread-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task. org.springframework.tran...
常见异常解释及解决办法
wxians的博客
07-11 401
在编写应用的时候，为了调试程序方便，可以在异常处理代码中把异常信息显示出来，这样可以根据错误提示调试代码。异常处理代码通常可以写成这样：  try{  …  }catch(Exception e){  System.out.println(e.toString());  }  下面是一些常见的错误信息：  （1）驱动程序不存在  提示的错误信息如下：  java.lang.Cla
kettle连接Webservice接口
热门推荐
pyy的博客
04-18 1万+
参考Webservice接口数据抽取_kettel 发送HTTP POST请求，获取返回内容。 发送HTTP GET请求，获取返回内容，可以从前面获取URL、参数名、参数值 通过Restful获取数据 通过webService获取数据 查询 HTTP/WebService 点击“load”能加载出方法 kettle的组件--生成记录 文本文件输出 ...
java实现row_number
最新发布
08-24
在Java中实现ROW_NUMBER函数可以通过使用窗口函数来实现。窗口函数是从数据库中提取数据的一个特殊函数，可以将数据划分为不同的窗口，并对每个窗口中的数据进行计算或排序。在Java中，可以使用一些数据库操作框架...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值