<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
@font-face
{font-family:"BentonSans Regular";
panose-1:2 0 5 3 0 0 0 2 0 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"BentonSans Regular";
color:#1F497D;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">Hi James,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">Do you have WORKFLOW_LOCAL_XXX registered in SMQS by any chance? (Queuing of tRFC’s)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">If so please make sure there are enough resources to cope with high load situations as well as regular traffic. Maybe looking at increasing Max Conn and Max
Runtime and if you have not assigned an AS Group in SMQS then maybe do so to ensure specific servers are available to SMQS. If the resources for SMQS are not sufficient then you start seeing a backlog in SM58 and delay in workflow execution of tRFC’s.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">Also if you have situations where many events are created at once I would suggest you use the event queue if possible and stagger the delivery….saves the system
from being overwhelmed.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">If you do not have WORKFLOW_LOCAL_XXX registered in SMQS then simply ignore all the above
</span><span style="font-size:10.0pt;font-family:Wingdings;color:#1F497D">J</span><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D">Eddie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"BentonSans Regular";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu]
<b>On Behalf Of </b>James Johnson<br>
<b>Sent:</b> Thursday, September 12, 2013 9:31 PM<br>
<b>To:</b> SAP Workflow Users' Group<br>
<b>Subject:</b> RE: Event Raised - WF-BATCH Configured - No Workflow<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Hi all,</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">As promised, here's an update - we fixed the issue. The fix in my instance requires the Basis team to conduct a number of resolution actions.</span>
<br>
<br>
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Cause of the issue</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">: poor performance in table access of SWWWIHEAD and SWW_WI2OBJ,
</span><span style="font-size:10.0pt">ARFCSSTATE, ARFCSDATA, ARFCRSTATE, TRFCQOUT, TRFCQIN, TRFCQSTATE and TRFCQDATA</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> tables (the first two being core workflows, the rest being Basis tables).
A time-out was occuring on the tRFC used to request workflow creation in the instances where a dialogue process was attempting to be used. The process was dialogue (instead of background) as the events/workflows affected were created under the user's name
instead of WF-BATCH.</span> <br>
<br>
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Fix</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">: One-off rebuild of the index for SWWWIHEAD and SWW_WI2OBJ, in addition to the update of the statistics for those
tables. Recommendation to Basis for a daily process to be instigated going forward, where indexing is rebuilt for the above Basis tables (due to their rapid expansion and contraction in size, the index rapidly degenerates). The affected tRFCs (where events
delivery didn't create the associated workflow) were re-executed by Basis and all workflows were produced.</span>
<br>
<br>
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Result</span></b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">: Event delivery now causes the associated workflow to be produced, in 0.5 seconds compared to a time-out occuring
after 10 minutes. Happy workflows means happy James :).</span> <br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Best Regards,<br>
James Johnson<br>
<br>
E-mail:JJohnson@uk.ibm.com<br>
Mobile: 07908715224 or 07920870270</span> <br>
<br>
<br>
<br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">From: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">James Johnson/UK/IBM@IBMGB</span>
<br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">To: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"SAP Workflow Users' Group" <<a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>>,
</span><br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Date: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">11/09/2013 11:30</span>
<br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Subject: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">RE: Event Raised - WF-BATCH Configured - No Workflow</span>
<br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">Sent by: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a></span>
<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" noshade="" style="color:#A0A0A0" align="center">
</div>
<p class="MsoNormal"><br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Hi Ed,</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
That's a pretty daring approach, deleting stuff out of workflow master data tables usually results in bad things. Yes, we got the same issue in production, the BASIS guys are looking into the RFC statuses in SM58, SCN also suggested authorisation to execute
RFCs as a possible issue but they haven't changed in this case (and before this issue manifested, there was a period where workflows were creating, just with a ~8 hour delay after being delivered from the event queue). Next test is amending the workflow to
'general task,' will let everyone know how the issue gets resolved :)</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
Best Regards,<br>
James Johnson<br>
<br>
E-mail:JJohnson@uk.ibm.com<br>
Mobile: 07908715224 or 07920870270</span> <br>
<br>
<br>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
From: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Edward Diehl <<a href="mailto:edwarddiehl@hotmail.com">edwarddiehl@hotmail.com</a>></span>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
To: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"SAP Workflow Users' Group" <<a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>>,
<span style="color:#5F5F5F"><br>
Date: </span>10/09/2013 19:22</span> <span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F">
<br>
Subject: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">RE: Event Raised - WF-BATCH Configured - No Workflow</span>
<span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
Sent by: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a></span>
<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" noshade="" style="color:#A0A0A0" align="center">
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<span style="font-size:13.5pt;font-family:"Garamond","serif""><br>
Thanks, James.<br>
We were able to get workflows going again by deleting bunchs of stuff out of SWWWIHEAD, etc. When we copied production to the test system it was a total misfit from a capacity standpoint. Perhaps now I can get them interested in deleting/archiving old data.<br>
<br>
Did you get that same RFC status message?</span><span style="font-family:"Calibri","sans-serif""><br>
</span><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><br>
<br>
Ed Diehl</span></b><i><span style="font-family:"Tahoma","sans-serif""><br>
"Success consists of going from failure to failure without loss of enthusiasm."</span></i><span style="font-family:"Tahoma","sans-serif"">
</span><span style="font-family:"Calibri","sans-serif""><br>
<br>
<br>
</span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif"">To: <a href="mailto:sap-wug@mit.edu">
sap-wug@mit.edu</a><br>
Subject: Re: Event Raised - WF-BATCH Configured - No Workflow<br>
From: <a href="mailto:JJOHNSON@uk.ibm.com">JJOHNSON@uk.ibm.com</a><br>
Date: Tue, 10 Sep 2013 18:46:58 +0100</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
<br>
Funnily enough, this exact same issue to my client, happened over the last couple of days. I did the workflow analysis and passed it over to our BASIS team. If I get any response back I'll post to the group for information.
<br>
<br>
Best Regards,<br>
James Johnson<br>
<br>
E-mail:JJohnson@uk.ibm.com<br>
Mobile: 07908715224 or 07920870270</span><span style="font-family:"Calibri","sans-serif"">
<br>
<br>
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
<br>
From: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Rick Bakker <<a href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>></span><span style="font-family:"Calibri","sans-serif"">
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
To: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"SAP Workflow Users' Group" <<a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>>,
<span style="color:#5F5F5F"><br>
Date: </span>09/09/2013 23:28</span><span style="font-family:"Calibri","sans-serif"">
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
Subject: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Re: Event Raised - WF-BATCH Configured - No Workflow</span><span style="font-family:"Calibri","sans-serif"">
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F"><br>
Sent by: </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a></span><span style="font-family:"Calibri","sans-serif"">
</span><o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" noshade="" style="color:#A0A0A0" align="center">
</div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif""><br>
<br>
<br>
Hello Ed, <br>
<br>
Try OSS </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#2F2F2F">Note 1025249 - Entries in transaction SM58 "hang"</span><span style="font-family:"Calibri","sans-serif"">
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#2F2F2F"><br>
"If a large number of deadlines are due at the same time, some of the entries in transaction SM58 may hang. The entries have a workflow destination WORKFLOW_LOCAL_<xxx> (xxx denotes the client) as the target system."</span><span style="font-family:"Calibri","sans-serif"">
</span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#2F2F2F"><br>
<br>
regards</span><span style="font-family:"Calibri","sans-serif""> </span><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:#2F2F2F"><br>
Rick</span><span style="font-family:"Calibri","sans-serif""> <br>
<br>
<br>
On Tue, Sep 10, 2013 at 5:44 AM, Edward Diehl <</span><a href="mailto:edwarddiehl@hotmail.com" target="_blank"><span style="font-family:"Calibri","sans-serif"">edwarddiehl@hotmail.com</span></a><span style="font-family:"Calibri","sans-serif"">> wrote:
</span><span style="font-size:13.5pt;font-family:"Garamond","serif""><br>
We're on SAPKB70107 - ECC 6.0<br>
<br>
We did a client copy from production to the test system. WF-BATCH was configured after some test data did not produce workflows. After that we STILL are not getting workflows. The Events go into the queue, as designed. When released the events show green,
but at the bottom of the event display under RFC status:<br>
"System overloaded, repeat immediately by batch"<br>
<br>
Okay, so a couple of questions:<br>
Has anyone out there seen this before?<br>
What does system overloaded mean?<br>
And what batch process/program is it talking about?<br>
<br>
Any feedback would be appreciated.<br>
<br>
Thanks,<br>
Ed Diehl</span><span style="font-family:"Calibri","sans-serif""><br>
</span><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><br>
<br>
<br>
Ed Diehl</span></b><i><span style="font-family:"Tahoma","sans-serif""><br>
"Success consists of going from failure to failure without loss of enthusiasm."</span></i><span style="font-family:"Tahoma","sans-serif"">
</span><span style="font-family:"Calibri","sans-serif""><br>
<br>
<br>
_______________________________________________<br>
SAP-WUG mailing list</span><u><span style="color:blue"><br>
</span></u><a href="mailto:SAP-WUG@mit.edu"><span style="font-family:"Calibri","sans-serif"">SAP-WUG@mit.edu</span></a><u><span style="color:blue"><br>
</span></u><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank"><span style="font-family:"Calibri","sans-serif"">http://mailman.mit.edu/mailman/listinfo/sap-wug</span></a><span style="font-size:10.0pt;font-family:"Calibri","sans-serif""><br>
<br>
_______________________________________________<br>
SAP-WUG mailing list<br>
<a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a></span><u><span style="color:blue"><br>
</span></u><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">http://mailman.mit.edu/mailman/listinfo/sap-wug</span></a><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
<br>
<br>
Unless stated otherwise above:<br>
IBM United Kingdom Limited - Registered in England and Wales with number 741598. <br>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU</span><span style="font-family:"Calibri","sans-serif""><br>
<br>
_______________________________________________ SAP-WUG mailing list <a href="mailto:SAP-WUG@mit.edu">
SAP-WUG@mit.edu</a> </span><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"><span style="font-family:"Calibri","sans-serif"">http://mailman.mit.edu/mailman/listinfo/sap-wug</span></a><tt><span style="font-size:10.0pt">_______________________________________________</span></tt><span style="font-size:10.0pt;font-family:"Courier New""><br>
<tt>SAP-WUG mailing list</tt><br>
<tt><a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a></tt></span><u><span style="color:blue"><br>
</span></u><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"><tt><span style="font-size:10.0pt">http://mailman.mit.edu/mailman/listinfo/sap-wug</span></tt></a><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
<br>
Unless stated otherwise above:<br>
IBM United Kingdom Limited - Registered in England and Wales with number 741598. <br>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU</span><tt><span style="font-size:10.0pt">_______________________________________________</span></tt><span style="font-size:10.0pt;font-family:"Courier New""><br>
<tt>SAP-WUG mailing list</tt><br>
<tt><a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a></tt><br>
</span><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"><tt><span style="font-size:10.0pt">http://mailman.mit.edu/mailman/listinfo/sap-wug</span></tt></a><span style="font-size:10.0pt;font-family:"Courier New""><br>
</span><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""><br>
Unless stated otherwise above:<br>
IBM United Kingdom Limited - Registered in England and Wales with number 741598. <br>
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU</span><o:p></o:p></p>
</div>
</body>
</html>