- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Technical changes of summarization tables
As part of the architecture improvement that will be delivered in RevPro 37.001.00.00, technical changes are made to some summarization objects. The product predefined programs and jobs are updated based on these changes.
If you have any customized programs or jobs that involve summarization objects, please make a note of these changes and also the customized one-time summarization script to ensure that these changes do not introduce any errors.
Changes
The summarization table names are changed as indicated in the table below.
Previous table name |
New table name |
Table usage |
rpro_ri_acct_summ_g |
rpro_ri_acct_summ_s1 |
The base table for all the summarized data. |
rpro_ri_acct_summ_t |
rpro_ri_acct_summ_s2 |
The temporary table used for summarization during the runtime. |
rpro_ri_wf_summ_g |
rpro_ri_wf_summ_s1 |
The base table for all summarized waterfall data. |
rpro_ri_wf_summ_t |
rpro_ri_wf_summ_s2 |
The temporary table used for waterfall data during the runtime. |
Impact
The following synonyms are created for the summarization base tables. Beginning from RevPro 37.001.00.00, the TRUNCATE command cannot be used on these synonyms.
- rpro_ri_acct_summ_g
- rpro_ri_acct_summ_t
- rpro_ri_wf_summ_g
- rpro_ri_wf_summ_t
If the previous table names are still being used with the TRUNCATE command in any of your customized script or job, it will error out.
User action
If you have used the TRUNCATE command on any of these summarization tables (rpro_ri_acct_summ_g and rpro_ri_wf_summ_g), please replace them with the new table names.
If the previous tables are used in the customized script or job but the TRUNCATE command is NOT used on them, then no action is required.
As indicated in the table below, the previous way of using the TRUNCATE command needs to be updated to the new way.
Previous way |
New way |
TRUNCATE TABLE rpro_ri_acct_summ_g; |
TRUNCATE TABLE rpro_ri_acct_summ_s1; |
TRUNCATE TABLE rpro_ri_acct_summ_s2; |
|
TRUNCATE TABLE rpro_ri_wf_summ_g; |
TRUNCATE TABLE rpro_ri_wf_summ_s1; |
TRUNCATE TABLE rpro_ri_wf_summ_s2; |
For Zuora staff to find more details regarding the latest one-time summarisation script, please check the JIRA ticket: RD-6761 after the 37.001.00.00 release
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Technical changes of summarization tables
Hi Zuora team,
Can you clarify if these technical changes of summarization tables will be part of revpro version upgrade 37.001.00.00 if we are using RevPro on cloud.
Will this be part of RevPro upgrade process if we use RevPro on cloud.
Do we need to do any changes from our side.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Technical changes of summarization tables
This will be part of the standard release 37.001.00.00 for the cloud. No action required by customers. The only request is not run One Time summarization programs created in prior versions without checking support.
If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √