Possible db corrupt after restoral , help please.!

system · February 6, 2007, 11:11am

Gerard Wadman wrote:

> With regard to the Virus, I had voiced concern to Epicor about excluding
> the Epicor directory from AV scanning especially since that folder has
> to be shared with full control to everyone.

You don't say what version you're running, but you most likely DO NOT
need the directory open for writing. It's a completely bogus urban
legend that's been rampant in the Vantage community for years. All the
database transactions are handled through the tcp port you designate for
each Progress DB; NOT through the windoze share. The typical user just
needs read-only to all the Vantage code.

In years past, it seemed that Epicor had their tech support guys each
running their own copy of Vantage and Progress in single-user mode on
their own workstations; in that scenario, it does go through the file
system and needs it writable. However, the guys seemed totally ignorant
of how Progress worked multi-user, and would tell you it needed write
access. Not true.

I haven't had my hands on version 8 or recent, so maybe something has
changed. But in a Progress environment, I doubt it. Worst case, there
are probably only a select few directories that need write access --
certainly not the one with the DB files.

-Wayne

system · February 2, 2007, 3:54am

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@...

system · February 2, 2007, 8:36am

Try the all switch

PROUTIL mfgsys -C IDXBUILD ALL

Also if you only want to rebuild the "idxOrderhedOrderdate" index use
the following:

PROUTIL mfgsys -C IDXBUILD TABLE pub. idxOrderhedOrderdate

One other thing to consider is to run CHKDSK on the drive where your DB
is located, if CHKDSK finds any errors.

If so you can attempt to run it again with the /R switch, this will
attempt to recover any readable data and place it on a known good
sector.

It has also been my experience that when you are having DB issues, you
will find better advise in the progress knowledge center than you can
get from Epicor.

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

You can also call progress technical support.

But you may be required to purchase a maintenance agreement, (I'm not
sure if they offer support per incident)

Progress Software Corporation
14 Oak Park Drive
Bedford, MA 01730
Tel: 1 781 280-4999

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>

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

system · February 2, 2007, 8:46am

Do you have a backup of your Progress directory and your Vantage
directory? You could restore those and then restore your database.
Sounds more like a program problem then a data problem. Virus probably
did some damage to the Vantage programs related to order entry.

Todd

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, February 02, 2007 8:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Try the all switch

PROUTIL mfgsys -C IDXBUILD ALL

Also if you only want to rebuild the "idxOrderhedOrderdate" index use
the following:

PROUTIL mfgsys -C IDXBUILD TABLE pub. idxOrderhedOrderdate

One other thing to consider is to run CHKDSK on the drive where your DB
is located, if CHKDSK finds any errors.

If so you can attempt to run it again with the /R switch, this will
attempt to recover any readable data and place it on a known good
sector.

It has also been my experience that when you are having DB issues, you
will find better advise in the progress knowledge center than you can
get from Epicor.

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

You can also call progress technical support.

But you may be required to purchase a maintenance agreement, (I'm not
sure if they offer support per incident)

Progress Software Corporation
14 Oak Park Drive
Bedford, MA 01730
Tel: 1 781 280-4999

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

system · February 2, 2007, 9:12am

With regard to the Virus, I had voiced concern to Epicor about excluding
the Epicor directory from AV scanning especially since that folder has
to be shared with full control to everyone.

I followed Epicor's recommendation and excluded it against my better
judgment, now after reading this I think I'll remove that exclusion
performance be damned.

You can also bet that even though Epicor recommended you exclude the
Epicor folder from real time protection, they will take no
responsibility for the potential disasters that can result from such an
act.

I'm assuming that this virus of yours is relatively new and therefore I
would advise all members on this list to make sure they are not infected
with the same thing.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Friday, February 02, 2007 8:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Do you have a backup of your Progress directory and your Vantage
directory? You could restore those and then restore your database.
Sounds more like a program problem then a data problem. Virus probably
did some damage to the Vantage programs related to order entry.

Todd

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Friday, February 02, 2007 8:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Try the all switch

PROUTIL mfgsys -C IDXBUILD ALL

Also if you only want to rebuild the "idxOrderhedOrderdate" index use
the following:

PROUTIL mfgsys -C IDXBUILD TABLE pub. idxOrderhedOrderdate

One other thing to consider is to run CHKDSK on the drive where your DB
is located, if CHKDSK finds any errors.

If so you can attempt to run it again with the /R switch, this will
attempt to recover any readable data and place it on a known good
sector.

It has also been my experience that when you are having DB issues, you
will find better advise in the progress knowledge center than you can
get from Epicor.

http://progress.atgnow.com/esprogress/results.do
<http://progress.atgnow.com/esprogress/results.do>

You can also call progress technical support.

But you may be required to purchase a maintenance agreement, (I'm not
sure if they offer support per incident)

Progress Software Corporation
14 Oak Park Drive
Bedford, MA 01730
Tel: 1 781 280-4999

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

________________________________

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 jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

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

system · February 2, 2007, 10:13am

Jonathan,

Here is a follow up to your issue. If you have corrupted
indexes, the IDXBUILD option will fail without generating a failure
message. If rebuilding Indexes doesn't work, you will need to perform a
dump and load to correct the problem but you will also need to run the
following procedure outlined by Progress before proceeding with the D &
L:

Dumping tables from a damaged database

Occasionally, data is damaged and the index rebuild utility does not
work. When this happens, you can use the following Progress 4GL
procedure to dump the data in a table called item. The p-dump.p
procedure runs slowly on large databases. Use it only when you cannot
use the Index Rebuild utility:

