Product:
Cognos Controller 10.4.2
Cognos Analytics 11.1.7
Microsoft Windows 2019 Server

Issue:
To run a optimization the users need to be out of Cognos Controller – how can i force users off Cognos controller at night?

Suggested Solution:
The Cognos controller code that handles users are inside the IIS application pool, so a restart of the IIS server will force all Cognos controller users out.

Suggestion is to also restart your Cognos Analytics service at the same time. This simple batch script can do it for you, if you run it from a scheduler with desktop access.

REM restart of IIS and then Cognos
REM https://ss64.com/nt/
echo ——– >> d:\temp\restartlog.txt
echo %date% %time% >> d:\temp\restartlog.txt
net stop W3SVC
net start W3SVC

echo Cognos Analytics Restart Begins….. >> d:\temp\restartlog.txt
CALL “d:\Program Files\ibm\cognos\analytics\bin64\cogconfig.bat” -stop
echo Services Stopped >> d:\temp\restartlog.txt
REM rename the cognos server log file for later inspection
rename “d:\Program Files\ibm\cognos\analytics\logs\cognosserver.log” “* %Date:/= % %Time::=.%.txt”

REM wait before start
PING -n 31 127.0.0.1 > nul

CALL “d:\Program Files\ibm\cognos\analytics\bin64\cogconfig.bat” -s

echo %date% %time% >> d:\temp\restartlog.txt
echo Services Started successfully >> d:\temp\restartlog.txt

 

If you have more than one Cognos server, you need to restart the CA11 Content Manager first, then the rest.  Leave at least 15 minutes between the servers restarts.

If users are logged into Cognos Controller Client during restart, they will see this message when they try to do something inside Cognos Controller Client after a restart.
They need to exit there client.

Note: If Cognos Configuration is left open on the Windows server, then this script will not work and Cognos will not start. It is important that you close Cognos Configuration before you exit a Remote Desktop session with the server.

The drawback is that windows event log will have entry like this:

Faulting application name: cogbootstrapservice.exe, version: 11.1.5.2, time stamp: 0x5daf2515
Faulting module name: ntdll.dll, version: 10.0.17763.1728, time stamp: 0x6e7b7e33
Exception code: 0xc0000374
Fault offset: 0x00000000000fa689
Faulting process id: 0x128c

More Information:
https://www.ibm.com/support/pages/how-properly-restart-cognos-analytics-services-windows-scheduler 

https://gist.github.com/gazzdev/6c38f067a62cf04a3c72

https://serverfault.com/questions/355207/what-does-iisreset-do-in-addition-to-recycling-all-application-pools

https://ss64.com/nt/syntax-stampme.html

Product:
Cognos Controller 10.4.2
Windows Server 2012
Problem:
When open Data Entry – Reported Values, the field are in wrong order.

Solution:
The normal look of data entry is like this:

The rows can be moved, by you click on them and drag them to new position in the dialog.

The settings are stored in the ccr.config file for your user in her windows profile.

To reset the values, we suggest that the user close cognos controller client and go to folder

C:\Users\%username%\AppData\Roaming\Cognos\ccr

and erase file ccr.config.

Then start Cognos Controller client and it should be back to normal layout.

Inside the ccr.config file this lines control above dialog:

<Layout>
<add key=”DE_ROW_ACTUALITY” value=”1″ />
<add key=”DE_ROW_PERIOD” value=”2″ />
<add key=”DE_ROW_COMPANY” value=”3″ />
<add key=”DE_ROW_CONSTYPE” value=”4″ />
<add key=”DE_ROW_GROUP” value=”5″ />
<add key=”DE_ROW_CURRTYPE” value=”6″ />
<add key=”DE_ROW_SUBMISSION” value=”12″ />
<add key=”DE_ROW_FORM” value=”7″ />
<add key=”DE_ROW_CLOVER” value=”8″ />
<add key=”DE_ROW_JOURNALTYPE” value=”9″ />
<add key=”DE_ROW_DIM1″ value=”10″ />
<add key=”DE_ROW_DIM2″ value=”11″ />
<add key=”DE_ROW_DIM3″ value=”13″ />
<add key=”DE_ROW_DIM4″ value=”14″ />
</Layout>

 

More information:
https://www.ibm.com/support/pages/how-install-controller-local-client

