GUID Error when trying to open an engagement from a Cognos report
SYMPTOMS:
Error when trying to open an engagement from a Cognos report
ERROR/WARNING MESSAGES:
GUID should contain 32 digits and 4 dashes
REASON:
Insufficient string size used when constructing the HTML link for the engagement, in Cognos report:
<a href="javascript:try{CPLP('||'''ENG'''||','''||cast([EngagementGUID],varchar(36))||'' + ''')}catch(e){}">'||[EngagementName]||'</a>
RESOLUTION:
Change the HTML link by invreasing the varchar size from 36 to 38
<a href="javascript:try{CPLP('||'''ENG'''||','''||cast([EngagementGUID],varchar(38))||'' + ''')}catch(e){}">'||[EngagementName]||'</a>