p-dump.p

DEFINE VARIABLE i AS INTEGER.

FIND _file "item".

OUTPUT TO item.d.

DO i = 1 TO 10000:

FIND item WHERE RECID(item) = i NO-ERROR.

IF AVAILABLE item AND i <> INTEGER(_file._template)

THEN EXPORT item.

END.

In this procedure, data from the item table is dumped into the item.d
file. Use the item.d file with the reload procedure. For more
information on loading, see "Dumping and Loading."
<http://progress.atgnow.com/esprogress/docs/Progress/esupport.progress.c
om/EDocHTML/OpenEdge/10.0B/dmadm/dmadm-12-1.html>

In the p-dump.p procedure, you must set the end value for the DO block
high enough (10,000 in the previous example procedure) so that every
record in the database is examined. Calculate a safe value using the
following formula:

100 + 32 (database-size-in-bytes / database-block-size)

The database block size varies among systems. Use the PROSTRCT
STATISTICS utility to determine the database block size for your system.

Good Luck,

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>

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

system · February 4, 2007, 1:20am

This was a new virus, W32.Fujacks.E . We caught it a day or so after it was identified by Symantec.

Gerard Wadman <gwadman@...> wrote: With regard to the Virus, I had voiced concern to Epicor about excluding
the Epicor directory from AV scanning especially since that folder has
to be shared with full control to everyone.

I followed Epicor's recommendation and excluded it against my better
judgment, now after reading this I think I'll remove that exclusion
performance be damned.

You can also bet that even though Epicor recommended you exclude the
Epicor folder from real time protection, they will take no
responsibility for the potential disasters that can result from such an
act.

I'm assuming that this virus of yours is relatively new and therefore I
would advise all members on this list to make sure they are not infected
with the same thing.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Friday, February 02, 2007 8:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Do you have a backup of your Progress directory and your Vantage
directory? You could restore those and then restore your database.
Sounds more like a program problem then a data problem. Virus probably
did some damage to the Vantage programs related to order entry.

Todd

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Friday, February 02, 2007 8:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Try the all switch

PROUTIL mfgsys -C IDXBUILD ALL

Also if you only want to rebuild the "idxOrderhedOrderdate" index use
the following:

PROUTIL mfgsys -C IDXBUILD TABLE pub. idxOrderhedOrderdate

One other thing to consider is to run CHKDSK on the drive where your DB
is located, if CHKDSK finds any errors.

If so you can attempt to run it again with the /R switch, this will
attempt to recover any readable data and place it on a known good
sector.

It has also been my experience that when you are having DB issues, you
will find better advise in the progress knowledge center than you can
get from Epicor.

http://progress.atgnow.com/esprogress/results.do
<http://progress.atgnow.com/esprogress/results.do>

You can also call progress technical support.

But you may be required to purchase a maintenance agreement, (I'm not
sure if they offer support per incident)

Progress Software Corporation
14 Oak Park Drive
Bedford, MA 01730
Tel: 1 781 280-4999

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

________________________________

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 jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

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

---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.

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

system · February 5, 2007, 10:51am

Yes we have separate backups and will also try this.

Thank you.

JD

Todd Hofert <todd@...> wrote:
Do you have a backup of your Progress directory and your Vantage
directory? You could restore those and then restore your database.
Sounds more like a program problem then a data problem. Virus probably
did some damage to the Vantage programs related to order entry.

Todd

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, February 02, 2007 8:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Possible db corrupt after restoral , help
please.!

Try the all switch

PROUTIL mfgsys -C IDXBUILD ALL

Also if you only want to rebuild the "idxOrderhedOrderdate" index use
the following:

PROUTIL mfgsys -C IDXBUILD TABLE pub. idxOrderhedOrderdate

One other thing to consider is to run CHKDSK on the drive where your DB
is located, if CHKDSK finds any errors.

If so you can attempt to run it again with the /R switch, this will
attempt to recover any readable data and place it on a known good
sector.

It has also been my experience that when you are having DB issues, you
will find better advise in the progress knowledge center than you can
get from Epicor.

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

You can also call progress technical support.

But you may be required to purchase a maintenance agreement, (I'm not
sure if they offer support per incident)

Progress Software Corporation
14 Oak Park Drive
Bedford, MA 01730
Tel: 1 781 280-4999

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jonathan9962003
Sent: Friday, February 02, 2007 3:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Possible db corrupt after restoral , help please.!

A few days ago we had a virus on our server in our mapped Vantage
folders, (vers 6.1). After cleaning the server was restarted and we
lost use of Vantage but it was working without issue up to re-start.
We restored recent back up and all appeared to be working but found
that we are no longer able to to enter a new sales order. The
following message appears after a customer is selected and OK is
entered.

"COMXref Company "MJLS" File "idxOrderhedOrderdate" Key1 "1212"
Key2 "JMD" Key3 "",(132)

Epicor suggested running:

PROUTIL mfgsys -C IDXCHECK
and if corrupt indexes found then run
PROUTIL mfgsys -C IDXBUILD

This has been done but no result.

Anyone have this problems before?

Many thanks

Jonathan Dickinson
SMJL China
jdickinson@... <mailto:jdickinson%40rsadesign.com.cn>
<mailto:jdickinson%40rsadesign.com.cn>

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

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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

---------------------------------
Access over 1 million songs - Yahoo! Music Unlimited.

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