any ideas on this??

anteena1

hi all i've been turning my hand to competitions on the comp forum but have recently noticed i keep getting the following message just before a winner is picked on an instant game. Am i being barred?? any help is greatly appreciated


Server Error in '/' Application.

Violation of PRIMARY KEY constraint 'PK_Winner_1'. Cannot insert duplicate key in object 'dbo.Winner'.
The statement has been terminated.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]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.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Winner_1'. Cannot insert duplicate key in object 'dbo.Winner'.
The statement has been terminated.

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:

[SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_Winner_1'. Cannot insert duplicate key in object 'dbo.Winner'.The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 DairyCrest.UtterlyButterly.DAL.UBTableAdapters.WinnerTableAdapter.Insert(Nullable`1 UserID, Nullable`1 Window, Nullable`1 PrizeID, Nullable`1 WinnersWall) in C:\IrisDigital\Clients\DairyCrest\Projects\UtterlyButterly\DairyCrest.UtterlyButterly.DAL\UtterlyButterly.Designer.cs:7898 DairyCrest.UtterlyButterly.Business.WinnerManager.Create(WinnerRow row) in C:\IrisDigital\Clients\DairyCrest\Projects\UtterlyButterly\dotnet\DairyCrest.UtterlyButterly.Business\WinnerManager.cs:49 DairyCrest.UtterlyButterly.Business.CompetitionManager.EnterCompetition(UserRow userRow) in C:\IrisDigital\Clients\DairyCrest\Projects\UtterlyButterly\dotnet\DairyCrest.UtterlyButterly.Business\CompetitionManager.cs:114 DairyCrest.UtterlyButterly.Business.CompetitionManager.EnterCompetition(String UserEmail, String UserPackCode, String UserTitle, String UserFirstName, String UserLastName, String UserAddressLine1, String UserAddressLine2, String UserAddressLine3, String UserTelephone, String UserPlaceOfBirth, Nullable`1 UserOptin, Nullable`1 UserSaveDetail, Nullable`1 UserOftenBuysUB, String UserBoughtPCodeFrom, String UserUpdateMeVia, String UserHowMuchFatInUB) in C:\IrisDigital\Clients\DairyCrest\Projects\UtterlyButterly\dotnet\DairyCrest.UtterlyButterly.Business\CompetitionManager.cs:287[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +371 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +480 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method) +38 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteInsert(IDictionary values) +867 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +72 System.Web.UI.WebControls.FormView.HandleInsert(String commandArg, Boolean causesValidation) +388 System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +602 System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +109 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 [/FONT]

cally6008

To my mind that means that the website you are on, their server / database cant handle the hits or whatever it is running and has crashed momently.

bingo_bango

Violation of PRIMARY KEY constraint 'PK_Winner_1'. Cannot insert duplicate key in object 'dbo.Winner'.
The statement has been terminated.

This statement would seem to indicate that the same info is trying to be written to the database twice at the same time.Perhaps you've just been really unlucky and have been clicking at the same time as a winner, but I suspect that there is a little more background to this question.

anteena1

thanx i just dont want to waste my time on it if i have no chance. I'm very basic on my pc knowledge so any help is appreciated

bingo_bango

It depends on a lot of things.

What comp is it, what browser / OS are you using. Do you have similar issues with inputting data on other sites? Could be any one of a number of things.

anteena1

its the utterly butterly comp and i am using firefox. I have won on this comp so wondered if if i was now be stopped from winning again even though it doesnt say you cant win again in its t&c

bingo_bango

That would explain it. You obviously need to input personal details before playing, and it's trying to write these details to it's database (SQL) when you win. The problem is that the primary key (the one it uses to identify the record) is trying to write the same info twice to the same database. Probably your email address. That's why it shows a sharing error. It's trying to write your details to the same space again on the database.

I would suggest you try playing with a new email addy and that should work. If not, then the primary key may be your name. Not much you can do to change that. If the T's&C's don't say you can't win more than one prize, I would email their customer services, including the message you have above, and a link to this thread. They will be able to clarify for you.

Can you also post this on the UB competition thread so the other users can see this thread? May help some of them too.

anteena1

thankyou for your help