Print Page - Full contect export giving error

Title: Full contect export giving error
Post by: ipmurali on 05 Nov 2008 01:59:03 AM

Hi,
I am using Cognos 8.1 under windows environment, SQLServer 2000 as the content store database.

When I am trying to take an export of the entire content store it throwing an error

CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters and then contact your database administrator. Out of memory - please use a server side cursor for large result sets:java.lang.OutOfMemoryError, Result set size:220303507, JVM total memory size:785186816

I tested the connection of content store database in my Cognos configuration, giving me success.

About two months back I am able to take it.

Please help me to resolve this issue..

Thanks for your time

Regards
Murali

Title: Re: Full contect export giving error
Post by: ducthcogtechie on 05 Nov 2008 10:12:35 AM

In cogos configuration change the memory from768 to 1152 and try again.

Title: Re: Full contect export giving error
Post by: ipmurali on 06 Nov 2008 06:21:41 AM

Yes !
That's the answer !!
Thanks a lot !!!

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: ipmurali on 05 Nov 2008 01:59:03 AM