Change status in SWN_NOTIF

[Morris, Eddie]

Hi Margaret,

The next run of the FULL filter sets the entries in SWN_NOTIF to status 'L' when the task is removed from the filter. If the category is deleted completely, then a run of report RSWN_RUNTIME_DATA_REORG might be necessary.

If this does not work then I would suggest you open a message/incident with SAP in component BC-BMT-WFM-NOT and put for my attention.

Regards,
Eddie

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Hilsbos, Margaret A
Sent: Tuesday, January 07, 2014 4:49 PM
To: SAP Workflow Users' Group
Subject: RE: Change status in SWN_NOTIF

Hi Eddie,

Thanks for your quick reply! I'm a little unclear about how this is supposed to happen (i.e. what 'job' is supposed to update the status).  We have recent work items (since the config was updated) that are correctly getting set to 'L' in SWN_NOTIF after they are completed. So I think the configuration is correct. But these old ones are NOT being updated.  Here is what I think is happening:


Example:  SWN_NOTIF has entries for:

Category Id : ZZ123
Task ID:   TS90100005
Status: D

But, the category ZZ123 (now) only applies to tasks TS90100001 , TS90100002, and TS90100004.

The task TS90100005 was once included in ZZ123 but no longer. It is  still active but under another category, for example ZZ456, which only applies to that task. New work items for TS90100005 are behaving correctly: at some point after the work item is completed or logically deleted it gets the status 'L' in SWN_NOTIF.

I'm thinking that:


*         when the selection runs for category ZZ123 it doesn't find or do anything with any tasks from TS90100005, because it doesn't care about them anymore, they aren't part of its selection.

*         When the selection runs for category ZZ456, it doesn't do anything with records in SWN_NOTIF that are in category ZZ123. So it ignores these old records we want to get rid of.

So those old records stay forever in status D.


Does that make sense?

Thanks again,

Margaret


From: sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu> [mailto:sap-wug-bounces at mit.edu] On Behalf Of Morris, Eddie
Sent: Tuesday, January 07, 2014 11:09 AM
To: SAP Workflow Users' Group
Subject: RE: Change status in SWN_NOTIF

Hi Margaret,

The job should see that the corresponding work items are now completed or logically deleted and should set the status in SWN_NOTIF to 'L' automatically. Have you run the job since the entries were created?

Regards,
Eddie

From: sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu> [mailto:sap-wug-bounces at mit.edu] On Behalf Of Hilsbos, Margaret A
Sent: Tuesday, January 07, 2014 3:56 PM
To: sap-wug at mit.edu<mailto:sap-wug at mit.edu>
Subject: Change status in SWN_NOTIF

Hi WUGers,

We have a little problem ... ok a few thousand entries ... in SWN_NOTIF with entries that are at status 'D' or 'S' and we would like them to be at 'L'. They were created in error under the wrong category. The category has since been updated so that those tasks are no longer included in the category. The corresponding work items have since been either completed or logically deleted, but I think the normal background job that would set the status to 'L' will not see them.  So we want to force the status change to 'L'. Once they are at 'L', RSWNNOTIFDEL can take care of them.

Is there any standard program or routine that we can run to update the status to 'L'  for selected entries?  Alternatively, what would you propose? Is this one of the rare cases where it's safe (or at least not too horrible) to write a program that will directly update the table to change the status?

Thanks for any advice,

Margaret

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