none
MSPS2013 April CU 2013 - can't publish projects with baseline RRS feed

  • Question

  • Hi!

    After we install the April CU 2013 on MSPS2013 we can't publish some projects with any baseline.

    Error in the queue  the following:


    Position Entry TimeSort ascending Completed Time Project Name Job Type Job State % Complete Owner Error

    N/A 04.06.2013 12:13 04.06.2013 12:14 TestPr1 Reporting (Project Publish) Failed But Not Blocking Correlation 0% User1 Click to view the error details



    • ReportingProjectChangeMessageFailed (24006) - Object reference not set to an instance of an object.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='62ad929d-eecc-e211-9438-6cf04974effb' QueueMessageBody='Project UID='7ed2b700-3775-44e1-b6e7-825d55e0aa6b'. PublishType='ProjectPublish'' Error='Object reference not set to an instance of an object.'. 

    Error in 15Hiv logs the following:

    Medium

    PSI: TaskTimephasedBaselineData: Failed to sync with 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)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.<GetTimephasedDataStreamed>d__1.MoveNext()  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingTaskBaselineTimephasedDataUdtRecord.<ToSqlDataRecords>d__0.MoveNext()  
    at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingProjectDalBase.InsertTaskBaselinesTimephasedData(IEnumerable`1 taskBaselinesTimephasedData)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.SyncTimephasedDataToReporting(), LogLevelManager Warning-ulsID:0x0020E493 has no entities explicitly specified.


    High

    PWA:http://site/PWA, ServiceApp:Project Server Service Application, User:i:0#.w|domain\admin, PSI: [RDS] ReportProjectPublishMessage for project 7ed2b700-3775-44e1-b6e7-825d55e0aa6b failed. Error: 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)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.<GetTimephasedDataStreamed>d__1.MoveNext()  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingTaskBaselineTimephasedDataUdtRecord.<ToSqlDataRecords>d__0.MoveNext()  
    at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingProjectDalBase.InsertTaskBaselinesTimephasedData(IEnumerable`1 taskBaselinesTimephasedData)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.SyncTimephasedDataToReporting()  
    at Microsoft.Office.Project.Server.DataAccessLayer.ReportingProjectDal.UpdateTasksTimephasedData(Guid projectUID, ReportingProjectData projectData, ReportingData timephasedReportingData, Int32 pageSize, String& transferPhase, Action`2 logProjStats)  
    at Microsoft.Office.Project.Server.BusinessLayer.ReportingLayer.ProjectPublishMessageProcessor.SaveProjectTimephaseData(String& transferPhase)  
    at Microsoft.Office.Project.Server.BusinessLayer.ReportingLayer.ProjectPublishMessageProcessor.runRDSTransformation(ReportProjectPublishMessageEx projectChangeMessage). Phase: DeleteTaskBaselineByDay, LogLevelManager Warning-ulsID:0x6174786D has no entities explicitly specified.

    On the advice here:

    http://social.technet.microsoft.com/Forums/en-US/projserv2010setup/thread/109c0708-bdd8-4392-850b-19e121078115

    No we have to fix this issue. Since you have already published all project plan without any issue, before attempting RDB refresh, we may need to re-save each enterprise custom field and look up table. This is another way to perform partial RDb refresh.

    After the advice here

    http://www.datazx.cn/Fv7p5a/xw-US/u7v3ax7otgigax2pu/2q7xs6/9bstbd4s-44j8-fjb4-b4bm-8sdb4tiscsxs23rsdfd.html


    We do Administrative Backup / Restore - Enterprise Custom Fields

    But after process restore the error is:

    Reporting message processor failed:◦ReportingRDBRefreshMessageFailed (24023) - RDB area: Epm, error mode: ContinueOnErrors, lock RDB on errors: False, refresh sleep time: 00:05:00. Details: id='24023' name='ReportingRDBRefreshMessageFailed' uid='cc9a198b-9fcc-e211-9438-6cf04974effb' QueueMessageBody='One of the stages of the Refresh operation failed' Error='RDB area: Epm, error mode: ContinueOnErrors, lock RDB on errors: False, refresh sleep time: 00:05:00'. 

    Any help, please?










    • Edited by Office4 Monday, June 3, 2013 8:34 PM
    Monday, June 3, 2013 8:24 PM

Answers

All replies

  • Helps decision in this post.

    But it does not always work, through time and you need when you change the baseline to run the macro every time.

    http://blogs.msdn.com/b/brismith/archive/2012/05/23/project-server-2007-reporting-project-publish-queue-job-fails-to-complete.aspx




    • Edited by Office4 Thursday, June 6, 2013 8:01 PM
    Thursday, June 6, 2013 12:24 PM
  • This is a known issue. Microsoft is working on it.


    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Tuesday, June 11, 2013 9:02 PM
    Moderator
  • Hey Gary,

    I am experiencing exactly the same issue. And I can clearly resimulate the issue now. We are having some other exceptions as well where timesheet approvers cannot open pending timesheets anymore once that one of these problematic schedules in on the list of timesheet lines. We get an exception telling us this in the ULS log viewer :

    Node Consistency Error: Exception loading Assignment. Uid=xxx

    For looking up the tasks for approval, I think that Project Server is also relying on the reporting database, so is this related ?

    Please keep me informed as well of any news concerning the fix, as this is getting a real issue for our customer. Much appreciated.

    Wednesday, June 12, 2013 5:34 PM
  • June 2013 CU is out http://support.microsoft.com/kb/2817341

    Tanzim Akhtar

    Saturday, June 15, 2013 8:56 AM
  • Hi!

    Unfortunately, after the installation June 2013 CU error with the publish of the project with baseline remains as before.

    Archive Custom Fields/Restore Custom Fields does not help.

    PSI: TaskTimephasedBaselineData: Failed to sync with 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)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.<GetTimephasedDataStreamed>d__1.MoveNext()  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingTaskBaselineTimephasedDataUdtRecord.<ToSqlDataRecords>d__0.MoveNext()  
    at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)  
    at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingProjectDalBase.InsertTaskBaselinesTimephasedData(IEnumerable`1 taskBaselinesTimephasedData)  
    at Microsoft.Office.Project.Server.DataAccessLayer.ContourBasedTimephasedDataSync`2.SyncTimephasedDataToReporting(), LogLevelManager Warning-ulsID:0x0020E493 has no entities explicitly specified.

    Saturday, July 6, 2013 7:01 AM
  • Hi Gary,

    Any update here?

    Thanks

    Tuesday, September 3, 2013 2:08 PM
  • There should be a fix coming in the October CU. The advice in my blog referenced above is also valid for this issue - but as has been noted - it can come back and the macro needs running again.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Tuesday, September 3, 2013 5:46 PM
    Owner
  • Brian,

       Could you post when you have more information about this? Telling customers to remove all their baselines to get the reports to work is not a good story.

    Since the April CU is required to fix a bug in the March PU - does this mean that we should be advising customers to stay on RTM until the October CU?

    Thanks,

       James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Monday, September 16, 2013 5:50 AM
  • Hi James, we have been advising our clients to remain on RTM where possible, hopefully until the October CU. Paul

    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Monday, September 16, 2013 6:44 AM
    Moderator
  • Just as I thought - Thanks Paul.

    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Monday, September 16, 2013 6:47 AM
  • I agree James that telling customers to remove baselines is not a good story - not sure where anyone on this thread or the associated blog posts has mentioned that it is.  I'm certainly very sorry for the inconvenience this bug has caused and that we cannot release a fix any sooner - but if there are fixes in earlier updates that customers require - or they have already loaded updates and are experiencing this issue - then the macro referenced in the blog post is a valid workaround without removing baselines.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Monday, September 16, 2013 1:58 PM
    Owner
  • Brian,

       Thanks for the reply on this issue - appreciate this one must be high on the list. 

    On the same PWA instance where this problem is occurring, the Approvals link shows the Grid with "An unknown error has occurred"

    Looking into the browser traffic shows a HTTP 500 error on calling the statusing webservice.

    Looking into the ULS shows:

    PWA:https://server/PWA, ServiceApp:Project Server Service, User:i:0#.w|domain\user, PSI: System.NullReferenceException: Object reference not set to an instance of an object.   

    at Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusApprovalsQueryInfo.AddAllTimesheets(DataTable& dt, Dictionary`2& timephased, List`1& actualDates)   

    at Microsoft.Office.Project.Server.BusinessLayer.Statusing.StatusApprovalsQueryInfo.TryLoad(LoadApprovalType method, DataTable& dt, Dictionary`2& timephased, List`1& actualDates), LogLevelManager Warning-ulsID:0x6333626E has no entities explicitly specified.

    Could you confirm if you think this is also a symptom of the same underlying problem?

    Thanks,

       James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Tuesday, September 17, 2013 12:51 AM
  • Hi James, that would tend to indicate that a timesheet being pulled into those approvals contains an assignment that is orphaned and has no associated task or project.  Perhaps the resource was unassigned, the task or project deleted.  Usually in cases like this a SQL Profiler trace will help to ascertain exactly what the issue is - but on the face of it I don't see a direct connection to the baseline issue.  I'd open a support incident if you need some help with the analysis - we don't charge if it is a bug - and failing due to a deleted task/project is a bug in my books.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Tuesday, September 17, 2013 2:05 PM
    Owner
  • Hey Brian,

    While waiting for the fix in the October CU, I have tested out your VBA work around. At least I am able to save and publish the project. I can see my update work and cost numbers in the reporting database. Great to see. But... Budget work and cost remains 0 in the reporting database on the baseline records. I don't know if this is related ?

    Thanks for the insights,

    Guy

    Thursday, September 19, 2013 7:29 PM
  • HI Brian

    Is the October CU out yet or is there a tentative date for the same?

    Regards

    Pinki

    Tuesday, October 8, 2013 7:09 PM
  • Hey Pinki,

    No, this one hasn't been released yet. In general, CU's are released by the end of the month, depending of course on the content of fixes of that package. I think it is better to wait for an official announcement, and don't forget to first test it out in a dev or test environment. So, earliest availability in production would be mid nov or even end nov ?

    When having done my own test, I'll try to post my test results here as well.

    Thanks,

    Guy

    Tuesday, October 8, 2013 7:27 PM
  • Thanks Guy

    Regards

    Pinki

    Wednesday, October 9, 2013 7:52 PM
  • Hi

    the october 2013 CU is released.

    http://support.microsoft.com/kb/2817337

    http://support.microsoft.com/kb/2825659

    Regards

    Christoph


    Christoph Muelder | Senior Consultant, MCSE, MCT | SOLVIN information management GmbH, Germany

    • Proposed as answer by James Boman Tuesday, October 15, 2013 11:25 PM
    Saturday, October 12, 2013 11:12 AM
  • Confirmed - October CU fixes the problem.

    Brian - please thank the team for us!

    Cheers,

       James.


    James Boman - http://www.boman.biz Software Consultant for IPMO - http://www.ipmo.com.au

    Tuesday, October 15, 2013 11:24 PM