MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

WAO View State Issue (Mono Support )

11267 put(a) pogledan, 4 odgovor(a) 2.5.2014. 11:40:15, Kreirao(la) nasman

nasman

2.5.2014. 11:40:15

hi,

I am using SqlProvider for the ViewStates .If I do alot of post backs on a same page then sometime I get following error message.

Any thoughts?

Many thanks

Server Error in '/' Application.Violation of PRIMARY KEY constraint 'PK_WAOViewStateData'. Cannot insert duplicate key in object 'dbo.WAOViewStateData'. The duplicate key value is (VIEWSTATE_fokuma4mj3d1hrh5wyppkiay_567609788_635346299515750645).
The statement has been terminated.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_WAOViewStateData'. Cannot insert duplicate key in object 'dbo.WAOViewStateData'. The duplicate key value is (VIEWSTATE_fokuma4mj3d1hrh5wyppkiay_567609788_635346299515750645).
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_WAOViewStateData'. Cannot insert duplicate key in object 'dbo.WAOViewStateData'. The duplicate key value is (VIEWSTATE_fokuma4mj3d1hrh5wyppkiay_567609788_635346299515750645).
The statement has been terminated.]
MonoSoftware.Web.WAO.ViewState.Providers.SqlProvider.Save() +1416
System.Web.UI.Page.SaveAllState() +1158
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4860

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18446

Ovaj sadržaj još nije ocijenjen.

845 Reputacija 93 Ukupno objava

khorvat

2.5.2014. 12:08:20

This seems very odd, or to put it differently, hard to produce. Can you please try to get back to us with the WAO version and try to compile a list of steps that we need to take in order to reproduce the issue.

Thanks

Ovaj sadržaj još nije ocijenjen.

15993 Reputacija 2214 Ukupno objava

nasman

2.5.2014. 13:43:42

Hi khorvat,

Thanks for your reply. WAO version is 1.0.2.200. I am posting a form with this.AjaxifiedPage = true;. After posting a same form couple of times I get this error message.

I think, MonoSoftware.Web.WAO.ViewState.Providers.SqlProvider.Save() method should check the id in the database . If id is already exist in the database then it should update the existing view state record instead of inserting a new record with the same ID.

Many thanks

Ovaj sadržaj još nije ocijenjen.

845 Reputacija 93 Ukupno objava

khorvat

7.5.2014. 13:30:49

Hi,

the workflow that you have describe is incorrect so viewstate items should never be updated (e.g. you can always go back in your browser and you state should be maintained in that scenario). I have attached the zip file with the latest version of WAO (1.0.2.216) please try to reproduce the issue with the latest version and get back to us. If you reproduce the issue please try to provide more details on how to reproduce the issue.

Thanks

Privici

Ovaj sadržaj još nije ocijenjen.

15993 Reputacija 2214 Ukupno objava

MonoX Nightly Builds MonoX Gallery MonoX Roadmap Mono Software at GitHub

Additional Resources

Pretražuju se:

MonoX support board

WAO View State Issue (Mono Support )

nasman

khorvat

nasman

khorvat

Privici