Corrupted Progress database

Yahoo Archive
1
Sorry to hear about loss of backups.



One part of our disaster recovery readiness is to take a copy of our
backup at least once a month and restore it to either our training db or
test db to make sure our backups are running correctly. More frequently
if any concerns. We also do a daily check of the backup logs from
scheduled tasks to make sure all looks good as well.



We also have a separate server that has the same version of software
that is loaded on live. We use this as a test server. This allows us to
test patches etc against a current copy of our database to see how it
performs without touching the live server since the same software runs
the training and test databases on the live server.



This helps avoid unpleasant surprises.



Jerry W. Rodden

Staff Administrator

Production Planning

Cardington Yutaka Technologies Inc

Phone: 419-864-8777 ext. 6209

FAX: 419-864-7771

jrodden@...







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



What could cause a Progress database to become corrupted?

We are on Vantage 6.1, Progress 9.1D platform



I've gone to technical support and they can't prove why our dB became
corrupted.

So, I wanted to ask this group if they have any suggestions. My
hardware on the server is fine. Of course, I have the antivirus
excluding the epicor folder and my backup software is not touching
Epicor. So, what else could be the cause?



Thank you so much for your input on this crucial 'whodunit' scenario!



Tamara



Tamara Blatny

Network Administrator

Gasket Engineering Co., Inc.

tblatny@... <mailto:tblatny@...>

816.363.8333 x108




#####################################################################################

Scanned by MailMarshal - Marshal's comprehensive email content security solution.
Download a free evaluation of MailMarshal at www.marshal.com

#####################################################################################


[Non-text portions of this message have been removed]
3
Hi Tamara,
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.

And what do they mean by corrupted? Does it not start? Do the Progress
tools tell you there's corruption or are they saying that the values
inside of your database won't work with Vantage? Do you update your
database via ODBC?

Mark W.
4
Without any warnings in our log file...our database stopped itself and
showed this in the mfgsys.lg file:



The last backup was not completed successfully. (1553)

SYSTEM ERROR: read wrong dbkey at offset 2351448064 in file
C:\epicor\mfgsys61\db\mfgsys.d1 retrying (9445)

Corrupt block detected when reading from database (4229)

bkRead: Error occurred in area 6, block number 574083, (10560)

Writing block 574083 to log file. Please save and send log file to
Progress software Corp. for investigation. (10561)



Our database stopped running and wouldn't start back up.

The log file was saying corrupt file. Then, when Vantage tech support
tried to Restore from my backup. The restore process would only go so
far then stop. So, tech support told me that our backups were damaged
or corrupted as well. We lost a lot of data, because the last valid
backup that would restore was 3 weeks ago.



The log file never said unsuccessful backup until the last 2 days before
it shut down.

Leading up to the complete shut down of dB, the database automatically
shut itself down twice, the first time I went into Progress Explorer
Tool and click Start and it started right up without errors in the log
file. The 2nd time, it didn't start up.



We haven't updated our dB via ODBC.



Thank you for your help!

Tamara

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, October 12, 2010 11:34 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Corrupted Progress database





Hi Tamara,
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.

And what do they mean by corrupted? Does it not start? Do the Progress
tools tell you there's corruption or are they saying that the values
inside of your database won't work with Vantage? Do you update your
database via ODBC?

Mark W.



Reply to sender
<mailto:mark_wonsil@...?subject=Re:%20%5bVantage%5d%20Corrupted%20
Progress%20database> | Reply to group
<mailto:vantage@yahoogroups.com?subject=Re:%20%5bVantage%5d%20Corrupted%
20Progress%20database> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJvYWw5bDVsBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5NDQyMARzZWM
DZnRyBHNsawNycGx5BHN0aW1lAzEyODY5MDI1MjU-?act=reply&messageNum=94420> |
Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjb2Y2bTVpBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEyODY5MDI1MjU->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/94418;_ylc=X3oDMTM0MTZkdG
NmBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5ND
QyMARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEyODY5MDI1MjUEdHBjSWQDOTQ0MTg-> (2)


Recent Activity:

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdXJjZmE4BF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEyODY5MDI1MjU->

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/.
<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

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJiN2RnNmwwBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTI4NjkwM
jUyNQ-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com?subject=Change%20Delivery%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com?subject=Email%20Delivery:%20Diges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe> *
Terms of Use <http://docs.yahoo.com/info/terms/>



