Dynamics Community Forum Thread Details

I have a plugin that is trying to use pss to create tasks. It is telling me that columns are missing to create it but in my trace log i clearly show that those columns exist in the payload. Any ideas why I am seeing this error?

=== OrderLineToTaskPlugin Started ===
Message=Create, Entity=salesorderdetail, Depth=1, CorrelationId=8380c994-d78c-4ff8-a6ce-ab94f77e81fb
→ HandleCreate
[Create] Start
OrderLine target Id=f599fe2d-430c-f111-8406-000d3ab11fcc, AttrCount=54
OrderLine retrieved AttrCount=6
Project found: 836dc343-d205-f111-8407-7ced8d44ddd4
Existing tasks for line f599fe2d-430c-f111-8406-000d3ab11fcc: 0
MaterialCode: check order line…
MaterialCode: from order line = 'test'
MaterialCode=test
SmallMod? Machine=False, Syntegon=False, Value=0.0000000000, Threshold=25000 → False
IsSmallMod=False
Material 'test' not found in product by productnumber or name.
Could not resolve material 'test' to a lookup record. Fallback to New Equipment.
Find template by type=1
Template tasks retrieved: 3
Template tasks count=3
Team seed: extract nrd_bookableresource from template tasks
Team seed: found 1 unique resource(s)
Team seed: already on team=1
Team seed: added=0
Project 'Test Oder Test Material 1', CreatedOn=2/9/2026 4:13:27 PM, Start=2/9/2026 3:00:00 PM, IsTemplate=False
Date base: ProjectCreated=2/9/2026 4:13:27 PM, TemplateProjectStart=2/6/2026 3:00:00 PM

PSS: Creating Operation Set V1 for project 836dc343-d205-f111-8407-7ced8d44ddd4, order line f599fe2d-430c-f111-8406-000d3ab11fcc
PSS: Operation Set V1 created Id=127fea35-430c-f111-8407-6045bddf1475

[1/3] Create from templateTask=433740c7-3c9e-4239-95db-0ff272c0229d, Subject='test task 3'
Copied 1 whitelisted attrs from template
Start → Template=2/10/2026 12:00:00 AM, Offset=3.38d, New=2/13/2026 1:13:27 AM
Finish → Template=2/20/2026 12:00:00 AM, Offset=13.38d, New=2/23/2026 1:13:27 AM
Effort Hours=16
Order Number=ORD-15701-F0T6J2
SAP Material=test
Activity Type copied from template
Bucket matched by name='Bucket 1' → 5e130514-62aa-451c-a182-998627361f66
EffortCompleted=0, EAC=16
Required field snapshot before PSS:
ProjectPresent=True, Value=836dc343-d205-f111-8407-7ced8d44ddd4;
BucketPresent=True, Value=5e130514-62aa-451c-a182-998627361f66;
SubjectPresent=True, Value=test task 3;
DashboardItemPresent=True, Value=False;
LinkStatusPresent=True, Value=192350000
Task attributes before PSS:
msdyn_project,
nrd_orderline,
msdyn_subject,
nrd_dashboarditem,
msdyn_linkstatus,
nrd_activitytype,
msdyn_scheduledstart,
msdyn_scheduledend,
msdyn_effort,
nrd_ordernumber,
nrd_orderlinesapmaterial,
msdyn_projectbucket,
msdyn_effortcompleted,
msdyn_effortestimateatcomplete
Error creating task from template 433740c7-3c9e-4239-95db-0ff272c0229d:
ScheduleAPI-EV-0003:127fea35-430c-f111-8407-6045bddf1475:
The table msdyn_projecttask does not contain all the required columns.
The required columns are msdyn_LinkStatus, msdyn_project, msdyn_projectbucket, msdyn_subject, nrd_dashboarditem.

[2/3] Create from templateTask=41af42f9-978d-43a7-8533-51e6825562f7, Subject='test task 2'
Copied 1 whitelisted attrs from template
Start → Template=2/13/2026 12:00:00 AM, Offset=6.38d, New=2/16/2026 1:13:27 AM
Finish → Template=3/13/2026 12:00:00 AM, Offset=34.38d, New=3/16/2026 1:13:27 AM
Effort Hours=60
Order Number=ORD-15701-F0T6J2
SAP Material=test
Activity Type copied from template
Bucket matched by name='Bucket 1' → 5e130514-62aa-451c-a182-998627361f66
EffortCompleted=0, EAC=60
Required field snapshot before PSS:
ProjectPresent=True, Value=836dc343-d205-f111-8407-7ced8d44ddd4;
BucketPresent=True, Value=5e130514-62aa-451c-a182-998627361f66;
SubjectPresent=True, Value=test task 2;
DashboardItemPresent=True, Value=False;
LinkStatusPresent=True, Value=192350000
Task attributes before PSS:
msdyn_project,
nrd_orderline,
msdyn_subject,
nrd_dashboarditem,
msdyn_linkstatus,
nrd_activitytype,
msdyn_scheduledstart,
msdyn_scheduledend,
msdyn_effort,
nrd_ordernumber,
nrd_orderlinesapmaterial,
msdyn_projectbucket,
msdyn_effortcompleted,
msdyn_effortestimateatcomplete
Error creating task from template 41af42f9-978d-43a7-8533-51e6825562f7:
ScheduleAPI-EV-0003:127fea35-430c-f111-8407-6045bddf1475:
The table msdyn_projecttask does not contain all the required columns.
The required columns are msdyn_LinkStatus, msdyn_project, msdyn_projectbucket, msdyn_subject, nrd_dashboarditem.

