Question
1
Replies
150
Views
Posted: November 24, 2017
Last activity: November 30, 2017
Closed
Optimize Schema - in 7.1.8
The application was upgraded from v6.2 to 7.1.8.
The optimize schema shows 100+ tables which are unused in the rules schema. However, the list for Data schema is 0.
is it because the data schema was not mentioned specifically in the migrateSystem.props file as detailed in the below article?
https://pdn.pega.com/support-articles/unable-view-unused-tables-data-schema-optimize-schema
Thanks,
Meera
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Since your data schema used to be the complete data/rules schema there should certainly be rules tables that need to be cleaned up from that table. If you have not cleaned them up and optimize schema is not finding them that indicates that your environment is either not configured correctly to specify the default rules and data schemas or the database user running the system does not have the correct permissions to look at the metadata of the tables in your data schema.
What database are you running on?