Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sudhanshu Kumar Yadav (SudhanshuY)
Labb Consulting
Sudhanshu Kumar Yadav
Labb Consulting
NL
SudhanshuY Member since 2013 15 posts
Labb Consulting
Posted: Aug 11, 2017
Last activity: Aug 14, 2017
Posted: 11 Aug 2017 7:56 EDT
Last activity: 14 Aug 2017 6:57 EDT
Closed

Regarding Dropping of Procedure from Rule Schema after Upgrade to 7.2.2

Hello All,

Recently we have upgraded our application from 6.2 SP2 to 7.2.2 after upgrade I can see 6 procedures are there which present in now both rule and data schema but all these 6 procedure are now invalid in rule schema as the table they are pointing to belong to now data schema so I am not sure whether we should delete these procedures or should give grant to the rule schema on these tables which these procedures are referring to, please clarify my confusion. Below are the mentioned procedures.

SPPC_DATA_UNIQUEID

SPPR_AGGREGATE_USAGE

SPPR_SYS_GETINDEXTIME

SPPR_SYS_STATUSNODES_SET

SPPR_SYS_UPDATESCACHE_FLUSH

SPPR_SYS_UPDATESCACHE_GETTIME

Thanks,

Sudhanshu Kumar Yadav

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Updates

Posted: 7 years ago
Posted: 14 Aug 2017 6:57 EDT
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Fellow, Technical Support, Cloud Service
Pegasystems Inc.
US

Yes, you should drop the unused stored procedures.  If you have not already done so you should also use the optimize schema tool to identify the unused tables in the rules and data schema to remove.  The procedures you listed only belong in the data schema.

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice