Cannot import the repository archive due to report.options.exception.label.already.exists

Scenario

You've exported the repository in one server and want to import it to another server. During the import process you get an error report.options.exception.label.already.exists. What to do?

Solution

This problem happens when your repository has saved different report options (input control values) under the same label. This was possible at some point but was disabled in the newer releases due to this exact problem. If you don't have a lot of report options you can manually check in the server which one is causing the problem and delete or rename it. If you can't find it, try the following:

1. Take a note of the last imported resource. Note what folder it's in. Open the repo archive and navigate to that folder inside the archive.
2. Open .folder.xml. This file lists all the resources that are to be imported and the order they are imported in.
3. Find the resource that was last imported during the step 1. Check out the next resource. Note it's ID
4. Find the resouce inside the folder with the same ID
5. Extract the XML definition, edit it and change the <label> value and zip it back into the archive
6. Alternatively just remove the resource entry from the .folder.xml file and re-create it later.
7. Try until you don't get the error anymore