by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database drivers install issue

Symptom:

Cognos Controller demands that you install both 64 and 32 bit oracle client on the controller application server. When you install the Oracle 32 bit client you get an error.

Error message:

[INS-20802] Oracle Net Configuration Assistant failed.

Cause:

The full 32-bit oracle client installation needs to have Microsoft Visual C++ 2010 32 bit installed.

 

Oracle client is downloaded from here:

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64)
  winx64_12102_client.zip (64-bit) (925,039,944 bytes)
 

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)
  winnt_12102_client32.zip (32-bit) (902,922,170 bytes)

 

Solution:

Download and install MVCPP 2010 from Microsoft

https://www.microsoft.com/en-gb/download/details.aspx?id=5555

Reinstall the Oracle drivers.

by ·0 Comments

Product:

IBM Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database

 

Symptom:

When click on connect inside DBCONV program to upgrade a database you get an error.

On the windows server, you have installed both 64 bit and 32 bit oracle 12c admin clients.

 

You get same error if you start DBCONV.EXE direct from here C:\Program Files\ibm\cognos\ccr_64\ and try to connect to a database.

 

Error message:

** ERROR: java.sql.SQLException: IO Error: Invalid connection string format, a valid format is: “host:port:sid”

 

Possible Cause:

The jar file in folder C:\Program Files\ibm\cognos\ccr_64 is wrong.

You may be using a ojdbc5.jar file.

or change to use only SID name as data source.

Solution:

Copy the ojdbc6.jar file to get it to work.

Then you will get this error;

** ERROR: java.sql.SQLRecoverableException: IO Error: could not resolve the connect identifier  “pp1140.companyx.com”

 

That is because your TNSNAME.ORA file is in wrong format.

 

Maybe like this, that does not work with DBCONV.EXE

 

PP1140.companyx.com =

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lx2814.companyx.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PP1140.COMPANYX.COM)))

 

Below format is the valid one to use for Cognos Controller.

 

PP1140.companyx.com =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=lx2814.companyx.com)(PORT=1521))

(CONNECT_DATA=(SERVICE_NAME=PP1140.companyx.com))

)

 

But if you change Cognos Controller to call the database with name only and not FQDN it will work fine with the OJDBC5.JAR file.

In Cognos Controller configuration for the database connection go to the last line for Data Source and change from pp1140.companyx.com to pp1140 only and click save.

Then the DBCONV will also work with the ojdbc5.jar file (that is 2043 Kb in size).

You need to update the TNSNAMES.ORA to contain

 

PP1140 =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=lx2814.companyx.com)(PORT=1521))

(CONNECT_DATA=(SERVICE_NAME=PP1140.companyx.com))

)

 

The JAVA menus in Cognos Controller 10.3 can only handle data source of a name, no periods are allowed in the connection string to the oracle database.

by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 Server

Oracle database 12c

 

Symptom:

Error when starting the new java menus in a new installation.

 

User clicks one of the following JAVA-based menu items:

* Company – Command Center

* Group – Command Center

* Maintain-System Audit Log – Overview and data

* Maintain – Configuration – Automatic Journals – Control Tables – Allocations.

* Maintain – Jobs – Define…

 

You need to test all five – they may call the oracle database different.

The problem does not occur in all environments. In other words, keeping the default (unmodified) file “ccr-system-properties.properties” will work in most environments.

  • By enabling the path in this file, then Controller’s Java-based functionality will try to connect using the ‘thin‘ protocol for oracle.
  • If the file/path is unmodified (the default settings), then those components will try to use the ‘OCI’ oracle client. This mean the full oracle client must be installed.

Error message:

Below from Cognos Controller client error dialog

 

com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)

at java.lang.Thread.run(Thread.java:798)

Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!

at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)

… 1 more

Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]

at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)

at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)

… 7 more

Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMTA6MzlkZDS05ODc0LTMwYTMjAxOTU1OjM3NDk3OTY4NzM7MDszOzE7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@123a963])]

at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)

at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)

… 10 more

Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)

… 19 more

 

 

com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)

at java.lang.Thread.run(Thread.java:798)

Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!

at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)

… 1 more

Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]

at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)

at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)

… 7 more

Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMDE6ZGIwYTFiN2UtNTZY3ODEtYmEyNGJhYOjAwNzE5ODMyNDI7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@880de732])]

at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)

at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)

