New Epicor9 (progress 10.2a) install - AppServer crashed due to

Yahoo Archive
1

Bruce, thanks so much for the help, I really appreciate it…

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 3:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

If you can access Epicweb, look for these answerbooks:

6983MPS

1452BRK

Here is a summary of some basic manual routine maintenance.

I'd suggest practicing on a test system before doing anything on your production server.

If you are interested, I also have some examples of bat files that automate some of this

And there are some sample bats in the files section of this group.

 

1.       Backup the database “A” -  ProENV

                                Command:     probkup online mfgsys TodaysDateA.bak

               

2.       Run Conversion programs - Admin Tools

                                6430 Recalculate Part OnHand/Allocation Summaries (run report, if blank move to next conversion)

                                7195 Fix PlantWhse, PartPlant and PartWhse Records

                                9527 Recalculate customer credit totals.

 

3.       Maintain Sessions  - Admin Tools

                                - Delete stale logons

 

4.       Stop the appservers and database

 

5.       Truncate the database - ProEnv

                                command:  proutil mfgsys -C truncate bi

 

6.       Repair the database - ProEnv

                                command:  prostrct repair mfgsys

 

7.       Optional - Rebuild the Indexes – ProEnv ( approximately 15 minutes runtime - your mileage may vary )

                                command:  proutil  mfgsys -C idxbuild  -TB 32 -TM 32

                                                                ----  Press "a" for ALL from the pop-up menu.

                                                                ----  Answer "n" for No to  "Do you have enough space for index sorting? (y/n)"

                               

8.       Backup the database “B” - ProEnv

                                command:   probkup mfgsys TodaysDateB.bak

 

9.       Clear out stale work files – Batch file

                                - 02_Delete_FM.bat (with database and appservers stopped)

 

10.    Clear log and email log files - Batch file

                                 - 04_Copy_Logs_FM.bat

               

11.    Stop OpenEdge service and Reboot

 

 

 

2

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going.  The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).   Anyone ever heard of a bad backup causing the main appserver to crash on Epicor???  I have no clue other than that as to what happened.  It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

3
I wonder if killing the task somehow put the DB in a bad state.... or if killing the task actually killed the proapsrv...Â


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Mon, Feb 15, 2016 at 10:27 AM, Mike Abell mabell@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going. The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).  Anyone ever heard of a bad backup causing the main appserver to crash on Epicor??? I have no clue other than that as to what happened. It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

Â

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:Â Â Â +1 931 432 8408
Fax:Â Â Â Â Â Â Â +1 931 432 1889
Mail:Â Â Â Â Â Â Â mabell@...
Website:Â http://www.flexial.com
              http://www.boagroup.com

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

4

What would be the proper way to kill the backup process if it goes out of control????

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 9:38 AM
To: Vantage
Subject: Re: [Vantage] New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

I wonder if killing the task somehow put the DB in a bad state.... or if killing the task actually killed the proapsrv... 



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Mon, Feb 15, 2016 at 10:27 AM, Mike Abell mabell@... [vantage] <vantage@yahoogroups.com> wrote:

 

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going.  The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).   Anyone ever heard of a bad backup causing the main appserver to crash on Epicor???  I have no clue other than that as to what happened.  It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

 

5

Mike,

 

I’m running 9.05.702 on progress.

Below are my scripts. I have not had a crash because of backing up the progress db.

I run the below script at night and a duplicate copy to a duplicate backup at noon each day.

Hope this helps.

 

Patrick Winter

 

bkup9_1.bat

echo Running Backup...

@echo off

D:

cd \Epicor\oe102a\bin

bkup905700c_1 online E:\epicor\db\mfgsys D:\backup\backup1

 

 

 

bkup905700c_1.bat

if "%DLC%"==""    set DLC=D:\epicor\oe102a

type %DLC%\version > D:\backup\backup905700c_1.wri

 

if "%1" == "online" goto Online

if "%1" == "ONLINE" goto Online

 

:Offline

_dbutil probkup %1 %2 %3 %4 %5 %6 %7 %8 %9 >> D:\backup\back905700c_1.wri

prorest %2 %3 -vp >> D:\backup\backup905700c_1.wri

GOTO End

 

:Online

