Product:
Cognos Controller FAP 10.1.1
Oracle Database

Problem:
Error log when start the Controller FAP service
Error message in file C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\error.log
2015-03-17 10:06:49,227 [schedulerThread] ERROR Scheduler – Connection error to FAP database
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername-lx2488.domain.com:1521:FAP42.domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.trace(LogDaoOracle.java:53)
at com.ibm.cognos.fap.common.persistence.dao.LogDao.info(LogDao.java:121)
at com.ibm.cognos.fap.common.persistence.dao.LogDao$$FastClassByCGLIB$$60127973.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:56)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$766a4385.info()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:197)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 9 more
Caused by:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.lang.Class.forName(Class.java:139)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
… 11 more
2015-03-17 10:06:49,242 [schedulerThread] ERROR RetryInterceptor – Trial 1 failed for method pingDatabase
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle$$EnhancerByCGLIB$$766a4385.pingDatabase()
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:213)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:139)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername-lx2488.domain.com:1521:FAP42.domain.com
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:72)
at com.ibm.cognos.fap.common.persistence.dao.LogDaoOracle.pingDatabase(LogDaoOracle.java:107)
… 9 more
Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.ibm.cognos.fap.common.persistence.dao.DbContext.getConnection(DbContext.java:70)
… 10 more
Caused by:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.lang.Class.forName(Class.java:139)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
… 12 more

Possible cause:
The oracle database is not configured with the correct tables needed to use it as a FAP database. Run DBCONV to update the database with correct tables.
Also that the ojdbc5.jar file is not in the folder C:\Program Files (x86)\ibm\cognos\c10\Server\FAP\lib

Product:
Cognos Controller 10.1.1 (update version 10.1.6302.53-0)
Controller FAP client (version 10.1.6235.60-0)
Windows 2008 R2 server
Oracle database

Problem:
When try to login to the FAP database from the FAP client you get a error message
“Can’t connect to FAP database”.
same error as when you write the wrong password.

Solution:
Install oracle driver 11.2.0.4.0 64 bit version on the computer where you run the Controller FAP client.
Select to do a Administration client installation.

If you have the TNSNAMES.ORA file in a different folder than the normal for Oracle, then you need to update the Windows registry with this value.
Start REGEDIT.EXE
Expand HKEY_LOCAL_MACHINE – SOFTWARE – ORACLE – KEY_OraClient11g_home2
Right Click and select NEW – String Value
Set Value name: TNS_ADMIN
Set Value data: c:\orarun\tnsadmin
(the path to the folder where the TNSNAMES file are)

Product:
Cognos TM1 Architect 10.2.2
Windows 2008 R2 Server
Oracle database
Problem:
When importing data from an ODBC oracle database, the preview in TM1 Architect is blank. You see the columns name, but no data.
You use a query statement like this SELECT * FROM IA_RUNREPORT;
Solution:
One of the columns in oracle database is in the format TIMESTAMP, and that is not considered a number or a string by TM1. You must then in your SQL statement convert that to a STRING.
Use this command:
TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”,

So then your SQL statement inside TM1 TI process Data Source Query should be something like this:
SELECT RUN_ID, ENV_ID, SOLUTION_ID, USER_ID, TIME_ID, CONTENT_ID, USERNAME, NAMESPACE, USERID, CAMID, REPORTPATH, TO_char(“IA_RUNREPORT”.”EXEC_TIMESTAMP”) AS “EXEC_TIMESTAMP”, TARGET_TYPE, STATUS, ERRORDETAILS, RUNTIME, PACKAGE, HOST_IPADDR, PROC_ID, SESSION_ID, REQUEST_ID, TIMEZONE_OFFSET, THREADID FROM IA_RUNREPORT;
Check in your Oracle data source with SQL Developer if there are any column that is not in NUMBER or VARCHAR format, because that you need to take care of in the import SQL statement to TM1.

Product:

Cognos TM1 10.2.2

Windows 2008 R2 Server

 

Problem:

How create the measure dimension in a TI process?

And not use the TM1S.CFG parameter DefaultMeasureDimension=T

That will make the last dimension the measure dimension at every cube creation.

http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SS9RXT_10.1.0/com.ibm.swg.ba.cognos.tm1_inst.10.1.0.doc/c_defaultmeasuresdimension_tm1.html%23DefaultMeasuresDimension_tm1

 

Solution:

Go into TM1 Architect and create a new TI process;

In PROLOG set some parameters for the cube.

