SWW_CONTOB entries missing

[Morris, Eddie]

Hi Lalitha,

If you archive work items then all data from the workflow runtime tables will be removed. So once archived, the data is gone....not move to another table.

Regards,
Eddie

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Lalitha Sankaran
Sent: 02 December 2009 17:15
To: SAP Workflow Users' Group
Subject: Re: SWW_CONTOB entries missing

Hi,

The custom report is reading directly from the SWW_CONTOB table, and I see that for archived workflows, then entry is missing in this table.
Not sure if the entries are archived as well, or moved to a different table.

Any input is appreciated.
Thank you
Lalitha
On Wed, Dec 2, 2009 at 5:18 AM, Morris, Eddie <eddie.morris at sap.com<mailto:eddie.morris at sap.com>> wrote:
Hi Lalitha,

Tables SWW_CONTOB & SWW_CONT are used in Basis 640 onwards, but only if you choose the 'old' container persistence. When using XML persistence in your workflow no entries will be written to these tables.  You can change the settings for the persistence profile of a workflow via the builder => Basic Data => Version Dependent => Control tab. Look in the 'Persistence profile' tab and you can change the settings (But I would not recommend changing it).

Entries with XML persistence are stored in table SWWCNTP0. The only issue will be if you have some custom code that reads directly from tables SWW_CONTOB & SWW_CONT.

As Sue has detailed below there are several standard reports to find work items related to an object or if doing it via custom code please use the WAPI's.

Regards,
Eddie

From: sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu> [mailto:sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu>] On Behalf Of Keohan, Susan - 1140 - MITLL
Sent: 01 December 2009 21:44

To: SAP Workflow Users' Group
Subject: RE: SWW_CONTOB entries missing

Hi Lalitha,
The first thing I wonder is why would you be doing lookups in SWW_CONTOB?  You should
probably be using SAP_WAPI_READ_CONTAINER rather than doing table lookups.

You said you want to track the history of this document thru workflow; don't the standard reports provide enough information? Swi2_freq, or, from the object, you can use Generic Object Services.
As for archiving, if you archived the data for the workflow - then you would not find the same data related to the PS object in SWW_CONTOB.
You can read about the affects of archiving on workflow data starting with the SAP Help (http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e704c462a11d189000000e8323d3a/content.htm)

Good luck,
Sue


----
Susan R. Keohan
SAP Workflow Specialist
Enterprise Applications
Information Services Department
MIT Lincoln Laboratory
244 Wood Street, LI-200
Lexington, MA. 02420
781-981-3561
keohan at LL.MIT.EDU<mailto:keohan at LL.MIT.EDU>

________________________________
From: sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu> [mailto:sap-wug-bounces at mit.edu<mailto:sap-wug-bounces at mit.edu>] On Behalf Of Lalitha Sankaran
Sent: Tuesday, December 01, 2009 3:55 PM
To: SAP Workflow Users' Group
Subject: SWW_CONTOB entries missing

Hi,

How do we view an archived workflow log ?

We have a document which went thru the approval process and was posted by WFBATCH, but am not able to find an entry
in the sww_contob table. The same document in the PS system has an entry in SWW_CONTOB and also am able to
view the workflow log.

Could the WF be archived, if yes, then is the entry removed from the sww_contob table?
Or could the support pack have deleted any entries from the table.

How do I track the WF history of this document ?

We are using ECC 6.0 , SP SAPKA70103
Please advise.

Thank you
Lalitha


_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu<mailto:SAP-WUG at mit.edu>
http://mailman.mit.edu/mailman/listinfo/sap-wug

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