_mprshut %2 -C backup online %3 %4 %5 %6 %7 %8 %9 >> D:\backup\backup905700c_1.wri

prorest %2 %3 %4 %5 -vp >> D:\backup\backup905700c_1.wri

 

:End

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 09:28
To: vantage@yahoogroups.com
Subject: [Vantage] New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going.  The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).   Anyone ever heard of a bad backup causing the main appserver to crash on Epicor???  I have no clue other than that as to what happened.  It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  
6
I assume your backup is just a batch file running probkup online?
- and no other AV/Backup software is hitting the database directory

Could your bi file have been larger then normal at the time?

I've recently seen some problems with my online backups after someone had run a bad query.
After truncating the bi file & things went back to normal.
Online backups can take a long time and result in "no server..." messages when the bi file is big.
7

Patrick, thanks…..My backup .bat file looks very similar to your bkup9_1.bat script (see mine below).  It runs at 1:30 am each morning and that’s all I do.  However, I’m not getting what your other script does….Can you elaborate??

 

Here’s mine…

 

echo Running Backup...

rem @echo off

cd c:\epicor\oe102a\bin

probkup online C:\epicor\epicor905\db\mfgsys c:\backup\epicor9_epicor9_a.1

 

 

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 9:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

Mike,

 

I’m running 9.05.702 on progress.

Below are my scripts. I have not had a crash because of backing up the progress db.

I run the below script at night and a duplicate copy to a duplicate backup at noon each day.

Hope this helps.

 

Patrick Winter

 

bkup9_1.bat

echo Running Backup...

@echo off

D:

cd \Epicor\oe102a\bin

bkup905700c_1 online E:\epicor\db\mfgsys D:\backup\backup1

 

 

 

bkup905700c_1.bat

if "%DLC%"==""    set DLC=D:\epicor\oe102a

type %DLC%\version > D:\backup\backup905700c_1.wri

 

if "%1" == "online" goto Online

if "%1" == "ONLINE" goto Online

 

:Offline

_dbutil probkup %1 %2 %3 %4 %5 %6 %7 %8 %9 >> D:\backup\back905700c_1.wri

prorest %2 %3 -vp >> D:\backup\backup905700c_1.wri

GOTO End

 

:Online

_mprshut %2 -C backup online %3 %4 %5 %6 %7 %8 %9 >> D:\backup\backup905700c_1.wri

prorest %2 %3 %4 %5 -vp >> D:\backup\backup905700c_1.wri

 

:End

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 09:28
To: vantage@yahoogroups.com
Subject: [Vantage] New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going.  The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).   Anyone ever heard of a bad backup causing the main appserver to crash on Epicor???  I have no clue other than that as to what happened.  It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  

8

Gives you a little summary wri file.

 

Patrick Winter

 

OpenEdge Release 10.2A0329  as of Thu Apr 19 10:03:06 EDT 2012

 

3046140 active blocks out of 3046143 blocks in E:\epicor\db\mfgsys will be dumped. (6686)

16384 BI blocks will be dumped. (6688)

Backup requires an

estimated 11.9 GBytes of media. (9285)

Restore would require an estimated 3117928 db blocks using 3.0M of media. (9286)

Backed up 3062524 db blocks in

00:27:23

Wrote a total of 91702 backup blocks using 11.9 GBytes of media. (13625)

 

Backup complete. (3740)

 

OpenEdge Release 10.2A0329  as of Thu Apr 19

10:03:06 EDT 2012

This is a full backup of E:\epicor\db\mfgsys.db. (6759)

This backup was taken Sat Feb 13 12:06:07 2016. (6760)

The blocksize is 4096. (6994)

Partial

verification successfully read backup volume. (6765)

Verify pass started. (3751)

Verified 3062524 db blocks in 00:01:19

Backup for E:\epicor\db

\mfgsys.db verified ok. (6758)

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 10:05
To: vantage@yahoogroups.com
Subject: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

Patrick, thanks…..My backup .bat file looks very similar to your bkup9_1.bat script (see mine below).  It runs at 1:30 am each morning and that’s all I do.  However, I’m not getting what your other script does….Can you elaborate??

 

Here’s mine…

 

echo Running Backup...

rem @echo off

cd c:\epicor\oe102a\bin

