Congnos 10.1.1 Indexing runs for a very long time & shows errors

[Gene]

Hi folks,

I am hoping somebody can give me some tips on Cognos indexing.

My Cognos Data Manager doesn't have too many reports (maybe a couple of hundred, many of them with saved Excel output), however I see two problems:

• It runs for a very long time (still running after 36 hours) -- I am forced to cancel it
• Or it completes with "Failed" status and a bunch of error messages

Here are typical error messages when indexing fails:
--------------------------
   
Message 
December 17, 2011 11:40:14 PM    Checking index compatibility.
December 17, 2011 11:40:15 PM    Done checking index compatibility.
December 17, 2011 11:44:13 PM    Incremental indexing started.
December 18, 2011 12:07:13 AM    An error occurred while indexing item /content/folder[@name='DM Business Warehouse']/package[@name='PPA']/folder[@name='Customer Retention and Attrition']/report[@name='Revenue generated by new IDS business partners since 2005 - Rajesh report (test package)']: CSN-IUS-0051 Operation GetReportSpec failed. CSN-IUS-0009 Failed to retrieve runnable object /content/folder[@name='DM Business Warehouse']/package[@name='PPA']/folder[@name='Customer Retention and Attrition']/report[@name='Revenue generated by new IDS business partners since 2005 - Rajesh report (test package)'] from Content Manager. 
December 18, 2011 12:12:47 AM    An error occurred while indexing item /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Sherry']/folder[@name='Requests']/folder[@name='Les']/folder[@name='2011.06.21 - DB2 Customers from 2007 and 2008 who have S&S today']/query[@name='2007 & 2008 DB2 Customers with S&S today']: CSN-IUS-0051 Operation GetReportSpec failed. CSN-IUS-0009 Failed to retrieve runnable object /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Sherry']/folder[@name='Requests']/folder[@name='Les']/folder[@name='2011.06.21 - DB2 Customers from 2007 and 2008 who have S&S today']/query[@name='2007 & 2008 DB2 Customers with S&S today'] from Content Manager. 
December 18, 2011 12:26:28 AM    Error indexing annotations for /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Gene']/dashboard[@name='Revenue Dashboard'] (/content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Gene']/dashboard[@name='Revenue Dashboard']/pagelet[@name='main']/portletInstance[@name='6b5a10217986003b0ccaf77c5dd86067'])
December 18, 2011 12:27:13 AM    Error indexing annotations for /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Gene']/dashboard[@name='Revenue Dashboard'] (/content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Gene']/dashboard[@name='Revenue Dashboard']/pagelet[@name='main']/portletInstance[@name='e06a1b54aa3001dc952e1eeb381a35d7'])
December 18, 2011 12:27:16 AM    An error occurred while indexing item /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Sherry']/folder[@name='Requests']/folder[@name='Les']/folder[@name='2011.06.07 - DB2 Customers on Sun - PMR analysis']/query[@name='DB2 Customers on SUN']: CSN-IUS-0051 Operation GetReportSpec failed. CSN-IUS-0009 Failed to retrieve runnable object /content/folder[@name='DM Business Warehouse']/folder[@name='Public user folders']/folder[@name='Sherry']/folder[@name='Requests']/folder[@name='Les']/folder[@name='2011.06.07 - DB2 Customers on Sun - PMR analysis']/query[@name='DB2 Customers on SUN'] from Content Manager. 
December 18, 2011 12:24:18 AM    Error indexing annotations for /content/folder[@name='Samples']/folder[@name='Models']/folder[@name='Business Insight Samples']/dashboard[@name='Revenue Data Dashboard'] (/content/folder[@name='Samples']/folder[@name='Models']/folder[@name='Business Insight Samples']/dashboard[@name='Revenue Data Dashboard']/pagelet[@name='main']/portletInstance[@name='e2ed133943944fc419c8da21f89ed56f'])

-----------

Interestingly some error messages (such as the last ones) are on the "Samples" shipped with Cognos -- I haven't touched those since installation.

Any suggestions on how to make Cognos indexing operate better?

Thanks in advance,

Gene

[MFGF]

I don't think you mean Data Manager, do you? I'm guessing this is a job to create the search indexes for use in searches for content from Cognos Connection/Business Insight etc?

The name of your report in the error log looks very long to me? Have you tried giving it a shorter name to see if this is the cause of the problem?

MF.


Sent from my iPad using Tapatalk

[Marva55]

We are also experiencing the same issues. I would appriciate if anyone could give some feedback about this issues.

[fladnag]

Hello out there,

seems nearly the same here... Building the index is not the problem, the tasks runs for about five minutes. But we get several errormessages similar to yours (CSN-IUS-0009, 0041, 0051). I've checked the names, the length does not have any effect. I've shorted one name and created a report with longer name.

Has anyone anything on this? Any help would be appreciated, thanks in advanced.

Edit: We use Cognos 10.1.1 without any FixPack.

[Jaro2]

Same problem....

Has anyone reported this to IBM yet?

[mvoosten]

Same here.. Errors all over and even index server crashes

[mvoosten]

Same here.. big issue as without indexing there is no search option.
Someone found a solution?

[MFGF]

What specific version and/or FP of Cognos 10 are you running? I think some builds had issues with the indexing and search.

MF.

[RubenvdLinden]

Same here.. big issue as without indexing there is no search option.

That's not entirely true. Next to the Search button is a 'Search Options' dropdown menu that allows you to search on the name and description fields. This is basically the Cognos 8 search option, which will also work without the indexing.
It's not ideal, but it might be a temporary solution until your indexing has been fixed.

[norkos]

Hi Gene,

You have got two types of errormessage:
1. "An error occurred while indexing item" - The reasons of these errors are some kind of existing errors in the related reports or items. Open the related items and check them manually. A root cause can be that the package referred by the report doesn't exist anymore.
2. "Error indexing annotations for" - I think that the cause of this problem is a known issue in Cognos 10.1.1, which was fixed by IBM in FP1.

[Yizi]

That's not entirely true. Next to the Search button is a 'Search Options' dropdown menu that allows you to search on the name and description fields. This is basically the Cognos 8 search option, which will also work without the indexing.
It's not ideal, but it might be a temporary solution until your indexing has been fixed.

It can be turned off as well from Cognos configuration under IBM Cognos Services:

• Index data service enabled
• Index search service enabled
• Index updateservice enabled

Make sure they all set to false. (This does not work in the 10.1.1 for due to different tier levels), hope it helps.