… 10 more

Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:Failed to load mapping in {0} for entity type {2} (connection details: {1}),%1=com.ibm.cognos.ccr.classic.MappingImportSQLDAO@9a78b98(size=12),%2=EntityType=configproperty,%3={SELECT id. code. entityTypeName FROM XMAPPING WHERE entityTypeName = ‘com.cognos.ccr.models.configproperty.ConfigProperty’}

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)

… 19 more

 

 

com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)

at java.lang.Thread.run(Thread.java:798)

Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!

at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)

… 1 more

Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]

at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)

at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)

at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)

… 7 more

Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMDE6N2MyNTdkYzctNjc4Yy1kZWNlMWJmN2Y5OjE4MTMzU1NDU7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@9d8fd360])]

at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)

at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)

at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)

at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)

… 10 more

Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘hidProvider’ defined in class path resource [com/ibm/cognos/ccr/common/bto-db-dao-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:

PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property ‘mappingDao’ threw exception; nested exception is com.ibm.cognos.ccr.common.UnhandledException: Could not load the Entity in the MappingImportDAO

at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)

… 19 more

 

Below from the CCR.LOG file

17:00:22,547 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.load…

17:00:26,587 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 4 040 ms

17:00:26,587 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms

17:00:26,993 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 406 ms

17:00:26,993 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.load (16 212 bytes): 4 446 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 034 | total free=516 762

17:00:29,926 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Executing inJobModelDAO.getLatestSequenceNumber…

17:00:29,926 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms

17:00:29,926 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms

17:00:29,941 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 15 ms

17:00:29,941 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Finished inJobModelDAO.getLatestSequenceNumber (108 bytes): 15 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 644 | total free=517 372

17:00:30,300 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Executing inAccountModelDAO.getLatestSequenceNumber…

17:00:30,300 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms

17:00:30,300 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms

17:00:30,316 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 16 ms

17:00:30,316 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Finished inAccountModelDAO.getLatestSequenceNumber (108 bytes): 16 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 226 | total free=516 954

17:00:30,394 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Executing inAccountModelDAO.load…

17:00:30,394 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms

17:00:30,394 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms

17:00:30,955 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@1a443e7a/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inAccountModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@aefe9f8e]

com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction

at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:89)

at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.createMapping(MappingImportSQLDAO.java:240)

at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.getOrCreateMapping(MappingImportSQLDAO.java:136)

at com.ibm.cognos.ccr.account.internal.KontoDTOConverter.convert(KontoDTOConverter.java:98)

at com.ibm.cognos.ccr.classic.AbstractDTOConverter.convertAll(AbstractDTOConverter.java:56)

at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO$DTOImportHandler.processResultSet(AbstractImportSQLDAO.java:472)

at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:325)

at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:293)

at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:254)

at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:290)

at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:268)

at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:251)

at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadEntitiesInto(AbstractImportSQLDAO.java:191)

at com.ibm.cognos.ccr.account.internal.AccountModelBTOSQLDAO.load(AccountModelBTOSQLDAO.java:126)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)

at java.lang.reflect.Method.invoke(Method.java:620)

at com.ibm.cognos.ccr.common.ws.ServerTask.execute(ServerTask.java:87)

at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:57)

at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:32)

at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:240)

at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)

at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)

Caused by:

java.sql.SQLException: Could not commit with auto-commit set on

at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2360)

at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2407)

at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:301)

at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:200)

at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:83)

… 23 more

17:00:30,987 INFO  [cognos.ccr.integration.ServerIntegrationFacade] Finished inAccountModelDAO.load (83 bytes): 593 ms, memory usage [kb]: max=524 288 | total=15 424 | free=5 253 | total free=514 117

 

 

 

 

 

 

 

Select the cause by row and search the google internet to find a solution from IBM support;

“Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘hidProvider’ defined in class path resource”

 

http://www-01.ibm.com/support/docview.wss?uid=swg21995182

http://www-01.ibm.com/support/docview.wss?uid=swg21672387

 

 

First things to check:

Check that oracle client is working by enter TNSPING FRANGO.DOMAIN.COM in a Command prompt to see that you have access to the database for Cognos Controller.

Replace FRANGO.DOMAIN.COM with database value in the TNSNAMES.ORA file.

Check that file C:\orarun\tnsadmin\sqlnet.ora contain TNSNAMES first like this

NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP,  EZCONNECT, HOSTNAME).

Check TNSNAMES.ORA that the file is not too big, try with only 2 entries in the file.

In add/remove program ensure that the oracle driver installed for both 64 and 32-bit version.

