Workaround for Workspace having larger volume of data:
The intention of this workaround is to simplify the previous workaround and manual effort involved in backup process. The base of this workaround is exactly same as the earlier that is to backup data, delete workspace, re-create workspace and add those data from backup. The requirements of the earlier workaround apply to this workaround also.
However there are certain possibilities where the backup of data and adding them to the newly created workspace may have issues based on the volume of data. So the recommendation is to export all the files on the workspace under Shared Documents to a local folder for importing them in later part after re-creating workspace. And delete those files on Shared Documents of workspace.
In this method, we would use STSADM.EXE tool to export and import the workspace data. To know more about this command, please refer the TechNet article . Below are the steps involving in this workaround.
- This workaround needs a temporary folder to store the exported data as a file from the project workspace. Let’s assume we have created a folder “C:\WSSExportData” on the server where MSPS 2007 is installed and where you would be running STSADM command.
- Once again, go to PWA – Server Settings – Project Workspaces section to copy the URL of the project workspace for usage in this workaround
- Open command window / console by clicking on Start menu – Run and type cmd and click Ok here
- Go to the location C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN in the command window. This is where we have the STSADM.EXE available
- Lets assume the workspace URL is http://myorgweb/sites/projectserver_999 and to export the content of this workspace, run the below command in command window
STSADM –o export –url “http://myorgweb/sites/projectserver_999” –filename “C:\WSSExportData\ExportedWSSSiteData.dat” – includeusersecurity –versions 4
- Once the above command is completed without errors, you will have the SharePoint site data ready as backup for importing later. You can see a log file and data file created under the folder C:\WSSExportData\
- Now, you would need to delete the workspace. To delete this, you can follow the
steps (Delete a workspace, Remove project’s association with workspace and Publish project plan) described in first workaround for Simple / Empty Workspace
- Once you publish the project plan by creating workspace, note down the new workspace URL that has been created and let’s assume it as “http://myorgweb/pwa/EPM_Demo_111_Published”.
Now, we need to use the STSADM.EXE tool to import the data from the file which we exported as earlier. Below will be the command you need to run in the console.
STSADM -0 import –url “http://myorgweb/pwa/EPM_Demo_111_Published” -filename “C:\WSSExportData\ExportedWSSSiteData.dat” -includeusersecurity -updateversions 1
- Once above command is completed without errors, open the project workspace and see if all the earlier data exists under the lists section.
- • You may also see duplicate list items like Announcements, contacts, risks and issues on the workspace. If you face this duplication follow the below steps:
- Open the project workspace and click on the Lists on the left side navigation menu
- Now on the All Site Content page you can see the duplicates of Announcements, Contacts, Risks and Issues
- Now click on the first Announcements link and click on the Site Actions menu on top right corner and choose Edit Page
- Now the web parts will appear in edit mode. Remove the first Announcements web part by choosing Edit option and Delete this web part. Please don’t just click on “X” to delete the web part
- Again within the edit mode of the page delete the second Announcements [1] web part using above method. Follow the same for Contacts, Issues and Risks so that they get deleted.
- Once these steps are completed, have the project plan published to ensure that the error is not appearing
Note: The STSADM command execution may throw many warnings but make sure there are no errors at the summary of execution. In case of errors you may have issues in getting the data imported into the workspace.
| |
