Question

2
Replies
133
Views
Christopher Rebuck (ChrisR81)
NASCO
System Engineer IV
NASCO
US
ChrisR81 Member since 2013 4 posts
NASCO
Posted: August 26, 2016
Last activity: September 14, 2016
Posted: 26 Aug 2016 11:20 EDT
Last activity: 14 Sep 2016 11:24 EDT
Closed

Tables of Unknown Origin Created In Data Schems

I am writing this post to try and determine the origin of about 200 tables that have been created in one of our Pega environments.  The tables are not part of the application and were not created by anyone on the team.  Given that we have to assume that Pega created them for some reason and are trying to understand why.   Also note that we have deployed this application for 2 customers in 8 different environments and these additional tables are only showing up in one of these environments.  

A small sample of the table names are contained in the attached screen shot......some of the table name prefixes are listed below

PR_HISTORY_CMIS_*

PR_HISTORY_CMIS_CMIS*

PR_HISTORY_DATA_DECISION*

PR_HISTORY_DATA_MO_DSM_*

PR_HISTORY_DATA_SAMLASSE_*

There are others and there now over 250 of them.

Most all of the tables have the same set of columns and all of then ones I checked have no data in them.

Thanks

***Updated by Moderator: Vidyaranjan. Removed user added #helpme and Ask the Expert tags. Apologies for confusion, shouldn't have been an end-user option***

***Updated by moderator: Marissa to update categories***

Data Integration System Administration
Moderation Team has archived post, 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.