Product:Cognos Controller 10.1.1 CCR-AW32-ML-RTM-10.1.6235.57-0FAP 1.0.13.0 CCRFAPCLIENT-AW32-ML-RTM-10.1.6235.57-0Microsoft 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>........................................................................................NOTE:localhost should be replace with the SQL server nameadam should be replaced with the FAP controller database namebertil should be replaced with the SQL server login username
www.cogknowhow.com