CommandCentral Enterprise Reporter (CCER) installation fails configuring Cognos

  • Modified Date:
  • Article ID:000010504


After migrating Oracle to a new server and installing CCER to connect to the new Oracle instance, the installation stops when configuring the Cognos software.

It can be tracked in the installccer log that the installation is proceding to configure Cognos.

This will be referred to the ccer_cognos.log which may show the issue where:

Error: Cognos server is not yet running. Please look into Cognos log files. Aborting Cognos configuration

The issue will be apparen in the cogserver.log as shown below.


Error Message


CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is "jdbc:oracle:thin:@<host>:1521:CCER".  ORA-01017: invalid username/password; logon denied  Cause: ORA-01017: invalid username/password; logon denied  

if the password is correct, the error could be:

CM-REQ-4012 You do not have the appropriate permissions to update or delete the object "/Directory/Cognos" or a related object


Test connection to the database using the SAHARA_COGNOS user.

/oracle/product/10.2.0/client_10g/bin/sqlplus SAHARA_COGNOS/******@"(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME =CCER)))"


It might be appropriate to reset the SAHARA_COGNOS user to the default password of SAHARA_COGNOS/SAHARA and retry the installation.  If the installation is then failing / only failing with permissions errors but the password is correct then clean the Cognos configuration from the database:

1. drop user SAHARA_COGNOS cascade;
2. create user SAHARA_COGNOS identified by sahara default tablespace SAHARA_CGNS_01 quota unlimited on SAHARA_CGNS_01;
3. grant create procedure,create sequence,create session,create table,create trigger,create view,SAHARA_READ to SAHARA_COGNOS;


Terms of use for this information are found in Legal Notices.



Did this article answer your question or resolve your issue?


Did this article save you the trouble of contacting technical support?


How can we make this article more helpful?

Email Address (Optional)