Topic
  • 2 replies
  • Latest Post - ‏2012-02-27T00:09:39Z by OpherB
OpherB
OpherB
679 Posts

Pinned topic CPS-PAG-4801 in Cognos BI 10.1.1

‏2012-02-25T01:24:27Z |
Hello - Working on an update to a bunch of report pages which are used as link farms internally.

The user runs a Report Studio report and is presented with a table that contains a series of text items and HTML link items. The HTML links are to Dashboard Portels, most are Multi-page format.

The original link URL was created using the content store item id like this:


https:
//prod-server.domain.com/cognos10/cgi-bin/cognosISAPI.dll?b_action=dashboard&pathinfo=/cm&frag-header=true&path=storeID(%22i60CCB2B2563B4CDCA5614E5D4157B94F%22)


Those worked, but are inflexible when content is moved/copied between development, test, production, etc.

So, I am re-writing these URLs in this format:


https:
//prod-server.domain.com/ibmcognos/cgi-bin/cognosISAPI.dll?b_action=dashboard&pathinfo=/content/folder[@name='Company Folders']/folder[@name='Sales Analytics']/folder[@name='Reports']/folder[@name='Dashboards']/pagelet[@name='FLASH DASHBOARD']


But these links fail with CPS-PAG-4801 and a HUGE dump of meaningless stuff.

I have also tried editing the links to use ..\cgi-bin\ at the start. Same results - the store ID works and the path returns the same error message.

So, it appears that the Path is processed differently than does the object ID. I know the path is correct. I have attached a text file of the full error message. Every line says "Java" at the end, making me think this is a Java error.

Looking through the KB, there are several entries with this error, with "fixes" from replace" SYSTEM.XML" to "use SQL authentication, not Windows authentication" to one entry with no update/fix since October.

So, calling on the wisdom of the crowd - how to fix this?

Environment: Cognos 10.1.1 64-bit Windows
Database: SQL Server 2008
Pages created in Report Studio
Thanks very much,
Opher
Updated on 2012-02-27T00:09:39Z at 2012-02-27T00:09:39Z by OpherB
  • SystemAdmin
    SystemAdmin
    1959 Posts

    Re: CPS-PAG-4801 in Cognos BI 10.1.1

    ‏2012-02-26T05:22:17Z  
    The error that you have seems to be a bit of a catch-all message rather than anything particularly useful. In my experience, the majority of the errors which occur calling resources via URLs are due to the format of the URL. You might try encoding the path of the dashboard using http://meyerweb.com/eric/tools/dencoder/. Another track that you could follow is to try narrowing down when the problem occurs. It might be good to start with a new dashboard page containing a simple HTML viewer (or even an empty dashboard page) located as close to the root of Public Folders as you can to see if the problem is related to the content of the existing dashboards or the lengthy path to the existing dashboards.

    On a side note, I would recommend contacting IBM support for this issue if you don't get any additional feedback from the forum.
  • OpherB
    OpherB
    679 Posts

    Re: CPS-PAG-4801 in Cognos BI 10.1.1

    ‏2012-02-27T00:09:39Z  
    The error that you have seems to be a bit of a catch-all message rather than anything particularly useful. In my experience, the majority of the errors which occur calling resources via URLs are due to the format of the URL. You might try encoding the path of the dashboard using http://meyerweb.com/eric/tools/dencoder/. Another track that you could follow is to try narrowing down when the problem occurs. It might be good to start with a new dashboard page containing a simple HTML viewer (or even an empty dashboard page) located as close to the root of Public Folders as you can to see if the problem is related to the content of the existing dashboards or the lengthy path to the existing dashboards.

    On a side note, I would recommend contacting IBM support for this issue if you don't get any additional feedback from the forum.
    Thanks for the suggestion, Phil.

    Seems there was a missing parameter in my re-written URL that was needed when giving a Path rather than the Object ID:

    
    https:
    //prod-server.domain.com/ibmcognos/cgi-bin/cognosISAPI.dll?b_action=dashboard&pathinfo=/pagelet&frag-header=true&path=/content/folder[@name='Company Folders']/folder[@name='Sales Analytics']/folder[@name='Reports']/folder[@name='Dashboards']/pagelet[@name='FLASH DASHBOARD']
    


    Not quite sure what pathinfo=/pagelet and frag-header=true do, but too rushed to finish on a Sunday afternoon to research.

    Opher