Unable to see page links in the space sidebar after space import.
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Summary
Problem
After importing a space into Confluence, the space sidebar doesn't render anymore the page linkes.
The following appears in the atlassian-confluence.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
2017-01-23 14:24:00,853 ERROR [http-nio-8-exec-16] [plugin.descriptor.web.ConfluenceWebInterfaceManager] getHtml Failed to render web panel: com.atlassian.plugin.web.descriptors.DefaultWebPanelModuleDescriptor$ContextAwareWebPanel@3a18a3
-- url: /display/TS/Test+Space+Home | page: 24314200 | traceId: 1195198cdd88e392 | userName: admin | referer: http://localhost:8090/spacedirectory/view.action | action: viewpage
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
- minor version:1
- major version:12
Driver:
- name:Oracle JDBC driver
- version:12.1.0.2.0
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFLUENCE"."AO_187CCC_SIDEBAR_LINK"."ID")
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:88)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:261)
at sun.reflect.GeneratedMethodAccessor2070.invoke(Unknown Source)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFLUENCE"."AO_187CCC_SIDEBAR_LINK"."ID")
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:86)
... 637 moreDiagnosis
Environment
Confluence running on Oracle database.
Cause
The sequence of the related ActiveObjects table, AO_187CCC_SIDEBAR_LINK, is defective.
Solution
Resolution
The resolution suggests dropping the table sequence and the table, and then restarting Confluence. Everytime Confluence is restarted, the AO tables are recreated. This will ensure the table is recreated with the correct sequence.
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Stop Confluence
Back up the database.
Drop Sequence and table
1 2DROP SEQUENCE AO_187CCC_SIDEBAR_LINK_ID_SEQ; DROP TABLE AO_187CCC_SIDEBAR_LINK;Start Confluence
Was this helpful?