In production there was an issue due to blob for pagelist properties so we created a declare index in dev and deployed to prod what will happen to the inflight cases
In production there was an issue due to blob for pagelist properties so we created a declare index in dev and deployed to prod what will happen to the inflight cases
Accepted Solution
Updated: 16 Jun 2024 22:02 EDT
Tata Consultancy Services
IN
Hi @TanyaS58
Question: So why do we need to copy old cases data whose columns are not exposed?what is the need to copy their data?this i didnt get?
Answer:
Answer 1: If it is a newly created property and newly exposed/optimized column then not required.
Answer 2: Let's take, for example, that every month at the end of the day, users or business teams take reports by executing the reports.
If you expose or optimize a property in the 3rd week of the month (e.g., First Name and Last Name, Doesn't Matter about Scalar Property or Embedded Property).
If you execute the report at the end of the month, the data will not shows the first two weeks of cases for these two columns, irrespective of the cases.
The process commander will not generate simultaneously two queries for the same property or column (BLOB Query and Table Column SQL Query).
Once If you expose or optimize a property, Process Commander will always fetch data from the exposed column for RD.
For that reason, we need to enable check (default is enabled—this is an automatic job) or execute an activity to populate or copy data for old cases or in-flight cases.
I hope this will help you.
Thanks,
Ashok
Tata Consultancy Services
IN
Hi @TanyaS58,
Whenever we deploy our index rule into the higher environment, Pega by default runs the optimization process of the declare index rule for the in-flight cases.
It It will Schedule process and Run the job, For Old cases it copy the data from Blob to Index Table.
If you want, you can manually execute the activity and process. (ReCreateIndexesForClass)
Did you went through this article Written by Kensho Tsuchihashi How to optimize properties in production environment ? This is nice article, please go through once.
and Declare Index – its Configuration, Usage & Execution
Automatically populating new columns in existing tables and Scheduling indexes for population
I hope this will help you.
Thanks,
Ashok
Cognizant
IN
@Bhumireddy here I would just like to ask one more thing that as you mentioned above "For Old cases it copy the data from Blob to Index Table" I have a confusion here,see we optimised a new property and moved that to higher environment by using R-A-P now the column which we exposed in dev will be present in prod as well since we are moving the db instance in the product file.So why do we need to copy old cases data whose columns are not exposed?what is the need to copy their data?this i didnt get?
Accepted Solution
Updated: 16 Jun 2024 22:02 EDT
Tata Consultancy Services
IN
Hi @TanyaS58
Question: So why do we need to copy old cases data whose columns are not exposed?what is the need to copy their data?this i didnt get?
Answer:
Answer 1: If it is a newly created property and newly exposed/optimized column then not required.
Answer 2: Let's take, for example, that every month at the end of the day, users or business teams take reports by executing the reports.
If you expose or optimize a property in the 3rd week of the month (e.g., First Name and Last Name, Doesn't Matter about Scalar Property or Embedded Property).
If you execute the report at the end of the month, the data will not shows the first two weeks of cases for these two columns, irrespective of the cases.
The process commander will not generate simultaneously two queries for the same property or column (BLOB Query and Table Column SQL Query).
Once If you expose or optimize a property, Process Commander will always fetch data from the exposed column for RD.
For that reason, we need to enable check (default is enabled—this is an automatic job) or execute an activity to populate or copy data for old cases or in-flight cases.
I hope this will help you.
Thanks,
Ashok
Cognizant
IN
@Bhumireddy thank you so much for the detailed solution.
Cognizant
IN
@Bhumireddy also the link that you have added How to optimize properties in production environment ? is really good but here what exactly is being done from which class obj browse will happen and what this page copy will do?
