Product:
Cognos Controller 10.1.1 CCR-AW32-ML-RTM-10.1.6235.57-0
FAP 1.0.13.0 CCRFAPCLIENT-AW32-ML-RTM-10.1.6235.57-0
Microsoft Windows 2008 R2 server
Symptom:
When install FAP manager on citrix server, the values are empty when the user starts the program.
Cause:
Default values for IBM Cognos Controller Financial Analytics Publisher are stored in a user.config file for each user in folder C:\Users\Administrator\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0 on the server.
Solution:
Create a batch file, that look something like this:
===================================
@echo off mkdir %userprofile%\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0 copy user.config %userprofile%\AppData\Local\IBM_Corp\FAPClient.exe_Url_hizg5pd121eg2yxnq50fgzjzluvgy4wb\1.0.13.0\user.config
cmd.exe /C start “FAP Manager” “C:\Program Files (x86)\ibm\cognos\c10\webcontent\ccr\FAPClient.exe”
=============================================
Copy a working user.config file and place it in same folder as above batch file.
Add the batch file to the publish FAP manager icon, to be run before the start of the application.
Now the file is in place before the FAP manager starts, and the default values are there.
Then the user only need to type in the SQL login password to the FAP database to work.
The user.config should look like this:
<?xml version=”1.0″ encoding=”utf-8″?>
<configuration>
<userSettings>
<FAPClient.My.MySettings>
<setting name=”DatabaseType” serializeAs=”String”>
<value>MSSqlServer2008</value>
</setting>
<setting name=”Server” serializeAs=”String”>
<value>localhost</value>
</setting>
<setting name=”Database” serializeAs=”String”>
<value>adam</value>
</setting>
<setting name=”User” serializeAs=”String”>
<value>bertil</value>
</setting>
</FAPClient.My.MySettings>
</userSettings>
</configuration>
…………………………………………………………………………….
localhost should be replace with the SQL server name
adam should be replaced with the FAP controller database name
bertil should be replaced with the SQL server login username
A easier way is to update the FAPClient.exe.config file in folder c:\program files (x86)\ibm\cognos\c10\webcontent\ccr folder.
This will affect all users that login to the Citrix server.