probkup online C:\epicor\epicor905\db\mfgsys c:\backup\epicor9_epicor9_a.1

 

 

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 9:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

Mike,

 

I’m running 9.05.702 on progress.

Below are my scripts. I have not had a crash because of backing up the progress db.

I run the below script at night and a duplicate copy to a duplicate backup at noon each day.

Hope this helps.

 

Patrick Winter

 

bkup9_1.bat

echo Running Backup...

@echo off

D:

cd \Epicor\oe102a\bin

bkup905700c_1 online E:\epicor\db\mfgsys D:\backup\backup1

 

 

 

bkup905700c_1.bat

if "%DLC%"==""    set DLC=D:\epicor\oe102a

type %DLC%\version > D:\backup\backup905700c_1.wri

 

if "%1" == "online" goto Online

if "%1" == "ONLINE" goto Online

 

:Offline

_dbutil probkup %1 %2 %3 %4 %5 %6 %7 %8 %9 >> D:\backup\back905700c_1.wri

prorest %2 %3 -vp >> D:\backup\backup905700c_1.wri

GOTO End

 

:Online

_mprshut %2 -C backup online %3 %4 %5 %6 %7 %8 %9 >> D:\backup\backup905700c_1.wri

prorest %2 %3 %4 %5 -vp >> D:\backup\backup905700c_1.wri

 

:End

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 09:28
To: vantage@yahoogroups.com
Subject: [Vantage] New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

We have been live on Epicor 9 for a few weeks now and about 2 weeks in, our server “crashed” early in the AM hours of the morning (main appserver said NO servers available) and I had to restart the whole thing to get it back going.  The only strange thing I could find was that a couple of hours or so before the crash was noticed, the nightly backup of the Progress db didn’t complete and I have the scheduled task to automatically terminate the process if it takes over an hour (it usually only takes 10 minutes or so for the backup to run).   Anyone ever heard of a bad backup causing the main appserver to crash on Epicor???  I have no clue other than that as to what happened.  It’s been fine since but we’ve only been live for a few weeks and it’s now got me a little concerned….

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.   ­­  

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
9
FYI... the backup bat below is an example I received from Epicor

@echo off

Rem  This is a batch file to backup your Progress 10.2A database
Rem  You will need one of these files for each database you want to backup
Rem  You will need to edit the SET statements for your installation
Rem  Do not edit anything other than the SET statements

Rem Edit below -----------------------------------------------

Rem  set your Progress directory, using only the physical path
SET XPrgsDir=d:\epicor\oe102A

Rem  set your Database file, using only the physical path
SET XDbFile=d:\epicor\Epicor905\db\mfgsys

Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=d:\epicor\backups\xxxxx.bak
SET XBackupLogFile=d:\epicor\backups\xxxxx.wri

Rem Do Not edit below -----------------------------------------

Rem Run backup

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%

Rem Run verification of backup

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%


Rem blank the variables out, since we are finished with them

SET XPrgsDir=""
SET XDbFile=""
SET XBackupFile=""
SET XBackupLogFile=""
10

Bruce, thanks for the script….Not sure what happened on mine that caused the APPServer to crash but I’m leaning toward what Jose said about the repercussions of me ending the backup task prematurely…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

FYI... the backup bat below is an example I received from Epicor

@echo off

Rem  This is a batch file to backup your Progress 10.2A database
Rem  You will need one of these files for each database you want to backup
Rem  You will need to edit the SET statements for your installation
Rem  Do not edit anything other than the SET statements

Rem Edit below -----------------------------------------------

Rem  set your Progress directory, using only the physical path
SET XPrgsDir=d:\epicor\oe102A

Rem  set your Database file, using only the physical path
SET XDbFile=d:\epicor\Epicor905\db\mfgsys

Rem set your backup file and backup log file, using only a physical path
SET XBackupFile=d:\epicor\backups\xxxxx.bak
SET XBackupLogFile=d:\epicor\backups\xxxxx.wri

Rem Do Not edit below -----------------------------------------

Rem Run backup

Call %XPrgsDir%\bin\probkup online %XDbFile% %XBackupFile% >> %XBackupLogFile%

Rem Run verification of backup

Call %XPrgsDir%\bin\prorest %XDbFile% %XBackupFile% -vp >> %XBackupLogFile%


