topic Re: Alfresco 4.2.2 + AAAR Extraction problem in Alfresco Archive

Alfresco 4.2.2 + AAAR Extraction problem

pawelb — Tue, 02 Sep 2014 08:11:16 GMT

Hello everyone!I have tried to parse Alfresco audit logs using AAAR. When I use default, freshly generated AAAR config I get authorization error for /alfresco/cmisatom service (which is good password). Full log attached in extract1.log file.After changing cmisatom url:USE AAAR_DataMart;UPDATE dm_dim

Re: Alfresco 4.2.2 + AAAR Extraction problem

fcorti — Tue, 02 Sep 2014 15:49:03 GMT

Hi Paul,

About the first problem you have had:
I have checked on a Alfresco EE 4.2.2 and the default CMIS url is not changed from the previous versions so the unauthorized message seems to be a authentication problem.
I suggest you to double check the login and password and permits.
In every case, the update you have done it's correct and what you have done, changes the CMIS connection url in all the AAAR connections.
Good job!

About the second problem you have had:
The problem is during the CMIS extraction in a temporary table (stg_cmis_folders_partial).
As you can read, the problem is on the primary key: the UUID of the node.
Seems to be that the CMIS query extracts duplicate nodes… I don't feel like the problem is on the AAAR side (it's only a feeling 🙂 ).

Looking at the log file you sent, I was surprised from the message:
2014/09/02 09:48:23 - Cmis Input modified folder.0 - Cmis Input - Retrieved n.100 results from item n.500 on a total of n.137981 results.
In the default installation settings, the SolR settings should avoid to extract more than 1.000 result and here you have +100K results… this seems to be quite strange.
Probably something has been customized in your Alfresco installation?

Please, let us know how it goes or contact me privately to develop more specific tests.

Thanks.

Re: Alfresco 4.2.2 + AAAR Extraction problem

vikash — Tue, 25 Nov 2014 19:09:00 GMT

Hi ,

when i executed AAAR_Extract.sh ,i am using postgres 9.3 and alfresco 4.2f,pentaho 5.2.0

i m getting
org.pentaho.di.core.exception.KettleStepException:
Unable to get queryfields for SQL:
select
*
from
cmis:folder
where
cmis:lastModificationDate >= TIMESTAMP '2001-01-01T00:00:00.000+00:00'
and (
cmis:lastModificationDate > TIMESTAMP '2001-01-01T00:00:00.000+00:00'
or (
cmis:lastModificationDate = TIMESTAMP '2001-01-01T00:00:00.000+00:00'
and cmis:name >= ''
))
order by
cmis:lastModificationDate asc,
cmis:name asc

Caused by: org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: 10260013

I am using AAR beta version from market place

Re: Alfresco 4.2.2 + AAAR Extraction problem

fcorti — Wed, 26 Nov 2014 08:19:22 GMT

Hi Vikash,

Is it the first run?
The first check I suggest you is that the Alfresco server is reachable from Pentaho.
I suggest you to check the url and settings in the AAAR_DataMart.dm_dim_alfresco table.

We all know that starting from Alfresco 5.0.a several changes has been on the CMIS interface but in the 4.2.f everything should work fine.

I hope this helps you,