Full contect export giving error

[ipmurali]

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

[ducthcogtechie]

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

[ipmurali]

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