topic AAAR Extract Finished with errors in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/aaar-extract-finished-with-errors/m-p/305041#M258171 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />org.pentaho.di.core.exception.KettleStepException: <BR />Error in step, asking everyone to stop because of:<BR /><BR />Error inserting/updating row<BR />ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"<BR />&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR /><BR /><BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:313)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745)<BR />Caused by: org.pentaho.di.core.exception.KettleDatabaseException: <BR />Error inserting/updating row<BR />ERROR: insert or update on table "dm_dim_dates" violates foreign key constraint "fk_dm_dim_dates_dm_dim_months"<BR />&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR /><BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1280)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1204)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1192)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1180)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)<BR />&nbsp;&nbsp;&nbsp;… 2 more<BR />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"<BR />&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)<BR />&nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1247)<BR />&nbsp;&nbsp;&nbsp;… 7 more<BR />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<BR />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: <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - Error in step, asking everyone to stop because of:<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - Error inserting/updating row<BR />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"<BR />2015/09/30 11:47:15 - dm_dim_dates.0 -&nbsp;&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:313)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - Error inserting/updating row<BR />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"<BR />2015/09/30 11:47:15 - dm_dim_dates.0 -&nbsp;&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - <BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1280)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1204)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1192)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1180)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:114)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:299)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;… 2 more<BR />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"<BR />2015/09/30 11:47:15 - dm_dim_dates.0 -&nbsp;&nbsp; Detail: Key (month_id)=(2015-10-01) is not present in table "dm_dim_months".<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;at org.pentaho.di.core.database.Database.insertRow(Database.java:1247)<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - &nbsp;&nbsp;&nbsp;… 7 more<BR />child index = 3, logging object : org.pentaho.di.core.logging.LoggingObject@7288e13f parent=5956354f-990f-4b6f-a700-45b8bd71bce6<BR />2015/09/30 11:47:15 - dm_dim_dates.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1)<BR />2015/09/30 11:47:15 - Dimension update 3 - Transformation detected one or more steps with errors.<BR />2015/09/30 11:47:15 - Dimension update 3 - Transformation is killing the other steps!<BR />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!<BR />2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension update 3] (result=[false])<BR />2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension update 2] (result=[false])<BR />2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Dimension audit update] (result=[false])<BR />2015/09/30 11:47:15 - Init audit data mart - Finished job entry [Clean dm_fact_actions] (result=[false])<BR />2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit data mart] (result=[false])<BR />2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit operational] (result=[false])<BR />2015/09/30 11:47:15 - Get audit - Finished job entry [Init audit staging] (result=[false])<BR />2015/09/30 11:47:15 - Get all on a server - Finished job entry [Get audit] (result=[false])<BR />2015/09/30 11:47:15 - Get all on a server - Finished job entry [get_audit] (result=[false])<BR />2015/09/30 11:47:15 - Get all - Finished job entry [Get all on a server] (result=[false])<BR />2015/09/30 11:47:15 - Get all - Finished job entry [Get all source id] (result=[false])<BR />2015/09/30 11:47:15 - Get all - Job execution finished<BR />2015/09/30 11:47:15 - Kitchen - Finished!<BR />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<BR />2015/09/30 11:47:15 - Kitchen - Start=2015/09/30 11:46:50.756, Stop=2015/09/30 11:47:15.692<BR />2015/09/30 11:47:15 - Kitchen - Processing ended after 24 seconds.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Wed, 30 Sep 2015 06:46:46 GMT supta 2015-09-30T06:46:46Z AAAR Extract Finished with errors https://connect.hyland.com/t5/alfresco-archive/aaar-extract-finished-with-errors/m-p/305041#M258171 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. Wed, 30 Sep 2015 06:46:46 GMT https://connect.hyland.com/t5/alfresco-archive/aaar-extract-finished-with-errors/m-p/305041#M258171 supta 2015-09-30T06:46:46Z Re: AAAR Extract Finished with errors https://connect.hyland.com/t5/alfresco-archive/aaar-extract-finished-with-errors/m-p/305042#M258172 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Thu, 01 Oct 2015 08:32:33 GMT https://connect.hyland.com/t5/alfresco-archive/aaar-extract-finished-with-errors/m-p/305042#M258172 supta 2015-10-01T08:32:33Z