2018/05/25 12:53:27 - load bp.0 - Finished processing (I=20, O=0, R=20, W=20, U=0, E=0)
2018/05/25 12:53:27 - load cost center.0 - Finished processing (I=31, O=0, R=31, W=31, U=0, E=0)
2018/05/25 12:53:27 - load org.0 - Finished processing (I=46, O=0, R=46, W=46, U=0, E=0)
2018/05/25 12:53:27 - load assetgroup.0 - Finished processing (I=66, O=0, R=66, W=66, U=0, E=0)
2018/05/25 12:53:27 - load product.0 - Finished processing (I=158, O=0, R=158, W=158, U=0, E=0)
2018/05/25 12:53:27 - load account.0 - Finished processing (I=255, O=0, R=255, W=255, U=0, E=0)
2018/05/25 12:53:28 - load asset.0 - Finished processing (I=2596, O=0, R=2596, W=2596, U=0, E=0)
2018/05/25 12:53:28 - load dimension with parent-child - All transaction of database connection 'OLTP' where committed at the end of the transformation.
2018/05/25 12:53:28 - load dimension with parent-child - All transaction of database connection 'OLAP' where committed at the end of the transformation.
2018/05/25 12:53:28 - load dimenssion - Starting entry [update parent_source_id]
2018/05/25 12:53:28 - update parent_source_id - Loading transformation from XML file [file:///home/nyoman.gunawan/datamartloading/dim_parentchild 2.ktr]
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - dim_parentchild 2 - Dispatching started for transformation [dim_parentchild 2]
2018/05/25 12:53:28 - read loaded account.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - read loaded org.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - read loaded account.0 - Finished processing (I=256, O=0, R=0, W=256, U=0, E=0)
2018/05/25 12:53:28 - read loaded org.0 - Finished processing (I=47, O=0, R=0, W=47, U=0, E=0)
2018/05/25 12:53:28 - read loaded cc.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - read loaded cc.0 - Finished processing (I=32, O=0, R=0, W=32, U=0, E=0)
2018/05/25 12:53:28 - read loaded asset.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - read loaded asset.0 - Finished processing (I=2597, O=0, R=0, W=2597, U=0, E=0)
2018/05/25 12:53:28 - read loaded sr.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - read loaded project.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - get org parent id.0 - Finished processing (I=45, O=0, R=47, W=47, U=0, E=0)
2018/05/25 12:53:28 - get account parent id.0 - Finished processing (I=250, O=0, R=256, W=256, U=0, E=0)
2018/05/25 12:53:28 - get cc parent id.0 - Finished processing (I=0, O=0, R=32, W=32, U=0, E=0)
2018/05/25 12:53:28 - Update org parent.0 - Finished processing (I=47, O=0, R=47, W=47, U=0, E=0)
2018/05/25 12:53:28 - Update cc parent.0 - Finished processing (I=32, O=0, R=32, W=32, U=0, E=0)
2018/05/25 12:53:28 - Update account parent.0 - Finished processing (I=256, O=0, R=256, W=256, U=0, E=0)
2018/05/25 12:53:28 - get asset parent id.0 - Finished processing (I=0, O=0, R=2597, W=2597, U=0, E=0)
2018/05/25 12:53:28 - Update asset parent.0 - Finished processing (I=2597, O=0, R=2597, W=2597, U=0, E=0)
2018/05/25 12:53:28 - dim_parentchild 2 - All transaction of database connection 'OLAP' where committed at the end of the transformation.
2018/05/25 12:53:28 - load dimenssion - Finished job entry [update parent_source_id] (result=[true])
2018/05/25 12:53:28 - load dimenssion - Finished job entry [load dim] (result=[true])
2018/05/25 12:53:28 - olapsycn - Starting entry [closure]
2018/05/25 12:53:28 - closure - Loading transformation from XML file [file:///home/nyoman.gunawan/datamartloading/closure.ktr]
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2018/05/25 12:53:28 - load closure - Dispatching started for transformation [load closure]
2018/05/25 12:53:28 - load closure salesregion.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure project.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure salesregion.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - load closure project.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - load closure account.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure org.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure asset.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure costcenter.0 - WARNING! Error handling in combination with batch processing is not fully supported on the used database because of driver limitations. Proceed with caution at your own risk.
2018/05/25 12:53:28 - load closure asset.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - load closure costcenter.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - load closure org.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - load closure account.0 - Connected to database [OLAP] (commit=1000)
2018/05/25 12:53:28 - get dim_organization.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - get dim_salesregion.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - get dim_organization.0 - Finished processing (I=47, O=0, R=0, W=47, U=0, E=0)
2018/05/25 12:53:28 - get dim_account.0 - Finished reading query, closing connection.
2018/05/25 12:53:28 - get dim_account.0 - Finished processing (I=256, O=0, R=0, W=256, U=0, E=0)
2018/05/25 12:53:29 - get dim_project.0 - Finished reading query, closing connection.
2018/05/25 12:53:29 - Closure account.0 - Finished processing (I=0, O=0, R=256, W=864, U=0, E=0)
2018/05/25 12:53:29 - get dim_costcenter.0 - Finished reading query, closing connection.
2018/05/25 12:53:29 - get dim_costcenter.0 - Finished processing (I=32, O=0, R=0, W=32, U=0, E=0)
2018/05/25 12:53:29 - Closure organization.0 - Finished processing (I=0, O=0, R=47, W=150, U=0, E=0)
2018/05/25 12:53:29 - load closure org.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
2018/05/25 12:53:29 - load closure org.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2018/05/25 12:53:29 - load closure org.0 - Unable to roll back database transaction to savepoint
2018/05/25 12:53:29 - load closure org.0 - Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure org.0 -
2018/05/25 12:53:29 - load closure org.0 -      at org.pentaho.di.core.database.Database.rollback(Database.java:4428)
2018/05/25 12:53:29 - load closure org.0 -      at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:351)
2018/05/25 12:53:29 - load closure org.0 -      at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2018/05/25 12:53:29 - load closure org.0 -      at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/05/25 12:53:29 - load closure org.0 -      at java.lang.Thread.run(Thread.java:748)
2018/05/25 12:53:29 - load closure org.0 - Caused by: org.postgresql.util.PSQLException: Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure org.0 -      at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:167)
2018/05/25 12:53:29 - load closure org.0 -      at org.pentaho.di.core.database.Database.rollback(Database.java:4426)
2018/05/25 12:53:29 - load closure org.0 -      ... 4 more
2018/05/25 12:53:29 - load closure - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!
2018/05/25 12:53:29 - get dim_asset.0 - Finished reading query, closing connection.
2018/05/25 12:53:29 - Closure costcenter.0 - Finished processing (I=0, O=0, R=32, W=32, U=0, E=0)
2018/05/25 12:53:29 - load closure costcenter.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
2018/05/25 12:53:29 - load closure costcenter.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2018/05/25 12:53:29 - load closure costcenter.0 - Unable to roll back database transaction to savepoint
2018/05/25 12:53:29 - load closure costcenter.0 - Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure costcenter.0 -
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.pentaho.di.core.database.Database.rollback(Database.java:4428)
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:351)
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/05/25 12:53:29 - load closure costcenter.0 -       at java.lang.Thread.run(Thread.java:748)
2018/05/25 12:53:29 - load closure costcenter.0 - Caused by: org.postgresql.util.PSQLException: Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:167)
2018/05/25 12:53:29 - load closure costcenter.0 -       at org.pentaho.di.core.database.Database.rollback(Database.java:4426)
2018/05/25 12:53:29 - load closure costcenter.0 -       ... 4 more
2018/05/25 12:53:29 - Closure asset.0 - Finished processing (I=0, O=0, R=1640, W=0, U=0, E=0)
2018/05/25 12:53:29 - get dim_asset.0 - Finished processing (I=1742, O=0, R=0, W=1741, U=0, E=0)
2018/05/25 12:53:29 - load closure account.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error, this step can't continue:
2018/05/25 12:53:29 - load closure account.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2018/05/25 12:53:29 - load closure account.0 - Unable to roll back database transaction to savepoint
2018/05/25 12:53:29 - load closure account.0 - Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure account.0 -
2018/05/25 12:53:29 - load closure account.0 -  at org.pentaho.di.core.database.Database.rollback(Database.java:4428)
2018/05/25 12:53:29 - load closure account.0 -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:351)
2018/05/25 12:53:29 - load closure account.0 -  at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2018/05/25 12:53:29 - load closure account.0 -  at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/05/25 12:53:29 - load closure account.0 -  at java.lang.Thread.run(Thread.java:748)
2018/05/25 12:53:29 - load closure account.0 - Caused by: org.postgresql.util.PSQLException: Server versions prior to 8.0 do not support savepoints.
2018/05/25 12:53:29 - load closure account.0 -  at org.postgresql.jdbc3.AbstractJdbc3Connection.rollback(AbstractJdbc3Connection.java:167)
2018/05/25 12:53:29 - load closure account.0 -  at org.pentaho.di.core.database.Database.rollback(Database.java:4426)
2018/05/25 12:53:29 - load closure account.0 -  ... 4 more
2018/05/25 12:53:29 - load closure org.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2018/05/25 12:53:29 - load closure - Transformation detected one or more steps with errors.
2018/05/25 12:53:29 - load closure - Transformation is killing the other steps!
2018/05/25 12:53:29 - load closure costcenter.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2018/05/25 12:53:29 - load closure account.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2018/05/25 12:53:29 - load closure - Transformation detected one or more steps with errors.
2018/05/25 12:53:29 - load closure - Transformation is killing the other steps!
2018/05/25 12:53:30 - load closure - Transformation detected one or more steps with errors.
2018/05/25 12:53:30 - load closure - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Errors detected!
2018/05/25 12:53:30 - load closure - Transformation is killing the other steps!
2018/05/25 12:53:30 - olapsycn - Finished job entry [closure] (result=[false])
2018/05/25 12:53:30 - olapsycn - Finished job entry [load dimenssion] (result=[false])
2018/05/25 12:53:30 - olapsycn - Job execution finished
2018/05/25 12:53:30 - Kitchen - Finished!
2018/05/25 12:53:30 - Kitchen - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Finished with errors
2018/05/25 12:53:30 - Kitchen - Start=2018/05/25 12:53:22.232, Stop=2018/05/25 12:53:30.222
2018/05/25 12:53:30 - Kitchen - Processing ended after 7 seconds.