Product:
Cognos Controller 11
Microsoft Windows 2022 server
Issue:
Error when you try to setup the Cognos Controller web, by running bat command to add the databases.
D:\Program Files\ibm\cognos\ccr_64\fcmweb>SyncDBConf.bat ..\data wlp\user\shared\config\datasources
Found 6 udl files in ..\data
FATAL ERROR: ‘java.io.FileNotFoundException: D:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\user\shared\config\datasources\datasources.xml (The system cannot find the path specified.)’
:D:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\user\shared\config\datasources\datasources.xml (The system cannot find the path specified.)
Datasources updated.
Solution:
Try to Find the config.js file in C:\Program Files\IBM\cognos\ccr_64\frontend folder
Open the file in a text editor and make the following changes:
/* IBM SOURCE CODE HEADER START
* =====================================================================
* IBM Confidential
*
* IBM Cognos Products: ccr
*
* © Copyright IBM Corp. 2023
*
* The source code for this program is not published or otherwise
* divested of its trade secrets, irrespective of that has been
* deposited with the U.S. Copyright Office.
* =====================================================================
* IBM SOURCE CODE HEADER END */
var fs = require('fs');
module.exports =
{
"proxies": [{
"urlPath": "fcm.web", //root context for Controller Web backend
"enabled": true, //forward requests through UI service
"options": {
"ws": true,
// details for Controller web backend connection
"target": {
"host": "controllerservername.domain.com",
"port": 3000,
"protocol": "http:" //set https: for SSL
},
"secure": true //set this to false if Controller Web Backend is using Self Signed certificates
}
},
{
"urlPath": "ibmcognos", //root context for Controller Server Backend
"enabled": true, //forward requests through UI service
"options": {
"ws": true,
//details for Controller Server connection
"target": {
"host": "controllerservername.domain.com",
"port": 80,
"protocol": "http:" //set https: for SSL
},
"secure": true //set this to false if Controller Server Backend is using Self Signed certificates
}
}],
//Details for Controller UI service
"expressJs": {
"host": "controllerservername.domain.com", //interface used by Controller Web UI Service
"port": "9080", //port used by Controller Web UI Service
"adminContext": "admin",
"enableAdminApp": true,
"enableRemoteExcel": false,
"enableClient": false,
"enableFap": true,
"enableFileSettings": true,
"enableIBMIDAuth": false,
"enableEncryption": false,
"allowedOrigin": '{allowedOrigin}',
"oidcProvider": 'IBMid', //IBMid or google or azure
"options": {
//Add ssl object with path to certificates file below for using HTTPS
//Note: the protocol in proxies section must also be set to HTTPS
/*
"ssl": {
// certificates
"key": fs.readFileSync(__dirname+"/keyfile.key"), //__dirname points to ccr_64\frontend
"cert": fs.readFileSync(__dirname+"/cert.crt"),
"passphrase":"changeit"
}
*/
},
//false to enable "real time updates" feature for all the users
//true to disable "real time updates" feature for all the users
"disableRealTimeUpdates": false
},
ibmIDConfig: {
"discoveryEndpoint": "{discoveryEndpoint}",
"client_id": "{client_id}",
"client_secret": "{client_secret}",
"redirect_uris": ["{basePath}/auth/sso/callback"]
},
"entryPoints":
{
"paLink": "http://tm1servername.domain.com:9510/tm1web"
},
}
Reboot the Microsoft Windows Server, and then try to run the SyncDBConf.bat command again.
More Information:
https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=only-configuring-controller-web