Check the C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-system-properties.properties file that it points to the folder where TNSNAMES.ORA is.

Check windows system variable TNS_NAMES point to the folder where TNSNAMES.ORA is.

This can be done by write SET in a CMD prompt.

Ensure that the correct OJDBC5.JAR file is in these folders;

C:\Program Files\ibm\cognos\ccr_64\server\integration

C:\Program Files\ibm\cognos\ccr_64\server\FAP\lib

C:\Program Files\ibm\cognos\ccr_64

Ensure the ORACLE drivers bin folder is first in the system variable PATH.

Any change requires a reboot of the Windows server before you test again in Cognos Controller.

 

For the Cognos BI 10.2.2 part you may want to check this;

Copy the appropriate file from the Oracle_installation directory of the database to be used for the connection to the c10_location\webapps\p2pd\WEB-INF\lib directory.

If your version of IBM Cognos BI uses Java™ version 1.5, copy the ojdbc5.jar file.

If your version of IBM Cognos BI uses Java version 1.6, copy the ojdbc6.jar file.

If your version of IBM Cognos BI uses Java version 1.7, copy the ojdbc7.jar file.

The path tells you what version you use C:\Program Files\ibm\cognos\ccr_64\bin64\jre\7.0\bin.

Stop and restart the IBM Cognos service.

 

How create log files:

Stop the Cognos Controller services on the Windows server.

Rename the file C:\Program Files\ibm\cognos\ccr_64\log\ccr.log

Start the Cognos Controller services.

Run the test to open a dialog again.

Copy the new ccr.log file to your Cognos support request.

JAVA errors are written to the ccr.log file, but many other errors are written to the windows event log.

 

Solution:

Ensure that you refer to the Oracle data source in Cognos Controller configuration with name only.  SID name (like: it1051) , and not add .company.com to the line.

 

You need to ensure that the TNSNAMES.ORA have this setting and format:

it1051 =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=lx21024.company.com)(PORT=1521))

(CONNECT_DATA=(SERVICE_NAME=IT1051.COMPANY.COM))

)

 

Download the Oracle odbc6.jar drivers from here

http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

 

Download the full Oracle client from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html  see far below on site the download links for the client only;

 

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64)
winx64_12102_client.zip (64-bit) (925,039,944 bytes)

Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)
winnt_12102_client32.zip (32-bit) (902,922,170 bytes)

 

Follow the installation instructions from IBM here http://www-01.ibm.com/support/docview.wss?uid=swg21608353

 

More Information:

http://www-01.ibm.com/support/docview.wss?uid=swg21988891

http://www-01.ibm.com/support/docview.wss?uid=swg21999559

by ·0 Comments

Product

Cognos Controller 8

Symptom
The form layout can not be saved unless a selection is made for which file format to use for the form.

Problem
When using Excel 2007, first time the user wants to save a new or updated form layout in Controller a pop up is displayed to select a ‘File format of report’. This selection will determine in which format the Controller form layout is saved.

Cause
As designed.

Solution
Select one of the formats available (depending on which Excel version the Controller users will be running):
.xls – Compatible with Excel 2003.
.xlsx – Excel 2007 format, not compatible with Excel 2003 or earlier.

by ·0 Comments

Product

Cognos Controller 8

Symptom
System.NullreferenceException: Object reference not set to an instance of an object. At cognos.controller.appcontext.initConfig()

Problem
This error occurs when Cognos Controller is executed from Cognos Connection or when the URL http://servername/cognos8/controllerbin/ccr.exe is executed

Cause
.NET component is not correctly registered in IIS

Solution
Register .NET in IIS
Steps:
1. Open a DOS box.
2. Browse to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 directory
3. Type aspnet_regiis.exe /i

by ·0 Comments

Product
Cognos Controller 8
Symptom

When opening controller after migration of the controller databases from SQL2000 to SQL2005 the following error occurs after providing login credentials;

“—Exception has been thrown by the target of an invocation”

Problem
In the event log of the controller application server the following entry can be found.

The VB Application identified by the event source logged this Application FrMiscST: Thread ID: 6108 ,Logged: Error occured at 9/14/2009 6:15:11 AM in FrMiscST, Error No=-2147217900, Source=Server Sub:Db_PushStruc(..) , Description=Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation., HelpFile= HelpContext=0

Cause
The collation settings of the new server is different than the original one. For controller all the collation settings of the temp db and controller databases must be the same collation.

