Distributed installation of cognos reportnet

[phani1979]

Hai
I had done Distributed installation of cognos reportnet
I installed in 4 systems
a: gateway
b:report server
c:report server
d:content store
I updated jar files. and wheni check the crnserverlog this errors:

CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is "jdbc:JSQLConnect://tr5:1433/cm".

"Cognos BI server not available"

Can anyone help me
Thank you
Sudhakar

[BIsrik]

the problem seems to be in content store itself. Well, Check whether the tables are created in both the content stores. If u have configured a single content store to both the RS..please make a change. There can be only one unique active content store to a RS. So, u need to have two content store for two RS.

Even check the error description in the crnserver.log file.

Srik

[phani1979]

Hai
In the content store , tables were created,  it's  sqlserver 2005 enterprise edition.
As you mentioned, Two Cotent stores for two RS. Can you tell me how to do that..
When i open the cognos configuration for  two systems of (report servers)  there is no namespace for content store..
A:Gateway
B:ReportServer
C: Report Server
D: Content Store,

In  (D):system i had configured the content store, i checked the log files also
the same message appears in  the crnserverlog file
"CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is "jdbc:JSQLConnect://tr5:1433/cm".
Failed Logon:com.jnetdirect.jsql.w: Cannot open database requested in login 'cm'. Login fails. url:jdbc:JSQLConnect://tr5:1433/cm]]></item></parameters>"

and one more message coming up" cryptographic information cannot be saved, do you want to save the information in the flat file, "  i said " Yes" and then closed  and started the service..

Thank you
Sudhakar

[smiley]

and one more message coming up" cryptographic information cannot be saved, do you want to save the information in the flat file, "Ã,  i said " Yes" and then closedÃ,  and started the service..

Your sun cert has expired, and needs to be replaced.
Without that it cannot encrypt the data, and nothing will work.
Cognos advisory on this:
http://support.cognos.com/supported/en/support/advisories/advcrn04_0405.html

[phani1979]

Hai
Thanks for the reply.
I had come across one more situtation. I need help ..
I need to Install a single production database server and two webservers accessing the  production data

I need to create 30 users,
6 of them will be working active
1-3 at peark

Iam using windows 2003 server and MS SQL server
I need the recommendations  of architecture for installing the cognos RepotNet software.
any commentws, always welcome

Thank you
Sudhakar

[smiley]

I would install reportnet full on both webservers.
websrv1 is the first install, and will automaticly be the primairy content manager.
websrv2 is the second install, and will be the backup content manager.

Load balancing is done automatically over these 2 servers.
When websrv1 is shot down, websrv2 will automatically become the active content manager.
In Cognos configuration on websrv1, just list websrv1 as Content Manager URI.
In Cognos configuration on websrv2, just list websrv1 as first Content Manager URI, and websrv2 as second Content Manager URI.

Failover is passive this way (websrv2 is hot standby for connections, but actively used for processing)
If you want to have active failover, you can use MS NLB or a hardware failover device.
If just used for connections, nothing needs to be changed. If you're going to use NLB or the hardware load balancer for full load balancing, instead of the cognos reportnet logic, you need to disable that logic by setting the dispatcher property to "clustercompatible" as described by Cognos kb  article 1012049

[pasumarthis]

Hai,
Thanks for the reply,

I had overview of installing two webservers and  four reportservers and two content managers
connected to  two contentstores.

As you said if one content manager fails, one content manager will be up and running.

Do you support this . ??

can you give me brief idea about how to do load balancing b/w report servers  how do i connect to web servers and content managers.

I had 6 power users.