Troubleshooting

Project Server 2010 | Removing orphan baseline

English Orphan baseline prevents Project Server 2010 report publishing queue to complete its job. In our environment it was caused by sudden disconnection of either client or SQL server during the publish command. I search arround internet and found following discussion on orphan baseline : http://social.technet.microsoft.com/Forums/projectserver/en-US/f4d638ad-003e-421c-85d9-7ed5d7fda029/project-server-2007-error-24006-reportingprojectchangemessagefailed-insert-statement-conflicted . The solution suggested by that discussion is:``` delete from MSP_TASK_BASELINES where MSP_TASK_BASELINES.PROJ_UID =’[PROJECT UID]’ AND MSP_TASK_BASELINES.TASK_UID NOT IN ( select TASK_UID from dbo.MSP_TASKS where PROJ_UID =’[PROJECT UID]‘ )

SharePoint 2010 | How to delete orphaned Web Application

ArnieRecruiter - Jul 0, 2013 RT @KbWorks: SharePoint 2010 | How to delete orphaned Web Application | Ideas For Free http://t.co/ctxq82RhfB KbWorks - Jul 5, 2013 SharePoint 2010 | How to delete orphaned Web Application | Ideas For Free http://t.co/ctxq82RhfB

SharePoint 2010 | How to delete orphaned Web Application

English Orphaned web application? I don’t know how it happened - but let call the symptoms orphaned web application. Definition Orphaned web application is a situation where you can not performed essential modification to the web application such as adding new content databases, remove extended IIS, delete web application or create new site collection. In short, the web application exists but it doesn’t work and Administrator can not remove it. Symptoms You will experience any of following symptoms: