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.
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.
Posted: 7 years ago
Posted: 23 Jun 2016 6:20 EDT
Vigneshwaran Aravindhan (VigneshAravind)
Senior Technology Architect
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...