Hello,
We absolutely had this issue back in February 2010 with R7.8 at PCM level 10572. This was a very hot issue for us as it was eating up CPU resources big time. It surprises me that support could not find this one as I went back and forth with them multiple times over several weeks before getting this fix from them in March. It is fixed on our system now. Hope this information helps:
Symptom: sh86203 address the performance issue with PSVTUE unattached job that runs with IFM installed
Fact: IFM
Fact: XAR7.8
Cause: performance enhancements were made to the Personal Account Balance Summary
Refresh processing.
For Single Currency customers, a fix was made to prevent the refresh from running every night.
Following enhancements apply to Multiple Currency environments:
- Reduce number of transactions by only updating totals where an exchange rate change had occurred.
- Don't update Euro totals if none of the other currencies are Euro-participants.
- Eliminate some unnecessary parent updates from Financial Division level when Financial Division is told to update the associated Personal Accounts from the refresh driver.
- Added logical view over Entity file (YAAFREU2), keyed by Entity Group, and used this instead of SQL for performance improvement.
- Removed logic from SH86079, which negatively impacted performance; it allowed holding of the Refresh ujob transactions.
It is recommended that the user also install SH86974, which replaces SH86079, but with no negative performance impact.
Fix: Download and apply SH86203. This fix will bring the programs to the following PTF level:
XAR7.8 PTF 10895.
Claude Stoltz
Manager of Enterprise Applications
Barry-Wehmiller Companies, Inc.
claude.stoltz@xxxxxxxxxxxxxxxxxxx
8020 Forsyth Boulevard
Saint Louis, Missouri 63105
(314) 862-8000 ext. 204
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of polshavsky@xxxxxxxxx
Sent: Saturday, September 25, 2010 7:16 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PSVTUE - eFin U-Job
James it does the same thing on our box I usually put it on hold to try to prevent it from running. I asked once what it was and did not get it answered
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: James Pankratz <pankratz@xxxxxxxxxxxx>
Sender: mapics-l-bounces@xxxxxxxxxxxx
Date: Sat, 25 Sep 2010 12:52:34
To: <mapics-l@xxxxxxxxxxxx>
Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: [MAPICS-L] PSVTUE - eFin U-Job
BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Hello,
We're looking for information about MAPICS job PSVTUE.
This job takes up 35% of our CPU and runs ALL THE TIME. We don't
know what it's for. We tried to get information from Infor but
although their help desk was semi-helpful, we didn't get enough
information to know if we should prevent this job from running
altogether, or how we could improve its performance, or limit its
appetite for processing millions of unknowable transactions.
Any help?
I can provide more information if there are any clarifying
questions.
Thanks.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
midrange.com
