Duplication of record in database

Kavita · Joined: 29 Nov 2007 Posts: 3

We have one web application developed in .Net framework 1.1. This site is
live on production server since one year and used across world by many users.

But only one of the users is facing following problem:

Whenever the user submits an “Approval Process” form, there are 3 times
entries of same record with 2 – 5 seconds time difference.

This problem was faced by user in May and now again in last week. So, even
this user does not get this problem always. Nor any other user has reported
same problem.

We maintain an exception log file. There are no exceptions neither written
in this log file nor shown on page. We are not able to replicate this issue.
We even asked user whether she does multiple clicks on submit button or has
multiple sessions opened. But the user denies doing anything of this.

Can anyone help me in this problem? What can be cause for this issue?

Archived from group: microsoft>public>dotnet>framework>aspnet

Nick Chan · Joined: 08 Nov 2007 Posts: 2

prevent multiple posting this way

Page_Load or Init
---------------------------------------------------------------------
if not ispostback
session(random_stringornumber) = 0
else
if session(random_stringornumber) = 1 then
response.end
end
end
---------------------------------------------------------------------

OnSubmitClick
-----------------------------------------------------
GetReadyToEnterRecord;
session(random_stringornumber) = 1
Finish;

----------------------------------------------------

On Nov 29, 3:13 pm, Kavita wrote:
> We have one web application developed in .Net framework 1.1. This site is
> live on production server since one year and used across world by many users.
>
> But only one of the users is facing following problem:
>
> Whenever the user submits an "Approval Process" form, there are 3 times
> entries of same record with 2 - 5 seconds time difference.
>
> This problem was faced by user in May and now again in last week. So, even
> this user does not get this problem always. Nor any other user has reported
> same problem.
>
> We maintain an exception log file. There are no exceptions neither written
> in this log file nor shown on page. We are not able to replicate this issue.
> We even asked user whether she does multiple clicks on submit button or has
> multiple sessions opened. But the user denies doing anything of this.
>
> Can anyone help me in this problem? What can be cause for this issue?

Kavita · Joined: 29 Nov 2007 Posts: 3

Hi Nick,

I know with code I can prevent multiple clicks to avoid this. But the
problem is user says that without doing multiple clicks this problem is
occuring. So we are not able to find out the cause.

"Nick Chan" wrote:

> prevent multiple posting this way
>
> Page_Load or Init
> ---------------------------------------------------------------------
> if not ispostback
> session(random_stringornumber) = 0
> else
> if session(random_stringornumber) = 1 then
> response.end
> end
> end
> ---------------------------------------------------------------------
>
>
> OnSubmitClick
> -----------------------------------------------------
> GetReadyToEnterRecord;
> session(random_stringornumber) = 1
> Finish;
>
> ----------------------------------------------------
>
> On Nov 29, 3:13 pm, Kavita wrote:
> > We have one web application developed in .Net framework 1.1. This site is
> > live on production server since one year and used across world by many users.
> >
> > But only one of the users is facing following problem:
> >
> > Whenever the user submits an "Approval Process" form, there are 3 times
> > entries of same record with 2 - 5 seconds time difference.
> >
> > This problem was faced by user in May and now again in last week. So, even
> > this user does not get this problem always. Nor any other user has reported
> > same problem.
> >
> > We maintain an exception log file. There are no exceptions neither written
> > in this log file nor shown on page. We are not able to replicate this issue.
> > We even asked user whether she does multiple clicks on submit button or has
> > multiple sessions opened. But the user denies doing anything of this.
> >
> > Can anyone help me in this problem? What can be cause for this issue?
>
>

Nick Chan · Joined: 08 Nov 2007 Posts: 2

if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita wrote:
> We have one web application developed in .Net framework 1.1. This site is
> live on production server since one year and used across world by many users.
>
> But only one of the users is facing following problem:
>
> Whenever the user submits an "Approval Process" form, there are 3 times
> entries of same record with 2 - 5 seconds time difference.
>
> This problem was faced by user in May and now again in last week. So, even
> this user does not get this problem always. Nor any other user has reported
> same problem.
>
> We maintain an exception log file. There are no exceptions neither written
> in this log file nor shown on page. We are not able to replicate this issue.
> We even asked user whether she does multiple clicks on submit button or has
> multiple sessions opened. But the user denies doing anything of this.
>
> Can anyone help me in this problem? What can be cause for this issue?

Kavita · Joined: 29 Nov 2007 Posts: 3

Hi Nick,

Actually we just want to find out how this can happen if multiple clicks is
not the cause for it. User denies doing multiple click or multiple sessions
open.

User also does not face this always. Sometimes this happen. Even she is not
able to replicate it.

"Nick Chan" wrote:

> if u know the code then it doesnt work !
>
> On Nov 29, 3:13 pm, Kavita wrote:
> > We have one web application developed in .Net framework 1.1. This site is
> > live on production server since one year and used across world by many users.
> >
> > But only one of the users is facing following problem:
> >
> > Whenever the user submits an "Approval Process" form, there are 3 times
> > entries of same record with 2 - 5 seconds time difference.
> >
> > This problem was faced by user in May and now again in last week. So, even
> > this user does not get this problem always. Nor any other user has reported
> > same problem.
> >
> > We maintain an exception log file. There are no exceptions neither written
> > in this log file nor shown on page. We are not able to replicate this issue.
> > We even asked user whether she does multiple clicks on submit button or has
> > multiple sessions opened. But the user denies doing anything of this.
> >
> > Can anyone help me in this problem? What can be cause for this issue?
>
>

