Cognos is integrated with Sterling Application and when reports are run from Sterling Portal, it throws error.
While running the report from Sterling Portal gives error RSV-CM-0005 Content Manager did not return an object for requested search path.
Sterling Package and reports was not imported in the Cognos Environment.
Diagnosing the problem
Access the Cognos Portal through Gateway or dispatcher URI.
Navigate to the Folder location to locate the package and Reports.
If the reports are not present in the Public Folder or My Folder, it is required to perform the deployment import of the Sterling Package and create the data source connection as mentioned in the Sterling documents.
Resolving the problem
- Obtain the Sterling Package SMCF-Analytics and WMS-Analytics from the Sterling Support Team.
- Perform the Cognos Deployment Import of the package as per mentioned in the Buisiness Intelligence Operational Reports Guide section - Deploying Sterling Business Intelligence Reports.
- Create the Data source connection as mentioned in the guide via Cognos Administration Portal
- Run the Sterling reports from Cognos Connection to test if reports runs successfully.
- Once the report runs successfully from Cognos Portal, test running the reports from Sterling Portal.