<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:st1="urn:schemas-microsoft-com:office:smarttags" 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 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Brush Script MT";
panose-1:3 6 8 2 4 4 6 7 3 4;}
@font-face
{font-family:"Bookman Old Style";
panose-1:2 5 6 4 5 5 5 2 2 4;}
@font-face
{font-family:"Arial monospaced for SAP";
panose-1:2 11 6 9 2 2 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</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 bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We experienced very long runtimes for job
SWWCOND on 4.71 and opened a message with SAP. Based on their responses
in September 2005, we cancelled the job.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=blue
face="Arial monospaced for SAP"><span style='font-size:9.0pt;font-family:"Arial monospaced for SAP";
color:blue'>Reply from
SAP 09/15/2005
04:27:04<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>I analyzed the problem in
your system. We really have a problem with<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>the performance of report
RSWWCOND. Development is aware of that, and<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>thinking of a redesign of
the functionality. For the time being, we<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>can offer the following
solution:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>- I checked the definition
table SWD_CONDEF. I see that the relevant<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> conditions are only
used in one workflow: WS90200019, step 29. This<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> step is the 'post'
step. It is task TS90200040.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> Relevant condition
types are only '<st1:place w:st="on">PO</st1:place>', 'PR', and 'WA'.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>- RSWWCOND really only
needs to check conditions for that task number.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> So, we can enter
this task on the selection screen for RSWWCOND.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> The report then runs
only 2 seconds, because it can access table<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> SWWWIHEAD with index
C.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>- You need to define this
selection criteria in a variant, and have<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> the background job
always run with this variant.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>- The great disadvantage of
this is: any time you change your workflow,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> or start working
with a new workflow in some application area, you<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> need to recheck
table SWD_CONDEF.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> I wonder if this is
acceptable to you?<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'> Please let me know.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Best regards,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Workflow Development
Support<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=black
face="Arial monospaced for SAP"><span style='font-size:9.0pt;font-family:"Arial monospaced for SAP";
color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=blue
face="Arial monospaced for SAP"><span style='font-size:9.0pt;font-family:"Arial monospaced for SAP";
color:blue'>Reply from
SAP 09/16/2005
04:58:20<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>A redesign of the
functionality can not be delivered per support<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>package.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>I ran the report with SQL
trace on, and found that index C is not ued.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Please see note 799002, and
change the index, and generate it.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Then check note 724614 for
anything to be done on the database side<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>(I am not at all a database
expert).<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Then please rerun the
report with SQL trace (ST05) switched on. The<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>select should be done by
index C then.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>If that is not the case, I
will need to send this message to the DB2<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>database experts. In that
case, please keep the system connection open<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>a little longer.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-autospace:none'><font size=1
color=black face="Arial monospaced for SAP"><span style='font-size:9.0pt;
font-family:"Arial monospaced for SAP";color:black'>Best regards,<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=black
face="Arial monospaced for SAP"><span style='font-size:9.0pt;font-family:"Arial monospaced for SAP";
color:black'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal style='text-autospace:none'><font size=4
face="Brush Script MT"><span style='font-size:14.0pt;font-family:"Brush Script MT"'>Marcia
Neumann</span></font><font size=2 face="Brush Script MT"><span
style='font-size:10.0pt;font-family:"Brush Script MT"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=gray
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:gray'>CMS
Workflow Administration<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=gray
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:gray'>IT Claims
Development/Support<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=gray
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:gray'>Phone:
(513) 870-2300 ext. 4461<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=1 color=gray
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:gray'>Fax:
(513) 603-5388<o:p></o:p></span></font></p>
<p><b><font size=1 color=navy face=Arial><span style='font-size:7.5pt;
font-family:Arial;color:navy;font-weight:bold'>Confidentiality notice:</span></font></b><font
size=1 color=navy face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:navy'> The information included in this e-mail, including any
attachments, is for the sole use of the intended recipient and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure, distribution or similar action is prohibited. If you are not the
intended recipient, please contact the sender and delete all copies of the
original message immediately.</span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Jeffrey A. Rappaport<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, May 14, 2008
11:25 AM<br>
<b><span style='font-weight:bold'>To:</span></b> SWUG (SAP)<br>
<b><span style='font-weight:bold'>Subject:</span></b> WF Background Jobs</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'>All,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'>
Had a couple of quick questions on the WF Jobs, first being has anyone seen the
job SWWCOND at times take hours to run? Second would be what the difference is
between the 2 DM Jobs SWFSLSDLEX & SWWDHEX & why there's now 2 jobs for
this.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'>Thanx,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'><br>
Jeffrey A. Rappaport<br>
Business Workflow, LLC<br>
Voice: +1 (732) 355-0123<br>
Fax: +1 (509) 757-4144<br>
Email: <a href="mailto:Jeff@Business-Workflow.com">Jeff@Business-Workflow.com</a><br>
Web: <a href="http://www.Business-Workflow.com">www.Business-Workflow.com</a><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face="Bookman Old Style"><span
style='font-size:10.0pt;font-family:"Bookman Old Style";color:blue'>
The information contained in this message may be privileged, confidential and
protected from disclosure. If the Reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received this
communication in error and would like to be removed from any future mailings
from this Sender, please hit 'Reply' to this email with "REMOVE" in
the Subject line.</span></font><o:p></o:p></p>
</div>
</div>
</body>
</html>