Setup IBM Cognos Connections 5 on SLES11 and Oracle. A novel

  • 19 Mar, 2015

This week i spend several hours to setup a machine with IBM Cognos and IBM Connections 5 CR2 on SLES 11 SP3 using Oracle as database.

The Cognos wizard complete the CognosBI setup but Trasnformer not.

I set the logs to debug level and the messages does not help.

The problem was when the error appears the wizard roll back the installation of CognosBI removing everything from WebSphere.

After several reviews of the SLES libraries and Oracle client setup i made the setup only for CognosBI (previously i setup CognosBI + Transformer) successfully.

I try to open the cognos URL like http://server:port/cognos/servlet/dispatch/ext but the server doesn’t send any response

Reading the cognos.log i found the following :

Initialization_SESS Initialization_REQ Thread-70        CM        6304        1        Audit.cms.CM        StartService Warning
CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. sealing violation:
package oracle.jdbc is sealed Runtime Exception stack trace: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed

I don’t now why but the installer copy the orajdbc6.jar into Cognos.ear.   I stop the cognos server, remove the orajdbc6.jar from the lib folder inside of cognos.ear and  start the server.

The cognosBI works and  Transformer was installed without problems.

The steps i follow

1 - Setup Cognos BI
2 - Stop the server and remove the orajdbc6.jar from the cognos.ear
3 - Start the Cognos Server
4 - Setup the Transformer

Related Posts

Homepage Search: Profiles server fails while creating the initial index

  • 10 Sep, 2013

When trying to create the initial index for Global Search from the Homepage server, the index update fails with an error. To prevent further problems with indexing, perform a search in the Profiles database for any null entries in the table EMPINST.EMPLOYEE. select \ from EMPINST.EMPLOYEE
where EMPINST.EMPLOYEE.PROF\DISPLAY\NAME is null If any entries are returned they must be updated with an entry in the display name column for the Profiles feature to index successfully. To prevent this issue from occurring, change the value of PROF\DISPLAY\NAME=256 in the validate\dbrepos\fields.properties file, to contain the following: PROF\DISPLAY\NAME=(x != null) && (x.length() > 0) && (x.lengt

Homepage Search: Profiles server fails while creating the initial indexRead More

Proud to be an HCL Ambassador 2021

  • 15 Dec, 2020

​If you have a problem, and no-one else can help, and if you can find them, maybe you can ask an HCL Ambassador… !(http://www.mysphere.com.br/wp-content/uploads/2020/12/HCLAmbassaborlight4x.png) See the HCL Ambassadors Class of 2021(https://hcltechsw.com/about/hcl-ambassadors/class-of-2021)

Proud to be an HCL Ambassador 2021Read More

Nominate an IBM Champion

  • 30 Oct, 2019

IBM Champions demonstrate both expertise in and extraordinary support and advocacy for IBM technology, communities, and solutions. I am an IBM Champion since the first class  (2011) an this year i wish to be  an IBM Champion for the year 2020. New Champion Nominations are open now through 22 November 2019. Current IBM Champions may submit a renewal through 9 November 2019. To nominate an IBM Champion use this link(https://developer.ibm.com/champions/)

Nominate an IBM ChampionRead More