About orphaned files and tables

The unica_acclean utility determines whether files and tables are orphaned in the following way:

Tables

The utility scans databases in the current partition to obtain the list of temporary tables. Tables are identified as “temporary” based on the “TempTablePrefix” or “ExtractTablePrefix” properties specified for each data source on the Marketing Platform Configuration page.

Once the list of temporary tables is compiled, all flowchart files in the system are scanned to see if any of these temporary tables are used by a flowchart. Any temporary table not referenced by a flowchart is considered orphaned.

The cleanup utility scans only those data sources defined in the Marketing Platform User Administration module for the user running the utility. Therefore, users running the cleanup utility should always make sure that they have authentication rights to the global or appropriate set of data sources for scanning.

Files

The utility scans two locations to identify temporary files:

the partition’s temp directory (< partition home>/< partition>/tmp) to obtain the list of files identified as “temporary” files based on the .t~# extension.

the < partition home>/< partition>/[campaigns | sessions] directory for files having a known Campaign temp file extension.

Once the list of temporary files is compiled, all flowchart files in the system are scanned to see if any of these temporary files are not used by any flowchart. Any temporary file not referenced by a flowchart is considered orphaned.