Explanation on Generated Pr_history_***_1b2ef and how to clean up
Hello,
using Pega 7.1.8 and looking through the development database tables in Data.pr_history_ECS-Part-1b2ef (size of 31 characters) I see a lot of these pertaining to perceived objects. There are a lot of these types of tables and only a small amount contain actual data. I am trying to determine:
1. why is the restriction at 31 characters?
2. How can I know without manually opening up every Data-Admin-DB-Table definition maps to which table?
3. For those tables that are empty, how can I properly delete them and dependent elements
4. for some of the defined tables, they are referenced by ECS data elements.. ie.. ORG-....-Data-Object. should they still exist? should they be migrated? should they be deleted?
Just trying to determine impact of cleanup and impact to migrations?
Hello,
using Pega 7.1.8 and looking through the development database tables in Data.pr_history_ECS-Part-1b2ef (size of 31 characters) I see a lot of these pertaining to perceived objects. There are a lot of these types of tables and only a small amount contain actual data. I am trying to determine:
1. why is the restriction at 31 characters?
2. How can I know without manually opening up every Data-Admin-DB-Table definition maps to which table?
3. For those tables that are empty, how can I properly delete them and dependent elements
4. for some of the defined tables, they are referenced by ECS data elements.. ie.. ORG-....-Data-Object. should they still exist? should they be migrated? should they be deleted?
Just trying to determine impact of cleanup and impact to migrations?
***Updated by moderator:Marissa. Removed user added Ask the Expert and #helpme tags. Apologies for confusion, shouldn't have been an end-user option***