Build Project Analysis

Yahoo Archive
1

Just to give some ideas.


I decided yesterday to finally put together an automated BPA.  Whenever we run too many projects at once in a BPA it seems to error out so scheduling it didn't seem to work.  I figured i'd attach the BPA process to when we change the earliest apply date and its form.  We change it once a month so I just have a script to grab any projects within the last 32 days of the earliest apply date(my way of doing a dynamic date since it seems Epicor didn't put one in). Then it populates the ProjectList on the ProjAnalParam parameters with my projects as "Project-1~Project-2~Project-3 ect.." from the last 32 days using a BAQ and an Ultragrid that fills a table with any dates that fall into that criteria. 


I also went and put in a checkbox (or you could use a message prompt) on the earliest apply date form that needs to be checked when BPA will run so that if we do have to change the date on a whim it isn't running it every time.


I've been wanting to automate this for a while but wasn't quite sure on how.


Now I don't have to worry about myself or someone else having to take care of this or falling behind on running it.


I'm running 701 but it should work on most versions. No SDK required..


Good luck!

2
We are using Epicor 9.05.607A.

I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).

Has anybody else had this problem? How did you solve it?
3
I know there is an issue related to scheduling the build project analysis that is fixed in 700. Notice the schedule dropdown is empty when you try to select a schedule.



________________________________
From: Douglas <dgum@...>
To: vantage@yahoogroups.com
Sent: Wednesday, July 18, 2012 4:09 PM
Subject: [Vantage] Build Project Analysis

We are using Epicor 9.05.607A.

I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).

Has anybody else had this problem? How did you solve it?




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

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



[Non-text portions of this message have been removed]
4
Yes we are seeing this in 701. The build Project Analysis works ok on the actions menu item from within project entry, but not the menu version one in General Operations where you have thecapability to select all projects with out the filter. It is also very slow.
It can take up to 4 minutes to build analysis for ONE project.

We have been informed by Epicor the hanging situation could be caused by spaces in our project ids, I'm not too sure if that is the issue, as I am seeing this happen when I select a range of projects all with no spaces.



Cheers
Simon Hall

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> I know there is an issue related to scheduling the build project analysis that is fixed in 700. Notice the schedule dropdown is empty when you try to select a schedule.
>
>
>
> ________________________________
> From: Douglas <dgum@...>
> To: vantage@yahoogroups.com
> Sent: Wednesday, July 18, 2012 4:09 PM
> Subject: [Vantage] Build Project Analysis
>
> We are using Epicor 9.05.607A.
>
> I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).
>
> Has anybody else had this problem? How did you solve it?
>
>
>
>
> ------------------------------------
>
> 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
>
>
>
> [Non-text portions of this message have been removed]
>
5
There is a design flaw with build project analysis in that it creates a list of the projects to run against in a character variable.
This is subject to the 32K limit within Progress hence if you have a lot of active projects or long id's it will fail when run without a filter as it hits this limit.

I created a custom version of BPA that just cycles though the projects and runs it for each to mitigate this issue. This is still an issue as of 701.

Secondly I created a new version of the process UI that allows the as of date to be a proper "dynamic" hence you can schedule it as you would want with a dynamic condition, it also fixed the missing schedule combo link.

regarding the speed this depends on many factors, as a baseline what does BPA take on your environment for a project with a single phase and no transactions.

Thanks,

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of s1mhall
Sent: 18 March 2013 11:47
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Build Project Analysis



Yes we are seeing this in 701. The build Project Analysis works ok on the actions menu item from within project entry, but not the menu version one in General Operations where you have thecapability to select all projects with out the filter. It is also very slow.
It can take up to 4 minutes to build analysis for ONE project.

We have been informed by Epicor the hanging situation could be caused by spaces in our project ids, I'm not too sure if that is the issue, as I am seeing this happen when I select a range of projects all with no spaces.