Rem blank the variables out, since we are finished with them

SET XPrgsDir=""
SET XDbFile=""
SET XBackupFile=""
SET XBackupLogFile=""

11
>>Not sure what happened on mine that caused the APPServer to crash
>> repercussions of me ending the backup task
I've never had any backup getting stuck.
I've had online backups can take a long time and in worst cases interfere with end users.
but only when there is a large bi file.

So have not had to try stop in the middle of a backup.
I'm wondering what your steps were, used the task manager, what you ended, etc..?
12

Bruce, our backup runs as a “scheduled task” on Windows Server 2008 and in the task properties I have it set to “end” the task if it takes more than an hour.  Normally, our backup only takes 10 minutes to finish so I didn’t think it would be a problem.  I’ve now increased the time to 4 hours before it will try to end it.  But I DO now that for whatever reason the other night when this happened, the backup didn’t finish within the hour so the server killed it.    

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 1:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

>>Not sure what happened on mine that caused the APPServer to crash
>> repercussions of me ending the backup task

I've never had any backup getting stuck.
I've had online backups can take a long time and in worst cases interfere with end users.
but only when there is a large bi file.

So have not had to try stop in the middle of a backup.
I'm wondering what your steps were, used the task manager, what you ended, etc..?

13
Increasing the timeout should take care of it if it was just a large bi file.

BTW...
Besides long backup times, I've had a few other issues with a bi file size growing.
I had a couple cases where it just keep growing until some action was taken on the server.

I finally scheduled a daily bat file to email me if my average bi file size has been exceeded.
I know there are better utilities, my bat file is kind of hokey but it's been working for me.
14

Bruce, can you give me a lesson on how you check and adjust your bi file?    I’m a progress noob and I’m not sure what I should be looking for…

 

Best regards

Mike Abell

IT Manager

Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA

Phone:    +1 931 432 8408
Fax:        +1 931 432 1889
Mail:        mabell@...
Website:  http://www.flexial.com
               http://www.boagroup.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 15, 2016 1:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: New Epicor9 (progress 10.2a) install - AppServer crashed due to backup not running - anyone heard of this??

 

 

Increasing the timeout should take care of it if it was just a large bi file.

BTW...
Besides long backup times, I've had a few other issues with a bi file size growing.
I had a couple cases where it just keep growing until some action was taken on the server.

I finally scheduled a daily bat file to email me if my average bi file size has been exceeded.
I know there are better utilities, my bat file is kind of hokey but it's been working for me.

15

If you can access Epicweb, look for these answerbooks:

6983MPS

1452BRK


Here is a summary of some basic manual routine maintenance.

I’d suggest practicing on a test system before doing anything on your production server.

If you are interested, I also have some examples of bat files that automate some of this

And there are some sample bats in the files section of this group.

 

1.       Backup the database “A” -  ProENV

                                Command:     probkup online mfgsys TodaysDateA.bak

               

2.       Run Conversion programs - Admin Tools

                                6430 Recalculate Part OnHand/Allocation Summaries (run report, if blank move to next conversion)

                                7195 Fix PlantWhse, PartPlant and PartWhse Records

                                9527 Recalculate customer credit totals.

 

3.       Maintain Sessions  - Admin Tools

                                - Delete stale logons

 

4.       Stop the appservers and database

 

5.       Truncate the database - ProEnv

                                command:  proutil mfgsys -C truncate bi

 

6.       Repair the database - ProEnv

                                command:  prostrct repair mfgsys

 

7.       Optional - Rebuild the Indexes – ProEnv ( approximately 15 minutes runtime - your mileage may vary )

                                command:  proutil  mfgsys -C idxbuild  -TB 32 -TM 32

                                                                ----  Press "a" for ALL from the pop-up menu.

                                                                ----  Answer "n" for No to  "Do you have enough space for index sorting? (y/n)"

                               

8.       Backup the database “B” - ProEnv

                                command:   probkup mfgsys TodaysDateB.bak

 

9.       Clear out stale work files – Batch file

                                - 02_Delete_FM.bat (with database and appservers stopped)

 

10.    Clear log and email log files - Batch file

                                 - 04_Copy_Logs_FM.bat

               

11.    Stop OpenEdge service and Reboot