Peter Bromberg [C# MVP] · Joined: 31 Oct 2007 Posts: 22

What's most important is simply to have quality code in place that prevents
it from ever happening, regardless of the cause. It might even be your own
code that is inadvertently causing the condition.

--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com

"Kavita" wrote:

> Hi Nick,
>
> Actually we just want to find out how this can happen if multiple clicks is
> not the cause for it. User denies doing multiple click or multiple sessions
> open.
>
> User also does not face this always. Sometimes this happen. Even she is not
> able to replicate it.
>
> "Nick Chan" wrote:
>
> > if u know the code then it doesnt work !
> >
> > On Nov 29, 3:13 pm, Kavita wrote:
> > > We have one web application developed in .Net framework 1.1. This site is
> > > live on production server since one year and used across world by many users.
> > >
> > > But only one of the users is facing following problem:
> > >
> > > Whenever the user submits an "Approval Process" form, there are 3 times
> > > entries of same record with 2 - 5 seconds time difference.
> > >
> > > This problem was faced by user in May and now again in last week. So, even
> > > this user does not get this problem always. Nor any other user has reported
> > > same problem.
> > >
> > > We maintain an exception log file. There are no exceptions neither written
> > > in this log file nor shown on page. We are not able to replicate this issue.
> > > We even asked user whether she does multiple clicks on submit button or has
> > > multiple sessions opened. But the user denies doing anything of this.
> > >
> > > Can anyone help me in this problem? What can be cause for this issue?
> >
> >

Scott Roberts · Joined: 15 Nov 2007 Posts: 23

Users say lots of things, usually starting with "I didn't do anything and my
computer just ........"

Implement code to prevent duplicate postbacks (via refresh button and/or
multiple clicks on submit button) and I bet $1 that the problem mysteriously
vanishes.

Scott

"Kavita" wrote in message @microsoft.com...
> Hi Nick,
>
> I know with code I can prevent multiple clicks to avoid this. But the
> problem is user says that without doing multiple clicks this problem is
> occuring. So we are not able to find out the cause.
>
> "Nick Chan" wrote:
>
>> prevent multiple posting this way
>>
>> Page_Load or Init
>> ---------------------------------------------------------------------
>> if not ispostback
>> session(random_stringornumber) = 0
>> else
>> if session(random_stringornumber) = 1 then
>> response.end
>> end
>> end
>> ---------------------------------------------------------------------
>>
>>
>> OnSubmitClick
>> -----------------------------------------------------
>> GetReadyToEnterRecord;
>> session(random_stringornumber) = 1
>> Finish;
>>
>> ----------------------------------------------------

Ian Semmel · Joined: 10 Aug 2007 Posts: 3

Perhaps this user is double-clicking something instead of single-clicking
it.

> -----Original Message-----
> From: Kavita [mailto:Kavita@discussions.microsoft.com]
> Posted At: Thursday, 29 November 2007 9:55 PM
> Posted To: microsoft.public.dotnet.framework.aspnet
> Conversation: Duplication of record in database
> Subject: Re: Duplication of record in database
>
> Hi Nick,
>
> Actually we just want to find out how this can happen if multiple
> clicks is
> not the cause for it. User denies doing multiple click or multiple
> sessions
> open.
>
> User also does not face this always. Sometimes this happen. Even she is
> not
> able to replicate it.
>
> "Nick Chan" wrote:
>
> > if u know the code then it doesnt work !
> >
> > On Nov 29, 3:13 pm, Kavita wrote:
> > > We have one web application developed in .Net framework 1.1. This
> site is
> > > live on production server since one year and used across world by
> many users.
> > >
> > > But only one of the users is facing following problem:
> > >
> > > Whenever the user submits an "Approval Process" form, there are 3
> times
> > > entries of same record with 2 - 5 seconds time difference.
> > >
> > > This problem was faced by user in May and now again in last week.
> So, even
> > > this user does not get this problem always. Nor any other user has
> reported
> > > same problem.
> > >
> > > We maintain an exception log file. There are no exceptions neither
> written
> > > in this log file nor shown on page. We are not able to replicate
> this issue.
> > > We even asked user whether she does multiple clicks on submit
> button or has
> > > multiple sessions opened. But the user denies doing anything of
> this.
> > >
> > > Can anyone help me in this problem? What can be cause for this
> issue?
> >
> >

SQLCE Encrypt Database problem - database creates but doesn' Hi all, I have been having a heck of a time getting my sqlce database to encrypt. Here's the create database string I am using: Dim SQLEngine As SQLEngine = New

delete NS record with wmi hi, I found a script by microsoft that allows to add, modify, delete different types of dns records. but I dont succeed in deleting NS record that have 'same as parent folder' as owner name. empty value won't do anything, either the zone name wihic is the

New record indication What is the easiest way to tell if the record you are working with is new? For example, if I click the standard Add button on a it clears all form controls and is ready to accept new input. Is there something similar to a IsNewRecord fun

Cannot create a new record? Ugh. I'm starting to dislike ADO.Net. ADO seemed so much simpler. I'm creating a small database application for logging phone calls. The program is supposed to load a data entry screen where the user can enter the details of a phone call and then save

Add a new record in GridView I experimented inserting new rows in a table using a GridView (show footers, make all columns and commands into add textboxes to the footer template of each column, add an Insert link in the footer, add a onInserting Now,