If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

help needed in configuring c8 with sql server 2005

Started by Desperado, 05 Jul 2007 08:56:49 PM

Previous topic - Next topic

Desperado

Hi All ,

I'm installing cognos 8.1.2 on my local xp professional machine with microsoft sql server 2005 . The connection to my content manager is failing .
I have the ip address on my machine. I'm getting the ip from a router.
the collation i selected is Arabic_cs_al. can some one plz confir,m if it's correct or not .
i did all the basic stuff .. creating virtual directories in IIS , is there anything specific that i need to know when installing with sql server 2005.
or is there any doc with cognos ???

please do the needful.

here is my cogserver.log


69.140.227.181:9300   4484   2007-07-04 15:49:49.265   -5               main   LOGSV   603   1   server.Audit.IPF   StartService   LogService      Success      <parameters><item name="Port"><![CDATA[9362]]></item><item name="Mode"><![CDATA[UDP]]></item><item name="Secure"><![CDATA[FALSE]]></item></parameters>

69.140.227.181:9300   4484   2007-07-04 15:49:55.656   -5   pogoStartup   na   na   0   Thread-15   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.contentmanager.coordinator.ActiveCMControl      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   DPR-CMI-4007 A request to perform an active content manager election failed.null
com.cognos.pogo.bibus.SoapFaultException
   at com.cognos.pogo.bibus.BIBusCommand.handleResponse(BIBusCommand.java:519)
   at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:280)
   at com.cognos.pogo.contentmanager.StandbyContentManagerElectionCommand.executeIfLocal(StandbyContentManagerElectionCommand.java:58)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.sendElectCommand(ActiveCMControl.java:224)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.startTimer(ActiveCMControl.java:171)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.startupFindCM(ActiveCMControl.java:134)
   at com.cognos.pogo.contentmanager.coordinator.RuntimeInfoPublishHandler.start(RuntimeInfoPublishHandler.java:152)
   at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:100)
   at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:415)
   at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:540)
   at java.lang.Thread.run(Unknown Source)


69.140.227.181:9300   4484   2007-07-04 15:49:55.64   -5   pogoStartup   na   na   0   Thread-15   DISP   1016   1   Audit.Other.dispatcher.DISP.com.cognos.pogo.contentmanager.coordinator.CMBootstrap   getActiveContentManager   ContentManager      Failure   <messages><message><messageString>DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.</messageString></message></messages>   

69.140.227.181:9300   4484   2007-07-04 15:49:55.656   -5   na   na         Thread-29   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.contentmanager.coordinator.ActiveCMControl      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   DPR-CMI-4007 A request to perform an active content manager election failed.null
com.cognos.pogo.bibus.SoapFaultException
   at com.cognos.pogo.bibus.BIBusCommand.handleResponse(BIBusCommand.java:519)
   at com.cognos.pogo.bibus.BIBusCommand.execute(BIBusCommand.java:280)
   at com.cognos.pogo.contentmanager.StandbyContentManagerElectionCommand.executeIfLocal(StandbyContentManagerElectionCommand.java:58)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.sendElectCommand(ActiveCMControl.java:224)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl.access$100(ActiveCMControl.java:24)
   at com.cognos.pogo.contentmanager.coordinator.ActiveCMControl$ElectTask.run(ActiveCMControl.java:240)
   at java.util.TimerThread.mainLoop(Unknown Source)
   at java.util.TimerThread.run(Unknown Source)


69.140.227.181:9300   4484   2007-07-04 15:49:55.375   -5   Initialization_SESS   Initialization_REQ         Thread-15   CM   1300   1   Audit.cms.CM   StartService         Warning      CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.

CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters and then contact your database administrator.

Failed Logon:com.jnetdirect.jsql.g: TCP/IP connection failed to host:BACHUSLTXP java.net.ConnectException: Connection refused: connect url:jdbc:JSQLConnect://bachusltxp:1433/Cognos

69.140.227.181:9300   4484   2007-07-04 15:50:11.359   -5   Termination_SESS   Termination_REQ         main   CM   1300   1   Audit.cms.CM   StopService   ContentManagerService      Success      CM-SYS-5094 Content Manager stopped.; Build=2.0.1300.0

69.140.227.181:9300   4484   2007-07-04 15:50:11.875   -5               stopper-jobService   JS   1060   1   Audit.js.JS   StopService   JobService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.875   -5   na   na         stopper-jobService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler asyncJobServiceHandlernull
java.lang.NullPointerException
   at com.cognos.pogo.async.impl.AsyncHandler.stop(AsyncHandler.java:308)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.468   -5               stopper-deliveryService   DLS   1173   1   Audit.ds.DLS   StopService   DeliveryService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.89   -5               stopper-agentService   ASV   1336   1   Audit.as.ASV   StopService   AgentService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.875   -5   na   na         stopper-agentService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler asyncAgentServiceHandlernull
java.lang.NullPointerException
   at com.cognos.pogo.async.impl.AsyncHandler.stop(AsyncHandler.java:308)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.359   -5   shutdown   na   na   0   main   DISP   1016   1   Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices   StopService   CPS Producer Registration Service      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.468   -5               stopper-monitorService   MS   1187   1   Audit.ms.MS   StopService   MonitorService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.468   -5   na   na         stopper-monitorService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler asyncMonitorServiceHandlernull
java.lang.NullPointerException
   at com.cognos.pogo.async.impl.AsyncHandler.stop(AsyncHandler.java:308)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.468   -5   na   na         stopper-deliveryService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler asyncDeliveryServicenull
