Version: 3.0, Updated on: 01/24/2017
The cube build process in MS Project Server 2003 could fail due to special characters. You can use the following SQL query to look for projects with special characters in their names.
-- MSPS 2013 SQL Query to Find projects with special characters in the name --by: Faisal Masood (www.softvative.com) PMP, CCNA, ITIL, MCSE, MCITP, MCTS, MCSA, MOS, MS select Proj_name, PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB, WPROJ_STS_SUBWEB_NAME FROM pub.msp_projects WHERE (Proj_name LIKE '%.%') OR (Proj_name LIKE '%_%') OR (Proj_name LIKE '%”%') OR (Proj_name LIKE '%/%') OR (Proj_name LIKE '%:%') OR (Proj_name LIKE '%;%') OR (Proj_name LIKE '%|%') OR (Proj_name LIKE '%?%') OR (Proj_name LIKE '%”%') OR (Proj_name LIKE '%<%') OR (Proj_name LIKE '%>%') OR (Proj_name LIKE '%*%') OR (Proj_name LIKE '%#%') OR (Proj_name LIKE '”%') OR (Proj_name LIKE '%”') OR (Proj_name LIKE '’%') OR (Proj_name LIKE '%"') OR (Proj_name LIKE '%&%') order by proj_name
Once you have the list, use the Rename Project tool to rename those projects. Make sure to look for any pending updates. After renaming make sure to publish those projects.
