Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Tommaso Genta (TomAGRVC)
Realvalue Consulting
Director
Realvalue Consulting
CH
TomAGRVC Member since 2013 2 posts
Realvalue Consulting
Posted: Mar 18, 2016
Last activity: Jul 9, 2016
Posted: 18 Mar 2016 6:41 EDT
Last activity: 9 Jul 2016 10:00 EDT
Closed
Solved

Smart Investigate - Production Environment Cleaning

Our Project is expected to Go-Live in ten days and, since we're now in Business Simulation in the Production Environment, we have to clean the whole database (all cases, cache, etc..) in order to have a clean situation for the users to start the actual business adoption of the new Platform.

The Platform is based on PEGA PRCP 7.1.9 + Smart Investigate for Payments 7.11.

Any kind advice or best practice you may provide in order to reach the clean environment status for the Go-Live is more than welcome.

Thanks

To see attachments, please log in.
Pega Customer Service
Installation and Deployment
Data Integration
System Administration

Accepted Solution

Posted: 8 years ago
Posted: 3 Apr 2016 14:35 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

Hi Genta, Good morning!

  • Most of the tables are covered in Kevin's post. again copying the tables just to draw the final list using both the posts.

Smart Investigate WorkObject Table Delete Script

DB2

Delete from si_work@

Delete from si_index_workparty@

Delete from research_links@

Delete from paf_work@

Delete from paf_index_workparty@

Delete from paf_index_txn@

Delete from paf_index_original@

Delete from paf_entry@

Delete from pc_assign_workbasket@

Delete from pc_assign_worklist@

Delete from pc_data_workattach@

Delete from pc_index_workparty@

Delete from pc_link_attachment@

Delete from pc_link_folder@

Delete from pc_history_work@

Commit@

Oracle

Delete from si_work;

Delete from si_index_workparty;

Delete from research_links;

Delete from paf_work;

Delete from paf_index_workparty;

Delete from paf_index_txn;

Delete from paf_index_original;

Delete from paf_entry;

Delete from pc_assign_workbasket;

Delete from pc_assign_worklist;

Delete from pc_data_workattach;

Delete from pc_index_workparty;

Delete from pc_link_attachment;

Delete from pc_link_folder;

Delete from pc_history_work;

Commit;

User Note

Show More

Hi Genta, Good morning!

  • Most of the tables are covered in Kevin's post. again copying the tables just to draw the final list using both the posts.

Smart Investigate WorkObject Table Delete Script

DB2

Delete from si_work@

Delete from si_index_workparty@

Delete from research_links@

Delete from paf_work@

Delete from paf_index_workparty@

Delete from paf_index_txn@

Delete from paf_index_original@

Delete from paf_entry@

Delete from pc_assign_workbasket@

Delete from pc_assign_worklist@

Delete from pc_data_workattach@

Delete from pc_index_workparty@

Delete from pc_link_attachment@

Delete from pc_link_folder@

Delete from pc_history_work@

Commit@

Oracle

Delete from si_work;

Delete from si_index_workparty;

Delete from research_links;

Delete from paf_work;

Delete from paf_index_workparty;

Delete from paf_index_txn;

Delete from paf_index_original;

Delete from paf_entry;

Delete from pc_assign_workbasket;

Delete from pc_assign_worklist;

Delete from pc_data_workattach;

Delete from pc_index_workparty;

Delete from pc_link_attachment;

Delete from pc_link_folder;

Delete from pc_history_work;

Commit;

User Note

  • Execute the above script to delete Exception & Message cases (work objects) to de-link the transactions from work objects.
  • If cache is deleted - first user might notice a slow response from application and we might need to run static assembler before user run through the application.

Thank you!

psahukaru


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 21 Mar 2016 18:40 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

As a startup, I copied what Elisha Tanikonda for early version of smart investigate running on 61sp2 - let's wait for SMEs to provide insights. But I believe for the most part, the list below is still valid. If necessary, create a SR for further investigation.

Provided the below suggestions to the customer.

For BIX
========
pr_extract_time

For PRPC
=======

