AnsweredAssumed Answered

Load data warehouse job when run on incremental fails and throws below error.

Question asked by Jashu on Jul 22, 2016
Latest reply on Aug 1, 2016 by Chris_Hackett

Execute SQL script - org.pentaho.di.core.exception.KettleStepException:  Error while running this step!  Couldn't execute SQL: ALTER TABLE DWH_INV_TEAM_LN ENABLE VALIDATE CONSTRAINT DWH_INV_TEAM_LN_FK1  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired    at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60) at java.lang.Thread.run(Thread.java:745) Caused by: org.pentaho.di.core.exception.KettleDatabaseException:  Couldn't execute SQL: ALTER TABLE DWH_INV_TEAM_LN ENABLE VALIDATE CONSTRAINT DWH_INV_TEAM_LN_FK1  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired   at org.pentaho.di.core.database.Database.execStatement(Database.java:1432) at org.pentaho.di.core.database.Database.execStatements(Database.java:1538) at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:225) ... 2 more

Outcomes