Question

2
Replies
140
Views
jafferSathick Member since 2010 23 posts
TCS
Posted: September 25, 2016
Last activity: September 27, 2016
Closed
Solved

Procedures and Views are invalidated when moving into higher environments for upgrade - Life & Shift approach

We are moving from QA to NFT environment as part of Upgrade Route to Live with Life & Shift approach. Our upgrade is Pega 6.1SP2 to 7.2

I copied the Pega 6 NFT schema into Pega 7 NFT Data Schema and Pega 7 QA Rule Schema into Pega 7 NFT Rules Schema.

We are planning to do the Data Only Upgrade. This only would update the Data schema to be compatible with Pega 7.

However, in the cloned NFT Pega 7 Rules schema, I see the following Stored Procedures and Views referring the source QA Schemas

Views:

PWBV4_CIRCUMSTANCE_DUPLICATES

PWBV4_RULE_LOCKING

PWBV4_RULE_OVERRIDES

Stored Procedures:

sppr_aggregate_usage

sppr_sys_statusnodes_set

sppr_sys_updatescache_flush

I believe the above need to be recreated in NFT Rules Schema with the appropriate schema. Or Is there any other way ?

  1. Am I missing any views & stored procedures in Rule Schema that ought to be rectified ?
  2. Apart from Views & Stored Procedures, Is there any other DB objects in Rules schema that ought to be rectified ?
Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn