IBM Support

How to resolve a "Parameter cannot be deleted if it is already saved" error message

Technote (troubleshooting)


In Atlas, someone has gone into Admin > Manage Reports, and added a parameter to a report. We now wish to revert the report to it's original state, but finding that a "Parameter cannot be deleted if it is already saved" message is being seen.

Resolving the problem

You will need to run three queries against your Atlas database as the PSSAPL account.

Query 1:
select REPORTID from CRYSTALREPORT where RECORDKEY = '<Report Class Name>'

Notice on the page for the report, there is a field called "Report Class Name" - place it into the query in the appropriate spot. This will return a number, which we need for the second query:

Query 2:
select * from REPORTPARAMETER where REPORTID = <result of query 1>

This will give you a list of all the parameters associated to your report. Find the new parameter(s) here, and note the PARAMETERID field(s), as we'll use it in our last query:

Query 3:
delete REPORTPARAMETER where PARAMETERID = <your parameter ID>

As you're deleting records from your database, you may want to pass these steps to your DBA. Make sure to take any backups along the way, especially before the third query, to ensure no loss of information.

Note that if the user had added multiple reports, you will need to run the delete query for each parameter ID.

These steps will return your report to it's original state.

Document information

More support for: Atlas eDiscovery Process Management

Software version: 6.0, 6.0.1,,,,

Operating system(s): Linux, Solaris, Windows

Reference #: 1623378

Modified date: 04 February 2013