COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Cog_rookie on 21 Mar 2013 09:08:59 AM

Title: Full Export Failed Cognos 10.1.1
Post by: Cog_rookie on 21 Mar 2013 09:08:59 AM
Hi all,

I am trying to do a full content export and has failed.

The following were the errors when I checked the cogserver logs:

CM-SYS-5001 A Content Manager internal error occurred

CM-SYS-5192 An error occurred with Content Manager


The content export fails when I tick the export user attributes box, otherwise it is successful.

Please advice.
Title: Re: Full Export Failed Cognos 10.1.1
Post by: Rahul Ganguli on 25 Mar 2013 06:27:56 AM
Are you able to browse the Authentication provider?
Title: Re: Full Export Failed Cognos 10.1.1
Post by: MAK on 16 Apr 2013 06:22:53 AM
do a consistency check. you might know the issue. we had a similar situation. up on doing consis check, we deleted some inactive users. then all set.
Title: Re: Full Export Failed Cognos 10.1.1
Post by: MMcBride on 23 Apr 2013 11:28:44 AM
Talk with your DBA as well
When we saw issues like this the root cause was we needed to update the SQL cache (the SQL size was to large, not the data size the SQL statement size trying to bring everything out)

Once our DBA raised these limits we were able to do full exports without any problems our Content Store size was around 2GB - not sure how to check this without a tool like Meta Manager

Hopefully a consistancy check will work for you but if not try to see if your DBA is getting any errors when attempting to run the job with Export users clicked.
Title: Re: Full Export Failed Cognos 10.1.1
Post by: Jiayue.lin on 29 Apr 2013 03:12:08 AM
actually in our project, we always got this error when doing back up. As the users in our environment may be changed some time, so we often do bellow steps to make the back up succeed;
1) Under Security Module,check user groups, whether we have unavailable users under these groups;
2) Under Configuration Module, chose Content Adminstration on the left list, click New Consistency Check under New Content Maintenance icon, before running the activity, chose Find Only, u can get the reasons why u cannot back up the full contenct with user account
3) After Checking the result, u can run the consistency check again, then chose Find and Fix.
4) Done the fixing, now u can back up the environment again, it will working fine, without error.

Hope this may help u :)
Title: Re: Full Export Failed Cognos 10.1.1
Post by: pumccg on 29 Apr 2013 05:10:58 AM
Make sure whoever is doing this is a System Administrator in the Cognos namespace. This can also make a difference.
Title: Re: Full Export Failed Cognos 10.1.1
Post by: Jiayue.lin on 30 Apr 2013 02:01:28 AM
yeah...we have admin role in the cognos env...

Quote from: Jiayue.lin on 29 Apr 2013 03:12:08 AM
actually in our project, we always got this error when doing back up. As the users in our environment may be changed some time, so we often do bellow steps to make the back up succeed;
1) Under Security Module,check user groups, whether we have unavailable users under these groups;
2) Under Configuration Module, chose Content Adminstration on the left list, click New Consistency Check under New Content Maintenance icon, before running the activity, chose Find Only, u can get the reasons why u cannot back up the full contenct with user account
3) After Checking the result, u can run the consistency check again, then chose Find and Fix.
4) Done the fixing, now u can back up the environment again, it will working fine, without error.

Hope this may help u :)
Title: Re: Full Export Failed Cognos 10.1.1
Post by: Cog_rookie on 31 Jul 2013 06:43:51 AM
It was resolved by deleting one of the user's profile in Cognos.