View source for Resetting Smart Dispute Data for Journey Re-run

Resetting Smart Dispute Data for Journey Re-run / ← Resetting Smart Dispute data

You do not have permission to edit this page, for the following reasons:

• The action you have requested is limited to users in one of the groups: Users, editor, pegaemployee.
• The action you have requested is limited to users in one of the groups: pegaemployee, editor, Administrators.

---

You can view and copy the source of this page.

{{Design pattern|Title=Resetting Smart Dispute data|Description=Script to reset work object and related data|Version=7.1.1|Applications=Pega Disputes and Payments Exceptions|Capability Area=Financial Services|Owner=Manjusha Gandham}} == Resetting Smart Dispute data for Journey rerun == To showcase a Smart Dispute journey demo to a new customer, a system without a dispute work object or any associated work object related data is required. To achieve this, one way is to reset or reinstall the application or delete all the existing work object and the associated data. Resetting or reinstalling the application takes a lot of time and resetting multiple configuration settings to achieve the desired demo scenario. Deleting and resetting the existing data is easy to perform, and is explained below. Run the following SQL script by replacing the <PegaData> with the exact schema name and modify the script per the database type to reset the Smart Dispute data: <code>delete from <PegaData>.pc_data_uniqueid;</code> <code>update <PegaData>.pc_data_uniqueid set pylastreservedid=0;</code> <code>delete from <PegaData>.sd_claim;</code> <code>delete from <PegaData>.sd_dispute;</code> <code>delete from <PegaData>. pc_work;</code> <code>delete from <PegaData>. pc_assign_worklist;</code> <code>delete from <PegaData>. pc_assign_workbasket;</code> <code>delete from <PegaData>. pc_history_work;</code> <code>delete from <PegaData>. pc_data_workattach;</code> <code>delete from <PegaData>. pc_index_workparty;</code> <code>delete from <PegaData>. pc_link_attachment;</code> <code>delete from <PegaData>. pc_link_folder;</code> <code>delete from <PegaData>. paf_entry;</code> <code>delete from <PegaData>. paf_index_workparty;</code> <code>delete from <PegaData>. pr_assign;</code> <code>delete from <PegaData>. pr_sys_locks;</code> <code>delete from <PegaData>. pr_sys_queue_sla;</code> <code>delete from <PegaData>. pr_sys_queues;</code> <code>delete from <PegaData>. pr_data;</code> <code>delete from <PegaData>. pr_link;</code> <code>delete from <PegaData>. pc_work_social;</code> <code>delete from <PegaData>. pr_index;</code> <code>delete from <PegaData>. pr_Index_PegaCard_Sd_FraudRepo;</code>

Return to Resetting Smart Dispute data.