Topic
  • 4 replies
  • Latest Post - ‏2012-06-21T13:34:29Z by KCamp
SylviaValentina
SylviaValentina
3 Posts

Pinned topic CMS : gauge charts do not show - a red cross is shown

‏2012-06-20T16:25:12Z |
Hi All,

my client is implementing Cognos Mashup Service ( CMS ) and utilizing in several reports gauge charts;
when invoking via CMS the gauge charts are not generated, only a red cross;

how can client get the gauge charts via CMS ?
I am not sure if this might be related to the LDX formate. My suspcion comes from entry ".. some formating.. " in the following article:

Relative performance comparisons between Cognos URL and Cognos Mashup Service
https://www.ibm.com/developerworks/mydeveloperworks/blogs/0a7c97bb-6cf9-4ddb-a918-80994e7b444d/entry/relative_performance_comparisons_between_cognos_url_and_cognos_mashup_serivce?lang=en
> cms_vs_url_c3blog.pdf
https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=0a7c97bb-6cf9-4ddb-a918-80994e7b444d#fullpageWidgetId=Wa2f8c8404116_41c8_b1d9_c74fea3113df&file=a583a385-1492-4c5d-91c1-6105fd79b9d1

"... The Mashup Service transforms all IBM Cognos 8 content into a single format called Layout Data ( LDX) format.
This format allows you to customize the presentation of IBM Cognos8 content using a simple API .... The LDX format captures the logical structure of the content, as well as some formatting information. For example, list grouping, crosstab dimensions, data values and styling information are represented in an LDX instance. ... "
Thanks in advance for any input - much appreciated
Updated on 2012-06-21T13:34:29Z at 2012-06-21T13:34:29Z by KCamp
  • arturr
    arturr
    12 Posts

    Re: CMS : gauge charts do not show - a red cross is shown

    ‏2012-06-20T16:43:38Z  
    what format does your client expect?
  • KCamp
    KCamp
    20 Posts

    Re: CMS : gauge charts do not show - a red cross is shown

    ‏2012-06-20T16:48:35Z  
    If you're consuming the LDX, the chart image is a relative URL like ?abcs.... This needs to be appended to the Cognos Gateway URL to be able to retrieve the image.

    If you're consuming the HTML output, the complete URL will be constructed. However, you need to be authenticated to retrieve at the client end. I.e, here's a situation where you might hit this. If you have say a JSP that makes a request to CMS (authenticated), retrieves an HTML fragement and adds it to the JSP's dynamically generated HTML, when a client browser hits the JSP you'll get a red X because the browser isn't authenticated with Cognos.

    The solution to this depends on the architecture of your app, and the version of Cognos you are going against. Without knowing more I can't provide a recommendation.
  • SylviaValentina
    SylviaValentina
    3 Posts

    Re: CMS : gauge charts do not show - a red cross is shown

    ‏2012-06-21T11:27:28Z  
    Hi KCamp,

    many thanks for your input - I think you might have hit the problem. Client did continue testing: by manually changing the URI generated the GaugeChart + Formating work - question is now how to "generate" the correct URI automatically - here the details:

    1.) CMS URI used:
    http://****/cognos10/cgi-bin/cognos_module/rds/pagedReportData/report/iC514D7DF9BF14CB28725CDF85008181C?fmt=HTML&version=LATEST&includeLayout=true
    -> effect:
    a) red cross=bad;
    b) styles not applied=bad;
    -> cogserver.log shows:
    reportDataService Failure <messages><message><messageString>RDS-ERR-1022 The request received by Report Data Service is not valid.</messageString></message> <trace>com.cognos.ccs.exceptions.CCSGeneralException: REQUEST_ERROR at com.cognos.ccs.service.CommandSession.extractSourceTypeID(Unknown Source) at com.cognos.ccs.service.CommandSession.processFormMessage(Unknown Source)
    2.) client applied the following steps:
    > verify source code of the page
    > verify URI requests with Httpwatch
    -> conclusion: here is the error: to call the gauge chart following URI is generated:
    http://!WEBSERVER1of2!:0/cognos10/cgi-bin/cognos_module//gdi/iD70B148F817B4B6C971F8038077ACE9E/graphic@name=%22img1%22

    URI contains:
    > !WEBSERVER1of2!
    > port 0
    > after the cognos_module TWO forward slash ( "//" )

    updating the URI manually to:
    http://APLICATIONSERVER/cognos10/cgi-bin/cognos_module/gdi/iD70B148F817B4B6C971F8038077ACE9E/graphic@name=%22img1%22
    > pointing to APLICATIONSERVER
    > without : port 0
    > after the cognos_module only ONE forward slash ( "/" )
    ->> EFFECT: GOOD = gauge chart is correctly generated + formats applied;

    Many thanks for any input - much appreciated
  • KCamp
    KCamp
    20 Posts

    Re: CMS : gauge charts do not show - a red cross is shown

    ‏2012-06-21T13:34:29Z  
    Hi KCamp,

    many thanks for your input - I think you might have hit the problem. Client did continue testing: by manually changing the URI generated the GaugeChart + Formating work - question is now how to "generate" the correct URI automatically - here the details:

    1.) CMS URI used:
    http://****/cognos10/cgi-bin/cognos_module/rds/pagedReportData/report/iC514D7DF9BF14CB28725CDF85008181C?fmt=HTML&version=LATEST&includeLayout=true
    -> effect:
    a) red cross=bad;
    b) styles not applied=bad;
    -> cogserver.log shows:
    reportDataService Failure <messages><message><messageString>RDS-ERR-1022 The request received by Report Data Service is not valid.</messageString></message> <trace>com.cognos.ccs.exceptions.CCSGeneralException: REQUEST_ERROR at com.cognos.ccs.service.CommandSession.extractSourceTypeID(Unknown Source) at com.cognos.ccs.service.CommandSession.processFormMessage(Unknown Source)
    2.) client applied the following steps:
    > verify source code of the page
    > verify URI requests with Httpwatch
    -> conclusion: here is the error: to call the gauge chart following URI is generated:
    http://!WEBSERVER1of2!:0/cognos10/cgi-bin/cognos_module//gdi/iD70B148F817B4B6C971F8038077ACE9E/graphic@name=%22img1%22

    URI contains:
    > !WEBSERVER1of2!
    > port 0
    > after the cognos_module TWO forward slash ( "//" )

    updating the URI manually to:
    http://APLICATIONSERVER/cognos10/cgi-bin/cognos_module/gdi/iD70B148F817B4B6C971F8038077ACE9E/graphic@name=%22img1%22
    > pointing to APLICATIONSERVER
    > without : port 0
    > after the cognos_module only ONE forward slash ( "/" )
    ->> EFFECT: GOOD = gauge chart is correctly generated + formats applied;

    Many thanks for any input - much appreciated
    This looks like a bug, I would log this with IBM Cognos customer support. Mashups should have generated the correct URL for you, but it looks like the generation is not happening correctly in your client's particular environment.

    In the meantime, the workaround would be to manually repair the URL on the client side in java or javascript using a regex expression based on "cognos_module".