COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Anke on 21 Sep 2010 05:02:38 PM

Title: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: Anke on 21 Sep 2010 05:02:38 PM
I currently have Cognos 8.3 installed on port 9400...I started through the steps to install 8.4.1, got all the way to the creating the Namespaces in Cognos Configuration, and then clicked to save and start the Cognos Service.  I get an error. :'(  At that point I change the current configuration port to 9300 so we can run both at the same time for testing before we move to 8.4.1...could setting up 8.4.1 on the same port as our current install have created this error?????   

Can I fix by simply dropping the table causing the error??  ???
TheERROR:

A Content Manager configuration error was detected while connecting to the content store. 
CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "C:\Program Files\cognos\c841\configuration\schemas\content\sqlserver\dbInitLock_mssqlserver.sql".  There is already an object named 'CMSYSPROPS' in the database. Cause: There is already an object named 'CMSYSPROPS' in the database.    Runtime Exception stack trace:  com.jnetdirect.jsql.JSQLException: There is already an object named 'CMSYSPROPS' in the database. 

Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: cognostechie on 21 Sep 2010 07:59:19 PM
Did you create a new schema for 8.4.1 or using the earlier Content Store of 8.3 ??
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: Anke on 22 Sep 2010 07:35:24 AM
I created new.
All of the tests in the Configuration pass, but the Service fails to start.  I have the Service log on with a Local System Account....should I have created an account specifically for the Service?
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: cognostechie on 22 Sep 2010 01:09:09 PM

I don't know what's hapenning but port 9400 cannot be the same for two versions. That's for sure. Port 80 can be the same but not 9400.
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: Anke on 22 Sep 2010 02:10:09 PM
I am using port 9400 for one version and 9300 for the other version.  I also created an account specifically for this service (copied security same as other Cognos service)..Service still will not start...errors in CBS_START.log

Wed Sep 22 15:24:41 2010  INFO  t[13e4] CBSNTService Attempt to starting service "cognos841"
Wed Sep 22 15:24:41 2010  INFO  t[13e4] CBSNTService Starting service "cognos841"
Wed Sep 22 15:24:41 2010  INFO  t[13e4] CBSNTService Waiting for service to start...
Wed Sep 22 15:29:47 2010  INFO  t[13e4] CBSNTService Started service "cognos841"

Wed Sep 22 15:29:47 2010  INFO  t[13e4] CBSBootstrapService attempt to load config from "C:/Program Files/cognos/c841\./bin\./bootstrap_win32.xml"
Wed Sep 22 15:29:48 2010  ERROR t[13e4] CBSSocketCommand failed to connect, CAM error: <errorDetail><errorCode>-12</errorCode><errorMessage>CAM-CRP-0026 The underlying socket: '10.2.1.111:9300' returned an error.</errorMessage><errorStack><errorCode>10061</errorCode><errorMessage>Could not connect the socket, errno: 0x274d(10061)</errorMessage></errorStack></errorDetail>
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: Suraj on 23 Sep 2010 10:00:00 AM
You may have already done this but just to confirm that you have different port numbers for the Dispatcher (change all dispatcher uri), Shutdown port and log server.
We have the following things on different port number on our multiple instances:
Dispatcher URIs (all of them).
Content Manager URIs.
Log server port number.
Shutdown port number.

Also, use a login for content store that can create tables.
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: Anke on 24 Sep 2010 09:11:55 AM
Yes, I have all of those setting changed in the configuration.

It is so odd.  When I try to start the service, it says the service failed to start...error CFG_ERR_0106.  Then, when I look at the service, it says it is running...
Title: Re: Error installing Cognos 8.4.1, after creating Namespace - when starting Service
Post by: MFGF on 29 Sep 2010 09:07:21 AM
Hi,

What database are you using for your content store for the 8.4.1 instance?  Is the database you are using definitely not already in use as the 8.3 content store?

If you go into Cognos Configuration and use the Test function on the content store configuration, does it report any errors?

If all else fails, try creating an entirely new content store database and pointing to this in your 8.4.1 configuration.

Regards,

MF.