Unable to view newly imported space in Confluence server.

Question

I'm following this process to create a copy of a confluence space:

1. Export space xml

2. Follow this guide to update the space key (https://confluence.atlassian.com/confkb/how-to-copy-or-rename-a-space-in-confluence-169578.html)

3. Upload the updated xml file.

The import is successful, but I'm unable to find the space in the space directory.

I can see in the space permissions section, under confluence administration, that the space has been created.

When I click manage permissions, I'm directed to a new page with a Page Not Found Error.

This leads me to believe that its a permissions issue but the space is a copy of a current space which I have administrative permissions to.

I've tried adding a new group to the space before import with no avail.

Any insight would be great appreciated.

Austin Wagner_z9yglz · Answer

Hi Suren,

Here is the output from the query. Apologies for the format, pasting the text file as a comment was too difficult to read. I've replaced the user names with users 1, 2, and 3. All 3 users are administrators.

Thanks again for your help,

Suren Raj · Answer

Hi, Austin. We would like to check the space permission, do you mind running the following query on your database and provide us with the output: SELECT sp.permid, sp.permtype, s.spacekey, s.spacename, sp.permgroupname, um.lower_username FROM SPACEPERMISSIONS sp JOIN SPACES s ON sp.spaceid = s.spaceid LEFT JOIN user_mapping um ON sp.permusername = um.user_key WHERE s.spacekey = ''; Cheers Suren Raj

Austin Wagner_z9yglz · Answer

Hi Suren,

Thank you for the reply! I rebuilt the Ancestor Table and rebuilt the index from scratch with no success. The imported space is still visible under space permissions but inaccessible.

Thanks