By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,533 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,533 IT Pros & Developers. It's quick & easy.

Duplication of record in database

P: n/a
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?
Nov 29 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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 <Kav...@discussions.microsoft.comwrote:
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?
Nov 29 '07 #2

P: n/a
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 <Kav...@discussions.microsoft.comwrote:
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?

Nov 29 '07 #3

P: n/a
if u know the code then it doesnt work !

On Nov 29, 3:13 pm, Kavita <Kav...@discussions.microsoft.comwrote:
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?
Nov 29 '07 #4

P: n/a
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 <Kav...@discussions.microsoft.comwrote:
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?

Nov 29 '07 #5

P: n/a
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 <Kav...@discussions.microsoft.comwrote:
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?
Nov 29 '07 #6

P: n/a
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" <Ka****@discussions.microsoft.comwrote in message
news:C7**********************************@microsof t.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;

----------------------------------------------------
Nov 29 '07 #7

P: n/a
Perhaps this user is double-clicking something instead of single-clicking
it.
-----Original Message-----
From: Kavita [mailto:Ka****@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 <Kav...@discussions.microsoft.comwrote:
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?
Nov 29 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.