Corruption of database

Your symptoms point to a problem with your customized job travler.
If the database was corrupt it's very unlikely that vantage would
display your data properly and ODBC wouldn't. Check the travler
first. If you can't get it then repost. There are a couple of
maintenance tools for the database you can try but I doubt they will
help and you'll have to shutdown Vantage to use them.

--- In vantage@y..., "vtaeroman" <brento@v...> wrote:
> Does anyone know where I go to access any utilities to test whether
> our Vantage database is corrupted?
>
> It looks like we are getting unpredictable results with our
> customized job traveler that uses ODBC to pull in a few fields.
> Depending on the job, sometimes the information is displayed
> correctly but usually there are some fields missing. We can see
the
> data in the fields by looking at the job in Vantage but the
traveler
> just doesn't always display the data.
>
> Any help would be appreciated.
>
> Brent O'Donnell
Does anyone know where I go to access any utilities to test whether
our Vantage database is corrupted?

It looks like we are getting unpredictable results with our
customized job traveler that uses ODBC to pull in a few fields.
Depending on the job, sometimes the information is displayed
correctly but usually there are some fields missing. We can see the
data in the fields by looking at the job in Vantage but the traveler
just doesn't always display the data.

Any help would be appreciated.

Brent O'Donnell
Brent,
My first suspicion would be the report -- especially using ODBC -- as opposed to database corruption. Odd linking can exhibit strange behaviour many times. Also, Crystal .dll inconsistencies can produce odd results as well (if you happen to be using or ever did use CR 8.5 on that machine). Have you tried running the report from other machines? If you go back to the original traveller does it look normal 100% of the time?

Troy Funte
Liberty Electronics

----- Original Message -----
From: vtaeroman
To: vantage@yahoogroups.com
Sent: Friday, November 15, 2002 10:39 AM
Subject: [Vantage] Corruption of database


Does anyone know where I go to access any utilities to test whether
our Vantage database is corrupted?

It looks like we are getting unpredictable results with our
customized job traveler that uses ODBC to pull in a few fields.
Depending on the job, sometimes the information is displayed
correctly but usually there are some fields missing. We can see the
data in the fields by looking at the job in Vantage but the traveler
just doesn't always display the data.

Any help would be appreciated.

Brent O'Donnell




Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]