[Non-text portions of this message have been removed]
5
Hi Tamara/Mark,

What do you mean by corrupted? We also think our DB is corrupted because when we apply fixes or patches in Test we dont get the same results in Live. Also, Live DB seems to create random errors in the credit card processing, allocation of materials etc.

I am trying to determine if our DV (SQL) is corrupted so we can decide if we should reinstall epicor.

--- In vantage@yahoogroups.com, "Tamara Blatny" <tblatny@...> wrote:
>
> Hello!
>
>
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
>
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.
>
> So, I wanted to ask this group if they have any suggestions. My
> hardware on the server is fine. Of course, I have the antivirus
> excluding the epicor folder and my backup software is not touching
> Epicor. So, what else could be the cause?
>
>
>
> Thank you so much for your input on this crucial 'whodunit' scenario!
>
>
>
> Tamara
>
>
>
> Tamara Blatny
>
> Network Administrator
>
> Gasket Engineering Co., Inc.
>
> tblatny@... <mailto:tblatny@...>
>
> 816.363.8333 x108
>
>
>
>
> #####################################################################################
>
> Scanned by MailMarshal - Marshal's comprehensive email content security solution.
> Download a free evaluation of MailMarshal at www.marshal.com
>
> #####################################################################################
>
>
> [Non-text portions of this message have been removed]
>
6
I've only used it once but there is a Progress Repair utility that can fix corruption, sometimes. You might lose a bit of data. I can't recall if it also re-indexes the database. It was so long ago I don't recall the retails but there ought to be info available to you (and Epicor Support) in the knowledgebase. At this point perhaps no harm in trying.
-Todd C,


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tamara Blatny
Sent: Tuesday, October 12, 2010 12:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Corrupted Progress database



Without any warnings in our log file...our database stopped itself and
showed this in the mfgsys.lg file:

The last backup was not completed successfully. (1553)

SYSTEM ERROR: read wrong dbkey at offset 2351448064 in file
C:\epicor\mfgsys61\db\mfgsys.d1 retrying (9445)

Corrupt block detected when reading from database (4229)

bkRead: Error occurred in area 6, block number 574083, (10560)

Writing block 574083 to log file. Please save and send log file to
Progress software Corp. for investigation. (10561)

Our database stopped running and wouldn't start back up.

The log file was saying corrupt file. Then, when Vantage tech support
tried to Restore from my backup. The restore process would only go so
far then stop. So, tech support told me that our backups were damaged
or corrupted as well. We lost a lot of data, because the last valid
backup that would restore was 3 weeks ago.

The log file never said unsuccessful backup until the last 2 days before
it shut down.

Leading up to the complete shut down of dB, the database automatically
shut itself down twice, the first time I went into Progress Explorer
Tool and click Start and it started right up without errors in the log
file. The 2nd time, it didn't start up.

We haven't updated our dB via ODBC.

Thank you for your help!

Tamara

________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Mark Wonsil
Sent: Tuesday, October 12, 2010 11:34 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Corrupted Progress database

Hi Tamara,
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.

And what do they mean by corrupted? Does it not start? Do the Progress
tools tell you there's corruption or are they saying that the values
inside of your database won't work with Vantage? Do you update your
database via ODBC?

Mark W.

Reply to sender
<mailto:mark_wonsil@...<mailto:mark_wonsil%40yahoo.com>?subject=Re:%20%5bVantage%5d%20Corrupted%20
Progress%20database> | Reply to group
<mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>?subject=Re:%20%5bVantage%5d%20Corrupted%
20Progress%20database> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJvYWw5bDVsBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5NDQyMARzZWM
DZnRyBHNsawNycGx5BHN0aW1lAzEyODY5MDI1MjU-?act=reply&messageNum=94420> |
Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjb2Y2bTVpBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEyODY5MDI1MjU->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/94418;_ylc=X3oDMTM0MTZkdG
NmBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5ND
QyMARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEyODY5MDI1MjUEdHBjSWQDOTQ0MTg-> (2)

Recent Activity:

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdXJjZmE4BF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEyODY5MDI1MjU->

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/.<http://groups.yahoo.com/group/vantage/files/>
<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

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJiN2RnNmwwBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTI4NjkwM
jUyNQ-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com<mailto:vantage-traditional%40yahoogroups.com>?subject=Change%20Delivery%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com<mailto:vantage-digest%40yahoogroups.com>?subject=Email%20Delivery:%20Diges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com<mailto:vantage-unsubscribe%40yahoogroups.com>?subject=Unsubscribe> *
Terms of Use <http://docs.yahoo.com/info/terms/>

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



