Need Progress DB recovery

Yahoo Archive
1
I'm sure that everybody would appreciate your solution.

--sf

--- In vantage@yahoogroups.com, xorone <xorone@...> wrote:
>
> Thanks... Epicor support came thru!  It appears we have a stable & usable DB again.
> Chris
>
> --- On Fri, 5/27/11, sanfranc415 <sanfranc415@...> wrote:
>
> From: sanfranc415 <sanfranc415@...>
> Subject: [Vantage] Re: Need Progress DB recovery
> To: vantage@yahoogroups.com
> Date: Friday, May 27, 2011, 1:56 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ÂÂ
>
>
>
>
>
>
>
>
>
> Have you tried manually deleting the offended Index record? You may also want to consult with the Progress Forum at: http://www.progresstalk.com/forumdisplay.php?37-Database-Admin
>
>
>
> --- In vantage@yahoogroups.com, Christopher Heins <cheins@> wrote:
>
> >
>
> > There should be some info on the Progress KBase for fixing this sort of thing, especially if you have the RECID, you can locate the offending records and dump around them without reading through the index.
>
> >
>
> > Looks like there is an Index fix utility available now too, I haven't tried that.
>
> >
>
> > http://progress.atgnow.com/esprogress/categoryBrowse.do
>
> >
>
> > try "corrupt index" in the search, and "RECID" in must have words.
>
> >
>
> > Entry P106594 looks promising!
>
> >
>
> > Good Luck!
>
> >
>
> > Christopher Heins
>
> > Progress Programmer/Analyst
>
> > [cid:image001.png@]
>
> > Cell# 908-256-3662
>
> > cheins@<mailto:cheins@>
>
> >
>
> >
>
> > ________________________________
>
> >
>
> > NOT INTENDED AS A SUBSTITUTE FOR A WRITING
>
> >
>
> > NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
>
> > This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
> > __________________________________________________________
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Anybody know of anyone who would or could reconstruct a corrupt Progress database?
3
I've done it once or twice. What happened?

On Thu, May 26, 2011 at 1:22 PM, George C <xorone@...> wrote:

>
>
> Anybody know of anyone who would or could reconstruct a corrupt Progress
> database?
>
>
>


[Non-text portions of this message have been removed]
4
Don't really know, Epicor thinks it was bad hardware. We've switched servers, and they tried to get it up, but in doing an IDXBUILD we get 29 errors. .LG file shows problems like "System Error: Index in Char03 in MfgCube for recid 18804040 could not be deleted". Not sure how to proceed at this point, been down for 11 days.


--- On Thu, 5/26/11, Waffqle <waffqle@...> wrote:

