[jira] [Updated] (CONNECTORS-948) CMIS Connector returns couldn't encrypt null when the query doesn't include cmis:objectId

["Piergiorgio Lucidi (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CONNECTORS-948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Piergiorgio Lucidi updated CONNECTORS-948:
------------------------------------------

    Description: 
Manifold needs to know the objectId of a content to create a reference for it.
This means that executing the following query there is no problem:
{code}
select * from cmis:document
{code}

But trying to execute a similar query:
{code}
select cmis:name from cmis:document
{code}

Manifold returns an error from OpenCMIS that is the following:
{code}
couldn't encrypt: null
{code}

This because the cmis:objectId is not added in the select clause and it is needed to create a reference for this content inside the Manifold database.

The workaround is to add the objectId in the query in the following way as the standard CMIS needs:
{code}
select cmis:objectId, cmis:name from cmis:document 
{code}

The involved code is the following from the CMISRepositoryConnector:
{code}
ItemIterable<QueryResult> results = session.query(cmisQuery, false).getPage(1000000000);
      for (QueryResult result : results) {
        String id = result.getPropertyValueById(PropertyIds.OBJECT_ID);
        activities.addSeedDocument(id);
      }
{code}

Should we solve this issue adding the cmis:objectId parameter if doesn't exist in the select clause of the query?

  was:
Manifold needs to know the objectId of a content to create a reference for it.
This means that executing the following query there is no problem:
{code}
select * from cmis:document
{code}

But trying to execute a similar query:
{code}
select cmis:name from cmis:document
{code}

Manifold returns an error from OpenCMIS that is the following:
{code}
couldn't encrypt: null
{code}

This because the cmis:objectId is not added in the select clause and it is needed to create a reference for this content inside the Manifold database.

The workaround is to add the objectId in the query in the following way as the standard CMIS needs:
{code}
select cmis:objectId, cmis:name from cmis:document 
{code}

Should we solve this issue adding the cmis:objectId parameter if doesn't exist in the select clause of the query?


> CMIS Connector returns couldn't encrypt null when the query doesn't include cmis:objectId
> -----------------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-948
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-948
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: CMIS connector
>    Affects Versions: ManifoldCF 1.6.1
>            Reporter: Piergiorgio Lucidi
>            Assignee: Piergiorgio Lucidi
>            Priority: Minor
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> Manifold needs to know the objectId of a content to create a reference for it.
> This means that executing the following query there is no problem:
> {code}
> select * from cmis:document
> {code}
> But trying to execute a similar query:
> {code}
> select cmis:name from cmis:document
> {code}
> Manifold returns an error from OpenCMIS that is the following:
> {code}
> couldn't encrypt: null
> {code}
> This because the cmis:objectId is not added in the select clause and it is needed to create a reference for this content inside the Manifold database.
> The workaround is to add the objectId in the query in the following way as the standard CMIS needs:
> {code}
> select cmis:objectId, cmis:name from cmis:document 
> {code}
> The involved code is the following from the CMISRepositoryConnector:
> {code}
> ItemIterable<QueryResult> results = session.query(cmisQuery, false).getPage(1000000000);
>       for (QueryResult result : results) {
>         String id = result.getPropertyValueById(PropertyIds.OBJECT_ID);
>         activities.addSeedDocument(id);
>       }
> {code}
> Should we solve this issue adding the cmis:objectId parameter if doesn't exist in the select clause of the query?



--
This message was sent by Atlassian JIRA
(v6.2#6252)