Error Id 24006 Name Reporting Project Change Message Failed
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeOnline20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Project Publish error : Reporting (Project Publish) job fails Project , Project Server > Project Server General Questions and Answers Question 0 Sign in to vote Dear I have a problem with project server 2010, when i publish a project in project professional or from the project web access, the status says that the project was published successfully but then i get an email to notify me that the job fails, i checked the queue jobs and i found a Reporting (Project Publish) job failed with the below error. this is happening for now for 2 project only i tried to back up then restore custom filed (administrative backup/restore) to force the Reporting Database Refresh but this job also fail with two other failed jobs. I read somewhere that the solution is to delete the project and then publish it again but this is not a solution in my case, i need all data related to the timesheet reporting related to these projects and i don't want to lose then. Can someone help me? Error message: General Reporting message processor failed: ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "PWA2010_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='98e0172b-9da3-46c1-ac1a-9c3a631608e0' QueueMessageBody='Project UID='caa73ec9-1688-4fbe-975c-8f22965e763b'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "PWA2010_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'. ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "PWA2010_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='d5b54bb8-a7a5-431e-891b-b5afacd9cd2b' QueueMessageBody='Project UID='caa73ec9-1688-4fbe-975c-8f22965e763b'. Pu
| 1 comment This is one that has been causing me some grief the past couple of weeks, after apply Project Server 2013 April CU (KB2737990) a couple of customers started reporting the following errors intermittently in the queue: GeneralQueueJobFailed (26000) - ReportingProjectPublish.ReportProjectPublishMessageEx. Details: id='26000′ name='GeneralQueueJobFailed' uid='b62dc86f-30cf-e211-9409-00155d11030a' JobUID='2cc0c869-30cf-e211-9409-00155d11030a' ComputerName=… General Reporting message processor failed: ReportingProjectChangeMessageFailed (24006) - Object reference https://social.technet.microsoft.com/Forums/projectserver/en-US/01d5b973-3ed5-4d90-9aeb-08275e8ca29b/project-publish-error-reporting-project-publish-job-fails?forum=projectserver2010general not set to an instance of an object.. Details: id='24006′ name='ReportingProjectChangeMessageFailed' uid='beef9169-30cf-e211-9409-00155d11030a' QueueMessageBody='Project UID='e296653a-30cf-e211-9409-00155d11030a'. PublishType='ProjectPublish" Error='Object reference not set to an instance of an object.'. … The ULS log indicates the source of this one: PWA:, ServiceApp:Project Service Application, User:i:0?.t|liveid|…=, PSI: [RDS] ULS Event: ReportingProjectChangeMessageFailed was associated with http://nearbaseline.com/2013/06/ms-reporting-project-publish-jobs-failed-after-aprilcu/ exception: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Office.Project.DataEdit.Reporting.ReportingData. GetTaskBaselineCoreTimephasedDataSetInternal(BaselineEntity[] baselineEntityArray, Int32 nIntervalLengthMinutes, Boolean enforceMaxRowLimit, Int32& index) at Microsoft.Office.Project.Server.DataAccessLayer. TaskBaselinesTimephasedDataSync.GetTimephasedDataForEntities(IEnumerable`1 entities, Int32 interval, Int32& index) So something is wrong in the baseline, unfortunately turns out to be nothing small! Looks like ANY task with 0 duration causes this failure, yes that’s right any milestone included in the baseline! Microsoft have confirmed this one just today so I certainly won’t be installing AprilCU ever again, however currently no workaround exists, so if like me you are stuck with this then for now take it up with Microsoft as they will hopefully have a fix ASAP, otherwise I’ll update this post when I learn more. HTH, Update 2/10/2013: Thanks Carl Dalton for testing and confirming that an old workaround to a similar issue for 2007 actually fixes this one: http://carl-projectserver.blogspot.com.au/2013/09/issues-update-on-projectserver2013.html Updat
Project Microsoft Project Developer Error in Queue, Reporting (Project Publish) ?? Ask a Question Sign http://www.textndata.com/forums/error-queue-reporting-project-publish-288023.html up for Free 220 Experts currently online. Ask Questions for Free! http://www.busydevelopers.com/article/43748714/ReportingProjectPublish+job+failed Error in Queue, Reporting (Project Publish) ?? - Microsoft Project Developer Hi, I am using Project server 2007, if i try to publish the project through Project proffesitional, the 'status' bar showing "publish job completed successfully". Then i open "Report Database" error id in sql server for verifying "Project Assignment Task" informations, but not updated the informations on the table "MSP_EpmAssignment_UserView" for the ... Results 1 to 6 of 6 LinkBack LinkBack URL About LinkBacks Bookmark & Share Add Thread to del.icio.usTweet this thread Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… error id 24006 Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-21, 01:41 PM #1 Error in Queue, Reporting (Project Publish) ?? Hi, I am using Project server 2007, if i try to publish the project through Project proffesitional, the 'status' bar showing "publish job completed successfully". Then i open "Report Database" in sql server for verifying "Project Assignment Task" informations, but not updated the informations on the table "MSP_EpmAssignment_UserView" for the particular project. Finally i have checked the "Queue Status", found some issues for publishing projects given below.. 1. JOB TYPE: WSS Workspace Create JOB STATUS: Failed But Not Blocking Correlation 2. JOB TYPE: Reporting (Project Publish) JOB STATUS: Waiting to be Processed (Sleeping) Note: Not updaing the Task informations on the RDB for the project. If any one can help me, helpful. Regards, Psk Psk Reply With Quote 05-21, 02:04 PM #2 Re: Error in Queue, Reporting (Project Pu
when publishing my projects to Project Server. Any ideas how to correct this? Your ReportingProjectPublish job failed. Its current state is FailedNotBlocking. It was 0% complete. It entered the queue at 08/20/2010 10:25:45. To get more information about the job failure, please go to Project Web Access. Select Personal Settings from the left menu. Then select My Queued Jobs. The errors returned from the queue are as follows: Error ID: 24006 Error ID: 26000 Detailed error below - send it to the administrator for more detailed troubleshooting.