Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2
Oracle Database
Problem:
FAP process stops when it founds a user in Controller that does not exist in CAM source (LDAP or AD)
Error in FAP log:
2015-01-07 12:36:03,673 [IP:FAP] ERROR RetryInterceptor – Trial 3 failed for method addCAMUser
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1$$EnhancerByCGLIB$$3867900c.addCAMUser()
at com.ibm.cognos.fap.service.security.User.createUsers(User.java:87)
at com.ibm.cognos.fap.service.security.Security.publish(Security.java:64)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.initialPublish(DatamartTimerTask.java:501)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.access$300(DatamartTimerTask.java:80)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask$1.run(DatamartTimerTask.java:367)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not add CAM user AD\username1 with CAMID
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:320)
… 12 more
Caused by:
com.ibm.cognos.tm1.TM1Exception: ObjectRegistrationFailed
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:314)
… 12 more

Possible Solution:
Go into the Cognos Controller client, and erase all users that should not be there. That has left the company and does not exist in the Active Directory.
http://www-01.ibm.com/support/docview.wss?uid=swg21632436
Different solution is to run SQL script to erase all users that have no CAMID in the table XCAMUSER inside the Cognos Controller database.
Start SQL developer and connect to the Cognos Controller database
Enter below to list the free rows:
Select * from frango.xcamuser where camid = ‘ ‘;
Enter below to make a copy of the table before deleting its contents:
create table xcamuser_backup as select * from xcamuser;
Enter below to delete the empty rows:
Delete from frango.xcamuser where camid = ‘ ‘;

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 13:02:48,664 [schedulerThread] ERROR Scheduler – Connection error to FAP database
com.ibm.cognos.fap.common.exception.ConnectionException: Could not connect to: jdbc:oracle:thin:@servername2488.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$$bd9ad5c2.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 create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
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.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 11 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 19 more
2015-03-17 13:02:48,680 [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$$bd9ad5c2.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:@servername2488.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 create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
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.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:18,695 [schedulerThread] ERROR RetryInterceptor – Trial 2 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$$bd9ad5c2.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:@servername2488.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 create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
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.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
2015-03-17 13:03:48,710 [schedulerThread] ERROR RetryInterceptor – Trial 3 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$$bd9ad5c2.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:@servername2488.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 create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
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.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
… 12 more
Caused by:
oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
… 20 more
Possible solution:
Change in the FAPService.properties file to use a different SID name, try without the domain.com values at the end. The Oracle listener is setup to listen to only the name.
Change from db=fap42.domain.com
To db=fap42
In below file example;
u# IBM SOURCE CODE HEADER START
# =====================================================================
# OCO Source Materials
#
# BI and PM: ccr
#
# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved
#
# The source code for this program is not published or
# otherwise divested of its trade secrets, irrespective of
# what has been deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END

db=fap42
host=servername.domain.com
dbType=oracle
user=COGFAP
passwd=xxxxxx
clientcamuri=http://biwebalias.domain.com/ibmcognos/cgi-bin/cognosisapi.dll

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

Product:

Cognos Controller 10.1 (version 10.1.2159)

Oracle database datamart ( dm version 43 )

Windows 2008 R2 server

Symptom:

After a publish to datamart from inside the Cognos Controller client there is no data in the DMFACT table. The publish (export) are very quick – a few minutes – and when you check there is no data in the DM tables in the Datamart.

Possible Solution:

You need to ensure that the text for provider and data source are spelled the same in Cognos Controller Configuration for both database connections and Database Connections for publish to datamart. If there are capitals letters they need be the same one both configurations for the two databases, one for the controller data and one for the datamart to be used by Cognos Controller.

The datamart must be of the same database version as the Cognos Controller database, you can not have Cognos Controller in Oracle and the datamart in a Microsoft SQL database, then you will get a “finish with error” when you do the Publish for datamart in Cognos Controller Client.

When you define the datamart inside Cognos Controller, you must set the additional target to be Cognos BI. This will create the data in the database you have defined inside Database Connections for publish to datamart. If you leave it blank it will try to publish the DM data to the same database as your Cognos Controller database. Set additional target to Cognos BI, save the definition, and then go to Transform – Publish Data and Structures – Publish Data Mart.

Only select Period there you have data – otherwise you can get a error message like “no data found” – and select all structures. In this dialog then the Target must be “IBM Cognos BI” and not “none”.

Ensure you have the ojdbc6.jar file in the c:\program files(x86)\ibm\cognos\c10 folder to make the dbconv.exe file to work.  If there are issues, try the :\program files(x86)\ibm\cognos\c10\legacy\dbconv.exe file instead. Point to the udl file in dmdata folder and check that it is of the right DM version.

Changes to the datamart udl take affect direct, but you can restart the Batch service to make them work better.

More information:

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

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

Product:
Cognos Controller FAP service
Windows 2012 R2
Microsoft SQL database

Symptom:
Start FAP Initial Publish for first time, after a half hour you get a fail message. Also show “java.lang.StackOverflowError” if you hold your mouse over the message in FAP log dialog.
You try by restart and new test but get same result again.

Text in C:\Program Files\ibm\cognos\ccr_64\Server\FAP\error.log file can be:

2015-08-25 17:47:42,429 [schedulerThread] INFO Scheduler – FAP service started on host:SEservername.domainsweden.com
2015-08-25 18:15:30,786 [pool-4-thread-7] ERROR RetryInterceptor – Trial 1 failed for method populateMonthlyPeriod
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:45)
at com.ibm.cognos.fap.service.persistence.dao.period.PeriodFAPDaoMSSqlServer$$EnhancerByCGLIB$$519ff1f8.populateMonthlyPeriod()
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:182)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)