#—————————–

# set default values

#——————————-

cCubeName = ‘IA.WLicensUsage’ ;

cDimParameter = ‘IA.WUsers’ ;

cDimMeasure=  ‘IA.WLicens’ ;

In EPILOG set this command

cellputs (cDimMeasure, ‘}CubeProperties’,cCubeName,’MEASURES_DIMENSION’);

 

Change the variables names to fit with your cube and dimensions names.


Product:
Cognos BI 10.2.2
Windows 2012 R2

Problem:
The tree prompt is starting all over again and is not showing the next 20 rows of selections as it did in previous version of Cognos BI.

Solution:
Go to the Framework Manager Package icon in Cognos Connection that is used of that report.
Click on MORE
Click Modify the package configuration
Change the Default member limit in a data tree level to 200 from 20
Change the Maximum member limit in a data tree level to 500 from 50
Click OK
Test runs the report again.

Product:
Cognos Controller 10.2.1 FAP service
Windows 2012 R2
Problem:
When starting the IP in FAP client you get an error message it cannot connect to the TM1 instance called FAP.
Error message:
2015-05-29 10:47:52,183 [schedulerThread] ERROR Scheduler – Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerClientNotFound
at com.ibm.cognos.tm1.API.logonCAMNamespace(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.login(TM1Context.java:106)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:530)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:252)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:157)
at java.lang.Thread.run(Thread.java:795)

Solution:
Enter correct password for the CAM user account domain\cognosfap
Save and try again.
More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21679216&aid=1

Product:
Cognos BI 10.2.2
Windows 2012 R2 server

Issue:
After upgrade from Cognos BI 10.1.1 to Cognos BI 10.2.2 the creation of PDF reports takes several minutes, when it before take only seconds.
HTML reports are as fast they were in the older version of Cognos BI.
If you remove the pictures in the report, then the PDF file is created fast.

Possible Solution:
Copy all the images to the Report BI server, in old version the images that are in reports are on the Cognos BI Gateway server only. Now it is recommended to have them on all BI servers.
Update all servers to have the pictures in the folder .. \samples\images.
D:\Program Files\ibm\cognos\c10_64\webcontent\samples\images

The PDF creation looks locally for the pictures at first, before going to the gateway.

Product:
IBM Data Studio 4.11
Windows 2012 R2 Server
DB2 database

Problem:
To save money the Cognos TM1 project does not want to use TOAD, and instead the free Data Studio – to allow the Developers have access to the data.

When run lanchpad.exe to install the DB2 Data Studio you get a installation screen without buttons. There are no links to select and install the product. Only a OK button to select language in the dialog exist in top right corner.
There should be buttons or menu options on the left side of the dialog, but there are none.
When you click on the OK button at the language, you are only brought back to the same dialog as before.

Instruction say to start LANCHPAD.EXE from the unzipped ibm_ds4110_win.zip file.
But that does not seem to work in some computer environments.

Solution:
Run the INSTALL.EXE instead.
Go to the folder \ibm_ds4110_win\disk1\installerimage_win64\
Right click on INSTALL.EXE and select “Run as Administrator”
This will first install the IBM Installation Manager
When that is done it will automatically start installation of Data Studio.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg24037681

Product:
IBM DB2 Data Studio 4.1.1
Windows 2012 R2 Server
DB2 database

Problem:
Get a error when I start the program Data Studio 4.1.1 Client

Error Message:
Locking is not possible in the directory “D:\xxxx…. ” A common reason is that the file system or Runtime Environment does not support file locking for that location. Please choose a different location, or disable file locking passing “-Dosgi.locking=none” as a VM argument. ….

Possible Solution:
Right click on the icon for Data Studio 4.1.1 Client and start the program “Run As Administrator”.

During installation the Windows environment was not setup to run in a “multiuser environment”.

Product:
Cognos TM1 10.2.2
Windows 2008 R2 Server
Cognos Controller 10.1.1 FAP service

Problem:
Suddenly the FAP client can not login to the TM1 FAP instance, that have worked before.

Error message:
Could not login to TM1, host: servername.domain.com, server name: FAP user name: AD\Roger
SystemServerClientNotFound

Solution:
If you restart the TM1 instance, then you need to restart the FAP service.
1. Stop the FAP Service
2. Stop the TM1Service
3. Start the TM1Service
4. Start the FAP Service

Make sure to pause between the startup of TM1 and FAP, to ensure that the TM1 is up complete and ready to accept calls from clients.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21599573