<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Sue,<BR>
<BR>
We saw something like this when we upgraded and the problem that affected us was actually buried deep in the Builder in a unicode check statement.<BR>
<BR>
I'm presuming here that the text on the right-hand side of the statements are constant strings? If so, then the unicode bug might be affecting you too.<BR>
<BR>
It could be, for example, that the lowercase letters are now significantly different to the event word 'OR' in upper case that an untrapped unicode error results.<BR>
<BR>
We found that by switching to change mode, clicking the condition editor for a step like this and then simply exiting the editor screen was sometimes enough to prompt the builder to add the 'missing' bits. Without actually having to save anything.<BR>
<BR>
We also found that some steps responded well to using SWUD by the execution of the 'Test Environment' function on the Workflow definition, but this wasn't always effective every time.<BR>
<BR>
Mike GT<BR> <BR>
<HR id=stopSpelling>
From: Sue.Doughty@odfl.com<BR>To: sap-wug@mit.edu<BR>Date: Wed, 25 Aug 2010 08:52:07 -0400<BR>Subject: Workflow syntax errors not in DEV or QAS<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass .ecxshape
{;}
</STYLE>
<STYLE>
</STYLE>
<STYLE>
.ExternalClass a:link
{;}
.ExternalClass span.ecxMSOHYPERLINK
{;}
.ExternalClass a:visited
{;}
.ExternalClass span.ecxMSOHYPERLINKFOLLOWED
{;}
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass span.ecxEmailStyle17
{font-family:Calibri;color:#1F497D;}
.ExternalClass span.ecxEmailStyle18
{font-family:Arial;color:black;font-weight:normal;font-style:normal;text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.ecxSection1
{page:Section1;}
</STYLE>
<DIV class=ecxSection1>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">We are on ECC 6.0. </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">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?</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><IMG id=ecx_x0000_i1026 height=471 src="cid:image001.jpg@01CB4432.CC76EA70" width=1059></SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<DIV>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Regards,</SPAN></FONT><FONT color=black><SPAN style="COLOR: black"></SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Sue</SPAN></FONT><FONT color=black><SPAN style="COLOR: black"></SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face="Times New Roman" color=black size=3><SPAN style="FONT-SIZE: 12pt; COLOR: black"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face="Arial Narrow" color=navy size=2><SPAN lang=EN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial Narrow'">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 face="Arial Narrow" color=navy size=1><SPAN lang=EN style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial Narrow'"> -</SPAN></FONT><STRONG><B><FONT face="Arial Narrow" color=navy size=2><SPAN lang=EN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial Narrow'">Andy Griffith</SPAN></FONT></B></STRONG><FONT face="Arial Narrow" size=1><SPAN lang=EN style="FONT-SIZE: 7.5pt; FONT-FAMILY: 'Arial Narrow'"></SPAN></FONT></P></DIV>
<DIV>
<DIV class=ecxMsoNormal style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=ecxMsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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></P></DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Hi,</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Try running RSWWWIDE_DEP on tables SWWUSERWI and SWWORGTASK and remove any obsolete entries. Then try running SWN_SELSEN again.</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Regards,</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri">Eddie</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face=Calibri color=#1f497d size=2><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: Calibri"> </SPAN></FONT></P>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=ecxMsoNormal><B><FONT face=Tahoma size=2><SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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</SPAN></FONT></P></DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P>
<DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Hi Rick,</SPAN></FONT></P></DIV>
<DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P></DIV>
<DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">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.</SPAN></FONT></P></DIV>
<DIV>
<TABLE class=ecxMsoNormalTable cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 52</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> IF NOT read_org_task IS INITIAL. </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">>>>>></SPAN></FONT> </P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> SELECT * FROM swworgtask INTO TABLE loc_org_task </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 54</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> WHERE wi_id = wi_id </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 55</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> AND no_sel = space. </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 56</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> ELSE. </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 57</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">* use given entries </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 58</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> loc_org_task[] = act_org_task[]. </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 59</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 60</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> DELETE loc_org_task WHERE wi_id <> wi_id </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 61</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> OR no_sel <> space. </SPAN></FONT></P></TD></TR>
<TR>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> 62</SPAN></FONT></P></TD>
<TD style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; BACKGROUND: #eef9ff; PADDING-BOTTOM: 0.75pt; CURSOR: hand; PADDING-TOP: 0.75pt" bgColor=#eef9ff>
<P class=ecxMsoNormal><FONT face="Courier New" size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"> ENDIF. </SPAN></FONT></P></TD></TR></TBODY></TABLE>
<P class=ecxMsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"> </SPAN></FONT></P></DIV>
<DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">On Sat, Aug 21, 2010 at 8:42 PM, Rick Bakker <<A href="mailto:rbakker@gmail.com">rbakker@gmail.com</A>> wrote:</SPAN></FONT></P>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Hello,<BR><BR>If you can't go the route of changing the SWN_TIMESTAMPS table (which<BR>Florin 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.</SPAN></FONT></P>
<DIV>
<P class=ecxMsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR>regards<BR>Rick Bakker<BR>Hanabi Technology</SPAN></FONT></P></DIV>
<DIV>
<DIV>
<P class=ecxMsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">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 WIs 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></SPAN></FONT></P></DIV></DIV></DIV>
<P class=ecxMsoNormal style="MARGIN-BOTTOM: 12pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR><BR clear=all><BR>-- <BR>Thanks and Regards<BR>Srini..</SPAN></FONT></P></DIV><BR>_______________________________________________ SAP-WUG mailing list SAP-WUG@mit.edu http://mailman.mit.edu/mailman/listinfo/sap-wug                                            </body>
</html>