|
Home > Archive > Commerce Server General > February 2005 > Unexpected duplicate in LINENUMBER_COLUMN
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unexpected duplicate in LINENUMBER_COLUMN
|
|
| GFergo 2005-01-27, 5:50 pm |
| Hi,
Our site has been running on Microsoft Commerce Server 2000 for over
four years. Once or twice in the past we have seen this error:
Unexpected duplicate in LINENUMBER_COLUMN
Lately, however, one customer is experiencing this error on a regular
basis.
Has anyone else ever seen it? Any idea what causes it? More
importantly, any idea how to fix it?
Thanks all!!
| |
| Yan-Hong Huang[MSFT] 2005-01-28, 5:49 pm |
| Hi GFergo,
When the same user is logged in twice into CS2000 there is the possibility
that an identical lineitem_id is entered more than one into the
BasketLineItems table. This brakes (Error: CS_Req: Unexpected Duplicate in
LINENUMBER_COLUMN was not handled) CS2000 the LoadBasket Method the
OrderGroup object. We know that a user should not login twice but in large
organizations it could be possible that a user id get shared. In fact, the
generation of the lineitem_id should be made transactional so that in no
case a duplicate id gets generated.
So please check with your customer to see whether his issue fits into this
area. Currently Order group result goes from 70+ operations/sec to 120+
operations/sec. So the possibility of this issue is quite low.
Thanks very much.
Best regards,
Yanhong Huang
Microsoft Community Support
Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| Yan-Hong Huang[MSFT] 2005-02-02, 7:47 am |
| Hi GFergo,
How is everything going? If you have any more concerns on the issue, please
feel free to post here and we will follow up. Thanks very much.
Best regards,
Yanhong Huang
Microsoft Community Support
Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|