SWW_CONTOB entries missing

[Lalitha Sankaran]

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> 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] *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
>
>
>  ------------------------------
>
> *From:* 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
> 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/2f5ec996/attachment.htm