[Non-text portions of this message have been removed]
7
I would truncate the database then if that didn't work I would perform a
Dump & Load.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Tuesday, October 12, 2010 4:05 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Corrupted Progress database





I've only used it once but there is a Progress Repair utility that can
fix corruption, sometimes. You might lose a bit of data. I can't recall
if it also re-indexes the database. It was so long ago I don't recall
the retails but there ought to be info available to you (and Epicor
Support) in the knowledgebase. At this point perhaps no harm in trying.
-Todd C,

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Tamara Blatny
Sent: Tuesday, October 12, 2010 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Corrupted Progress database

Without any warnings in our log file...our database stopped itself and
showed this in the mfgsys.lg file:

The last backup was not completed successfully. (1553)

SYSTEM ERROR: read wrong dbkey at offset 2351448064 in file
C:\epicor\mfgsys61\db\mfgsys.d1 retrying (9445)

Corrupt block detected when reading from database (4229)

bkRead: Error occurred in area 6, block number 574083, (10560)

Writing block 574083 to log file. Please save and send log file to
Progress software Corp. for investigation. (10561)

Our database stopped running and wouldn't start back up.

The log file was saying corrupt file. Then, when Vantage tech support
tried to Restore from my backup. The restore process would only go so
far then stop. So, tech support told me that our backups were damaged
or corrupted as well. We lost a lot of data, because the last valid
backup that would restore was 3 weeks ago.

The log file never said unsuccessful backup until the last 2 days before
it shut down.

Leading up to the complete shut down of dB, the database automatically
shut itself down twice, the first time I went into Progress Explorer
Tool and click Start and it started right up without errors in the log
file. The 2nd time, it didn't start up.

We haven't updated our dB via ODBC.

Thank you for your help!

Tamara

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Mark Wonsil
Sent: Tuesday, October 12, 2010 11:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Corrupted Progress database

Hi Tamara,
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.

And what do they mean by corrupted? Does it not start? Do the Progress
tools tell you there's corruption or are they saying that the values
inside of your database won't work with Vantage? Do you update your
database via ODBC?

Mark W.

Reply to sender
<mailto:mark_wonsil@... <mailto:mark_wonsil%40yahoo.com>
<mailto:mark_wonsil%40yahoo.com>?subject=Re:%20%5bVantage%5d%20Corrupted
%20
Progress%20database> | Reply to group
<mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>?subject=Re:%20%5bVantage%5d%20Corrupt
ed%
20Progress%20database> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJvYWw5bDVsBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5NDQyMARzZWM
DZnRyBHNsawNycGx5BHN0aW1lAzEyODY5MDI1MjU-?act=reply&messageNum=94420> |
Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjb2Y2bTVpBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEyODY5MDI1MjU->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/94418;_ylc=X3oDMTM0MTZkdG
NmBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5ND
QyMARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEyODY5MDI1MjUEdHBjSWQDOTQ0MTg-> (2)

Recent Activity:

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdXJjZmE4BF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEyODY5MDI1MjU->

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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJiN2RnNmwwBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTI4NjkwM
jUyNQ-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com
<mailto:vantage-traditional%40yahoogroups.com>
<mailto:vantage-traditional%40yahoogroups.com>?subject=Change%20Delivery
%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com
<mailto:vantage-digest%40yahoogroups.com>
<mailto:vantage-digest%40yahoogroups.com>?subject=Email%20Delivery:%20Di
ges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe%40yahoogroups.com>
<mailto:vantage-unsubscribe%40yahoogroups.com>?subject=Unsubscribe> *
Terms of Use <http://docs.yahoo.com/info/terms/>

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

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





[Non-text portions of this message have been removed]
8
That sounds like bad data, not data corruption or a corrupted database.

Re-installing Epicor won't fix a corrupted database or bad data.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
liss_c
Sent: Tuesday, October 12, 2010 2:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Corrupted Progress database

Hi Tamara/Mark,

What do you mean by corrupted? We also think our DB is corrupted because
when we apply fixes or patches in Test we dont get the same results in Live.
Also, Live DB seems to create random errors in the credit card processing,
allocation of materials etc.

