Error occurred during template rendering after migrating from confluence server v8.0.4 to v8.5.3

[Chun Kang]

After upgrading to 8.5.3 from 8.0.4, I can't use confluence server at all.

Blow is the operation environment for Confluence Server 8.5.3 - it worked very well on 8.0.4

• OS: Centos 7
• Database: PostgreSQL 14.10

1) Expected Result:

The website based on Confluence 8.5.3 standalone shows data normally with no error message - The data is upgraded/migrated from Confluence 8.0.4 standalone server.

2) It shows error message on the Chrome/Edge Browser as below

---

Error occurred during template rendering. Contact your administrator for assistance.

---

To be clear, the site is now based on the default template. No customization.

3) I tried folllowing two approaches, but the result is always the same 

- Upgrade from 8.0.4 to 8.5.3

- Install new based on 8.5.3 and import data that created in 8.0.4

4) Following errors are observerd in the atlassian-confluence.log 

---

Caused by: com.atlassian.cache.CacheException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2

...
Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
2023-11-23 11:01:48,401 ERROR [http-nio-8090-exec-2]

...

[confluence.util.profiling.ConfluenceSitemeshDecorator] renderToResponse Error occurred rendering template: /decorators/main.vmd
-- url: / | userName: anonymous | traceId: 6b13fe86fd1e7166

...
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'isUsesCustomLogo' in class

...

com.atlassian.confluence.plugins.lookandfeel.SiteLogoVelocityHelper threw exception

...

com.atlassian.cache.CacheException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at /decorators/includes/common-header.vm[line 23, column 22]

...
Caused by: com.atlassian.cache.CacheException: org.hibernate.NonUniqueResultException: query did not return a unique result: 2

....
Caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2

---

Now I rollbacked to v8.0.4 again to continue operating my wiki based on confluence.

5) Others

You can see the detailed logs and captured screen at  https://qsok.com/display/KB/Error+occurred+during+template+rendering+on+confluence+8.5.3

[Chun Kang]

This is resolved by leaving only one unique content record, whose type is GLOBALDESCRIPTION. You can see the reference link at link