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.

Discussion

 Rakesh Bommisetty (bommr1)
PEGA
Fellow Cloud Architect, Management Plane Services
Pegasystems Inc.
IN
bommr1 Member since 2015 8 posts
PEGA
Posted: Aug 7, 2015
Last activity: Oct 4, 2018
Posted: 7 Aug 2015 5:17 EDT
Last activity: 4 Oct 2018 11:08 EDT
Closed

Not able to view Optimize Schema option to clean up unused tables after upgrade

Hi Team,

Post upgrade to PRPC 7.1.8, Optimize Schema tab which is used to do clean up of unsed tables is not visible under Designer Studio > System > Database.

Kindly let me know how to view it.

Regards,

Rakesh Bommisetty


**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.

To see attachments, please log in.
Updates

Posted: 9 years ago
Posted: 7 Aug 2015 5:29 EDT
Ravi Padwal (RaviP@incessant)
NIIT Technologies Limited

NIIT Technologies Limited
AU

Can you please check the value of Data-Admin-System-Setting named 'database/autodbschemachanges'? It should be set to 'true'

And user should have privilege 'ViewAndOptimizeSchema'

To see attachments, please log in.
Posted: 9 years ago
Posted: 7 Aug 2015 6:32 EDT
Rakesh Bommisetty (bommr1)
PEGA
Fellow Cloud Architect, Management Plane Services
Pegasystems Inc.
IN

Hi Ravi,

Thank you.

ViewAndOptimizeSchema is returning false. On further analysis we found that the issue is because of Production Level. There is a detailed pdn link on that. For Optimize Schema tab to be visible production level should be 2 or less, on changing it, I'm able to view the tab.

Pdn link on Production Level and Optimize Schema is:

https://pdn.pega.com/system-operations/how-to-set-privileges-to-restrict-database-schema-changes-generated-from-process-commander

Regards,

Rakesh Bommisetty

To see attachments, please log in.
Posted: 7 years ago
Posted: 7 Aug 2017 9:06 EDT
sudheer kurmana (sudheerk0543)
ING Bank NV
Dev Engineer
ING Bank NV
NL

Hi

i have the privilige ViewAndOptimizeSchema and the DSS database/AutoDBSchemaChanges is true but still i am unable to view the optimize schema under system - database

 
To see attachments, please log in.

Related content:

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