AnsweredAssumed Answered

AAAR Extract Finished with errors

Question asked by supta on Sep 30, 2015
Latest reply on Oct 1, 2015 by supta
Hi,

I'm in the process of installing AAAR on my localhost to access alfresco in remote server. The following are errors found in log when I run AAAR_Extract.sh. I know the error is related to database (sql query) but I honestly have no idea how to solve them. Any suggestion would be very appreciated. Thank you.


org.pentaho.di.core.exception.KettleStepException:
Error in step, asking everyone to stop because of:

Error inserting/updating row
ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
  Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".


   at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:313)
   at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
   at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Error inserting/updating row
ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
  Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".

   at org.pentaho.di.core.database.Database.insertRow(Database.java:1280)
   at org.pentaho.di.core.database.Database.insertRow(Database.java:1204)
   at org.pentaho.di.core.database.Database.insertRow(Database.java:1192)
   at org.pentaho.di.core.database.Database.insertRow(Database.java:1180)
   at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)
   at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)
   … 2 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
  Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
   at org.pentaho.di.core.database.Database.insertRow(Database.java:1247)
   … 7 more
2015/09/30 11:47:15 - dm_dim_dates.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Unexpected error
2015/09/30 11:47:15 - dm_dim_dates.0 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2015/09/30 11:47:15 - dm_dim_dates.0 - Error in step, asking everyone to stop because of:
2015/09/30 11:47:15 - dm_dim_dates.0 -
2015/09/30 11:47:15 - dm_dim_dates.0 - Error inserting/updating row
2015/09/30 11:47:15 - dm_dim_dates.0 - ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
2015/09/30 11:47:15 - dm_dim_dates.0 -   Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".
2015/09/30 11:47:15 - dm_dim_dates.0 -
2015/09/30 11:47:15 - dm_dim_dates.0 -
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:313)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at java.lang.Thread.run(Thread.java:745)
2015/09/30 11:47:15 - dm_dim_dates.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2015/09/30 11:47:15 - dm_dim_dates.0 - Error inserting/updating row
2015/09/30 11:47:15 - dm_dim_dates.0 - ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
2015/09/30 11:47:15 - dm_dim_dates.0 -   Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".
2015/09/30 11:47:15 - dm_dim_dates.0 -
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.core.database.Database.insertRow(Database.java:1280)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.core.database.Database.insertRow(Database.java:1204)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.core.database.Database.insertRow(Database.java:1192)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.core.database.Database.insertRow(Database.java:1180)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)
2015/09/30 11:47:15 - dm_dim_dates.0 -    … 2 more
2015/09/30 11:47:15 - dm_dim_dates.0 - Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"
2015/09/30 11:47:15 - dm_dim_dates.0 -   Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)
2015/09/30 11:47:15 - dm_dim_dates.0 -    at org.pentaho.di.core.database.Database.insertRow(Database.java:1247)
2015/09/30 11:47:15 - dm_dim_dates.0 -    … 7 more
child index = 3, logging object : org.pentaho.di.core.logging.LoggingObject@7288e13f parent=5956354f-990f-4b6f-a700-45b8bd71bce6
2015/09/30 11:47:15 - dm_dim_dates.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1)
2015/09/30 11:47:15 - Dimension update 3 - Transformation detected one or more steps with errors.
2015/09/30 11:47:15 - Dimension update 3 - Transformation is killing the other steps!
2015/09/30 11:47:15 - Dimension update 3 - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Errors detected!
2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension update 3] (result=[false])
2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension update 2] (result=[false])
2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension audit update] (result=[false])
2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Clean dm_fact_actions] (result=[false])
2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit data mart] (result=[false])
2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit operational] (result=[false])
2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit staging] (result=[false])
2015/09/30 11:47:15 - Get all on a server - Finished job entry [Get audit] (result=[false])
2015/09/30 11:47:15 - Get all on a server - Finished job entry [get_audit] (result=[false])
2015/09/30 11:47:15 - Get all - Finished job entry [Get all on a server] (result=[false])
2015/09/30 11:47:15 - Get all - Finished job entry [Get all source id] (result=[false])
2015/09/30 11:47:15 - Get all - Job execution finished
2015/09/30 11:47:15 - Kitchen - Finished!
2015/09/30 11:47:15 - Kitchen - ERROR (version 5.4.0.1-130, build 1 from 2015-06-14_12-34-55 by buildguy) : Finished with errors
2015/09/30 11:47:15 - Kitchen - Start=2015/09/30 11:46:50.756, Stop=2015/09/30 11:47:15.692
2015/09/30 11:47:15 - Kitchen - Processing ended after 24 seconds.

Outcomes