Troubleshooting
Problem
When saving reports to file system locations, some fail with an error mesage and others get stuck in 'executing' state.
Symptom
The following error can be seen in the 'Run History':
CNC-DS-0022 Cannot retrieve the canonical path for <path to folder>.
The following error can be seen in the logs (this is for Oracle):
ORA-12899: value too large for column
"COGP_NS"."NC_RESOURCE_LOCK"."LOCK_RESOURCE" actual: 52, maximum: 50
Resolving The Problem
Steps (require assistance from DBA):
1. Stop the Cognos service.
2. Locate the NC_RESOURCE_LOCK table in the Notification Store.
3. Manipulate the definition, increase the length of 50 to a higher value e.g. 100. (UPDATE statement)
4. Start up the Cognos Service.
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.1.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21959050