Cheers
Simon Hall

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@...<mailto:tkoch77@...>> wrote:
>
> I know there is an issue related to scheduling the build project analysis that is fixed in 700. Notice the schedule dropdown is empty when you try to select a schedule.
>
>
>
> ________________________________
> From: Douglas <dgum@...<mailto:dgum@...>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Wednesday, July 18, 2012 4:09 PM
> Subject: [Vantage] Build Project Analysis
>
> We are using Epicor 9.05.607A.
>
> I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).
>
> Has anybody else had this problem? How did you solve it?
>
>
>
>
> ------------------------------------
>
> 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
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
6
Thanks for your feedback everyone, and apologies for my terrible first post. I guess I was a bit tired when I posted my first message :( the joys of a new implementation.

I'll do a baseline as you suggested Stephen, but it generally takes 4 about minutes to build a project analysis that has very few labordtl records.

With regards to building a custom version. I assume you have the SDK?

We have just about every module apart from Knowledge Management and the SDK which is a bit disappointing. There already have been a few instances where it would have come in handy.

Over the past few days things have gone from bad to worse for BPA. Now our phase budget estimates are not being created even though we have operations with hours against them.

I have logged calls with Epicor, but unfortunately I'm not getting any response. Time to push the escalate button me thinks.

Kind Regards
Simon Hall


--- In vantage@yahoogroups.com, Stephen Edginton <stephene@...> wrote:
>
> There is a design flaw with build project analysis in that it creates a list of the projects to run against in a character variable.
> This is subject to the 32K limit within Progress hence if you have a lot of active projects or long id's it will fail when run without a filter as it hits this limit.
>
> I created a custom version of BPA that just cycles though the projects and runs it for each to mitigate this issue. This is still an issue as of 701.
>
> Secondly I created a new version of the process UI that allows the as of date to be a proper "dynamic" hence you can schedule it as you would want with a dynamic condition, it also fixed the missing schedule combo link.
>
> regarding the speed this depends on many factors, as a baseline what does BPA take on your environment for a project with a single phase and no transactions.
>
> Thanks,
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of s1mhall
> Sent: 18 March 2013 11:47
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Build Project Analysis
>
>
>
> Yes we are seeing this in 701. The build Project Analysis works ok on the actions menu item from within project entry, but not the menu version one in General Operations where you have thecapability to select all projects with out the filter. It is also very slow.
> It can take up to 4 minutes to build analysis for ONE project.
>
> We have been informed by Epicor the hanging situation could be caused by spaces in our project ids, I'm not too sure if that is the issue, as I am seeing this happen when I select a range of projects all with no spaces.
>
> Cheers
> Simon Hall
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@<mailto:tkoch77@>> wrote:
> >
> > I know there is an issue related to scheduling the build project analysis that is fixed in 700. Notice the schedule dropdown is empty when you try to select a schedule.
> >
> >
> >
> > ________________________________
> > From: Douglas <dgum@<mailto:dgum@>>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, July 18, 2012 4:09 PM
> > Subject: [Vantage] Build Project Analysis
> >
> > We are using Epicor 9.05.607A.
> >
> > I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).
> >
> > Has anybody else had this problem? How did you solve it?
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
7
Hi Simon,

We are a platinum partner, alliance partner and development partner with Epicor so we undertake SDK type work.
4 minutes for an empty project shell is way too long.

I have never had BPA fail generating the estimates, ensure you review you Appserver logs for any locking issues or 4GL stops.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of s1mhall
Sent: 20 March 2013 11:25
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Build Project Analysis



Thanks for your feedback everyone, and apologies for my terrible first post. I guess I was a bit tired when I posted my first message :( the joys of a new implementation.

I'll do a baseline as you suggested Stephen, but it generally takes 4 about minutes to build a project analysis that has very few labordtl records.

With regards to building a custom version. I assume you have the SDK?

We have just about every module apart from Knowledge Management and the SDK which is a bit disappointing. There already have been a few instances where it would have come in handy.

Over the past few days things have gone from bad to worse for BPA. Now our phase budget estimates are not being created even though we have operations with hours against them.

I have logged calls with Epicor, but unfortunately I'm not getting any response. Time to push the escalate button me thinks.

Kind Regards
Simon Hall

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Stephen Edginton <stephene@...<mailto:stephene@...>> wrote:
>
> There is a design flaw with build project analysis in that it creates a list of the projects to run against in a character variable.
> This is subject to the 32K limit within Progress hence if you have a lot of active projects or long id's it will fail when run without a filter as it hits this limit.
>
> I created a custom version of BPA that just cycles though the projects and runs it for each to mitigate this issue. This is still an issue as of 701.
>
> Secondly I created a new version of the process UI that allows the as of date to be a proper "dynamic" hence you can schedule it as you would want with a dynamic condition, it also fixed the missing schedule combo link.
>
> regarding the speed this depends on many factors, as a baseline what does BPA take on your environment for a project with a single phase and no transactions.
>
> Thanks,
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of s1mhall
> Sent: 18 March 2013 11:47
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Build Project Analysis
>
>
>
> Yes we are seeing this in 701. The build Project Analysis works ok on the actions menu item from within project entry, but not the menu version one in General Operations where you have thecapability to select all projects with out the filter. It is also very slow.
> It can take up to 4 minutes to build analysis for ONE project.
>
> We have been informed by Epicor the hanging situation could be caused by spaces in our project ids, I'm not too sure if that is the issue, as I am seeing this happen when I select a range of projects all with no spaces.
>
> Cheers
> Simon Hall
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@<mailto:tkoch77@>> wrote:
> >
> > I know there is an issue related to scheduling the build project analysis that is fixed in 700. Notice the schedule dropdown is empty when you try to select a schedule.
> >
> >
> >
> > ________________________________
> > From: Douglas <dgum@<mailto:dgum@>>
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Sent: Wednesday, July 18, 2012 4:09 PM
> > Subject: [Vantage] Build Project Analysis
> >
> > We are using Epicor 9.05.607A.
> >
> > I want to set up Build Project Analysis to run automatically on a regular schedule. However the dialog does not have a 'dynamic' as-of date. Plus, I have noticed that when I attempt to re-build analysis for ALL projects the process will run for a couple of hours then seem to freeze-up (System Monitor changes from 'xx Processor Cycles' to '1 Processor Cycles' then just hangss there till I stop and re-start the Task Agent (which ends the process).
> >
> > Has anybody else had this problem? How did you solve it?
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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/linksYahoo! Groups Links
> >
> >
> >
> > [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]