Discussion
Stored Procedures for Pega 7.1.9
Hi Team,
We are upgrading from 6.1 sp2 to 7.1.9. We want to know what are the stored procedure system would contain with respect to rules schema and data schema. And do we need to also update the stored procedures if we are not using the default pc_work table?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
We just upgraded an application from 6.2.1 to 7.1.9
We were not using the default pc_work to hold the cases.
No need to touch the OOTB stored procedures; just leave them alone.
Post upgrade the following stored procedures were found in...
RULES_SCHEMA
SPPR_REBUILD_INDEXES
DATA_SCHEMA
SPPC_DATA_UNIQUEID
SPPR_POPULATE_INDEX_DATA
SPPR_PURGE_TABLE
SPPR_RR_CLASS_FILTERED
SPPR_SYS_GETINDEXTIME
SPPR_SYS_RESERVEQUEUEITEM_B
SPPR_SYS_STATUSNODES_SET
SPPR_SYS_UPDATESCACHE_FLUSH
SPPR_SYS_UPDATESCACHE_GETTIME
SPPR_AGGREGATE_USAGE
SPPR_DEFRAGMENT_TABLE
SP_TABLE_STRUCTURE_COMP
SP_DEFRAG_SCHEMA_TAB
SP_DEFRAG_TA
Hi,
You can use generateDDL.bat/sh to identify stored procedures which are generated/altered during upgrade. Irrespective of whether pc_work is utilized or not, all stored procedures generated has to be applied to the appropriate schema.