AnsweredAssumed Answered

Problem with selecting data before aspect applied to any file

Question asked by pogoma on Feb 24, 2014
Latest reply on Feb 25, 2014 by pogoma
I have problem when trying to execute CMIS query like this:
SELECT * FROM namespace:aspectName WHERE namespace:lastUpdate<=1392983610113  ORDER BY namespace:lastUpdate ASC

before aspect 'aspectName' is applied to any document. Result should be the empty set but Alfresco is throwing exception:

org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException:
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end of input
  Position: 983
### The error may involve alfresco.metadata.query.select_byDynamicQuery-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end of input
  Position: 983
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at end of input
  Position: 983

The aspect description is added to db after aspect is applied to first document. Is there any simple way to force Alfresco to add this data on custom model loading?

Outcomes