How To
Summary
Sometimes a data set, report, report view or report version can't be updated or deleted and the below error is seen: 'CM-REQ-4380 You cannot update or delete objects that have not been archived'
Objective
To be able to delete/Update the data set/multiple data sets/reports/report versions
Environment
Both Windows and Linux.
Steps
The following steps should be taken :
- Stop Cognos
- Take a backup of the Content Store
- In each Content Manager installation, remove repositoryIntegration.xml in the folder webappsp2pd/WEB-INF/services. If you need to have a backup, do not leave the backup file in the same folder or anywhere in the Content Manager installation and change the file extension of the backup file
- In IBM Cognos Analytics 11.1.7 and earlier,in each Content Manager installation, remove CMArchiving.jar in the folder webappsp2pd/WEB-INF/lib. If you need to have a backup, do not leave the backup file in the same folder or anywhere in the Content Manager installation and change the file extension of the backup file. Do not remove CMArchiving.jar in 11.2 or later version.
- Reset archival flags by executing the following SQLs against the content store database:
- update CMARCHIVESTATUS set ARCHSTAT=0; commit;
- delete from CMARCHIVEQUEUE; commit;
- Start Cognos
Note : This is important to know that after renaming the CMArchiving.jar, content archiving feature won't work. Please make sure that you are not using content archiving feature.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
02 May 2024
UID
ibm16851899