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
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?