pc_work  —  Primary work object record
pc_history_work —  Audit trail details
pc_assign_* tables —  Incomplete assignments 
pc_link_attachment — Associates a work object with attachments, optional files, e-mail messages, or images.
pc_link_folder — Support folders, an  optional facility for grouping multiple work objects 
pc_data_workattach — Holds work object attachments
pc_index_workparty — Cross-references work objects by an identifier for each party (participant), such as an account number, Social Security Number, e-mail address, or telephone number.
pc_data_unique. — Supports unique work object numbering 
pr_data —  Holds unsent correspondence for work objects [don't truncate the whole table!]
pr_assign - external assignments go here

Show More

As a startup, I copied what Elisha Tanikonda for early version of smart investigate running on 61sp2 - let's wait for SMEs to provide insights. But I believe for the most part, the list below is still valid. If necessary, create a SR for further investigation.

Provided the below suggestions to the customer.

For BIX
========
pr_extract_time

For PRPC
=======

pc_work  —  Primary work object record
pc_history_work —  Audit trail details
pc_assign_* tables —  Incomplete assignments 
pc_link_attachment — Associates a work object with attachments, optional files, e-mail messages, or images.
pc_link_folder — Support folders, an  optional facility for grouping multiple work objects 
pc_data_workattach — Holds work object attachments
pc_index_workparty — Cross-references work objects by an identifier for each party (participant), such as an account number, Social Security Number, e-mail address, or telephone number.
pc_data_unique. — Supports unique work object numbering 
pr_data —  Holds unsent correspondence for work objects [don't truncate the whole table!]
pr_assign - external assignments go here

For Smart Investigate and SWIFTNet (E & I)
============================
delete from si_work;
si_index_workparty;
research_links;
paf_work;
paf_index_workparty;
paf_index_txn;
paf_index_original;
paf_entry;
pc_assign_workbasket;
pc_assign_worklist;
pc_data_workattach;
pc_index_workparty;
pc_link_attachment;
pc_link_folder;
pc_history_work;


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 29 Mar 2016 11:55 EDT
Elisha Tanikonda (Elisha Tanikonda)
PEGA
Senior Manager of Technical Support Engineering
Pegasystems Inc.
US

Hi Kevin

Due to some reason, I did not receive an email notification from mesh on this thread. I just found this item today when I was going through my mesh inbox.

I am copying, Srikanth Tadi who can help you on your Smart Investigate query.

Thanks

Elisha

To see attachments, please log in.

Accepted Solution

Posted: 8 years ago
Posted: 3 Apr 2016 14:35 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

Hi Genta, Good morning!

  • Most of the tables are covered in Kevin's post. again copying the tables just to draw the final list using both the posts.

Smart Investigate WorkObject Table Delete Script

DB2

Delete from si_work@

Delete from si_index_workparty@

Delete from research_links@

Delete from paf_work@

Delete from paf_index_workparty@

Delete from paf_index_txn@

Delete from paf_index_original@

Delete from paf_entry@

Delete from pc_assign_workbasket@

Delete from pc_assign_worklist@

Delete from pc_data_workattach@

Delete from pc_index_workparty@

Delete from pc_link_attachment@

Delete from pc_link_folder@

Delete from pc_history_work@

Commit@

Oracle

Delete from si_work;

Delete from si_index_workparty;

Delete from research_links;

Delete from paf_work;

Delete from paf_index_workparty;

Delete from paf_index_txn;

Delete from paf_index_original;

Delete from paf_entry;

Delete from pc_assign_workbasket;

Delete from pc_assign_worklist;

Delete from pc_data_workattach;

Delete from pc_index_workparty;

Delete from pc_link_attachment;

Delete from pc_link_folder;

Delete from pc_history_work;

Commit;

User Note

Show More

Hi Genta, Good morning!

  • Most of the tables are covered in Kevin's post. again copying the tables just to draw the final list using both the posts.

Smart Investigate WorkObject Table Delete Script

DB2

Delete from si_work@

Delete from si_index_workparty@

Delete from research_links@

Delete from paf_work@

Delete from paf_index_workparty@

Delete from paf_index_txn@

Delete from paf_index_original@

Delete from paf_entry@

Delete from pc_assign_workbasket@

Delete from pc_assign_worklist@

Delete from pc_data_workattach@

Delete from pc_index_workparty@

Delete from pc_link_attachment@

Delete from pc_link_folder@

Delete from pc_history_work@

Commit@

Oracle

Delete from si_work;

Delete from si_index_workparty;

Delete from research_links;

Delete from paf_work;

Delete from paf_index_workparty;

Delete from paf_index_txn;

Delete from paf_index_original;

Delete from paf_entry;

Delete from pc_assign_workbasket;

Delete from pc_assign_worklist;

Delete from pc_data_workattach;

Delete from pc_index_workparty;

Delete from pc_link_attachment;

Delete from pc_link_folder;

Delete from pc_history_work;

Commit;

User Note

  • Execute the above script to delete Exception & Message cases (work objects) to de-link the transactions from work objects.
  • If cache is deleted - first user might notice a slow response from application and we might need to run static assembler before user run through the application.

Thank you!

psahukaru


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 9 Jul 2016 10:00 EDT
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

yes. ideally when application extended for implementation app express/DCO will create implementation specific work table.

To see attachments, please log in.

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

Pega Collaboration Center 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