System Maintenance Tasks: Maintain Setup Data
As well as staging table data, Data Management/FDMEE stores various setup components in SQL tables behind the scenes. We do not have direct access to these tables in PBCS, however there are a number of ‘System Maintenance Tasks’ within data management which can be used to update and maintain these hidden tables. This blog will focus on the ‘Maintain Setup Data’ task only. Maintain Setup Data This task is useful to clean up the setup component tables, including clearing invalid import formats, data load rules or locations from data management. Occasionally, “phantom” artefacts seem to get stuck in the background tables, with no way of deleting them from the front-end. For example, if there are rules which are selectable from the Workbench but do not appear in the Data Load Rules list and therefore can’t be removed. When this happens, the ‘Maintain Setup Data’ task can resolve the issue, providing a way to view and remove these stuck artefacts. There are