Discussion
Services Australia
AU
Last activity: 6 Apr 2018 19:26 EDT
Delete unused tables from rules and data schemas post upgrade
Hi,
We have completed Out-Of-Place Upgrade of 6.1 SP1 to 7.1.6. Now we have two schemas abc_rules and abc_data. Problem we see is, there are unused duplicate tables left over in both the schemas. I want to understand which utilities do i need to run to delete these tables
Thanks in advance
Vamshi
**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.
Wipro Ltd
AU
Hi Vamshi,
Try this: Designer Studio > System > Database > Optimize Schema.
This may not remove all your duplicate tables, but as up now we have only this to remove unused tables.
If you can't see Optimize Schema, then you may need to set some privileges. Please check below link for that.
Saikhom.
TCS
GB
Scope International
SG
Hi jafferSathick,
After the upgrade from pega6.3 to pega 7 some of the tables are below available in rule schema. But those tables are not having class association from PRPC(Means all these tables are referring to Data schema from data table instances). Can you tell whether we can delete these tables in rule schema as they did not have class association. And one more observation is one of the data base table instance is referring to 'data base' is data schema and 'Reports data base' is rule schema. So do we needs to keep this table in both schemas or it should map to Data schema for both? Data table instance is "Pega-CEP-Subscription".
Hi jafferSathick,
After the upgrade from pega6.3 to pega 7 some of the tables are below available in rule schema. But those tables are not having class association from PRPC(Means all these tables are referring to Data schema from data table instances). Can you tell whether we can delete these tables in rule schema as they did not have class association. And one more observation is one of the data base table instance is referring to 'data base' is data schema and 'Reports data base' is rule schema. So do we needs to keep this table in both schemas or it should map to Data schema for both? Data table instance is "Pega-CEP-Subscription".
PR_DATA_ADMIN_TENANT
PR_DATA_DECISION_DDF_ERROR
PR_DATA_DMS_CUSTOMER
PR_DATA_DMS_GLOBAL
PR_DATA_DM_ADMMART_MDL_FACT
PR_DATA_DM_ADMMART_MODEL
PR_DATA_DM_ADMMART_PRED_FACT
PR_DATA_IH_ASSOCIATION
PR_DATA_IH_DIM_ACTION
PR_DATA_IH_DIM_APPLICATION
PR_DATA_IH_DIM_CHANNEL
PR_DATA_IH_DIM_CONTEXT
PR_DATA_IH_DIM_CUSTOMER
PR_DATA_IH_DIM_LOCATION
PR_DATA_IH_DIM_OPERATOR
PR_DATA_IH_DIM_OUTCOME
PR_DATA_IH_FACT
PR_DATA_MOBILE_APPINFO
PR_DATA_MOBILE_ASSET
PR_DATA_MOBILE_BUILD
PR_DATA_MOBILE_CERTIFICATE
PC_ASSIGN_WORKBASKET
PC_ASSIGN_WORKLIST
PC_CEP_ACTIONS_REPOSITORY
PC_CEP_EVENTS_REPOSITORY
PC_DATA_UNIQUEID
PC_DATA_WORKATTACH
PC_EVENTS
PC_HISTORY_WORK
PC_INDEX_ACCEL
PC_INDEX_FLOWREF
PC_INDEX_WORKPARTY
PC_LINK_ATTACHMENT
PC_LINK_FOLDER
PC_LINK_TOPCASE
PC_SCHEDULE_TASK
PC_WORK
PC_WORK_ACCEL
PC_WORK_DSM_BATCH
PC_WORK_PROCESSEMAIL
PI_DATA_CONNECT
PR4_HISTORY_RULE
PR4_LOG_RULE_USAGE
PR4_LOG_RULE_USAGE_DETAILS
PR_ASSIGN
PR_CEP_EVENTSLOOKUP
And also it will help us to validate the rule schema if you post the list of tables (if you have)that should be available in rule schema after upgrade and cleanup.
Thanks in Advance.