<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:st="" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns1="http://schemas.microsoft.com/sharepoint/soap/workflow/"
xmlns:ns2="http://schemas.microsoft.com/office/2006/digsig-setup"
xmlns:ns3="http://schemas.microsoft.com/office/2006/digsig"
xmlns:ns4="http://schemas.openxmlformats.org/package/2006/digital-signature"
xmlns:ns5="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:ns6="http://schemas.microsoft.com/office/2004/12/omml"
xmlns:ns7="http://schemas.openxmlformats.org/package/2006/relationships"
xmlns:ns8="http://microsoft.com/sharepoint/webpartpages"
xmlns:ns9="http://schemas.microsoft.com/exchange/services/2006/types"
xmlns:ns10="http://schemas.microsoft.com/exchange/services/2006/messages"
xmlns:ns11="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/"
xmlns:ns12="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService"
xmlns:ns13="urn:schemas-microsoft-com:">
<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"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 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:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:black;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>We are on ECC 6.0. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>I have made changes to two workflows and
have moved them up the path to production. I had no syntax error messages
in DEV or QAS, but when it gets to PRD, I have syntax errors. The errors
make no sense because what it says is not true. Can anyone help?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><img width=1059 height=471
id="_x0000_i1026" src="cid:image001.jpg@01CB4432.CC76EA70"><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Regards,</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black'>Sue</span></font><font color=black><span
style='color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt;color:black'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="Arial Narrow"><span lang=EN
style='font-size:10.0pt;font-family:"Arial Narrow";color:navy'>I firmly believe
that in every situation, no matter how difficult, God extends grace greater
than the hardship, and strength and peace of mind that can lead us to a place
higher than where we were before.</span></font><font size=1 color=navy
face="Arial Narrow"><span lang=EN style='font-size:7.5pt;font-family:"Arial Narrow";
color:navy'> -</span></font><strong><b><font size=2 color=navy
face="Arial Narrow"><span lang=EN style='font-size:10.0pt;font-family:"Arial Narrow";
color:navy'>Andy Griffith</span></font></b></strong><font size=1
face="Arial Narrow"><span lang=EN style='font-size:7.5pt;font-family:"Arial Narrow"'><o:p></o:p></span></font></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>Morris, Eddie<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, August 23, 2010 8:36
AM<br>
<b><span style='font-weight:bold'>To:</span></b> SAP Workflow Users' Group<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: SWN_SELSEN dump
problem</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>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Try running
RSWWWIDE_DEP on tables SWWUSERWI and SWWORGTASK and remove any obsolete
entries. Then try running SWN_SELSEN again.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Eddie<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<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>srinivas<br>
<b><span style='font-weight:bold'>Sent:</span></b> 23 August 2010 12:57<br>
<b><span style='font-weight:bold'>To:</span></b> SAP Workflow Users' Group<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: SWN_SELSEN dump
problem<o:p></o:p></span></font></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=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi Rick,<o:p></o:p></span></font></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=3 face="Times New Roman"><span style='font-size:
12.0pt'>I checked the dump file,the time out error is getting at different
select statement and I checked the table SWN_TIMESTAMPS and found the
zdelivery entry what I have customized in SWNCONFIG. Does this mean the
time stamp created ?? If I run the report SWN_SELSEN again will it work??
Because I dont have access to run the report in Production
system I need to raise a request for this.<o:p></o:p></span></font></p>
</div>
<div>
<table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 52</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> IF NOT read_org_task IS INITIAL. </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'>>>>>></span></font><o:p> </o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> SELECT * FROM swworgtask INTO TABLE loc_org_task </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 54</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> WHERE wi_id = wi_id </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 55</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> AND no_sel = space. </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 56</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> ELSE. </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 57</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'>* use given entries </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 58</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> loc_org_task[] = act_org_task[]. </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 59</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 60</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> DELETE loc_org_task WHERE wi_id <> wi_id </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 61</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> OR no_sel <> space. </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> 62</span></font><o:p></o:p></p>
</td>
<td bgcolor="#EEF9FF" style='background:#EEF9FF;padding:.75pt .75pt .75pt .75pt;
cursor:hand'>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'> ENDIF. </span></font><o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-bottom:12.0pt'><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=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Sat, Aug 21, 2010 at 8:42 PM, Rick Bakker <<a
href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>> wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hello,<br>
<br>
If you can't go the route of changing the SWN_TIMESTAMPS table (which<br>
<st1:place w:st="on">Florin</st1:place> managed to do, see my prvious mail)
then maybe you could set up<br>
some filters first to split up the tasks (TS......) so that not all of<br>
them are done at once.<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
regards<br>
Rick Bakker<br>
Hanabi Technology<o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Sat, Aug 21, 2010 at 2:08 AM, srinivas <<a
href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>>
wrote:<br>
> Hi Rick and Sarawana,<br>
><br>
> I have scheduled a batch job for SWN_SELSEN report in production, after<br>
> running for 23.5 hrs the report agian gone to dump.Any suggetions??<br>
><br>
> On Thu, Aug 19, 2010 at 11:26 PM, srinivas <<a
href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
> wrote:<br>
>><br>
>> Hi Rick,Sarawana and all,<br>
>><br>
>> Thanks for your inputs. I have executed SWN_SELSEN in
background for the<br>
>> first time,as per your inputs may be this program will take a lot of
time<br>
>> for the first time but going forward after the first run I assume and
wish<br>
>> this program should consume less time.<br>
>><br>
>> On Thu, Aug 19, 2010 at 12:04 AM, Rick Bakker <<a
href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>> wrote:<br>
>>><br>
>>> Hello,<br>
>>><br>
>>> Earlier this year, Florin Wach (who I believe had the same
problem)<br>
>>> wrote in this mailing list:<br>
>>><br>
>>> <quote><br>
>>> I'm already using only DELTA filters, although there is an
ALL_FULL<br>
>>> filter, but this is not checked at the selection, so it's there,
but<br>
>>> it's not active.<br>
>>><br>
>>> I have debugged down to the SELECT statement and tracked back to where<br>
>>> the timestamp was read. In fact, although the DELTA filter was
used,<br>
>>> the ALL_FULL still throws in between (probably, when the DELTA
filter<br>
>>> has no timestamp set itself).<br>
>>><br>
>>> With the hint from Rick I could manually create a time stamp entry
for<br>
>>> DELTA, using the ABAP OO class CL_SWN_FILTER, create an instance,<br>
>>> execute method LOAD_INSTANCE, use ID=WORKLOW, SCENARIO=STANDARD
(or<br>
>>> whatever was appropriate), then select the interface IF_SWN_FILTER
and<br>
>>> execute method SET_LAST_APPLIED and... e voila ... enter the
TimeStamp<br>
>>> number here. (I have written a small report to run in the
D-System to<br>
>>> write the timestamp to copy it into that field. It's basically the<br>
>>> exact format, Rick gave).<br>
>>> <unquote><br>
>>><br>
>>> I hope it helps.<br>
>>><br>
>>> regards<br>
>>> Rick Bakker<br>
>>> Hanabi Technology<br>
>>><br>
>>><br>
>>> On Wed, Aug 18, 2010 at 12:40 PM, Vijayakumar, Sarawana K<br>
>>> <<a href="mailto:Sarawana.Vijayakumar@energyeast.com">Sarawana.Vijayakumar@energyeast.com</a>>
wrote:<br>
>>> > Following is some information I learned when I faced this
problem. Hope<br>
>>> > it helps other users.<br>
>>> ><br>
>>> > As everyone might know, a timeout occurs at the select
statement<br>
>>> > indicated in the dump Srinivas had given in earlier posts.<br>
>>> ><br>
>>> > Whenever SWN_SELSEN is run, it looks at entries in table
SWN_TIMESTAMPS<br>
>>> > to see when the program was run last for a given delivery<br>
>>> > schedule/filter/selection schedule. If the program is being
called for the<br>
>>> > first time then there is no entry in this table and the
timestamp is set to<br>
>>> > all zeros. In such a case, a sequential read of the
SWWLOGHIST table will be<br>
>>> > done to get work items created after the timestamp in hand
(which is all<br>
>>> > zeros). So depending upon the number of entries in table SWWLOGHIST
it will<br>
>>> > take a long time. And thanks to the inner join on the
SWWWIHEAD in the same<br>
>>> > select statement, it takes even longer than that!<br>
>>> ><br>
>>> > But once this program runs successfully, the time is recorded
in the<br>
>>> > SWN_TIMESTAMPS table for the given delivery
schedule/selection/filter. And<br>
>>> > when it runs the next time it selects <st1:State w:st="on"><st1:place
w:st="on">WIs</st1:place></st1:State> from SWWLOGHIST which were created<br>
>>> > only after this timestamp.<br>
>>> ><br>
>>> > In sandbox system I was able to run this program in debug
mode and<br>
>>> > change the timestamp at the select statement to a very recent
time (like<br>
>>> > right now!) and allowed the rest of the program to run. It
completed in a<br>
>>> > jiffy. The next time I ran the program, no problems, it
completes within<br>
>>> > seconds. My development has not been in QA or PRD, and I know
going in debug<br>
>>> > mode is not an option.<br>
>>> ><br>
>>> > But if any user can give me a way to update the timestamp, it
will put<br>
>>> > an end to this problem.<br>
>>> ><br>
>>> > Thank you,<br>
>>> > -Sarawana<br>
>>> ><br>
>>> ><br>
>>> ><br>
>>> > -----Original Message-----<br>
>>> > From: <a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>
[mailto:<a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>]
On<br>
>>> > Behalf Of <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>
>>> > Sent: Wednesday, August 18, 2010 12:06 PM<br>
>>> > To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>
>>> > Subject: SAP-WUG Digest, Vol 69, Issue 36<br>
>>> ><br>
>>> > Send SAP-WUG mailing list submissions to<br>
>>> > <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>
>>> ><br>
>>> > To subscribe or unsubscribe via the World Wide Web, visit<br>
>>> > <a
href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
>>> > or, via email, send a message with subject or body 'help' to<br>
>>> > <a
href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>
>>> ><br>
>>> > You can reach the person managing the list at<br>
>>> > <a
href="mailto:sap-wug-owner@mit.edu">sap-wug-owner@mit.edu</a><br>
>>> ><br>
>>> > When replying, please edit your Subject line so it is more
specific<br>
>>> > than "Re: Contents of SAP-WUG digest..."<br>
>>> ><br>
>>> ><br>
>>> > Today's Topics:<br>
>>> ><br>
>>> > 1. SWN_SELSEN dump (Karl Nietz)<br>
>>> ><br>
>>> ><br>
>>> >
----------------------------------------------------------------------<br>
>>> ><br>
>>> > Message: 1<br>
>>> > Date: Wed, 18 Aug 2010 11:44:31 +1100<br>
>>> > From: Karl Nietz <<a href="mailto:knietz@csc.com.au">knietz@csc.com.au</a>><br>
>>> > Subject: SWN_SELSEN dump<br>
>>> > To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>
>>> > Message-ID:<br>
>>> ><br>
>>> > <<a
href="mailto:OF8503395E.9040788E-ONCA257783.0003E141-CA257783.0004142E@csc.com">OF8503395E.9040788E-ONCA257783.0003E141-CA257783.0004142E@csc.com</a>><br>
>>> > Content-Type: text/plain; charset="us-ascii"<br>
>>> ><br>
>>> > Hi,<br>
>>> > Check the size of the workflow log history file. If it
is massive then<br>
>>> > this can cause this error. You may wish to experiment
by running the<br>
>>> > program with the Delta filter only. Or run archiving to
reduce the<br>
>>> > size<br>
>>> > of the file.<br>
>>> ><br>
>>> > Karl Nietz<br>
>>> ><br>
>>> > Check this note<br>
>>> > Note 1105696 - WF Notif: Memory consumption and performance
of<br>
>>> > SWN_SELSEN<br>
>>> ><br>
>>> > Regards,<br>
>>> > Imthiaz<br>
>>> ><br>
>>> > -----Original Message-----<br>
>>> > From: <a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>
[mailto:<a href="mailto:sap-wug-bounces@mit.edu">sap-wug-bounces@mit.edu</a>]
On<br>
>>> > Behalf<br>
>>> > Of<br>
>>> > <a href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>
>>> > Sent: Tuesday, August 17, 2010 2:45 PM<br>
>>> > To: <a href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>
>>> > Subject: SAP-WUG Digest, Vol 69, Issue 33<br>
>>> ><br>
>>> > Send SAP-WUG mailing list submissions to<br>
>>> > <a
href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a><br>
>>> ><br>
>>> > To subscribe or unsubscribe via the World Wide Web, visit<br>
>>> > <a
href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
>>> > or, via email, send a message with subject or body 'help' to<br>
>>> > <a
href="mailto:sap-wug-request@mit.edu">sap-wug-request@mit.edu</a><br>
>>> ><br>
>>> > You can reach the person managing the list at<br>
>>> > <a
href="mailto:sap-wug-owner@mit.edu">sap-wug-owner@mit.edu</a><br>
>>> ><br>
>>> > When replying, please edit your Subject line so it is more
specific<br>
>>> > than "Re: Contents of SAP-WUG digest..."<br>
>>> ><br>
>>> ><br>
>>> > Today's Topics:<br>
>>> ><br>
>>> > 1. SWN_SELSEN going to dump (srinivas)<br>
>>> > 2. SWN_SELSEN dump result (srinivas)<br>
>>> > 3. Re: SWN_SELSEN dump result (Rick Bakker)<br>
>>> > 4. Re: SWN_SELSEN dump result (srinivas)<br>
>>> ><br>
>>> ><br>
>>> >
----------------------------------------------------------------------<br>
>>> ><br>
>>> > Message: 1<br>
>>> > Date: Tue, 17 Aug 2010 22:05:44 +0530<br>
>>> > From: srinivas <<a
href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
>>> > Subject: SWN_SELSEN going to dump<br>
>>> > To: "SAP Workflow Users' Group" <<a
href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>><br>
>>> > Message-ID:<br>
>>> > <AANLkTimgn-3SOuV2XFr5RCra7+gB9OR+_-=<a
href="mailto:X3xC547y_@mail.gmail.com">X3xC547y_@mail.gmail.com</a>><br>
>>> > Content-Type: text/plain; charset="iso-8859-1"<br>
>>> ><br>
>>> > Hi All,<br>
>>> ><br>
>>> > While executing the report SWN_SELSEN (extended
notifications) via<br>
>>> > batch<br>
>>> > job<br>
>>> > or manually the report is going to dump.Can someone tell me
what are<br>
>>> > the<br>
>>> > possible causes for the dump in SWN_SELSEN??Actually I dont
have dump<br>
>>> > file<br>
>>> > at the moment,this issue is happening in production server.<br>
>>> ><br>
>>> > --<br>
>>> > Thanks and Regards<br>
>>> > Srini..<br>
>>> > -------------- next part --------------<br>
>>> > An HTML attachment was scrubbed...<br>
>>> > URL:<br>
>>> ><br>
>>> > <a
href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/8bcbfbd8/attac"
target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/8bcbfbd8/attac</a><br>
>>> ><br>
>>> > hment-0001.htm<br>
>>> ><br>
>>> > ------------------------------<br>
>>> ><br>
>>> > Message: 2<br>
>>> > Date: Tue, 17 Aug 2010 23:04:06 +0530<br>
>>> > From: srinivas <<a
href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
>>> > Subject: SWN_SELSEN dump result<br>
>>> > To: "SAP Workflow Users' Group" <<a
href="mailto:sap-wug@MIT.EDU">sap-wug@MIT.EDU</a>><br>
>>> > Message-ID:<br>
>>> > <<a
href="mailto:AANLkTikKNvHRDLvJxBwObAOGnAMn1b0a3p4S%2B9n283GX@mail.gmail.com">AANLkTikKNvHRDLvJxBwObAOGnAMn1b0a3p4S+9n283GX@mail.gmail.com</a>><br>
>>> > Content-Type: text/plain; charset="iso-8859-1"<br>
>>> ><br>
>>> > Hi All,<br>
>>> ><br>
>>> > Below is the dump result when the report SWN_SELSEN is
executed. Does<br>
>>> > this<br>
>>> > issue related to memory??<br>
>>> ><br>
>>> ><br>
>>> > Memory consumption<br>
>>> > Roll.... 16192<br>
>>> > EM...... 12569520<br>
>>> > Heap.... 0<br>
>>> > Page.... 90112<br>
>>> > MM Used. 2145408<br>
>>> > MM Free. 2041808<br>
>>> ><br>
>>> > --<br>
>>> > Thanks and Regards<br>
>>> > Srini..<br>
>>> > -------------- next part --------------<br>
>>> > An HTML attachment was scrubbed...<br>
>>> > URL:<br>
>>> ><br>
>>> > <a
href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/2578f7f7/attac"
target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100817/2578f7f7/attac</a><br>
>>> ><br>
>>> > hment-0001.htm<br>
>>> ><br>
>>> > ------------------------------<br>
>>> ><br>
>>> > Message: 3<br>
>>> > Date: Tue, 17 Aug 2010 13:01:40 -0500<br>
>>> > From: Rick Bakker <<a href="mailto:rbakker@gmail.com">rbakker@gmail.com</a>><br>
>>> > Subject: Re: SWN_SELSEN dump result<br>
>>> > To: "SAP Workflow Users' Group" <<a
href="mailto:sap-wug@mit.edu">sap-wug@mit.edu</a>><br>
>>> > Message-ID:<br>
>>> > <AANLkTikZGSUyM8GwXfFc+kecQsDGHz9UX+=<a
href="mailto:R53TYH_6F@mail.gmail.com">R53TYH_6F@mail.gmail.com</a>><br>
>>> > Content-Type: text/plain; charset=ISO-8859-1<br>
>>> ><br>
>>> > Hello,<br>
>>> ><br>
>>> > Doesn't the dump show any sort of error?<br>
>>> ><br>
>>> > Has it been working in the past?<br>
>>> > Check also SLG1.<br>
>>> ><br>
>>> > regards<br>
>>> > Rick Bakker<br>
>>> > Hanabi Technology<br>
>>> ><br>
>>> > On Tue, Aug 17, 2010 at 12:34 PM, srinivas<br>
>>> > <<a href="mailto:ootasrinivasreddy@gmail.com">ootasrinivasreddy@gmail.com</a>><br>
>>> > wrote:<br>
>>> >><br>
>>> >> Hi All,<br>
>>> >><br>
>>> >> Below is the dump result when the report SWN_SELSEN is
executed. Does<br>
>>> > this<br>
>>> >> issue related to memory??<br>
>>> >><br>
>>> > -------------- next part --------------<br>
>>> > An HTML attachment was scrubbed...<br>
>>> > URL:<br>
>>> > <a
href="http://mailman.mit.edu/pipermail/sap-wug/attachments/20100818/0f46b8dc/attachment-0001.htm"
target="_blank">http://mailman.mit.edu/pipermail/sap-wug/attachments/20100818/0f46b8dc/attachment-0001.htm</a><br>
>>> ><br>
>>> > ------------------------------<br>
>>> ><br>
>>> > _______________________________________________<br>
>>> > SAP-WUG mailing list<br>
>>> > <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
>>> > <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"
target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
>>> ><br>
>>> ><br>
>>> > End of SAP-WUG Digest, Vol 69, Issue 36<br>
>>> > ***************************************<br>
>>> ><br>
>>> > _______________________________________________<br>
>>> > SAP-WUG mailing list<br>
>>> > <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
>>> > <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"
target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
>>> ><br>
>>><br>
>>> _______________________________________________<br>
>>> SAP-WUG mailing list<br>
>>> <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
>>> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug"
target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
>><br>
>><br>
>><br>
>> --<br>
>> Thanks and Regards<br>
>> Srini..<br>
>> SAP Technical Consultant<br>
>> <a href="mailto:srinivasa.reddy.oota@sap.com">srinivasa.reddy.oota@sap.com</a><br>
>> +919886760677<br>
>><br>
><br>
><br>
><br>
> --<br>
> Thanks and Regards<br>
> Srini..<br>
><br>
> _______________________________________________<br>
> SAP-WUG mailing list<br>
> <a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
><br>
><br>
<br>
_______________________________________________<br>
SAP-WUG mailing list<br>
<a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><o:p></o:p></span></font></p>
</div>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br clear=all>
<br>
-- <br>
Thanks and Regards<br>
Srini..<o:p></o:p></span></font></p>
</div>
</body>
</html>