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 rowERROR: 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 rowERROR: 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 moreCaused 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 more2015/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 error2015/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 row2015/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 row2015/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 more2015/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 morechild index = 3, logging object : org.pentaho.di.core.logging.LoggingObject@7288e13f parent=5956354f-990f-4b6f-a700-45b8bd71bce62015/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 finished2015/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 errors2015/09/30 11:47:15 - Kitchen - Start=2015/09/30 11:46:50.756, Stop=2015/09/30 11:47:15.6922015/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.