-
Type: Bug
-
Status: Resolved
-
Priority: Blocker
-
Resolution: Fixed
-
Affects Version/s: 8.1-SNAPSHOT
-
Component/s: Core MongoDB, Notifications
-
Epic Link:
Clicking on the Home > Alerts tab shows an error feedback message saying "There was an error communicating with the server, status: 500". This error message is always displayed, whether the user is following documents or not.
Problem doesn't occur on a PostgreSQL or h2 environment.
Cause: Cannot use two wildcards: notif:notifications/*/subscribers/*
Stack trace:
Caused by: org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query: SELECT * FROM Document WHERE ecm:mixinType ='Notifiable' AND notif:notifications/*/subscribers/* = 'user:mlumeau', Cannot use two wildcards: notif:notifications/*/subscribers/* at org.nuxeo.ecm.core.storage.mongodb.MongoDBQueryBuilder.walkAnd(MongoDBQueryBuilder.java:509) at org.nuxeo.ecm.core.storage.mongodb.MongoDBQueryBuilder.walkMultiExpression(MongoDBQueryBuilder.java:490) at org.nuxeo.ecm.core.storage.mongodb.MongoDBQueryBuilder.walkExpression(MongoDBQueryBuilder.java:251) at org.nuxeo.ecm.core.storage.mongodb.MongoDBQueryBuilder.walk(MongoDBQueryBuilder.java:140) at org.nuxeo.ecm.core.storage.mongodb.MongoDBRepository.queryAndFetch(MongoDBRepository.java:709) at org.nuxeo.ecm.core.storage.dbs.DBSSession.doQueryAndFetch(DBSSession.java:1455) at org.nuxeo.ecm.core.storage.dbs.DBSSession.doQuery(DBSSession.java:1383) at org.nuxeo.ecm.core.storage.dbs.DBSSession.query(DBSSession.java:1374) ... at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1137) at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1083) at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1067) at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1047) at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.run(UnrestrictedDocFetcher.java:48) at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:146) at org.nuxeo.ecm.platform.ec.notification.service.UnrestrictedDocFetcher.query(UnrestrictedDocFetcher.java:66) at org.nuxeo.ecm.platform.ec.notification.service.NotificationService.getSubscribedDocuments(NotificationService.java:545) at org.nuxeo.ecm.user.center.notification.UserNotificationActions.fetchSubscriptionsFor(UserNotificationActions.java:83) at org.nuxeo.ecm.user.center.notification.UserNotificationActions.getUserSubscriptions(UserNotificationActions.java:68)