Planning Assignment Error
manuelgruber100
Member Posts: 2
Hello,
For our customers system we have two different servers where the specific services are running.
Specifically, it deals with the problem that a service on server A, which has activated the TaskScheduler and is only responsible for the job queue, has an error in combination with a service on server B, which is only responsible for web services for the web store.
This is a snippet from the server responsing with the errors:
It's important to know, that both Services on both Server have most of their interaction with SalesHeader and SalesLine.
We've already invested lots of time with analyzing SQL Server Management Studio and therefore we also introduced some deadlock monitoring.
This is one of the resutls that is corresponding to the above error message:
<process-list>
<process id="process25ca92784e8" taskpriority="0" logused="55308" waitresource="KEY: 9:72057602553151488 (f99bd892dd02)" waittime="7207" ownerId="1205052036" transactionname="user_transaction" lasttranstarted="2025-04-23T10:48:53.620" XDES="0x26dc4808420" lockMode="U" schedulerid="6" kpid="1872" status="suspended" spid="86" sbid="6" ecid="0" priority="0" trancount="1" lastbatchstarted="2025-04-23T10:48:53.887" lastbatchcompleted="2025-04-23T10:48:53.867" lastattention="2025-04-23T10:38:12.870" clientapp="Microsoft Dynamics 365 Business Central Server" hostname="ServiceA" hostpid="14668" loginname="ABC" isolationlevel="repeatable read (3)" xactid="1205052036" currentdb="9" currentdbname="bcdb" lockTimeout="10000" clientoption1="671156320" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="98" stmtend="1294" sqlhandle="0x02000000ba79d406f1e663519554bc629bd010cdb0976a9f0000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 nvarchar(20),@1 nvarchar(10),@2 nvarchar(10))SELECT "99000850"."timestamp","99000850"."Item No_","99000850"."Variant Code","99000850"."Location Code","99000850"."Latest Date","99000850"."Inactive","99000850"."Action Msg_ Response Planning","99000850"."Net Change Planning","99000850"."$systemId","99000850"."$systemCreatedAt","99000850"."$systemCreatedBy","99000850"."$systemModifiedAt","99000850"."$systemModifiedBy" FROM "bcdb".dbo."Example$Planning Assignment$437dbf0e-84ff-417a-965d-ed2bb9650972" "99000850" WITH(UPDLOCK) WHERE ("99000850"."Item No_"=@0 AND "99000850"."Variant Code"=@1 AND "99000850"."Location Code"=@2) </inputbuf>
</process>
<process id="process25ca9251848" taskpriority="0" logused="693244" waitresource="KEY: 9:72057602553151488 (ee793a78de78)" waittime="3438" ownerId="1205051893" transactionname="user_transaction" lasttranstarted="2025-04-23T10:48:53.277" XDES="0x27ce2c80420" lockMode="U" schedulerid="6" kpid="8944" status="suspended" spid="68" sbid="72" ecid="0" priority="0" trancount="1" lastbatchstarted="2025-04-23T10:48:57.657" lastbatchcompleted="2025-04-23T10:48:57.657" lastattention="2025-04-23T10:48:57.600" clientapp="Microsoft Dynamics 365 Business Central Server" hostname="ServiceB" hostpid="5580" loginname="ABC" isolationlevel="repeatable read (3)" xactid="1205051893" currentdb="9" currentdbname="bcdb" lockTimeout="1000000000" clientoption1="671156320" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="98" stmtend="1294" sqlhandle="0x02000000ba79d406f1e663519554bc629bd010cdb0976a9f0000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 nvarchar(20),@1 nvarchar(10),@2 nvarchar(10))SELECT "99000850"."timestamp","99000850"."Item No_","99000850"."Variant Code","99000850"."Location Code","99000850"."Latest Date","99000850"."Inactive","99000850"."Action Msg_ Response Planning","99000850"."Net Change Planning","99000850"."$systemId","99000850"."$systemCreatedAt","99000850"."$systemCreatedBy","99000850"."$systemModifiedAt","99000850"."$systemModifiedBy" FROM "bcdb".dbo."Example $Planning Assignment$437dbf0e-84ff-417a-965d-ed2bb9650972" "99000850" WITH(UPDLOCK) WHERE ("99000850"."Item No_"=@0 AND "99000850"."Variant Code"=@1 AND "99000850"."Location Code"=@2) </inputbuf>
</process>
</process-list>
How can we avoid this error message? Why does it always interact with the Planning Assignment table? Is there any way to stop this?
thx
For our customers system we have two different servers where the specific services are running.
Specifically, it deals with the problem that a service on server A, which has activated the TaskScheduler and is only responsible for the job queue, has an error in combination with a service on server B, which is only responsible for web services for the web store.
This is a snippet from the server responsing with the errors:
It's important to know, that both Services on both Server have most of their interaction with SalesHeader and SalesLine.
We've already invested lots of time with analyzing SQL Server Management Studio and therefore we also introduced some deadlock monitoring.
This is one of the resutls that is corresponding to the above error message:
<process-list>
<process id="process25ca92784e8" taskpriority="0" logused="55308" waitresource="KEY: 9:72057602553151488 (f99bd892dd02)" waittime="7207" ownerId="1205052036" transactionname="user_transaction" lasttranstarted="2025-04-23T10:48:53.620" XDES="0x26dc4808420" lockMode="U" schedulerid="6" kpid="1872" status="suspended" spid="86" sbid="6" ecid="0" priority="0" trancount="1" lastbatchstarted="2025-04-23T10:48:53.887" lastbatchcompleted="2025-04-23T10:48:53.867" lastattention="2025-04-23T10:38:12.870" clientapp="Microsoft Dynamics 365 Business Central Server" hostname="ServiceA" hostpid="14668" loginname="ABC" isolationlevel="repeatable read (3)" xactid="1205052036" currentdb="9" currentdbname="bcdb" lockTimeout="10000" clientoption1="671156320" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="98" stmtend="1294" sqlhandle="0x02000000ba79d406f1e663519554bc629bd010cdb0976a9f0000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 nvarchar(20),@1 nvarchar(10),@2 nvarchar(10))SELECT "99000850"."timestamp","99000850"."Item No_","99000850"."Variant Code","99000850"."Location Code","99000850"."Latest Date","99000850"."Inactive","99000850"."Action Msg_ Response Planning","99000850"."Net Change Planning","99000850"."$systemId","99000850"."$systemCreatedAt","99000850"."$systemCreatedBy","99000850"."$systemModifiedAt","99000850"."$systemModifiedBy" FROM "bcdb".dbo."Example$Planning Assignment$437dbf0e-84ff-417a-965d-ed2bb9650972" "99000850" WITH(UPDLOCK) WHERE ("99000850"."Item No_"=@0 AND "99000850"."Variant Code"=@1 AND "99000850"."Location Code"=@2) </inputbuf>
</process>
<process id="process25ca9251848" taskpriority="0" logused="693244" waitresource="KEY: 9:72057602553151488 (ee793a78de78)" waittime="3438" ownerId="1205051893" transactionname="user_transaction" lasttranstarted="2025-04-23T10:48:53.277" XDES="0x27ce2c80420" lockMode="U" schedulerid="6" kpid="8944" status="suspended" spid="68" sbid="72" ecid="0" priority="0" trancount="1" lastbatchstarted="2025-04-23T10:48:57.657" lastbatchcompleted="2025-04-23T10:48:57.657" lastattention="2025-04-23T10:48:57.600" clientapp="Microsoft Dynamics 365 Business Central Server" hostname="ServiceB" hostpid="5580" loginname="ABC" isolationlevel="repeatable read (3)" xactid="1205051893" currentdb="9" currentdbname="bcdb" lockTimeout="1000000000" clientoption1="671156320" clientoption2="128056">
<executionStack>
<frame procname="adhoc" line="1" stmtstart="98" stmtend="1294" sqlhandle="0x02000000ba79d406f1e663519554bc629bd010cdb0976a9f0000000000000000000000000000000000000000">
unknown </frame>
</executionStack>
<inputbuf>
(@0 nvarchar(20),@1 nvarchar(10),@2 nvarchar(10))SELECT "99000850"."timestamp","99000850"."Item No_","99000850"."Variant Code","99000850"."Location Code","99000850"."Latest Date","99000850"."Inactive","99000850"."Action Msg_ Response Planning","99000850"."Net Change Planning","99000850"."$systemId","99000850"."$systemCreatedAt","99000850"."$systemCreatedBy","99000850"."$systemModifiedAt","99000850"."$systemModifiedBy" FROM "bcdb".dbo."Example $Planning Assignment$437dbf0e-84ff-417a-965d-ed2bb9650972" "99000850" WITH(UPDLOCK) WHERE ("99000850"."Item No_"=@0 AND "99000850"."Variant Code"=@1 AND "99000850"."Location Code"=@2) </inputbuf>
</process>
</process-list>
How can we avoid this error message? Why does it always interact with the Planning Assignment table? Is there any way to stop this?
thx
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions