This should only be performed if you do not use the CA Process Automation reporting – Reports tab.
A backup of your database should be performed prior to any modifications.
Stop all CA Process Automation orchestrator services. The update in step 2 below must be done at all orchestrators in your environment.
- Edit the OasisConfig.properties located in the <PAM_Install>/server/c2o/.config folder
- Add the line oasis.disable.reporting.manager=true at the end of the file, with no leading or trailing spaces
- Clean up the reporting tables in the database using the following statements:
For SQL Server
TRUNCATE TABLE filetransferserviceoperation
TRUNCATE TABLE mapialertserviceoperation
TRUNCATE TABLE playwaveformalertsvc
TRUNCATE TABLE promptuserserviceoperation
TRUNCATE TABLE soapclientcall
TRUNCATE TABLE startprocessserviceoperation
TRUNCATE TABLE tapialertserviceoperation
TRUNCATE TABLE c2oflowchartinstanceobject
TRUNCATE TABLE c2oreferenceobject
TRUNCATE TABLE c2oconfigcomponents
TRUNCATE TABLE c2oserviceoperationinstance
Additionally, in the Process Automation RUNTIME database, you should also truncate the c2oQueryStore table. This populates the reporting database with information for the reports, and serves no other function. Use the same method as above:
TRUNCATE TABLE c2oQueryStore
For Oracle add 'DROP STORAGE;' to the end of each statement as
TRUNCATE TABLE filetransferserviceoperation DROP STORAGE;
After the folder deletes have completed, file changes have been saved, and the database (if necessary) has been modified, restart the CA Process Automation orchestrator services.