Error AAAR - Error in extraction

flavia — Thu, 04 Jan 2018 12:29:50 GMT

HiFrancesco Corti! Congratulations on the AAAR! I think it's an incredible tool and I'm trying to use it.Some errors appear after extraction and I do not know how to solve them. Could you help me please?2018/01/04 11:21:07 - stg_workflow_instances.0 - Finished reading query, closing connection.2018/

Re: Error AAAR - Error in extraction

fcorti — Fri, 05 Jan 2018 08:13:56 GMT

HI Flavia,

Thank you for the feedback.

The issue is well known and it is due to the foreign key violation on dates.

Cannot add or update a child row: a foreign key constraint fails (`aaar_datamart`.`dm_dim_workflow_instances`, CONSTRAINT `fk_dm_dim_workflow_instances_dm_dim_dates_due` FOREIGN KEY (`due_date_id`) REFERENCES `dm_dim_dates` (`id`))

Most of the times, the issue is related to a "wrong date" in the workflows instances.

Sometimes happens that the dm_dim_dates is not correctly filled.

To solve the issue, you can:

1) Check the dm_dim_dates is filled with some data (it should contain several dates).

2) Check the wrong values into the stg_workflow_instances.duedate field. For example you can create a SQL query searching for the duedate values that are not included into the dm_dim_dates.id values.

Once found the issue, the solution is quite easy:

1) There is a problem in the ETL to fill the dates and it should be solved understanding why the values are not correctly filled (usually date formats).

2) Adjust the duedate on Alfresco side because it is often a wrong value.

Cheers.

topic Re: Error AAAR - Error in extraction in Alfresco Forum

Error AAAR - Error in extraction

Re: Error AAAR - Error in extraction