Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 325 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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.
found
We've already invested lots of time with analyzing und 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 "biohof".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 "biohof".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.
found
We've already invested lots of time with analyzing und 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 "biohof".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 "biohof".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