topic Re: AAAR don't extract all data of my custom aspects in Alfresco Forum

AAAR don't extract all data of my custom aspects

arak — Fri, 05 May 2017 22:02:37 GMT

Hi, I have problems with the "AAAR" tool. I have generated the respective tables (with "AAAR_Create_custom_structures.sh") for my custom aspects, and when I run "AAAR_Extract.sh", not all the data is extracted in the tables. Francesco Corti I attached the extraction log.Thanks for any help.

Re: AAAR don't extract all data of my custom aspects

fcorti — Wed, 10 May 2017 09:56:57 GMT

Hi Arak,

The error message is this:

017/05/09 15:01:11 - HTTP request - Connecting to URL: http://localhost:8082/alfresco/service/AAAR/getCounters?counter=types&classes={"types":[],"aspects":[]}
2017/05/09 15:01:11 - HTTP request - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : I was unable to save the HTTP result to file because of a I/O error: Server returned HTTP response code: 400 for URL: http://localhost:8082/alfresco/service/AAAR/getCounters?counter=types&classes={"types":[],"aspects":[]}

This error is due to the fact that no types/aspects are specified in the array lists.

It could be a bug but it should not affect the extraction (it affect the data quality check only).

Do you have data into the custom tables related to the custom types and aspects?

Re: AAAR don't extract all data of my custom aspects

arak — Wed, 10 May 2017 12:06:43 GMT

Hi Francesco,

I have data in the table dm_custom_metadata (only aspects) and I create the tables related to this custom aspects,
but are empty after extraction :/, any idea?. I use Pentaho 7, Alfresco 5.1 and AAAR 4.5.

Greetings,

Pablo V.

Re: AAAR don't extract all data of my custom aspects

fcorti — Wed, 10 May 2017 12:10:07 GMT

Can you please share the dm_custom_metadata table?

Re: AAAR don't extract all data of my custom aspects

arak — Wed, 10 May 2017 13:35:50 GMT

This is my dm_custom_metadata table:

I only see the getCounter error when I extract the data. In the alfresco console appear the next:

....

2017-05-10 11:42:45,459 ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8082-exec-15] Exception from executeScript - redirecting to status template error: 04100047 Error: 400: Class list empty in 'aspects' parameter.
org.springframework.extensions.webscripts.WebScriptException: 04100047 Error: 400: Class list empty in 'aspects' parameter.

.....

ERROR [extensions.webscripts.AbstractRuntime] [http-apr-8082-exec-13] Exception from executeScript - redirecting to status template error: 04100051 Error: 400: Class list empty in 'types' parameter.
org.springframework.extensions.webscripts.WebScriptException: 04100051 Error: 400: Class list empty in 'types' parameter.

....

And, when I install AAAR, without erros, I can see this:

Unfortuantely Pentaho does not permit to define a custom data source using PDI.
Please, remember to create them manually as described below:
AAAR_AuditTrail is a Analysis data source on AAAR_AuditTrail.xml mondrian schema and AAAR_DataMart JDBC data source.
AAAR_Repository is a Analysis data source on AAAR_Repository.xml mondrian schema and AAAR_DataMart JDBC data source.

I do not know if this has anything to do with it.

Re: AAAR don't extract all data of my custom aspects

fcorti — Wed, 10 May 2017 16:30:12 GMT

Nope, they are not related.
And the dm_custom_metadata seems to be correct.

I think it's time for a debug session. 🙂

If you can give me an access to the Alfresco instance, I would like to try the extraction from my development environment and let you know (of course for free).

If you cannot give an access... you have to debug it by yourself using the Pentaho Data Integration.

Feel free to write me privately for the details (fcorti at gmail dot com).