VO code broke overnight

Hi ALL

I have two installations of a software about 80kms apart. The software at
the two installations are a little different but almost identical, same
libraries, just minor changes.

Anyway, the software was running for 3-4 years without problem but this
morning it is cactus... and no apparent reason. It happened at the same time
(overnight) on both servers, thay are both SBS 2000.

The program is on the WEB, and it had over 1 million customers visiting at
one site, the other is a lot less popular. It has never missed a beat...

Has there been some updates by Microsoft ...????

Any clues will be highly appreciated,

TIA

Tom

Tom

Not enough info.

What's in the error logs??
System event logs if there's no VOError.log

> I have two installations of a software about 80kms apart.
Are they connected in any way - other than your software.

Did they experience any power failures/fluctuations (aka black/brown outs)??
Do they have UPSes??

Is your app the only one failing??

> Has there been some updates by Microsoft ...????
Probably - but you'll need ask your users if they've applied any to their servers.

--
CYA
Steve

Hi Stephen,

The two servers are 80kms apart, identical machines, windows 2000 Small
Business Servers.

It is unlikely that they had power failure and besides they have decent
UPSs. There is no apparent reason, everything else is working fine...

Nothing in the logs, there is no VOError.Log

The only logical explanation would be an automatic update...otherwise why
would the same or similar VO code brake overnight that has worked 4 - 4
years without a problem?

I have no other clues...

have a look at "checkmyphoto.com" ....that is the error code...

Regards,

Tom


"Stephen Quinn" <stevejqNO@SPbigpond.AMnet.au> wrote in message
news:1%a0j.14530$CN4.12730@news-server.bigpond.net.au...
> Tom
>
> Not enough info.
>
> What's in the error logs??
> System event logs if there's no VOError.log
>
> > I have two installations of a software about 80kms apart.
> Are they connected in any way - other than your software.
>
> Did they experience any power failures/fluctuations (aka black/brown
outs)??
> Do they have UPSes??
>
> Is your app the only one failing??
>
> > Has there been some updates by Microsoft ...????
> Probably - but you'll need ask your users if they've applied any to their
servers.
>
> --
> CYA
> Steve
>
>

Tom

you need a bit more detail in your error trapper... like the calling
stack

wi := 0
cEntity := STRING(ProcName(wi))
DO WHILE ! Empty(cEntity)
cText := PadR(STRING(ProcFile(wi)),20)
cText := cText + PadR(cEntity,28)
uLine := ProcLine(wi)
IF uLine <> NIL
cText := cText + PadL(NTrim(uLine),4)
ENDIF
FWriteLine(siHandle,cText)
wi:=wi + 1
cEntity := STRING(ProcName(wI))
ENDDO

that will help you. this code from vo1 many years ago still works for
us

richard

On Mon, 19 Nov 2007 18:16:13 +1000, "Tom Szabo" <tom@intersoft.net.au>
wrote:

>have a look at "checkmyphoto.com" ....that is the error code...
>
Hello Tom,

Did you try it with a backup set of databases? Probably it's just an
error in database which needs repair.

Otherwise could you organize to have the checkmyphoto.com data+program
to run on the server of your other client (or v.v.)? This would rule
out that the server or any update causes the problem. Finally, creates
some logs to see until what point the program is still functioning.

Dick van Kooten

Tom

> It is unlikely that they had power failure and besides they have decent
> UPSs. There is no apparent reason, everything else is working fine...

The point is - did you ask them??

Saying "it's unlikely" doesn't mean they didn't and if the app was running when the UPS shut the system down (because
the power didn't come back online before the auto shutdown) then your indices and/or DBFs may be corrupt.

> The only logical explanation would be an automatic update...otherwise why
> would the same or similar VO code brake overnight that has worked 4 - 4
> years without a problem?

You can view the dates/times these things happen in
"Control Panel->Add/Remove Programs"
"Show Updates" checkbox

Does your app handle the "System Shutdown" messages gracefully or at all??

Could one of the Client machines been been reset while the app was still running corrupting the files??
ie it may not have been the Server which caused the problem

--
CYA
Steve