IT Process Automation

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.

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

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:

  oasis.disable.reporting.manager=true

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:

http://stackoverflow.com/questions/9565939/cannot-truncate-table-because-it-is-being-referenced-by-a-foreign-key-constraint

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:

oasis.disable.reporting.manager=true


Thank you.