Clean Deliveries User Catalog Folder OBIEE 11G

Question

Hi community,

Do you know if there's a way to delete or purge the Deliveries Folder of each user in the OBIEE 11g Catalog? I know that there's a tag on instanceconfig file that can limit the size of each user folder, but do you know if there's a way to delete the Deliveries Folder is under /users/username/_delivers/_deliveries ?

Thanks,

Hector Andrade

Gianni Ceresa · Accepted Answer

but we were uncertain if that could affect the catalog integrity, if it could be corrupted or with missing things on it.

The catalog only recognize objects having a .atr file with the same name. If you don't have a .atr file, the object doesn't exist for the catalog. That's why when deleting content from outside OBIEE, you should make sure you delete both the file and the related .atr file. The file will be the one taking space, while the .atr is only a few hundreds of bytes. But you should make sure to delete both, that's how you guarantee the catalog integrity.