at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.facts.BaseFactsHandler.addPeriodsIfTheyNotExist(BaseFactsHandler.java:276)
at com.ibm.cognos.fap.service.dimension.facts.CompositeFactsHandler.addPeriodsIfTheyNotExist(CompositeFactsHandler.java:258)
at com.ibm.cognos.fap.service.dimension.facts.Facts$Transformer.run(Facts.java:128)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:483)
at java.util.concurrent.FutureTask.run(FutureTask.java:274)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
at java.lang.Thread.run(Thread.java:801)
Caused by:
java.lang.StackOverflowError
at java.util.concurrent.CopyOnWriteArrayList.toArray(CopyOnWriteArrayList.java:364)
at java.util.logging.Logger.accessCheckedHandlers(Logger.java:1368)
at java.util.logging.LogManager$RootLogger.accessCheckedHandlers(LogManager.java:1507)
at java.util.logging.Logger.getHandlers(Logger.java:1362)
at java.util.logging.Logger.log(Logger.java:624)
at java.util.logging.Logger.doLog(Logger.java:653)
at java.util.logging.Logger.log(Logger.java:676)
at java.util.logging.Logger.severe(Logger.java:1162)
at com.microsoft.sqlserver.jdbc.TDSParser.throwUnexpectedTokenException(tdsparser.java:97)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:88)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1488)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processResults(SQLServerStatement.java:1135)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processBatch(SQLServerStatement.java:1123)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processExecuteResults(SQLServerStatement.java:1115)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.processResponse(SQLServerPreparedStatement.java:347)
at com.microsoft.sqlserver.jdbc.TDSCommand.close(IOBuffer.java:4660)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.discardLastExecutionResults(SQLServerStatement.java:93)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.closeInternal(SQLServerStatement.java:583)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closeInternal(SQLServerPreparedStatement.java:172)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.close(SQLServerStatement.java:595)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at com.ibm.cognos.fap.common.persistence.dao.BaseDao.closeJDBCObjects(BaseDao.java:85)
at com.ibm.cognos.fap.service.persistence.dao.period.PeriodFAPDao.populateMonthlyPeriod(PeriodFAPDao.java:135)
… 5294 more

Solution:
Try with a different Cognos Controller database as a source. Try with less period of data, only select 6 months instead of 18 months inside the FAP manager client.

Product:
Cognos Controller 10.2.1 Fix Pack 2
Microsoft Windows 2012 Server

Problem:
After installation of Cognos Controller 10.2.1 Fix Pack 2 on a existing Cognos Controller 10.2.1 installation the Windows services are missing:
IBM Cognos Controller Java Proxy
IBM Cognos Controller User Manager

Maybe because the service is set to use a windows account different from the person logged in to the server doing the installation – can caused this error.

Error in log file isconfig-UPDATER_CNTRL-20151124_1249.log:

Error: Failed to retrieve environment variable “JAVA_HOME”.
==== Component: ccrconfigappserver ====
Setup File: ‘C:\Program Files\ibm\cognos\ccr_64\bin\wct\ccrconfigappserver.xml’
Macro Definition: ‘InstallDir’ = ‘C:\Program Files\ibm\cognos\ccr_64’

Solution:
1. Reboot the Controller application server.

If this fails to solve the problem, go to step 2.

2. Logon to the Controller application server as a Windows administrator
3. Launch a command prompt (START – RUN – “CMD” )
4. Type the following command:

sc create frLicServer binpath= “C:\Program Files\ibm\cognos\ccr_64\server\FrLicServer.exe” DisplayName= “IBM Cognos Controller User Manager” depend= RpcSs start= auto

5. Type the following command:

sc create “IBM Cognos Controller Java Proxy” binpath=”C:\Program Files\ibm\cognos\ccr_64\server\CCRProxy.exe” DisplayName=”IBM Cognos Controller Java Proxy” depend=RpcSs start=auto

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

Product:
Cognos Controller 10.2.1 Fix Pack 2
Microsoft Windows 2012 Server

Problem:
After installation of Cognos Controller 10.2.1 Fix Pack 2 on a existing Cognos Controller 10.2.1 installation, the FAP program give error when you login to the FAP client.

Because you have forgotten to upgrade the FAP database to the new version 9.
Error:
Microsoft NET Framework
Unhandled exception has occurred in your application.

Invalid Length for a Base-64 char array.

Solution:
1. Go to the Controller Configuration
2. Go to the Database settings
3. Create a new connection to the FAP database
4. Save and test it
5. Click on RUN to go to the DBCONV program
6. Select FAP
7. Click Connect
8. Click Upgrade
9. Click Close
Try again to start the Financial Analytics Publisher client and login.

More information
http://www-01.ibm.com/support/docview.wss?uid=swg21602419
http://www-01.ibm.com/support/knowledgecenter/SS9S6B_10.2.1/com.ibm.swg.ba.cognos.ctrl_inst.10.2.1.doc/c_win_ctrl_installfap.html%23win_ctrl_InstallFAP