RSWUWFML2 Report

[Mike Pokraka]

Hi Seth,

This might still be correct. I may be wrong and don't really have the time
to check, but your variant looks right so a sensible conclusion may be
that one initial run with 'new work items only' is needed to set your last
run date - thus your interval only becomes effective on the second run.

Cheers,
Mike


> I updated the variant to include "New Work Items Only" and the report
> still took 3.5 hours to run this morning.  Below is the screen variant
> used, any suggestions?
>
> Thanks,
> Seth
>
> Job suffix                      2
>
> Tasks (blank = all)             TS90000070
>
>                                 TS90000110
>
>                                 TS90000130
>
>                                 TS90000058
>
>                                 TS90000066
>
>                                 TS90000005
>
>                                 TS90000150
>
>                                 TS90000129
>
>                                 TS90000142
>
> New Work Items Only             X
>
> With Passive Substitution
>
> One Message Per Work Item
>
> Collective Message              X
>
> Workflow Entry
>
> Work Item Display
>
> Work Item Execution
>
> Message Class for Subject       SWU_NOTIF
>
> Message Number for Subject      001
>
> Before Work Item Description    SWU_NOTIF_INBOX
>
> After Work Item Description
>
> SAPLOGON_ID
>
> FB for Preparation Phase
>
> FB for Address Determination
>
>>From Work Item Creation Date    00/00/0000
>
>>From Work Item Creation Time      :  :
>
> Users (blank = all)
>
> Errors Only                     X
>
> All
>
>
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
> Of Stevens, Seth
> Sent: Monday, August 07, 2006 9:45 AM
> To: SAP Workflow Users' Group
> Subject: RE: RSWUWFML2 Report
>
> As you guessed "only new workitems" isn't set...guess I missed it when
> setting up the variant.
>
> I'll change it today suspect we'll see MUCH better performance
> tomorrow's run.  Thanks for the tips.
>
> --Seth
>
> -----Original Message-----
> From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
> Of Mike Pokraka
> Sent: Monday, August 07, 2006 9:37 AM
> To: SAP Workflow Users' Group
> Subject: Re: RSWUWFML2 Report
>
> What the...? Three hours? Sone hints:
>
> Make sure you set "only new workitems" (methinks this is where your
> setup is choking)
>
> You can create separate instances of the job for different tasks /
> frequencies / whatevers. Not uncommon to run it e.g. an hourly one for
> 'urgent notification' type tasks and a twice daily job for others etc.
>
> It's pretty well documented, click the info button on the front screen.
>
> Cheers,
> Mike
>
>
>> Hi all...does any one have any performance suggestions for the
>> RSWUSFML2 report for workitem notification?  It is currently taking
>> over 3 hours to run and is increasing at a rate of about 10 minutes
>> per day.  I'm sure that archiving the workitems and logs would help
>> but I didn't want to do that yet as the system has been in production
>> for less than 1 month.  Is the architecture of the report such that
>> the response time is affected by all workitems (even completed) or is
>> it only affected by the number of in process workitems?
>>
>> Any tips?
>>
>> Thanks,
>> Seth
>>
>>
>>
>> -----------------------------------------
>> Anadarko Confidentiality Notice:
>> This electronic transmission and any attached documents or other
>> writings are intended only for the person or entity to which it is
>> addressed and may contain information that is privileged, confidential
>
>> or otherwise protected from disclosure.  If you have received this
>> communication in error, please immediately notify sender by return
>> e-mail and destroy the communication. Any disclosure, copying,
>> distribution or the taking of any action concerning the contents of
>> this communication or any attachments by anyone other than the named
>> recipient is strictly prohibited.
>> _______________________________________________
>> SAP-WUG mailing list
>> SAP-WUG at mit.edu
>> http://mailman.mit.edu/mailman/listinfo/sap-wug
>>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>