Solution
Create new SQL2005 instance or perform a complete new SQL2005 server installation with the correct collation. In this case “SQL_Latin1_General_CP1_CI_AS”

by ·0 Comments

Symptom
User launches Cognos Controller. User notices that the quick-link/shortcut icon to launch Excel is grayed out, and they cannot use it to launch Microsoft Excel.

Cause
User(s) belong to a security group which has the selection “Reports – Controller Link” configured. But its “Access Rights” are set to “Not Available”

Solution
1. Click “Maintain – Rights – Security Groups”
2. Select the tab ‘Menus’
3. In the ‘Code’ section, select the group which the user(s) belong to
4. Locate the entry for ‘Reports – Controller Link’
5. Change the setting ‘Access Rights’ from ‘Not Available’ to ‘Normal’.

by ·0 Comments

If a BiBusTKServerMain process terminates unexpectedly, a dump file is created in the ../bin directory.  In order to troubleshoot the termination of these processes, follow the steps below to use the Windows Debug (Windbg) tool available from Microsoft.

Use the Windbg tool to open the dump file to help determine the cause of the BiBusTKServerMain crash.

Steps:
Download and Install Windbg from Microsoft here

1. From the Start menu, launch Windbg.
2. From the File menu, choose Symbols File Path
3. In the Symbol Search Path dialog box, enter \\localhost\Symbols\dbg
4. Click Ok
5. From the File menu, choose Open Crash Dump
6. Navigate to the dmp file and click Open
7. Click Yes to the Save Workspace dialog
You may see an error such as:

*** ERROR: Symbol file could not be found.  Defaulted to export symbols for ntdll.dll –
This dump file has an exception of interest stored in it
The stored exception information can be accessed via .exr

8. On the white line at the bottom of the Command window type .exr -1 and hit enter
9. In the command line at the bottom of the Command window, type  k 20 and hit enter (This will show the to 20 lines of the stack trace)
10. Click on “View” in the top menu bar and select “Call Stack” – A new window will open
11. Click on “View” in the top menu bar and select “command” – a new window will open
12. Click on “View” in the top menu bar and select “locals” – a new window will open
13. Click on “View” in the top menu bar and select “processes and threads” – a new window will open
14. Click on “Window” in the top menu bar and select “Undock all”.
15. Click on “Window” in the top menu bar and select “Vertically tile floating windows” – The screen should show four windows
16. In the call stack window (“Calls”), click on the button “More” at the top until you get to the bottom of the stack
17. We need to locate an entry similar to the following:  RSReportService!RSASyncExecutionThread::run+0x606
18. Double click on this entry. Then move to the “Locals” Window and look for the following thread: “this”
19. Expand the plus sign next to “this” and you should see the following: m_pPrimaryRequest
20. Expand the thread m_pPrimaryRequest and you should see the following: m__objectPath
21. Expand the thread m__objectPath and you should see the following: m__value
22. Note down the value corresponding to the entry. It could be or it could indicate a particular report name.

If the value shows , it could be that the system did not have enough resources but is not conclusive.

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 server

Symptom:
After installation of Cognos Controller you get an error message when you start Cognos Controller Configuration

Error message in Controller:
Web Service, ControllerProxyServer, could not be found. Section is disabled.
The type initializer for ‘Cognos.Controller.Configuration.CRN’ threw an exception.

Cause:
The IIS installation is damage.

Check by start the IIS manager and expand the Application pool or the site list. You will get error like below:
There was an error while performing this operation
Details:
Filename:
\\?\c:\windows\microsoft.net\framework64\v2.0.50727\CONFIG\web.config
Line number: 13
Error: The configuration section “system.web” cannot be read because it is missing a section declaration.
or
Configuration system failed to initialize.

Possible Solution:
Uninstall IIS from windows and reinstall it from add/remove roles.

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 server
Oracle Database 12c

Symptom:
Error when you do optimize of the database inside Cognos Controller 10.3 in a new installation.

Error message:
Number: 5
Source: System.Web.Services
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: ORA-12516: TNS:listener could not find available handler with matching protocol stack
at Microsoft.VisualBasic.
…

Cause:
The Cognos controller use more connections to the database server than the database server is setup for.

Solution:
Increase the max Connections value for the Oracle server from 500 to max 1000.

The Cognos Controller 10.3 can create 300 inactive connections to the database during some heavy processes. If the oracle database use around 90 connections for internal use, then you soon hit the limit of 500 on the Oracle database.