Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Now and then wrong data is inserted in oracle

Re: Now and then wrong data is inserted in oracle

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 02 Dec 2004 16:25:10 +0100
Message-ID: <conc57$gq3$1@news1.zwoll1.ov.home.nl>


Jeffrey wrote:
> VB 6.0
> Oracle version 8.1.7
> Webserver OS: Windows 2000
>
> The problem is very simple: we are loading data from an XML file in an
> oracle database. The data processed in the database is sometimes
> different from what we have in the XML file. This is occuring once in
> a while. The VB component is scheduled in coldfusion via an asp page
> every 10 minutes. There is a check if the component is already
> running, there can be no overlap! The asp pages, component and XML
> files are on the webserver.
> I have ran through the code step by step for the "corrupt" files but
> when I do that it is processed just fine. I have ran already a lot of
> other test cases. I've even reloaded all the files we received for one
> day in our development, test and production environment all processed
> ok. I am not able to simulate the problem. I am not saying it is an
> oracle issue. I can just give you the facts we are dealing with. It
> could be either VB, Oracle, the connection between the webserver (XML
> files are stored here) and the database server or a combination. I
> really don't know.
> Anyway already thanks for your friendly advise!

What is "wrong"? Is it like the previous file getting reloaded? Check your cache settings on CF, if that's the case.

-- 
Regards,
Frank van Bortel
Received on Thu Dec 02 2004 - 09:25:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US