<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Rick,<BR>
<BR>
We've had problems with this kind of thing before as well. Sometimes it seems that Workflow is just too quick for the database changes to actually take hold with the implicit COMMIT WORK statement issued inside the standard code.<BR>
<BR>
In the end we resorted to explicit COMMIT WORK AND WAIT statements inside our Methods where we wanted to be absolutely sure the changes have happened before we proceed any further. This seems to have done the trick although it's a bit clunky and really not that elegant at all. <BR>
<BR>
Occasionally we also ask the BOR Object to refresh itself at the end of these Methods to keep the OBJECT-_* structures up to date when we think something important may have changed.<BR>
<BR>
Using a Virtual attribute rather than a Database attribute would enforce a certain 'delay' in retrieving the database value again because you have to execute a discrete SELECT. This might be enough time for the V2 updates to happen in the back-end in the meantime. But then again it might not be enough of a delay if the system is under stress and lots of updates are happening at the same time.<BR>
<BR>
I guess it all depends on how soon after a database change are you trying to fetch the new value?<BR>
<BR>
Regards,<BR>
<BR>
Mike GT<BR><BR>> Subject: RE: Release Strategy issues in 4.6c<BR>> Date: Wed, 2 Jul 2008 09:59:57 -0500<BR>> From: Rick.Sample@graybar.com<BR>> To: sap-wug@mit.edu<BR>> <BR>> Hi Florin,<BR>> <BR>> Sounds plausible and I planned to extend the object after I figured out<BR>> the buffering issue(s). <BR>> To recap:<BR>> 1. The standard BOR bus2012 swc_get_property self 'RELEASESTATUS'<BR>> l_status gets buffered data. Not the current data I need when I need it.<BR>> 2. I run the SELECT... right after the swc_get_property as a test,<BR>> without a few seconds wait and still not the current data I need.<BR>> 3. If I do #2 with WAIT UP TO 3 SECONDS, I do get the most recent data.<BR>> <BR>> Now, what you are saying is if I extend the attribute, make virtual, and<BR>> use SELECT ..., I can bypass the WAIT?<BR>> What is the difference between getting from BOR DATABASE attribute vs. a<BR>> SELECT in the method? The BOR bypassing the buffers?<BR>> <BR>> Rick<BR>> <BR>> <BR>> <BR>> -----Original Message-----<BR>> From: sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] On Behalf<BR>> Of Florin Wach<BR>> Sent: Wednesday, July 02, 2008 8:46 AM<BR>> To: SAP Workflow Users' Group<BR>> Subject: Re: Release Strategy issues in 4.6c<BR>> <BR>> Hi,<BR>> <BR>> oh, I see. There's no problem with that on purchase requisitions<BR>> BUS2105, as that table attribute is reading by itself using a SELECT ...<BR>> FROM EBAN, but the same form within BUS2012 uses the function module for<BR>> a buffered read.<BR>> <BR>> To work around that, create a subtype w/delegation.<BR>> Redefine the attribute ReleaseStatus<BR>> Change the Source from "Database field" to "Virutal"<BR>> Create a coding with SELECT SINGLE FRGST FROM EKKO INTO<BR>> object-releaseStatus WHERE ebeln = object-key.<BR>> <BR>> Best wishes,<BR>> Florin<BR>> <BR>> -------- Original-Nachricht --------<BR>> > Datum: Wed, 2 Jul 2008 08:37:34 -0500<BR>> > Von: "Sample, Rick" <Rick.Sample@graybar.com><BR>> > An: "SAP Workflow Users\' Group" <sap-wug@mit.edu><BR>> > Betreff: Release Strategy issues in 4.6c<BR>> <BR>> > Hi WF's,<BR>> > <BR>> > I have an issue with performance. I think! <BR>> > I have a Purchase Release Strategy WF I am working on. <BR>> > User approves his step, Wf catches the Release event and <BR>> > evaluates for next approver. Standard approval stuff. <BR>> > <BR>> > The issue:<BR>> > When user approves his task, wf event triggers, then I immediately go<BR>> > and evaluate the Rel Strategy.<BR>> > The standard BOR swc_get_property self 'RELEASESTATUS' l_status is<BR>> > obviously getting the BUFFERED data. <BR>> > If I put in a WAIT UP TO 3 SECONDS then to a SELECT with BYPASSING<BR>> > BUFFER I get the correct value <BR>> > from the SELECT, and I can verify that the BOR get property is the<BR>> > buffered data. <BR>> > <BR>> > In all my time doing WF, I have never had to work around such a timing<BR>> > issues. <BR>> > This solution 'appears' to work and is in a background task, so I<BR>> don't<BR>> > think it will be an problem. <BR>> > <BR>> > Also, I tried using the FMs in ME01 to refresh EKKO buffers, read the<BR>> > EKKO buffered data, etc. with no success.<BR>> > Anyone have a more elegant solution or comments with my above<BR>> solution?<BR>> > <BR>> > Thanks much,<BR>> > <BR>> > <BR>> > <BR>> > _______________________________________________<BR>> > SAP-WUG mailing list<BR>> > SAP-WUG@mit.edu<BR>> > http://mailman.mit.edu/mailman/listinfo/sap-wug<BR>> _______________________________________________<BR>> SAP-WUG mailing list<BR>> SAP-WUG@mit.edu<BR>> http://mailman.mit.edu/mailman/listinfo/sap-wug<BR>> <BR>> _______________________________________________<BR>> SAP-WUG mailing list<BR>> SAP-WUG@mit.edu<BR>> http://mailman.mit.edu/mailman/listinfo/sap-wug<BR><BR><br /><hr />Play Live Search Charades and win £5000 <a href='http://www.searchcharades.com' target='_new'>Think you know your TV, music and film?</a></body>
</html>