CommandCentral Enterprise Reporter (CCER) installation fails configuring Cognos

Article:TECH145934  |  Created: 2010-12-09  |  Updated: 2011-08-15  |  Article URL http://www.symantec.com/docs/TECH145934
Article Type
Technical Solution


Issue



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



/opt/VRTSccer/cognos/c8/logs/cogserver.log

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
 

Cause



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)))"

Solution



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;

 


Supplemental Materials

SourceError Code
ValueCM-CFG-5036
Description

Content Manager failed to connect to the content store


SourceError Code
ValueCM-REQ-4012
Description

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



Article URL http://www.symantec.com/docs/TECH145934


Terms of use for this information are found in Legal Notices