Unable to see page links in the space sidebar after space import.
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
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
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.
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 performing any modifications to the database. 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
DROP SEQUENCE AO_187CCC_SIDEBAR_LINK_ID_SEQ; DROP TABLE AO_187CCC_SIDEBAR_LINK;- Start Confluence