Product:
BigFix Client
Microsoft Windows 2012

Problem:
How install the Big Fix client/agent on the Windows server?

Solution:
On the ILMT linux server you can search for the client files with find . -name ClientMSI*

Copy the files you need over to your Windows server

Copy BigFixAgent.msi setup, its .mst files and the actionsite.afxm masthead file to a folder of your target computer, for instance C:\install\bigfix. Actionsite.afxm file is in the /var/opt/BESInstallers/Client folder of the Linux server.

Then create a CMD file with following content:

msiexec.exe /i “BigFixAgent.msi” TRANSFORMS=”1033.mst” REBOOT=ReallySuppress MSIRESTARTMANAGERCONTROL=Disable /qn

Start a DOS prompt as administrator and go to the \install\bigfix folder

Run your installagent.cmd file, to install.

If you run the BIGFIXAGENT.MSI it can look like this

You will have a new “BES Client” windows service on your computer after the installation.

You must copy the actionsite.afxm file to the folder C:\Program Files (x86)\BigFix Enterprise\BES Client to make the client start.

Client/Agent can be downloaded from https://support.bigfix.com/bes/release/10.0/patch2/

More information:

https://help.hcltechsw.com/bigfix/9.5/platform/Platform/Installation/c_installing_the_client_with_msi.html

https://help.hcltechsw.com/bigfix/9.5/platform/Platform/Installation/c_using_login_scripts.html

https://cdn2.hubspot.net/hubfs/1697611/Events/Webinar.%20Basic%20ILMT%20Skills%20for%20IT%203.16.17.pdf

https://www.ibm.com/software/passportadvantage/subcaplicensing.html

https://exploringtm1.com/tm1-ilmt/

Product:

Microsoft Powershell

Problem:
You are low on disk space, or the Cognos BI have created some large file (dump files or log files) and you want to know where they are.

Solution:
Enter below text in notepad++ and save as checksize.ps1 in your c:\temp folder

$folder = “C:\Program Files\ibm\cognos”
Get-ChildItem $folder -recurse -ErrorAction SilentlyContinue |Sort-Object length -descending| Select-Object -first 27 @{Name=”MegaBytes”;Expression={“{0:F2}” -f ($_.length/1MB)}} , Fullname | Export-Csv c:\temp\LargeFiles_Report.csv

Start Powershell from Start menu
Go to temp folder with command cd /temp
Enter ./checksize.ps1 to run the script


Open the Largefile_report.csv in notepad++

You need to change the first line to your folder for Cognos products e.g. $folder = “D:\Program Files\ibm\cognos\analytics”

Then you check the list to find the files that you do not need, and can remove them, to get more space.

More Information:
https://www.linkedin.com/pulse/powershell-script-finding-large-size-files-your-windows-milad-mousavi/?articleId=6610936483329257472

http://woshub.com/find-large-files-with-powershell/ 

https://blog.danskingdom.com/find-largest-or-smallest-files-in-a-directory-or-drive-with-powershell/

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 server
Problem:
Can i store the Native SQL query the users send to the database for later troubleshooting?

Solution:
Activate logging of the SQL query to the AUDIT database.
Setup the AUDIT database logging in Cognos Configuration.
https://www.ibm.com/support/pages/how-configure-audit-reporting-cognos-analytics

Browse to Cognos Analytics (ibmcognos) and go to Manage > Administrative Console > Configuration > Dispatchers and Services. Click on the Set Properties – Configuration icon.
Click the Settings tab, choose logging as category.

Go down to Generate comments in native SQL and mark it.
Click OK.
Run some reports to test the system.
Open SQL Developer and go to your AUDIT database and check the

COGIPF_NATIVEQUERY table.

 

 

More Information:

https://www.ibm.com/support/pages/how-see-which-user-generating-query-cognos-analytics

https://www.envisn.com/envisn-cognos-blog/bid/102418/What-s-Wrong-with-IBM-Cognos-Audit-Data

https://www.ibm.com/support/pages/cognos-ipf-audit-table-descriptions

https://cognoshub.blogspot.com/2015/02/cognos-sql-native-sql-and-pass-through.html

https://www.wisdomjobs.com/e-university/ibm-cognos-tutorial-196/auditing-4398.html