topic CMIS Queries via DotCMIS not working anymore on V5 in Alfresco Archive

CMIS Queries via DotCMIS not working anymore on V5

fka — Thu, 12 Mar 2015 10:49:54 GMT

I run CMIS Query via dotCMIS 0.6It used to work perfectly with Alfresco 4.x but it generate an exception with 5.0I query against : http://SERVERORT/alfresco/api/-default-/public/cmis/versions/1.0/atomClient side message : 2015-03-12 10:44:18.8445 ERROR at DotCMIS.Binding.AtomPub.AbstractAtomPub

Re: CMIS Queries via DotCMIS not working anymore on V5

afaust — Thu, 12 Mar 2015 11:26:06 GMT

Hello,

what was the query? The error states that the query was deemed invalid by the OpenCMIS server implementation.

Regards
Axel

Re: CMIS Queries via DotCMIS not working anymore on V5

fka — Thu, 12 Mar 2015 11:41:00 GMT

Hi

The query is "SELECT * FROM cmis:folder as A WHERE IN_FOLDER(A,'workspace://SpacesStore/670ae6e9-57d2-495a-b713-5d30ac7e231b') AND A.cmis:name = 'documentLibrary'"

It does work with CMISWorkbench though but not DotCMIS.
The guys at Apache told me it was not on their side …
Same query worked perfectly on Alfresco v4

Re: CMIS Queries via DotCMIS not working anymore on V5

fka — Fri, 13 Mar 2015 09:37:31 GMT

Did some more digging :

With DotCMIS :
    Simple queries like 'SELECT * FROM cmis:Folder' work on Alf4 and 5
   More complex queries, like the one above, work on Alf4 but not Alf5

With CMISWorkbench
   Both queries work on Alf5

I guess there is something in the communication between DotCMIS and Alfresco 5 going wrong for complex queries
Every other combination of tools / Alf version seems to work

Re: CMIS Queries via DotCMIS not working anymore on V5

fka — Fri, 13 Mar 2015 10:54:37 GMT

There may be an issue with our Alfresco Instance.
I'll make some more checks.