Troubleshooting
Problem
Cognos : CAM-AAA-0023 - The parameter 'id' is invalid error when executing Sterling reports
Symptom
On clicking the execute report button on Sterling report, system displays
"CAM-AAA-0023 - The parameter 'id' is invalid error".
Same error is
thrown from all Sterling reports and no reports could be retrieved. No changes
made to the instance and the reports stopped working suddenly.
CAM-AAA-0023 - The parameter 'id' is invalid.
Resolving The Problem
Cause:
This error is thrown when encryption
keys were expired. By default the expiry date is set to 365 days in Cognos
configuration. The timestamp of the files in signkeypair and encryptkeypair
directories of the install's configuration directory
(crn_location/configuration) might have been a year old. Usually these files
get recreated when the application is restarted and Cognos configuration is
launched.
Resolution:
1. Launch Cognos
Configuration.
2. Export the current configuration to a clear text file.
Ex: config_export.xml
In Cognos Configuration click File -> Export
As....
Note: The exported file will contain all passwords and user information in clear text, so be sure to protect it from unauthorized access!
3. Stop Cognos service.
4. Exit Cognos
Configuration.
5. Delete/Backup the current configuration
For
Cognos ReportNet: ./configuration/crnstartup.xml
For Cognos 8:
./configuration/cogstartup.xml
6. Copy/Move the backup file
config_export.xml into./configuration directory.
7. Rename the backup
file config_export.xml to
For ReportNet:
./configuration/crnstartup.xml
For Cognos 8:
./configuration/cogstartup.xml
8. Delete/Backup the three keystore
directories
- ./configuration/csk
-
./configuration/encryptkeypair
- ./configuration/signkeypair
9.
Delete/Backup the ./temp/cam/freshness file.
10. Launch Cognos
Configuration and save configuration
This will result in recreation of
the keystores in the respective directories.
There is no need to re-enter
passwords because they are all saved in the backup file.
After the last
step of saving configuration, all passwords in the new
crnstartup.xml/cogstartup.xml file will be re-encrypted again.
Reference link: http://www-01.ibm.com/support/docview .wss?rs=0&q1=CAM-AAA-0023&uid=swg21346353&loc=en_US&cs=utf-8&cc=us%E3%80%88=en</ a>
Historical Number
NFX7994
Product Synonym
[<p><b>]Function Area[</b><p>];Cognos reports;[<p><b>]Escalation ID[</b><p>];127366
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21555629