I am trying to determine if our DV (SQL) is corrupted so we can decide if we
should reinstall epicor.

--- In vantage@yahoogroups.com, "Tamara Blatny" <tblatny@...> wrote:
>
> Hello!
>
>
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
>
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.
>
> So, I wanted to ask this group if they have any suggestions. My
> hardware on the server is fine. Of course, I have the antivirus
> excluding the epicor folder and my backup software is not touching
> Epicor. So, what else could be the cause?
>
>
>
> Thank you so much for your input on this crucial 'whodunit' scenario!
>
>
>
> Tamara
>
>
>
> Tamara Blatny
>
> Network Administrator
>
> Gasket Engineering Co., Inc.
>
> tblatny@... <mailto:tblatny@...>
>
> 816.363.8333 x108
>
>
>
>
> ######################################################################
> ###############
>
> Scanned by MailMarshal - Marshal's comprehensive email content security
solution.
> Download a free evaluation of MailMarshal at www.marshal.com
>
> ######################################################################
> ###############
>
>
> [Non-text portions of this message have been removed]
>




------------------------------------

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/linksYahoo! Groups Links
9
My gut instinct is telling me that you had a something wrong with a hard
drive at some point, which caused a write error.

Your best bet to try to recover the most recent version of your data would
be to try to do a dump and load on the database where it sits now, although
the fact that you tried to restore multiple backups til you found one that
works makes me think you aren't able to do that since it probably over wrote
that copy that wasn't working in the first place.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tamara Blatny
Sent: Tuesday, October 12, 2010 1:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Corrupted Progress database

Without any warnings in our log file...our database stopped itself and
showed this in the mfgsys.lg file:



The last backup was not completed successfully. (1553)

SYSTEM ERROR: read wrong dbkey at offset 2351448064 in file
C:\epicor\mfgsys61\db\mfgsys.d1 retrying (9445)

Corrupt block detected when reading from database (4229)

bkRead: Error occurred in area 6, block number 574083, (10560)

Writing block 574083 to log file. Please save and send log file to Progress
software Corp. for investigation. (10561)



Our database stopped running and wouldn't start back up.

The log file was saying corrupt file. Then, when Vantage tech support tried
to Restore from my backup. The restore process would only go so far then
stop. So, tech support told me that our backups were damaged
or corrupted as well. We lost a lot of data, because the last valid
backup that would restore was 3 weeks ago.



The log file never said unsuccessful backup until the last 2 days before it
shut down.

Leading up to the complete shut down of dB, the database automatically shut
itself down twice, the first time I went into Progress Explorer Tool and
click Start and it started right up without errors in the log file. The 2nd
time, it didn't start up.



We haven't updated our dB via ODBC.



Thank you for your help!

Tamara

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, October 12, 2010 11:34 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Corrupted Progress database





Hi Tamara,
>
> What could cause a Progress database to become corrupted?
>
> We are on Vantage 6.1, Progress 9.1D platform
>
> I've gone to technical support and they can't prove why our dB became
> corrupted.

And what do they mean by corrupted? Does it not start? Do the Progress tools
tell you there's corruption or are they saying that the values inside of
your database won't work with Vantage? Do you update your database via ODBC?

Mark W.



Reply to sender
<mailto:mark_wonsil@...?subject=Re:%20%5bVantage%5d%20Corrupted%20
Progress%20database> | Reply to group
<mailto:vantage@yahoogroups.com?subject=Re:%20%5bVantage%5d%20Corrupted%
20Progress%20database> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJvYWw5bDVsBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5NDQyMARzZWM
DZnRyBHNsawNycGx5BHN0aW1lAzEyODY5MDI1MjU-?act=reply&messageNum=94420> |
Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjb2Y2bTVpBF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEyODY5MDI1MjU->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/94418;_ylc=X3oDMTM0MTZkdG
NmBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAM5ND
QyMARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEyODY5MDI1MjUEdHBjSWQDOTQ0MTg-> (2)


Recent Activity:

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdXJjZmE4BF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEyODY5MDI1MjU->

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/.
<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

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJiN2RnNmwwBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTI4NjkwM
jUyNQ-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com?subject=Change%20Delivery%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com?subject=Email%20Delivery:%20Diges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe> * Terms of
Use <http://docs.yahoo.com/info/terms/>



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



------------------------------------

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/linksYahoo! Groups Links