473,395 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Duplication of record in database

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
7 1738
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
by: Steve Jorgensen | last post by:
A while back, I started boning up on Software Engineering best practices and learning about Agile programming. In the process, I've become much more committed to removing duplication in code at a...
2
by: Aeden Jameson | last post by:
Supose you have NLB'd web servers with affinity set to none. A user fills out a form whose content will be written to a database. Also suppose the impatient user hits the submit button a second...
2
by: Beagle | last post by:
Hey all, I'm somewhat new to working with Access (aw geez, a noob) so I am hacking and slashing my way through creation of a database for a user at my job. The problem is this: I have created a form...
10
by: rave3085 | last post by:
I have 5 fields in my access table date,typeofexpenses,discription,amount,paymentmode. Now the problem is that i need to define a record by two fields-date and typeofexpenses. If the user tries to...
12
by: nathan | last post by:
Hello, Has anyone experienced that records get duplicated by itself. When I look in my tables backend mdb file there are 2 records with the same information. I'm sure the frontend created this...
3
by: jeenajos | last post by:
Hi... Im having 12 tables in a database.Record contain mobileno,place,date. Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables...
1
by: dbarmer | last post by:
I have a unix database system that hold three tables, 254, 255, 256, and all are linked together by WO, CUST NO, LOC NO. This is for Unix Program Purposes Only. Duplication here is by design. So...
1
by: gurmet | last post by:
Hi All I have been looking around for help, and finally post this problem. I created a form to edit a record. Before i can click save button on the edit form i need to check if the data that...
1
by: xraive | last post by:
I have a problem with this. Currently I am trying Allen's code and i am not successful. Current Design Table1 (Main Form) TravelID (PK) ApprovedBY EntreredBy BudgetCode ExpenseCode
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.