WF Background Jobs

[Neumann, Marcia]

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.

 

Reply from SAP               09/15/2005 04:27:04

I analyzed the problem in your system. We really have a problem with

the performance of report RSWWCOND. Development is aware of that, and

thinking of a redesign of the functionality. For the time being, we

can offer the following solution:

- I checked the definition table SWD_CONDEF. I see that the relevant

  conditions are only used in one workflow: WS90200019, step 29. This

  step is the 'post' step. It is task TS90200040.

  Relevant condition types are only 'PO', 'PR', and 'WA'.

- RSWWCOND really only needs to check conditions for that task number.

  So, we can enter this task on the selection screen for RSWWCOND.

  The report then runs only 2 seconds, because it can access table

  SWWWIHEAD with index C.

- You need to define this selection criteria in a variant, and have

  the background job always run with this variant.

- The great disadvantage of this is: any time you change your workflow,

  or start working with a new workflow in some application area, you

  need to recheck table SWD_CONDEF.

  I wonder if this is acceptable to you?

  Please let me know.

Best regards,

Workflow Development Support

 

Reply from SAP               09/16/2005 04:58:20

A redesign of the functionality can not be delivered per support

package.

I ran the report with SQL trace on, and found that index C is not ued.

Please see note 799002, and change the index, and generate it.

Then check note 724614 for anything to be done on the database side

(I am not at all a database expert).

Then please rerun the report with SQL trace (ST05) switched on. The

select should be done by index C then.

If that is not the case, I will need to send this message to the DB2

database experts. In that case, please keep the system connection open

a little longer.

Best regards,

 

Marcia Neumann

CMS Workflow Administration

IT Claims Development/Support

Phone: (513) 870-2300 ext. 4461

Fax: (513) 603-5388

Confidentiality notice: 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.

________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Jeffrey A. Rappaport
Sent: Wednesday, May 14, 2008 11:25 AM
To: SWUG (SAP)
Subject: WF Background Jobs

 

All,

 

   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.

 

Thanx,


Jeffrey A. Rappaport
Business Workflow, LLC
Voice:  +1 (732) 355-0123
Fax:     +1 (509) 757-4144
Email:  Jeff at Business-Workflow.com
Web:   www.Business-Workflow.com

 

   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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20080514/9c2df463/attachment.htm