AAAR Extract Finished with errors

[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.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[supta]

So Francesco (such a great guy) was assisting me and he said it's a bug he's working on the solution. In the meantime the solution is not to extract at the end of month (Sep 30 in my case). I tried again today (Oct 1) and those errors strangely didn't show up anymore.