java.lang.NullPointerException
   at com.cognos.pogo.async.impl.AsyncHandler.stop(AsyncHandler.java:308)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.875   -5               stopper-eventManagementService   EMS   1187   1   Audit.ems.EMS   StopService   EventService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.89   -5   shutdown   na   na   0   main   DISP   1016   1   Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices   StopService   BatchReportService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.906   -5   shutdown   na   na   0   main   DISP   1016   1   Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices   StopService   reportDataService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.906   -5   na   na         stopper-reportDataService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler reportDataServicenull
java.lang.NullPointerException
   at com.cognos.pogo.async.impl.AsyncHandler.stop(AsyncHandler.java:308)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.89   -5   na   na         stopper-batchReportService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler warptaskmtanull
java.lang.NullPointerException
   at com.cognos.pogo.reportservice.ReportServerHandler.stop(ReportServerHandler.java:431)
   at com.cognos.pogo.reportservice.BatchReportServerHandler.stop(BatchReportServerHandler.java:201)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.89   -5   na   na         stopper-dispatcher   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler dispatcherStatusHandlernull
java.lang.NullPointerException
   at com.cognos.pogo.handlers.engine.DispatcherStatusHandler.stop(DispatcherStatusHandler.java:106)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.906   -5   shutdown   na   na   0   main   DISP   1016   1   Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices   StopService   ReportService      Success      

69.140.227.181:9300   4484   2007-07-04 15:50:11.906   -5   na   na         stopper-reportService   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler warpmtanull
java.lang.NullPointerException
   at com.cognos.pogo.reportservice.ReportServerHandler.stop(ReportServerHandler.java:431)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.906   -5   na   na         stopper-bal   DISP   1016   1   Audit.Other.dispatcher.DISP.pogo   pogo   com.cognos.pogo.services.DefaultHandlerService      Failure   <messages><message><messageString>DPR-DPR-1035 Dispatcher detected an error.</messageString></message><message><messageString></messageString></message></messages>   problem stopping handler lb_forwardernull
java.lang.NullPointerException
   at com.cognos.p2plb.clerver.LoadBalanceHandler.stop(LoadBalanceHandler.java:865)
   at com.cognos.pogo.services.DefaultHandlerService.stop(DefaultHandlerService.java:188)
   at com.cognos.pogo.services.DispatcherServices$ServiceStopper.run(DispatcherServices.java:359)


69.140.227.181:9300   4484   2007-07-04 15:50:11.921   -5               stopper-logService   LOGSV   603   1   server.Audit.IPF   StopService   LogService      Success      <parameters><item name="Port"><![CDATA[9362]]></item><item name="Mode"><![CDATA[UDP]]></item><item name="Secure"><![CDATA[FALSE]]></item></parameters>


kommireddy

Hi,

Collation name should be Latin1_General_CI_AI, and Sql server should be installed in mixed mode. To avoid confusion about IP, just leave localhost as server name in application URIs in cognos configuration. 

Desperado

Hi
Thanks for the reply. i installed sql server with mixed mode. should i name the instance name as localhost ? I'll try changing the collation name ....
but after checking my log , i feel that it's somehow failing to establish link thru tcp/ip.... it's giing me an error msg even before chking the collation ....
I'll try these today.

Thanks in advance for all the future updates  :)

praveennb

Quote from: Desperado on 06 Jul 2007 02:01:21 PM
Hi
Thanks for the reply. i installed sql server with mixed mode. should i name the instance name as localhost ? I'll try changing the collation name ....
but after checking my log , i feel that it's somehow failing to establish link thru tcp/ip.... it's giing me an error msg even before chking the collation ....
I'll try these today.

Thanks in advance for all the future updates  :)

1. if you have created a default instance for SQL 2005 then in the cognos config you can specify for the sql server name as localhost.
2. Ensure that SQL Server Browser service is started.
3. Try to disable windows firewall and see if it works.

right click the left side pane of the cognos configuration node for the content manager section,  a context menu under this you select and do a "Test"  which will tell you wether cognos is able to connect to the SQL server.

let us know if this worked.


Desperado

I tried it with localhost even , but it didn't work for me  :( . May be i have to remove everything and re install it again .
thank you for the reply

*NL*

Make sure SQL server 2005 is using TCP/IP.
Go to the SQL Server Configuration Manager and enable the tcp/ip protocol.

It is possible to install SQL server in windows mode, just make sure the cognos service runs as a network service and authenticate the content store that way.

kommireddy

Hi,

It seems to be bit of confusion here, I didnt mentioned to name the DB instance as localhost.

By default in cognos configuration, content store selects MS SQL server as DB and instance name as 'cm'.

So just create a new database instance with name cm in SQL server Enterprise manager with collation

name Latin1_General_CI_AI.

Check whether SQL server is using default port 1433, by going to Start->Programs->Microsoft SQL Server->Server Network Utility, select TCP/IP under 'Enabled Protocols' anc click on properties.

Open cognos configuration and test the connection to 'Content Store'.

after passing the tes, save the configuration and start the configuration, you should see some 100+ tables created in cm instance.

Hope this helps.

tdyoda

Quote from: prav on 10 Jul 2007 08:54:23 AM
Ensure that SQL Server Browser service is started.

This service is not required the content manager to consume the services of SQL Server 2005.

COGNOiSe administrator

Are you using default SQL Server instance or did you opt for a named instance?