General discussion

Locked

Strange Occurrance

By lwheeler ·
My company has many retail sites which access a centralized database over a wireless network. At only one of our locations, on 2 occasions, a custom ticketing application has produced a crystal report (v8.5) where the data is doubled. If you specify the same report the next day, the numbers are fine. Three separate reports are printed one after the other; the first 2 have duplicated (as in totals are exactly 2x what they really should be) and the third one is fine. The o/s is Windows 2003 Server; the database is SQL Server 7.0; the application is written in VB 6.0

Does anyone have an idea why this is happening? It is only one location and it happens very infrequently (2 times in the last 2 months).

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mshavrov In reply to Strange Occurrance

First, it does not seem to be an network issue. Even if user has lost the connection and later hit "Enter" again, your application and database should catch that transaction. So, possibly reasons are:

1. Pourly written application. May be it does not catch duplicate records. May be it does not use proper mechanism to complete transaction (i.e. writes data directly into production database without staging/verification, etc.) Probably it has some kind of mechanism to catch duplicate transactions later, but most likely it just uses "unique sort key" which actually just "hides" duplicates.

2. Pourly written report in CR 8.5. Again, it may be anything - improper reindexing, bug in software, bug in report, etc.

What I would advice - either do it yourself or hire somebody to look database physically, if you have these duplicate records PHYSICALLY in the database. If you have them - most likely it's problem with the software. If not - it's problem with Crystal Report.

Good luck,

Michael Shavrov
MCSE W2K, MCSE+I, MCDBA, CCNP, CCDP, CCSP, Security+, ...

Collapse -

by lwheeler In reply to

The same report is run many times from a different location and the figures are not doubled. The records are not duplicated in the database. Every location is connecting to the same database and using the same application, but there is no duplication anywhere else. And it has only happened twice in the last 2 months (these reports are run several times daily). One more thing I just thought of that I did not mention. All locations run this application through Citrix.

Collapse -

by BobHo In reply to Strange Occurrance

Is there a way to run an audit to see if the issue is with a certain user? It sounds like more of a data-entry issue. Is there a user who posts data differently than other users which might be causing the duplications? If you run the same report the next day and everything is correct were there any updates/corrections made overnight which would cancel the duplicate data?

Hmmm, very interesting.

RW

Collapse -

by lwheeler In reply to

This is a legitimate and possible answer. There are no processes that run overnight or anytime at that matter to correct or cancel transactions. We have looked into which user(s) have input the transactions and which workstation, we have tried to find a connection, but there doesn't seem to be anything except that both times happened on a Friday afternoon about 4:30 pm.

Collapse -

by BobHo In reply to Strange Occurrance

I do not have alot of knowledge regarding Citrix but a quick look through their knowledge base shows quite a few issues regarding random duplicate identical sessions. Is there anyway for you to see if a workstation has a duplicate session does it cause duplicate data to show up but then after the session(s) are terminated the data updates correctly?

Cheers,

RW

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums