Unable to view newly imported space in Confluence server.

[Austin Wagner]

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. 

[Suren Raj]

Hi, Austin.

Can you please rebuild the index from scratch and rebuild the Ancestor Table and check if the issue still persists?

Cheers
Suren

[Austin Wagner]

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

[Suren Raj]

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 = '<SPACEKEY>';

Cheers

Suren Raj

[Austin Wagner]

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,