SWW_CONTOB entries missing

[Sheldon Oxenberg]

Hi Eddie and Lalitha,

Workflow data from archived work items is gone from the workflow runtime
tables, but archive functions maintain an index that points to the archived
data.
Therefore, it is possible in a custom report to utilize the archive
functions and index to access the archived workflow data.

Regards,
SHELDON OXENBERG
System Architect Principal Leader
LMP Technical Architect, SAP Workflow
CSC


                                                                                                                       
  From:       "Morris, Eddie" <eddie.morris at sap.com>                                                                   
                                                                                                                       
  To:         "SAP Workflow Users' Group" <sap-wug at mit.edu>                                                            
                                                                                                                       
  Date:       12/02/2009 12:50 PM                                                                                      
                                                                                                                       
  Subject:    RE: SWW_CONTOB entries missing                                                                           
                                                                                                                       





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> 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
 _______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug