Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 78

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 29th November 2012, 19:05
Joy Conner's Avatar
Joy Conner Joy Conner is offline
Join Date: Aug 2001
Posts: 375
Joy Conner is on a distinguished road
Baan: IVc4 - DB: MS SQL - OS: Windows Server 2008 & 2008 R2
error 100 duplicate record in tdsls050
Baan: Baan IVc4

Recently this error has occurred 3 times in our production environment. While I have modified program tdsls4101 using Qkey, changes are not recent and the latest change does not appear to be the problem.

I have been able to replicate the error in our test environment using this scenario:
1. Create order header.
2. Add sales line, save and exit.
3. Add ship to address on order header, save and exit.

The error is more likely to appear when I complete the process quickly. If there is a delay, the process inserts 2 records into tdsls050, the second record having a different time.

The primary key to table tdsls050 is sales order #, date, & time.

Has anyone had this problem and discovered a solution?

Thanks in advance for your assistance.

Joy Conner
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
zoom to session and find record automatically timb25 Tools Development 11 25th April 2012 23:21
Record Type Value Question GabrielVA Finance, Invoicing and Integration 4 13th September 2010 16:17
I want set NO current record simona AFS/DDC/OLE: Function servers 1 10th October 2009 07:03
How to delete record in scheme? yurong Tools Administration & Installation 4 31st December 2004 00:35

All times are GMT +2. The time now is 20:47.

©2001-2018 - -