[3/3] Create from templateTask=1ad59f60-edb2-44eb-90fc-68f91c89b414, Subject='test task 1'
Copied 1 whitelisted attrs from template
Start → Template=2/16/2026 12:00:00 AM, Offset=9.38d, New=2/19/2026 1:13:27 AM
Finish → Template=2/20/2026 12:00:00 AM, Offset=13.38d, New=2/23/2026 1:13:27 AM
Effort Hours=20
Order Number=ORD-15701-F0T6J2
SAP Material=test
Activity Type copied from template
Bucket matched by name='Bucket 1' → 5e130514-62aa-451c-a182-998627361f66
EffortCompleted=0, EAC=20
Required field snapshot before PSS:
ProjectPresent=True, Value=836dc343-d205-f111-8407-7ced8d44ddd4;
BucketPresent=True, Value=5e130514-62aa-451c-a182-998627361f66;
SubjectPresent=True, Value=test task 1;
DashboardItemPresent=True, Value=False;
LinkStatusPresent=True, Value=192350000
Task attributes before PSS:
msdyn_project,
nrd_orderline,
msdyn_subject,
nrd_dashboarditem,
msdyn_linkstatus,
nrd_activitytype,
msdyn_scheduledstart,
msdyn_scheduledend,
msdyn_effort,
nrd_ordernumber,
nrd_orderlinesapmaterial,
msdyn_projectbucket,
msdyn_effortcompleted,
msdyn_effortestimateatcomplete
Error creating task from template 1ad59f60-edb2-44eb-90fc-68f91c89b414:
ScheduleAPI-EV-0003:127fea35-430c-f111-8407-6045bddf1475:
The table msdyn_projecttask does not contain all the required columns.
The required columns are msdyn_LinkStatus, msdyn_project, msdyn_projectbucket, msdyn_subject, nrd_dashboarditem.

PSS: Executing Operation Set V1 127fea35-430c-f111-8407-6045bddf1475
ERROR: OperationSet is empty
at Microsoft.CDSRuntime.SandboxWorker.SandboxCallbackService.<>c__DisplayClass16_1.<ExecuteStreamingCallBack>b__1(ExecuteRequest response)
at Microsoft.CDSRuntime.SandboxWorker.SandboxCallbackService.GrpcClientSendAndReceive(ExecuteResponse executeResponse, Func`2 isTerminalResponse)
at Microsoft.CDSRuntime.SandboxWorker.SandboxCallbackService.<>c__DisplayClass16_0.<ExecuteStreamingCallBack>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)
at Microsoft.CDSRuntime.SandboxWorker.SandboxCallbackService.ExecuteStreamingCallBack(Fun`2 callback, Func`2 isTerminalChunk, Func`2 HandleClientException)
at Microsoft.CDSRuntime.SandboxWorker.SandboxOrganizationService.Execute(String operation, ByteString serializedRequest, Assembly proxyTypes, Object traceSettings)
at Microsoft.CDSRuntime.SandboxWorker.SandboxOrganizationServiceWrapper.<>c__DisplayClass23_0.<ExecuteInternal>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Fun`1 func, IEnumerable`1 additionalCustomProperties)
at Microsoft.CDSRuntime.SandboxWorker.SandboxOrganizationServiceWrapper.ExecuteInternal(OrganizationRequest request)
at NRD.Plugins.OrderTableRecordChange.OrderLineToTaskPlugin.ExecuteOperationSet(IOrganizationService service, String opSetId, ITracingService tracing)
at NRD.Plugins.OrderTableRecordChange.OrderLineToTaskPlugin.CreateTasksFromTemplatesWithDates(IOrganizationService service, Entity orderLine, Entity targetProject, Entity templateProject, EntityCollection templateTasks, ITracingService tracing)
at NRD.Plugins.OrderTableRecordChange.OrderLineToTaskPlugin.HandleCreate(IOrganizationService service, IPluginExecutionContext context, ITracingService tracing)
at NRD.Plugins.OrderTableRecordChange.OrderLineToTaskPlugin.Execute(IServiceProvider serviceProvider)

Categories:

Dynamics 365 general