Issue with EntityLinks in Project Online API
Hello everyone, I'm working with Project Online and trying to retrieve task data via the API. While reviewing the metadata, I noticed that PublishedTasks have a navigation property called EntityLinks, but I couldn't find clear documentation on its purpose or usage. What I Tried I attempted the following API requests: Retrieve EntityLinks for a task: GET https://{sitename}.sharepoint.com/sites/pwa/_api/ProjectServer/Projects(guid'{validProjectId}')/Tasks('{validTaskId}')/EntityLinks Expand EntityLinks within tasks: GET https://{sitename}.sharepoint.com/sites/pwa/_api/ProjectServer/Projects(guid'{validProjectId}')/Tasks?$expand=EntityLinks Observations When the project has tasks, the request fails with: { "odata.error": { "code": "42, Microsoft.ProjectServer.PJClientCallableException", "message": { "lang": "en-US", "value": "PJClientCallableException: GeneralUnhandledException\r\nGeneralUnhandledException\r\nException = System.NotImplementedException: The method or operation is not implemented.\r\n at Microsoft.Office.Project.Server.BusinessLayer.EntityLinks.ThrowIfEntityLinksNotSupported()\r\n at Microsoft.Office.Project.Server.BusinessLayer.EntityLinks.ReadEntityLinksForEntities(Guid[] entityUids)\r\n at Microsoft.Office.Project.Server.Wcf.Implementation.CSOMImpl.<>c__DisplayClass35_0.<ReadEntityLinksForEntities>b__1()\r\n at Microsoft.Office.Project.Server.BusinessObjectMethodInvocation.InvokeBusinessObjectMethod(String methodName, IEnumerable`1 actions)" } } } If the project has no tasks, the request returns an empty response without errors: { "odata.metadata": "https://{sitename}.sharepoint.com/sites/pwa/_api/$metadata#SP.ApiData.PublishedTasks", "value": [ ] } Other navigation properties (e.g., Predecessors) work fine with a similar request. Questions What are EntityLinks, and what do they refer to? How can they be created via the UI in Project Online? Is there a way to retrieve them successfully through the API? I couldn't find references for this error or EntityLinks. Any insights would be greatly appreciated! Thanks in advance!
How to extract the value of RBS in Enterprise Resource in Project Server 2019?
I try to retrieve the value of RBS in Enterprise Resource in Project Server by using C#/ CSOM. Unfortunately, I just got the Resource Name, as for the value of RBS, I always cannot extract any value from this field. Sometimes, the value of RBS is wrong or the same. I shared the code for you to look at and hope the seasoned people can help me to address it or sharing some idea in this. I appreciate your help. Thanks. Explanation: The Enterprise Resources will be extracted by ID. "projectContext" will load specificRes with all Custom Fields. I'm going to retrieve the value of a specific field (RBS) Finally, When I specify to retrieve the value of "RBS", no matter how I change the Resource Id, the value of RBS is the same Is there any idea on this issue? Thanks for everyone's help. var specificRes = projectContext.EnterpriseResources.GetById(new Guid("46914ae8-3c55-488d-a045-4d1a5aaf1e74").ToString()); projectContext.Load(specificRes, r => r.Name, r => r.CustomFields, r => r.CustomFields.IncludeWithDefaultProperties( lu => lu.LookupTable, lu => lu.LookupEntries)); projectContext.ExecuteQuery(); var cusField = specificRes.CustomFields.FirstOrDefault(cf => cf.InternalName == "Custom_000039b78bbe4ceb82c4fa8c0c400284"); projectContext.Load(cusField); projectContext.ExecuteQuery(); Console.WriteLine(cusField.LookupEntries.First().FullValue);
Using Project to plan a resource's work completion dates
Good morning, I've got a single person working on different tasks. The main task is a "background task", representing a set number of working hours every month (the actual amount of work may vary from month to month). In parallel, there are smaller side tasks, with their own given amount of work. What I'm trying to do is to set up the background task (fixed duration) one month at the time so I can manually adjust the work planned on a given month. Then, I'd like Project to automatically place the side tasks so my resource is working at 100% all the time and I get an estimation of the finish date for said side tasks. I already set up the resource calendar to fit reality (36h/week). It's not working as intended despite my resource working only at ~24% on the background task: when I right-click "reschedule to available date", they always move far in future instead of being concurrent with the "background task". Is there a way to resolve this please? NB: I can't manually set the %unit for my ressource on each task, as I have no idea how much work will be allocated to the monthly task and this amount may fluctuate a lot.Issue: Reporting (Project Publish) Failed But Not Blocking Correlation - Project Server 2013
All of a sudden, I am facing an issue where Reporting Database is not updating and all data are not updated in User Views. Why it is happened? Please help. For reference, I am sharing one of the project's Queue Job Error Details below: General Reporting message processor failed: ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='0b185432-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='80b06539-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='acb26539-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='72422640-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='9e442640-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. ReportingProjectChangeMessageFailed (24006) - Column name or number of supplied values does not match table definition.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='94c01147-6ed5-ed11-8151-00505696f030' QueueMessageBody='Project UID='ff33ac2a-6ed5-ed11-8151-00505696f030'. PublishType='ProjectPublish'' Error='Column name or number of supplied values does not match table definition.'. Queue: GeneralQueueJobFailed (26000) - ReportingProjectPublish.ReportProjectPublishMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='95c01147-6ed5-ed11-8151-00505696f030' JobUID='073bac2a-6ed5-ed11-8151-00505696f030' ComputerName='ce6d0330-7acd-453a-8878-707a8ba1971e' GroupType='ReportingProjectPublish' MessageType='ReportProjectPublishMessageEx' MessageId='1' Stage='' CorrelationUID='def0a6a0-a58b-e06d-1971-e97102f3d7a8'. For more details, check the ULS logs on machine ce6d0330-7acd-453a-8878-707a8ba1971e for entries with JobUID 073bac2a-6ed5-ed11-8151-00505696f030.
Referring on previous task's custom field in formula
Hi everybody! I need to set indicators in custom fields that would implement a comparison of the custom field Number1 from the current task with Number1 from the previous task. How can I set a link in a formula to another task? Details: If the finish deviation of task #2 is 5% greater than the finish deviation of task #1, then I need a yellow indicator. My boss wants to see the variance trend, whether it's growing or not. I don't know how to refer to the previous task field in the custom field formula. Thanks!Remaining Duration
Hi, I have a number of Ghant Charts tracking progress through a large contract whereby there are sometimes around 300 Tasks divided between 8 Teams (resources) each Team starting at the same time and working through their stream alongside each other. The unit for each task is days. Every month I am having to manually go in to the charts and count how many remaining days I have on the program before completion. Is there any way of running off some kind of report that will tell me how many remaining days I have on program from a certain date to the completion date? Thanks.
Summarize by Rollup Task and Resource Group
Is there a way to write a report that groups resource groups under top level task and rolls up the summary values? Specifically: List all level two tasks Under each level 2 task, list the resource groups working on any task in that group Values SUM(Cost) and SUM(Actual Cost) The output would look something like this: L2 Task A - R Group X [##] [##] - R Group Y [##] [##] L2 Task B - R Group Y [##] [##] - R Group Z [##] [##] I've been able to group by Resource Group and by L2 Tasks but not both.
