Invocation of method 'getSpaceNotificationsForUser' error when clicking on 'Watch'
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When a particular user clicks 'Watch' in any page it fails with the following stack trace:
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getSpaceNotificationsForUser' in class com.atlassian.confluence.user.actions.EditNotificationsAction threw exception org.springframework.orm.hibernate.HibernateObjectRetrievalFailureException: No row with the given identifier exists: 4456508, of class: com.atlassian.confluence.pages.AbstractPage; nested exception is net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: 4456508, of class: com.atlassian.confluence.pages.AbstractPage at /users/editnotifications.vm[line 32, column 68] at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)
Diagnosis
Verify that the user is watching a page with the ID mentioned in the stack trace:
SELECT * FROM NOTIFICATIONS WHERE pageid = 4456508;This should return a row. Now, check if there is a page with the ID mentioned in the stack trace.
SELECT * FROM CONTENT where contentid = 4456508;If it returns no row, see below.
Cause
When a user tries to watch a page, Confluence verifies the pages that the user has already watched. In this case, the user is watching an invalid page with ID 4456508, hence, it returns the stack trace.
Resolution
Remove the invalid watch from the database:
DELETE FROM NOTIFICATIONS WHERE pageid = 4456508;