Resetting Smart Dispute Data for Journey Re-run

From PegaWiki
Resetting Smart Dispute Data for Journey Re-run /
Revision as of 13:29, 24 February 2021 by Guru Deshkulkarni (talk | contribs) (curator assigned)

Jump to navigation Jump to search

Curator Assigned Manjusha Gandham
Request to Publish Yes
Description Resetting Smart Dispute Data for Journey Re-run
Version as of 7.x
Application Smart Dispute
Capability/Industry Area Financial Services

↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ Please Read Below ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓

Enter your content below. Use the basic wiki template that is provided to organize your content. After making your edits, add a summary comment that briefly describes your work, and then click "SAVE". To edit your content later, select the page from your "Watchlist" summary. If you can not find your article, search the design pattern title.

When your content is ready for publishing, next to the "Request to Publish" field above, type "Yes". A Curator then reviews and publishes the content, which might take up to 48 hours.

↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ The above text will be removed prior to being published ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓

Resetting Smart Dispute Data for Journey Re-run[edit]

During the Smart Dispute Journey demo, it is often required to have a system with no dispute work object and no associate data related to work object to showcase proper scenario to new customer.

To achieve this, one way is to reset the current application and reinstall Smart Dispute or delete all the existing work object and its associate data. The first approach is time taking and the team providing demo must perform lots of configuration setting to achieve the desired demo scenario. The later approach is quite simple and easy to perform, giving the team providing the demo to focus only on the demo scenario.

Script to reset Smart Dispute data[edit]

Run the following SQL script to reset the Smart Dispute data.

  • delete from <PegaData>.pc_data_uniqueid;
  • update <PegaData>.pc_data_uniqueid set pylastreservedid=0;
  • delete from <PegaData>.sd_claim;
  • delete from <PegaData>.sd_dispute;
  • delete from <PegaData>. pc_work;
  • delete from <PegaData>. pc_assign_worklist;
  • delete from <PegaData>. pc_assign_workbasket;
  • delete from <PegaData>. pc_history_work;
  • delete from <PegaData>. pc_data_workattach;
  • delete from <PegaData>. pc_index_workparty;
  • delete from <PegaData>. pc_link_attachment;
  • delete from <PegaData>. pc_link_folder;
  • delete from <PegaData>. paf_entry;
  • delete from <PegaData>. paf_index_workparty;
  • delete from <PegaData>. pr_assign;
  • delete from <PegaData>. pr_sys_locks;
  • delete from <PegaData>. pr_sys_queue_sla;
  • delete from <PegaData>. pr_sys_queues;
  • delete from <PegaData>. pr_data;
  • delete from <PegaData>. pr_link;
  • delete from <PegaData>. pc_work_social;
  • delete from <PegaData>. pr_index;
  • delete from <PegaData>. pr_Index_PegaCard_Sd_FraudRepo;

Replace the <PegaData> with the exact schema name. Also, modify the above script as per the database type.