How can I archive/delete old data from the PAM reporting database?
My disk has run out of space and the reporting DB is 89GB.
There is an option in PAM to purge reporting data. Below are the steps
- Login to PAM and navigate to Configuration tab
- At domain level, navigate to properties tab
- There is a drop down "Option to purge reporting data". Use this to set purge policy around your reporting data
EDIT - per the correct information from Vinay.
Info on disabling reporting and direct database purging remains below:
If you do not want to keep the reporting data you can turn off reporting and drop all the data from the reporting tables. Your other option would be to move the reporting database to another database which has enough room for expansion into the future.
Edit OasisConfig.properties located in <PAM>/server/c2o/.config; add the following line:
In the database, you need to clean up the reporting tables. These statements are for Sql Server. If you are using Oracle, add ‘DROP STORAGE;’ to the end of each statement as
TRUNCATE TABLE filetransferserviceoperation DROP STORAGE;
TRUNCATE TABLE filetransferserviceoperation
TRUNCATE TABLE mapialertserviceoperation
TRUNCATE TABLE playwaveformalertsvc TRUNCATE TABLE promptuserserviceoperation
TRUNCATE TABLE soapclientcall
TRUNCATE TABLE startprocessserviceoperation
TRUNCATE TABLE tapialertserviceoperation
TRUNCATE TABLE c2oserviceoperationinstance
TRUNCATE TABLE c2oflowchartinstanceobject
TRUNCATE TABLE c2oreferenceobject
TRUNCATE TABLE c2oconfigcomponents
This will work on Oracle but this is restricted for SQL server. SQL Server restriction, you cannot truncate a table which is referenced by a foreign key:
If SQL, stop the Orchestrator service and instead of "Truncate TABLE" use "DROP TABLE". This assumes Reporting has been disabled and you don't plan on using it:
How to turn off reporting completely in PAM If you don't use reporting, you can turn it off entirely by adding the following in the oasisConfig.properties file:
Retrieving data ...