Loading data using PDI (Star Schema)

1 post / 0 new
kleysonr
kleysonr's picture
Offline
Last seen: 10 months 2 weeks ago
Joined: Sep 4 2013
Junior Boarder

Posts: 1

Kleyson Rios
Loading data using PDI (Star Schema)

We are planning change our DW from Postgres to InfiniDB.

I have an ETL that load data for dimensions and fact table stored in Postgres DB.

I am trying to use the same ETL for InfiniDB, but I am getting the following error:

[code]
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
org.pentaho.di.core.exception.KettleDatabaseException:
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error inserting/updating row
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
IDB-2010: Unable to perform DDL/DML because session 4214 is currently updating dimensao.d_fornecedor.
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.core.database.Database.insertRow(Database.java:1411)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.core.database.Database.insertRow(Database.java:1325)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.core.database.Database.insertRow(Database.java:1313)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.combiInsert(CombinationLookup.java:676)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.lookupValues(CombinationLookup.java:298)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.trans.steps.combinationlookup.CombinationLookup.processRow(CombinationLookup.java:406)
2013/09/04 13:17:21 - D_FORMALIDADE_FINALIDADE.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : at
org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)