CogKnowHow

Product:
Cognos Controller Web 10.4.2

Issue:
User can not enter the date in a form. See / instead of – for the date format.

Solution:
The date format is controlled by the Windows region settings in your laptop or on your citrix server.
Keep in mind that some date format is in the other order e.g. day-month-year can be month/day/year.

Go to control panel – region, to change the settings to Swedish if you want.

Other information:

https://www.ibm.com/support/pages/node/5736855

Product:
Cognos Controller 10.4.2

Issue:
After change of SQL server to Cognos Controller, ERO reports does not work.

Error message:

Solution:
Ask the DBA to ensure that the SQL login (frango) you are using to the Controller database have the server roles: bulkadmin and public

You check what SQL login you are using in Cognos Controller Configuration.

More information:

https://www.ibm.com/docs/en/cognos-controller

https://www.ibm.com/support/pages/node/795804

https://www.ibm.com/support/pages/node/271267

Product:
Cognos Controller Web 10.4.2

Issue:
When open a period to work with you get this error

Invalid forms
There are invalid forms for Submission 1. Please check the form definition and process the form layouts or contact your administrator

Suggested solution:
Check a other period and company if that works.
Can be that this period contains forms that you do not use, like forms that do not contain any accounts, they will not work in controller web.

More information:

To open a company for submission click on the z icon.

https://www.advectas.com/sv/kunskapsbank/webinar-fa-ut-mer-av-cognos-controller-kom-igang-med-cognos-controller-web/

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