Product:

Cognos Controller 8.5.1532 FAP

Windows 2008

Cognos TM1 9.5.2

Symptom:

During IP for Controller FAP you get a error message that the FAP service can not login to the TM1 application. When you change client id and restart the FAP service, you get not error message, the FAP service is only hanging.

If you reboot the physical server, the FAP service will try to login once, and then fail.

There are no “fatalerror.log” in the FAP service folder on the server.

Background:

You have changed to use CAM ID and SSO to access Cognos Controller.

The servers and the users are in different Windows domains with trust between.

Error message:

Severity: CRITICAL

Description: Could not login to TM1, host: SERVERNAME, server name: TM1 SERVER NAME, user name: admin

If you hold the mouse over the error message in FAP manager, you see the text:

SystemServerNotFound

Cause:

The windows account that run the IBM Cognos Controller FAP server must be a domain account in the same domain that the Cognos BI server authenticate against. You must be able to surf to http://servername/cognos8 from the server logged in as the service account, and SSO should work.

Solution:

Create a new windows service account in the domain that contains the users

Make that new windows service account local admin on the FAP server

Change the windows account that start the FAP service, to use the new service account.

You may need to enter the account with domain\name in the field for name to the FAP service to make it possible for the FAP service to use the account.

Start FAP service again and test if the FAP publish works now.

In FAP Manager for the connection edit, ensure you enter the client name and domain in same capital letters as used for the namespace id in cognos configuration.  If the namespace ID is AD then you need to enter AD\username in the FAP manager for the TM1 connection.

Product:
IBM Cognos Controller 10.2.1 FAP
C8BISRVR_UPDATE_version=C8BISRVR-AW64-ML-RTM-10.2.5002.78-0
C8BISRVR_UPDATE_name=IBM Cognos Business Intelligence Server Update
CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.2.5003.68-0
CONTRL_UPDATE_name=IBM Cognos Controller Update
Microsoft Windows 2008 R2 Server

Problem:
After update of certificate on TM1 server, the FAP will not work.

Error message:
2016-10-15 13:36:58,382 [schedulerThread] INFO Scheduler – FAP service started
2016-10-15 13:37:31,251 [schedulerThread] ERROR Scheduler – Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerNotFound
at com.ibm.cognos.tm1.API.getServerSecurityMode(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.preLoginCheckIfCAM(TM1Context.java:62)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:454)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:230)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:144)
at java.lang.Thread.run(Thread.java:781)

Solution:
You have the FAP service installed on the Cognos Controller server, and not the TM1 10.2.2 server.
Then there is a TM1 client installed on the Cognos Controller server that also need to have the certifikate updated.

Stop the Cognos services.
Backup the folder D:\Program Files\ibm\cognos\tm1_64\bin64\ssl and D:\Program Files\ibm\cognos\tm1_64\bin\ssl

Download the updated TM1 SSL Certificates from the following location: http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FCognos+TM1&fixids=BA-CTM1-SSL-ZIP-IF001

Extract the downloaded file/archive and extract it to any directory. For the purpose of this document, our files will be extracted in to <tm1_client_install_dir>\tm1_64\NewSSLCerts\

Copy the contents of the folder you extracted earlier <tm1_client_install_dir>\tm1_64\NewSSLCerts\ , and place them inside of the 2 directories listed above in Step 4. During this process, you will be required to REPLACE all conflicting files as we must replace the old certificate files with new ones.

After all files have been copied successfully, navigate to <tm1_client_install_dir>\tm1_64\bin\ssl\

Execute the uninstallSSL.bat file, to uninstall old keys from the Windows Keystore

If uninstallSSL.bat does not exist, run importsslcert.exe -remove from Command Line

Execute the importsslcert.exe file, to install the new keys in to the Windows Keystore
Start the Cognos services.

Start IBM Cognos FAP service.

Login to IBM Cognos Controller Financial Analytics Publisher and do a initial publish by click on START in the Data Marts tab.

If it works, then the certificate it replaced good.

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

Problem:
When starting the FAP service, where we use Cognos BI CAM authentication, we get a error in the logs that say:
“Could not login to TM1, host: , server name: , user name: <namespace\username>”
C8ITKShared (C:\Program Files\IBM\cognos\TM1_64\bin64\ C8ITKShared.dll is not a valid Win32 application.)

Background:
TM1 10.2.2 64 bit server installed to same Windows server as the Controller FAP Service.
The Windows FAP Service are 32 bit and uses 32 bit dll.
The new FAP client is 64 bit and uses the 64 bit dll and database drivers.
Default install of TM1 10.2.2 only install 64 bit dll files for TM1.

Solution:
Install TM1 Architect in 32 bit version to the server.
Add the path to the C8ITKShared.dll to the system path e.g. C:\Program Files (x86)\IBM\cognos\TM1\bin.
Right click on My Computer and select properties
Click on Advance System Settings
Click Environment Variables
Select PATH and click Edit
Update the path and save.
Click OK to exit dialog.
Restart the Server.

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

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