Sales Line Already exist error during posting.

KYDutchie
Member Posts: 345
Hi all,
I have this strange problem and I do not seem to be able to get this sorted out.
A customer of ours does sporadically get the "Sales Line already exists." error when he posts a sales order.
The sales order posting is completely native. The only modification to the sales order process are a couple of fields added to the Sales Header and Sales line table.
These fields will transfer to the posted documents using the transferfields statement and there is no validation on these fields in the Posted document table.
The strangest thing is that when this error occurs, it could happen a couple of times for the same order, but eventually it will get posted. Even by the same user without leaving the Sales Order form??? But I did notice that when this error occurs, the sales order is not in the archived sales orders. I have not been able to get the error to occur myself and thus not been able to capture it with the debugger.
These are my questions to the forum:
1. could this error be related to Performance issues due to other products on the database server taking up a lot of resources (CRM).
2. can I trace this error without putting to much strain on the server/workstation?
3. has anyone seen this before and could point me in the right direction?
They are using NAV2009SP1, SQL 2005 on a windows 2003 server.
I am reluctant to run tools like the code coverage or SQL profiler because that would influence the performance of the database server and or workstation.
Especially since the error only occurs so sporadically, about once or twice a month.
Thanks in advance for your help,
Willy
I have this strange problem and I do not seem to be able to get this sorted out.
A customer of ours does sporadically get the "Sales Line already exists." error when he posts a sales order.
The sales order posting is completely native. The only modification to the sales order process are a couple of fields added to the Sales Header and Sales line table.
These fields will transfer to the posted documents using the transferfields statement and there is no validation on these fields in the Posted document table.
The strangest thing is that when this error occurs, it could happen a couple of times for the same order, but eventually it will get posted. Even by the same user without leaving the Sales Order form??? But I did notice that when this error occurs, the sales order is not in the archived sales orders. I have not been able to get the error to occur myself and thus not been able to capture it with the debugger.
These are my questions to the forum:
1. could this error be related to Performance issues due to other products on the database server taking up a lot of resources (CRM).
2. can I trace this error without putting to much strain on the server/workstation?
3. has anyone seen this before and could point me in the right direction?
They are using NAV2009SP1, SQL 2005 on a windows 2003 server.
I am reluctant to run tools like the code coverage or SQL profiler because that would influence the performance of the database server and or workstation.
Especially since the error only occurs so sporadically, about once or twice a month.
Thanks in advance for your help,
Willy
Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.
0
Comments
-
I recommend you to create same order using copy document function and find if you can recreate the issue. I will also check if there are any modifications made to ArchiveManagement because this is the codeunit being called if they are using archiving.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