> From: Waffqle <waffqle@...>
> Subject: Re: [Vantage] Need Progress DB recovery
> To: vantage@yahoogroups.com
> Date: Thursday, May 26, 2011, 1:27 PM
> I've done it once or twice. What
> happened?
>
> On Thu, May 26, 2011 at 1:22 PM, George C <xorone@...>
> wrote:
>
> >
> >
> > Anybody know of anyone who would or could reconstruct
> a corrupt Progress
> > database?
> >
> >Â
> >
>
>
> [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/.%c2%a0
> (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
>
>
> Â Â vantage-fullfeatured@yahoogroups.com
>
>
>
5
Have you tried doing a data dump and load first? Or am I missing a comment and this is what you are trying to do already?

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of xorone
Sent: Thursday, May 26, 2011 11:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Need Progress DB recovery



Don't really know, Epicor thinks it was bad hardware. We've switched servers, and they tried to get it up, but in doing an IDXBUILD we get 29 errors. .LG file shows problems like "System Error: Index in Char03 in MfgCube for recid 18804040 could not be deleted". Not sure how to proceed at this point, been down for 11 days.

--- On Thu, 5/26/11, Waffqle <waffqle@...<mailto:waffqle%40gmail.com>> wrote:

> From: Waffqle <waffqle@...<mailto:waffqle%40gmail.com>>
> Subject: Re: [Vantage] Need Progress DB recovery
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Date: Thursday, May 26, 2011, 1:27 PM
> I've done it once or twice. What
> happened?
>
> On Thu, May 26, 2011 at 1:22 PM, George C <xorone@...<mailto:xorone%40yahoo.com>>
> wrote:
>
> >
> >
> > Anybody know of anyone who would or could reconstruct
> a corrupt Progress
> > database?
> >
> >
> >
>
>
> [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/.<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
>
>
> vantage-fullfeatured@yahoogroups.com<mailto:vantage-fullfeatured%40yahoogroups.com>
>
>
>



[Non-text portions of this message have been removed]
6
What about your backup. Couldn't you restore from a previous backup? Is that why you are thinking it a hardware problem. Just curious.

--- In vantage@yahoogroups.com, xorone <xorone@...> wrote:
>
> Don't really know, Epicor thinks it was bad hardware. We've switched servers, and they tried to get it up, but in doing an IDXBUILD we get 29 errors. .LG file shows problems like "System Error: Index in Char03 in MfgCube for recid 18804040 could not be deleted". Not sure how to proceed at this point, been down for 11 days.
>
>
> --- On Thu, 5/26/11, Waffqle <waffqle@...> wrote:
>
> > From: Waffqle <waffqle@...>
> > Subject: Re: [Vantage] Need Progress DB recovery
> > To: vantage@yahoogroups.com
> > Date: Thursday, May 26, 2011, 1:27 PM
> > I've done it once or twice. What
> > happened?
> >
> > On Thu, May 26, 2011 at 1:22 PM, George C <xorone@...>
> > wrote:
> >
> > >
> > >
> > > Anybody know of anyone who would or could reconstruct
> > a corrupt Progress
> > > database?
> > >
> > >Â
> > >
> >
> >
> > [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/.%c2%a0
> > (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
> >
> >
> > Â Â vantage-fullfeatured@yahoogroups.com
> >
> >
> >
>
7
Dump and load seems to put our data back to May of 2010.   Some of the backups we had restored but would not startup others had CRC errors. Â
--- On Thu, 5/26/11, randyduly <randy.duly@...> wrote:

From: randyduly <randy.duly@...>
Subject: [Vantage] Re: Need Progress DB recovery
To: vantage@yahoogroups.com
Date: Thursday, May 26, 2011, 2:28 PM
















Â









What about your backup. Couldn't you restore from a previous backup? Is that why you are thinking it a hardware problem. Just curious.



--- In vantage@yahoogroups.com, xorone <xorone@...> wrote:

>

> Don't really know, Epicor thinks it was bad hardware. We've switched servers, and they tried to get it up, but in doing an IDXBUILD we get 29 errors. .LG file shows problems like "System Error: Index in Char03 in MfgCube for recid 18804040 could not be deleted". Not sure how to proceed at this point, been down for 11 days.

>

>

> --- On Thu, 5/26/11, Waffqle <waffqle@...> wrote:

>

> > From: Waffqle <waffqle@...>

> > Subject: Re: [Vantage] Need Progress DB recovery

> > To: vantage@yahoogroups.com

> > Date: Thursday, May 26, 2011, 1:27 PM

> > I've done it once or twice. What

> > happened?

> >

> > On Thu, May 26, 2011 at 1:22 PM, George C <xorone@...>

> > wrote:

> >

> > >

> > >

> > > Anybody know of anyone who would or could reconstruct

> > a corrupt Progress

> > > database?

> > >

> > >Â

> > >

> >

> >

> > [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/.%c2%a0

> > (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

> >

> >

> > Â Â vantage-fullfeatured@yahoogroups.com

> >

> >

> >

>



























[Non-text portions of this message have been removed]
8
There should be some info on the Progress KBase for fixing this sort of thing, especially if you have the RECID, you can locate the offending records and dump around them without reading through the index.

Looks like there is an Index fix utility available now too, I haven't tried that.

http://progress.atgnow.com/esprogress/categoryBrowse.do

try "corrupt index" in the search, and "RECID" in must have words.

Entry P106594 looks promising!

Good Luck!

Christopher Heins
Progress Programmer/Analyst
[cid:image001.png@01CC1BC5.771A47A0]
Cell# 908-256-3662
cheins@...<mailto:cheins@...>


________________________________

NOT INTENDED AS A SUBSTITUTE FOR A WRITING

NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
______________________________________________________________


[Non-text portions of this message have been removed]
9
Have you tried manually deleting the offended Index record? You may also want to consult with the Progress Forum at: http://www.progresstalk.com/forumdisplay.php?37-Database-Admin

--- In vantage@yahoogroups.com, Christopher Heins <cheins@...> wrote:
>
> There should be some info on the Progress KBase for fixing this sort of thing, especially if you have the RECID, you can locate the offending records and dump around them without reading through the index.
>
> Looks like there is an Index fix utility available now too, I haven't tried that.
>
> http://progress.atgnow.com/esprogress/categoryBrowse.do
>
> try "corrupt index" in the search, and "RECID" in must have words.
>
> Entry P106594 looks promising!
>
> Good Luck!
>
> Christopher Heins
> Progress Programmer/Analyst
> [cid:image001.png@...]
> Cell# 908-256-3662
> cheins@...<mailto:cheins@...>
>
>
> ________________________________
>
> NOT INTENDED AS A SUBSTITUTE FOR A WRITING
>
> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
> This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> ______________________________________________________________
>
>
> [Non-text portions of this message have been removed]
>
10
Thanks... Epicor support came thru! Â It appears we have a stable & usable DB again.
Chris

--- On Fri, 5/27/11, sanfranc415 <sanfranc415@...> wrote:

From: sanfranc415 <sanfranc415@...>
Subject: [Vantage] Re: Need Progress DB recovery
To: vantage@yahoogroups.com
Date: Friday, May 27, 2011, 1:56 PM
















Â









Have you tried manually deleting the offended Index record? You may also want to consult with the Progress Forum at: http://www.progresstalk.com/forumdisplay.php?37-Database-Admin



--- In vantage@yahoogroups.com, Christopher Heins <cheins@...> wrote:

>

> There should be some info on the Progress KBase for fixing this sort of thing, especially if you have the RECID, you can locate the offending records and dump around them without reading through the index.

>

> Looks like there is an Index fix utility available now too, I haven't tried that.

>

> http://progress.atgnow.com/esprogress/categoryBrowse.do

>

> try "corrupt index" in the search, and "RECID" in must have words.

>

> Entry P106594 looks promising!

>

> Good Luck!

>

> Christopher Heins

> Progress Programmer/Analyst

> [cid:image001.png@...]

> Cell# 908-256-3662

> cheins@...<mailto:cheins@...>

>

>

> ________________________________

>

> NOT INTENDED AS A SUBSTITUTE FOR A WRITING

>

> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.

> This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

> __________________________________________________________

>

>

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

>



























[Non-text portions of this message have been removed]
11
I am not sure if this is relevant to your question…

Back in version 6.1, I witnessed a database get corrupted due to hiding the share from users. The database was acting strangely. Fortunately, an online backup was made prior to rebooting the server. When the server came backup, the database would not start and was corrupted. The database was recovered from the backup and all was well.

Bruce Butler, IS Manager

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of xorone
Sent: Friday, May 27, 2011 4:39 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Need Progress DB recovery



Thanks... Epicor support came thru! It appears we have a stable & usable DB again.
Chris

--- On Fri, 5/27/11, sanfranc415 <sanfranc415@...<mailto:sanfranc415%40yahoo.com>> wrote:

From: sanfranc415 <sanfranc415@...<mailto:sanfranc415%40yahoo.com>>
Subject: [Vantage] Re: Need Progress DB recovery
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Date: Friday, May 27, 2011, 1:56 PM



Have you tried manually deleting the offended Index record? You may also want to consult with the Progress Forum at: http://www.progresstalk.com/forumdisplay.php?37-Database-Admin

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Christopher Heins <cheins@...> wrote:

>

> There should be some info on the Progress KBase for fixing this sort of thing, especially if you have the RECID, you can locate the offending records and dump around them without reading through the index.

>

> Looks like there is an Index fix utility available now too, I haven't tried that.

>

> http://progress.atgnow.com/esprogress/categoryBrowse.do

>

> try "corrupt index" in the search, and "RECID" in must have words.

>

> Entry P106594 looks promising!

>

> Good Luck!

>

> Christopher Heins

> Progress Programmer/Analyst

> [cid:image001.png@...]

> Cell# 908-256-3662

> cheins@...<mailto:cheins@...>

>

>

> ________________________________

>

> NOT INTENDED AS A SUBSTITUTE FOR A WRITING

>

> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.

> This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

> __________________________________________________________

>

>

> [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]