Page 1 of 1
Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Wed Jul 01, 2009 2:00 am
by flattmatt
Searched forever, can't find this problem/solution
I try to view somebody's wishlist via ViewWishlist.aspx
All fine, except my header, footer, leftnav, etc are all screwed up to default.
If I choose the "Edit" dropdown on the page to change the layout (from "view"), It crashes with this error:
Code: Select all
Server Error in '/' Application.
Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId'
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ArgumentException: Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId']
System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) +2904181
System.Collections.Hashtable.Add(Object key, Object value) +11
System.Collections.Specialized.OrderedDictionary.Add(Object key, Object value) +49
System.Web.UI.WebControls.DataKey.LoadViewState(Object state) +88
System.Web.UI.WebControls.DataKey.System.Web.UI.IStateManager.LoadViewState(Object state) +4
System.Web.UI.WebControls.GridView.LoadDataKeysState(Object state) +310
System.Web.UI.WebControls.GridView.LoadControlState(Object savedState) +450
System.Web.UI.Control.LoadControlStateInternal(Object savedStateObj) +118
System.Web.UI.Page.LoadAllState() +212
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1092
Anybody else seen this? I don't see how I could be the only one....
Thanks in advance
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Wed Jul 01, 2009 6:29 am
by mazhar
What is your application version? You can found this information under Administration -> Help -> About AbleCommerce
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Tue Jul 07, 2009 11:35 am
by flattmatt
Heres all the information:
PLATFORM: ASP.NET
VERSION: 7.0.3
BUILD: 12458
MSSQL v2000
AC SCHEMA v2000
AjaxControlToolkit: 1.0.20229.20821
CommerceBuilder: 7.3.12065.0
CommerceBuilder.AbleCommerceTax: 7.3.12396.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.3.12065.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.3.12065.0
CommerceBuilder.DataClient.Api: 7.0.3.1
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.0.10052.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.2.11284.0
CommerceBuilder.PayPal: 7.3.12238.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.3.12065.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.3.12065.0
ComponentArt.Web.UI: 2008.2.1267.3
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
edtFTPnet: 1.2.4.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Practices.EnterpriseLibrary.Common: 2.0.0.0
Microsoft.Practices.EnterpriseLibrary.Data: 2.0.0.0
Microsoft.Practices.ObjectBuilder: 1.0.51205.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Thu Aug 06, 2009 9:25 am
by ThinkNoodle
I have the same error...
be interested to know the solution
Matt
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Thu Aug 06, 2009 10:52 am
by ZLA
This is probably due to redundant data. I had this problem with ac_ProductTemplateFields when I did some updates via sql. See this post for an explanation:
viewtopic.php?f=42&t=11885
I reported the error in this post but never updated it with what I found:
viewtopic.php?f=42&t=11881
If you look into the wishlist tables, I suspect you or AC will find that one or more of them have an artificial (non-natural) primary key but really should have a composite primary key on two or more other columns in the table. Look at the foreign key columns and try doing a count of records by them. A count > 1 would probably generate the error.
Removing the duplicate data should fix the problem.
HTH.
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Tue May 18, 2010 12:10 pm
by napacabs
Any other solution, if no redundant data found:
VERSION: 7.0.3
BUILD: 12458
MSSQL v2005
AC SCHEMA v2005
Error at ViewWishlist.aspx?WishlistId=
Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId'
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ArgumentException: Item has already been added. Key in dictionary: 'WishlistItemId' Key being added: 'WishlistItemId']
System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) +2866787
System.Collections.Hashtable.Add(Object key, Object value) +11
System.Collections.Specialized.OrderedDictionary.Add(Object key, Object value) +49
System.Web.UI.WebControls.DataKey.LoadViewState(Object state) +88
System.Web.UI.WebControls.DataKey.System.Web.UI.IStateManager.LoadViewState(Object state) +4
System.Web.UI.WebControls.GridView.LoadDataKeysState(Object state) +310
System.Web.UI.WebControls.GridView.LoadControlState(Object savedState) +450
System.Web.UI.Control.LoadControlStateInternal(Object savedStateObj) +118
System.Web.UI.Page.LoadAllState() +212
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1092
Version Information: Microsoft .NET Framework Version:2.0.50727.1873; ASP.NET Version:2.0.50727.1433
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Fri May 21, 2010 11:32 am
by mazhar
Is this happens when there is some special product in wishlist or it happens for any product in wishlist? If this is some special case then can you explain what type of product must be in wishlist to produce this.
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Sun May 23, 2010 6:47 pm
by napacabs
This happens with every product. It's a simple product with no "Bundle", no "Options and Variants", and no custom product fields.
Thanks for replying.
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Mon May 24, 2010 7:30 am
by mazhar
I tried to reproduce it on same build of 7.0.3 means VERSION: 7.0.3 BUILD: 12458 but was unable to reproduce the case. I am able to open viewwishlist page in edit mode having some items in it.
Re: Edit ViewWishlist.aspx Gives SQL Server Error
Posted: Mon May 24, 2010 11:37 am
by napacabs
From ViewWishlist.aspx, were you able to add wish items to cart? That's when I get the error.