Unable to see page links in the space sidebar after space import.

Still need help?

The Atlassian Community is here for you.

Ask the community

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 more

Diagnosis

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.

  1. Stop Confluence
  2. Back up the database.
  3. Drop Sequence and table 

    DROP SEQUENCE AO_187CCC_SIDEBAR_LINK_ID_SEQ;
    DROP TABLE AO_187CCC_SIDEBAR_LINK;
  4. Start Confluence

 

Last modified on Mar 17, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.