Re: Ideas - Your Help Needed
Also a favorite that always keeps users on the latest page: If they're not swift enough to realize they shouldn't click the back button during form data entry, they also usually don't know how to disable Javascript on their own. :-) -- Ian Skinner wrote: I like adding these lines to applications like this, just for this reason. So that users can't cause bad things to happen by using the back button. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199441 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ideas - Your Help Needed
More ideas for what they are worth. Is the user authentication rock solid? Could have another user made the changes? Could a proxy server have mixed things up somehow? Kore "Gavin Brook" <[EMAIL PROTECTED]To: CF-Talk tec.com> cc: Subject: Ideas - Your Help Needed 03/18/2005 06:42 AM Please respond to cf-talk Hi All, I've got a little bit of a problem and I hope that you guys would be able to give me advice or shed a little light on a situation I have The Setup 1xApplication Server - Windows 2003 Web Edition - CFMX 6.1 Standard, all patches 1xDatabase Server - Windows 2003 Standard Edition - SQL Server 2000 SP3a This setup is running an application that our company wrote to store data relating people. This information is entered through a dynamic form which is configured through an admin interface. The whole application has been developed using Mach-II. The system has been live for a year now and was thouroughly tested by all parties before go live. There have been a couple of bugs since, but the code has been unchanged and stable for at 8months now. The problem is this. We have been getting reports of "data corruption" on a very small number of forms. I have investigated this "corruption". The system logs who made what changes to the system to provide an audit trail for each form. The audit trail shows users have made the "corrupt" changes to the form and I presented this to the client. They will not accept this response. I'll give you an example, a name had been changed from one to another. I checked the live database and a backup and they both show that a user changed the name. The user insists that he did not change the name. I cannot see in light of this evidence and problem with my code or the system. My question to the forum is basically, is there anything I'm missing? Sorry for the longwinded explanation, but I feel like I'm banging my head against a wall! Any ideas you might will be greatly appreciated. Thanks in advance, Gavin ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
The session is only used to store the details of the user who has logged in. Everything is through the forms. Even manipulating the form would show up in the audit log. As an update, I've now added logging to log everything being sent to the server, so we can effectively track every mouse click. All the evidence points to user error, so hopefully when confronted with the extensive logs, it will carry more weight. Thanks, Gavin -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 16:24 To: CF-Talk Subject: RE: Ideas - Your Help Needed We had a situation where a manager would enter a pay increase for employee A but it would save the record into employee B record. Basically what was happening is they would enter employee B make some changes to the form, change their mind, click the back button a couple times to employee A record and hit submit. Well, the session information from employee B was still hanging around and was insert into employee A record. Maybe something like this could have occurred, he entered a different name, changed his mind went to a different screen and saved some form contents and it saved the bogus name. Thanks, CC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
I like adding these lines to applications like this, just for this reason. So that users can't cause bad things to happen by using the back button. Causes any page with these headers, to not be cached so that they can not be reached with the back button. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Friday, March 18, 2005 8:24 AM To: CF-Talk ....Subject: RE: Ideas - Your Help Needed We had a situation where a manager would enter a pay increase for employee A but it would save the record into employee B record. Basically what was happening is they would enter employee B make some changes to the form, change their mind, click the back button a couple times to employee A record and hit submit. Well, the session information from employee B was still hanging around and was insert into employee A record. Maybe something like this could have occurred, he entered a different name, changed his mind went to a different screen and saved some form contents and it saved the bogus name. Thanks, CC - --- This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - --- "Gavin Brook" 03/18/2005 08:59 AM Please respond to cf-talk To: CF-Talk cc: .... Subject: RE: Ideas - Your Help Needed No, the key is unique and not editable. The transactions are all complete. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 15:37 To: CF-Talk Subject: RE: Ideas - Your Help Needed Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola > -Original Message- > From: Gavin Brook [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:08 ....> To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Definitely. I have reviewed my code and had other developers review it > too, just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] ....> Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > > Stay away from accusations, say that all the evidence points to a > mistake on their part.This way they may be less defensive. Also double > check that your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > > If your client contact is non technical, you may just need to talk > them through the evidence very carefully so they can understand the > sequence of events as you do. > > Maybe you could should them as example of entering data and changing > data and then show them the log records that are created from the > example. > > Mike > > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook > <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would > > be able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > c
RE: Ideas - Your Help Needed
We had a situation where a manager would enter a pay increase for employee A but it would save the record into employee B record. Basically what was happening is they would enter employee B make some changes to the form, change their mind, click the back button a couple times to employee A record and hit submit. Well, the session information from employee B was still hanging around and was insert into employee A record. Maybe something like this could have occurred, he entered a different name, changed his mind went to a different screen and saved some form contents and it saved the bogus name. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Gavin Brook" 03/18/2005 08:59 AM Please respond to cf-talk To: CF-Talk cc: Subject: RE: Ideas - Your Help Needed No, the key is unique and not editable. The transactions are all complete. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 15:37 To: CF-Talk Subject: RE: Ideas - Your Help Needed Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola > -Original Message- > From: Gavin Brook [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:08 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Definitely. I have reviewed my code and had other developers review it > too, just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > > Stay away from accusations, say that all the evidence points to a > mistake on their part.This way they may be less defensive. Also double > check that your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > > If your client contact is non technical, you may just need to talk > them through the evidence very carefully so they can understand the > sequence of events as you do. > > Maybe you could should them as example of entering data and changing > data and then show them the log records that are created from the > example. > > Mike > > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook > <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would > > be able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > configured through an admin interface. The whole application has > > been developed using Mach-II. The system has been live for a year > > now and was thouroughly tested by all parties before go live. There > > have been a couple of bugs since, but the code has been unchanged > > and stable for at 8months now. > > > > The problem is this. We have been getting reports of "data > > corruption" on > a > > very small number of forms. I have investigated this "corruption". > > The system logs who made what changes to the system to provide an > > audit trail for each form. The audit trail shows users have made the > > "corrupt" changes to the form and I presented this to the client. > > They will not accept this response. I'll give you an example, a name > > had been changed from one to another. I checked the live database > > and a backup and they both show that > a > > user changed the name. The
RE: Ideas - Your Help Needed
No, the key is unique and not editable. The transactions are all complete. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 15:37 To: CF-Talk Subject: RE: Ideas - Your Help Needed Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola > -Original Message- > From: Gavin Brook [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:08 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Definitely. I have reviewed my code and had other developers review it > too, just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > > Stay away from accusations, say that all the evidence points to a > mistake on their part.This way they may be less defensive. Also double > check that your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > > If your client contact is non technical, you may just need to talk > them through the evidence very carefully so they can understand the > sequence of events as you do. > > Maybe you could should them as example of entering data and changing > data and then show them the log records that are created from the > example. > > Mike > > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook > <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would > > be able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > configured through an admin interface. The whole application has > > been developed using Mach-II. The system has been live for a year > > now and was thouroughly tested by all parties before go live. There > > have been a couple of bugs since, but the code has been unchanged > > and stable for at 8months now. > > > > The problem is this. We have been getting reports of "data > > corruption" on > a > > very small number of forms. I have investigated this "corruption". > > The system logs who made what changes to the system to provide an > > audit trail for each form. The audit trail shows users have made the > > "corrupt" changes to the form and I presented this to the client. > > They will not accept this response. I'll give you an example, a name > > had been changed from one to another. I checked the live database > > and a backup and they both show that > a > > user changed the name. The user insists that he did not change the > > name. > > > > I cannot see in light of this evidence and problem with my code or > > the system. My question to the forum is basically, is there anything > > I'm missing? > > > > Sorry for the longwinded explanation, but I feel like I'm banging my > > head against a wall! Any ideas you might will be greatly > > appreciated. > > > > Thanks in advance, > > > > Gavin > > > > > > > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola > -Original Message- > From: Gavin Brook [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:08 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Definitely. I have reviewed my code and had other developers review it > too, > just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > > Stay away from accusations, say that all the evidence points to a mistake > on > their part.This way they may be less defensive. Also double check that > your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > > If your client contact is non technical, you may just need to talk them > through the evidence very carefully so they can understand the sequence of > events as you do. > > Maybe you could should them as example of entering data and changing data > and then show them the log records that are created from the example. > > Mike > > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would be > > able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > configured through an admin interface. The whole application has been > > developed using Mach-II. The system has been live for a year now and > > was thouroughly tested by all parties before go live. There have been > > a couple of bugs since, but the code has been unchanged and stable for > > at 8months now. > > > > The problem is this. We have been getting reports of "data corruption" > > on > a > > very small number of forms. I have investigated this "corruption". The > > system logs who made what changes to the system to provide an audit > > trail for each form. The audit trail shows users have made the > > "corrupt" changes to the form and I presented this to the client. They > > will not accept this response. I'll give you an example, a name had > > been changed from one to another. I checked the live database and a > > backup and they both show that > a > > user changed the name. The user insists that he did not change the > > name. > > > > I cannot see in light of this evidence and problem with my code or the > > system. My question to the forum is basically, is there anything I'm > > missing? > > > > Sorry for the longwinded explanation, but I feel like I'm banging my > > head against a wall! Any ideas you might will be greatly appreciated. > > > > Thanks in advance, > > > > Gavin > > > > > > > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ideas - Your Help Needed
rehearse the step-by-step process you are going to do for the client, without the client present. this will be a good double check and will either get you well prepared or uncover the problem ;-) On Fri, 18 Mar 2005 13:07:30 -, Gavin Brook <[EMAIL PROTECTED]> wrote: > Definitely. I have reviewed my code and had other developers review it too, > just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Stay away from accusations, say that all the evidence points to a mistake on > their part.This way they may be less defensive. Also double check that your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > If your client contact is non technical, you may just need to talk them > through the evidence very carefully so they can understand the sequence of > events as you do. > > Maybe you could should them as example of entering data and changing data > and then show them the log records that are created from the example. > > Mike > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would be > > able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > configured through an admin interface. The whole application has been > > developed using Mach-II. The system has been live for a year now and > > was thouroughly tested by all parties before go live. There have been > > a couple of bugs since, but the code has been unchanged and stable for > > at 8months now. > > > > The problem is this. We have been getting reports of "data corruption" > > on > a > > very small number of forms. I have investigated this "corruption". The > > system logs who made what changes to the system to provide an audit > > trail for each form. The audit trail shows users have made the > > "corrupt" changes to the form and I presented this to the client. They > > will not accept this response. I'll give you an example, a name had > > been changed from one to another. I checked the live database and a > > backup and they both show that > a > > user changed the name. The user insists that he did not change the > > name. > > > > I cannot see in light of this evidence and problem with my code or the > > system. My question to the forum is basically, is there anything I'm > > missing? > > > > Sorry for the longwinded explanation, but I feel like I'm banging my > > head against a wall! Any ideas you might will be greatly appreciated. > > > > Thanks in advance, > > > > Gavin > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
Definitely. I have reviewed my code and had other developers review it too, just to be sure. Is there any possibility of CFMX or SQL doing this?? I've searched and cannot find anything. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 13:03 To: CF-Talk Subject: RE: Ideas - Your Help Needed Stay away from accusations, say that all the evidence points to a mistake on their part.This way they may be less defensive. Also double check that your code is solid. Ade -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> wrote: > Hi All, > > I've got a little bit of a problem and I hope that you guys would be > able to give me advice or shed a little light on a situation I > have > > The Setup > 1xApplication Server > - Windows 2003 Web Edition > - CFMX 6.1 Standard, all patches > > 1xDatabase Server > - Windows 2003 Standard Edition > - SQL Server 2000 SP3a > > This setup is running an application that our company wrote to store > data relating people. This information is entered through a dynamic > form which is > configured through an admin interface. The whole application has been > developed using Mach-II. The system has been live for a year now and > was thouroughly tested by all parties before go live. There have been > a couple of bugs since, but the code has been unchanged and stable for > at 8months now. > > The problem is this. We have been getting reports of "data corruption" > on a > very small number of forms. I have investigated this "corruption". The > system logs who made what changes to the system to provide an audit > trail for each form. The audit trail shows users have made the > "corrupt" changes to the form and I presented this to the client. They > will not accept this response. I'll give you an example, a name had > been changed from one to another. I checked the live database and a > backup and they both show that a > user changed the name. The user insists that he did not change the > name. > > I cannot see in light of this evidence and problem with my code or the > system. My question to the forum is basically, is there anything I'm > missing? > > Sorry for the longwinded explanation, but I feel like I'm banging my > head against a wall! Any ideas you might will be greatly appreciated. > > Thanks in advance, > > Gavin > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
I've shown them the audit logs for each bit, but I will arrange to go through the process step-by-step. That's a good idea. Thanks -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> wrote: > Hi All, > > I've got a little bit of a problem and I hope that you guys would be > able to give me advice or shed a little light on a situation I > have > > The Setup > 1xApplication Server > - Windows 2003 Web Edition > - CFMX 6.1 Standard, all patches > > 1xDatabase Server > - Windows 2003 Standard Edition > - SQL Server 2000 SP3a > > This setup is running an application that our company wrote to store > data relating people. This information is entered through a dynamic > form which is configured through an admin interface. The whole > application has been developed using Mach-II. The system has been live > for a year now and was thouroughly tested by all parties before go > live. There have been a couple of bugs since, but the code has been > unchanged and stable for at 8months now. > > The problem is this. We have been getting reports of "data corruption" > on a very small number of forms. I have investigated this > "corruption". The system logs who made what changes to the system to > provide an audit trail for each form. The audit trail shows users have > made the "corrupt" changes to the form and I presented this to the > client. They will not accept this response. I'll give you an example, > a name had been changed from one to another. I checked the live > database and a backup and they both show that a user changed the name. > The user insists that he did not change the name. > > I cannot see in light of this evidence and problem with my code or the > system. My question to the forum is basically, is there anything I'm > missing? > > Sorry for the longwinded explanation, but I feel like I'm banging my > head against a wall! Any ideas you might will be greatly appreciated. > > Thanks in advance, > > Gavin > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
Stay away from accusations, say that all the evidence points to a mistake on their part.This way they may be less defensive. Also double check that your code is solid. Ade -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 12:52 To: CF-Talk Subject: Re: Ideas - Your Help Needed If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> wrote: > Hi All, > > I've got a little bit of a problem and I hope that you guys would be able > to give me advice or shed a little light on a situation I have > > The Setup > 1xApplication Server > - Windows 2003 Web Edition > - CFMX 6.1 Standard, all patches > > 1xDatabase Server > - Windows 2003 Standard Edition > - SQL Server 2000 SP3a > > This setup is running an application that our company wrote to store data > relating people. This information is entered through a dynamic form which is > configured through an admin interface. The whole application has been > developed using Mach-II. The system has been live for a year now and was > thouroughly tested by all parties before go live. There have been a couple > of bugs since, but the code has been unchanged and stable for at 8months > now. > > The problem is this. We have been getting reports of "data corruption" on a > very small number of forms. I have investigated this "corruption". The > system logs who made what changes to the system to provide an audit trail > for each form. The audit trail shows users have made the "corrupt" changes > to the form and I presented this to the client. They will not accept this > response. I'll give you an example, a name had been changed from one to > another. I checked the live database and a backup and they both show that a > user changed the name. The user insists that he did not change the name. > > I cannot see in light of this evidence and problem with my code or the > system. My question to the forum is basically, is there anything I'm > missing? > > Sorry for the longwinded explanation, but I feel like I'm banging my head > against a wall! Any ideas you might will be greatly appreciated. > > Thanks in advance, > > Gavin > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Ideas - Your Help Needed
If your client contact is non technical, you may just need to talk them through the evidence very carefully so they can understand the sequence of events as you do. Maybe you could should them as example of entering data and changing data and then show them the log records that are created from the example. Mike On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook <[EMAIL PROTECTED]> wrote: > Hi All, > > I've got a little bit of a problem and I hope that you guys would be able > to give me advice or shed a little light on a situation I have > > The Setup > 1xApplication Server > - Windows 2003 Web Edition > - CFMX 6.1 Standard, all patches > > 1xDatabase Server > - Windows 2003 Standard Edition > - SQL Server 2000 SP3a > > This setup is running an application that our company wrote to store data > relating people. This information is entered through a dynamic form which is > configured through an admin interface. The whole application has been > developed using Mach-II. The system has been live for a year now and was > thouroughly tested by all parties before go live. There have been a couple > of bugs since, but the code has been unchanged and stable for at 8months > now. > > The problem is this. We have been getting reports of "data corruption" on a > very small number of forms. I have investigated this "corruption". The > system logs who made what changes to the system to provide an audit trail > for each form. The audit trail shows users have made the "corrupt" changes > to the form and I presented this to the client. They will not accept this > response. I'll give you an example, a name had been changed from one to > another. I checked the live database and a backup and they both show that a > user changed the name. The user insists that he did not change the name. > > I cannot see in light of this evidence and problem with my code or the > system. My question to the forum is basically, is there anything I'm > missing? > > Sorry for the longwinded explanation, but I feel like I'm banging my head > against a wall! Any ideas you might will be greatly appreciated. > > Thanks in advance, > > Gavin > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
