Question

1
Replies
19
Views
DIETERHAUS Member since 2018 1 post
Deutsche Bank
Posted: 2 years ago
Last activity: 2 years 4 months ago
Closed

PMD 6.6.2.0.GA on SLES - object reference for CB* or OT_TMP* not found

Hello together,

in times of GDPR we need to check our data objects and if they can be housekept and/or deleted. So far we checked the PMD repository and found some tables with no reference in the OBJ_TYPE table. i check the provided purge document and script.

Now my question:
The procedure purge_CStables only lookup table from cancelled / completed campaigns like

SELECT db_ent_name
FROM vantage_dyn_tab
WHERE db_ent_name LIKE 'CS%_%_%' ...
and drops the tables from repository.

The deleted CS tables.have the obj_type_id = 27

All the table we looking for like CB* and OT_TMP_*.
Has the same obj_type_id = 27 like the CS tables.

Could i drop the tables if referenced campaign status is complete or cancelled?

Additional question:

We have 5404 table called like F1080_1_18984_27_0

select * from all_tables where owner='ADVANTAGE' and table_name like 'F%_%_%'

These tables not referenced in vantage_dyn_tab

Could i drop thise tables?

Thanks a lot in advance

i raised this questions 14 days ago, with

https://pdn.pega.com/community/product-support/question/pmd-6620ga-sles-object-reference-not-found

Dieter

Data Integration
Moderation Team has archived post
Share this page LinkedIn