Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Need more details about archiving the Work Objects to another DB

SA-10395

Summary


Provide more details on following queries:

1.Handling the Index related tables
 User tries deleting Work Object from Work table system automatically deletes the indexes from index tables, but when retrieved it system did not create the index instances related to the work Object.
What is the reason?

2.What are the different tables, in which Work Object data is stored.
-User is aware of the pc_work, history, workparty and pc_link_attachment tables. Please provide rest of the table details.

3.How to handle the archiving, can this be done with below approach, or do we have any OOTB approach for archiving:
 -Open the WorkObject from the work table, copy the WorkObject to the Archive table (this is a replica of the work table) and delete the Workobject from Work table (With Obj-* methods).

4.Do we have any document link for knowing more information about the archiving.


Resolution




Handling the Index related tables? how it will be populated?

When we import the archive zip, index should be created on saving the WO and saving is done automatically in the process of importing.

How do we need to handle the archiving, can this be done with below approach, or do we have any OOTB approach for archiving.

https://pdn.pega.com/sites/default/files/help_v62/procomhelpmain.htm#tools/purgearchive/aboutpurgearchivewizard.htm

What are the different tables, in which Work Object data will be stored.

You can enable the Global DB trace in SME and get all the insert statements when creating the work item to precisely get an idea which all table gets updated.


 

Published June 12, 2015 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us