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.

 

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:
Cognos Controller 10.3.x
Microsoft Windows 2012 server

Problem:
After restore of a backup of a database, when you run the upgrade script in DBCONV you get a error message:

Running DB step: 882 ….
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot create more than one clustered index on table ‘xdbtrickle’. Drop the existing clustered index ‘idx_xdbtrickle_vat1’ before creating another

Solution:

Ask the DBA to drop the two index. And then run the upgrade again.

After the DBA have restored a backup of the Cognos Controller database, you need to go to the controller server, and inside Cognos Controller Configuration add the new database (if it not already exist). Fill in the fields as appropriate. Data source is the SQL host (server).

Click on the green arrow to go to the database conversion.

Click on CONNECT and then on UPGRADE.

When done, and no errors, click on CLOSE.

Then you should in Controller Configuration go to Report Server tab and click on the CHECK icon, to update the data sources in Cognos BI.

The sql commands that give issues are:

IF NOT EXISTS (SELECT * FROM sysindexes WHERE id = object_id(‘XDBTRICKLE’) AND name = ‘NC_XDBTRICKLE_SEQUENCNO’)
CREATE CLUSTERED INDEX NC_XDBTRICKLE_SEQUENCNO ON xdbtrickle (sequenceno ASC);

IF NOT EXISTS (SELECT * FROM sysindexes WHERE id = object_id(‘XDBTEXTTRICKLE’) AND name = ‘NC_XDBTEXTTRICKLE_SEQUENCNO’)
CREATE CLUSTERED INDEX NC_XDBTEXTTRICKLE_SEQUENCNO ON xdbtexttrickle (sequenceno ASC);

 

More information:

https://www.ibm.com/support/pages/how-backup-and-restore-db2-databases-use-cognos-controller

https://www.ibm.com/support/pages/how-move-controller-databases-new-database-server-basic-instructions

https://www.ibm.com/support/pages/ibm-cognos-controller-104x-fix-list

https://www.ibm.com/support/pages/cognos-controller-builds-ccr-name-and-database-version

Currently Supported Versions of Controller (incl. Interim Fixes):

Updater Kit Build CCR Version DB Version Comment
10.4.2000.1063 10.4.2000.292 10.4.2 IF7 1010 Generally available (FixCentral)
10.4.2000.1018 10.4.2000.270 10.4.2 IF3 1010
10.4.2000.1013 10.4.2000.267 10.4.2 IF2 1010
10.4.2000.1002 10.4.2000.259 10.4.2 IF1GA 1010 Generally available (FixCentral)
10.4.2000.185 10.4.2000.252 10.4.2 RTM 1010 Available via Passport Adv. (full install)

See more at IBM web site.

Product:
Cognos Controller FAP service 10.4.2
Microsoft Windows 2019 server

Problem:
How do i know if the FAP service stopped working, even do the windows “IBM Cognos FAP Service” is running?

Suggested solution:
Ask the IT department monitor team (splunk) to collect the log file from the FAP service on the TM1 server.
You find the file error.log in folder D:\Program Files\ibm\cognos\ccr_64\Server\FAP

Let there tool scan the file for the keyword ERROR, and if that is found send a e-mail alert to the TM1 people. Next step would be to check the TM1server.log file for more clues. Then they can stop the FAP service and restart it. Also recommended to do a FAP Initial publish at this time.

If the stop have been long, they may need to also do this;

https://www.ibm.com/support/pages/how-perform-fap-reset-sequence-re-synchronise-controller-data-publishing-tm1

There are 3 main components for FAP:

  1. Microsoft SQL Server for the Controller machine
  2. FAP TM1 Server on the TM1 machine
  3. FAP Service Software on the TM1 machine

If any of these machines needs to be rebooted or taken offline for any reason – the order in which the FAP related services is important.  If either TM1 server or database server is shutdown or rebooted – the FAP service on the TM1 server must be restarted.  The order is important – the FAP Service for the Controller server must be started last.

If the ram memory on the TM1 server is to low – you can see this in the error.log file

| ERROR [common.persistence.retry.RetryInterceptor] [pool-2-thread-1], Trial 1 failed for method refreshMdxHierarchy
java.lang.reflect.InvocationTargetException….
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not create stub TI process: refreshMdxHierarchyProcess….

If the network make FAP service loose contact with the SQL server – you can see this in the error.log file

| ERROR [fap.service.schedule.Scheduler] [schedulerThread], Something severe has happened…..

More information:
https://www.ibm.com/support/pages/frequently-asked-questions-about-ibm-cognos-controller-extended-fap

https://www.ibm.com/support/pages/working-cognos-controller-financial-information-financial-analytical-publisher-fap

https://www.ibm.com/support/pages/how-configure-financial-analytics-publish-fap-allow-publishing-controller-data-planning-analytics

Product:
Cognos Controller Web 10.4.2
Microsoft Windows 2019 server

Problem:
User browse to Controller web and get a message

Server is not reachable or still initializing, please refresh the page in a few seconds

Possible Solution:

Depending on the URL you enter in your Internet Explorer you will succeed or not.

This give above error

http://servername:9080/#!/Login

If you enter the FQDN like this it will work

http://servername.domain.com:9080/#!/Login

The error can also be that you are to fast, the controller web will need some time to start up.

More information:

https://www.ibm.com/support/knowledgecenter/SS9S6B_10.4.2/com.ibm.swg.ba.cognos.ctrl_web_ug.doc/c_web_workflow.html

https://www.ibm.com/support/pages/link-planning-analytics-not-configured-when-configure-controller-web-connect-tm1-pa-web-caused-apar-ph19087

Product:

Cognos Controller Web 10.4.2

Microsoft Windows 2019 Server

Problem:
When user browse to Controller Web on URL http://servername.domain.com:9080/ they see a blank page.

Solution:
Inside Internet Options for IE change the value for Compatibility View Settings.

Uncheck both, so this is not used.

Close and then test again.
Controller Web may need in Internet Explorer to Deselect the “Display intranet sites in Compatibility View”.

In some cases the controller web windows server need to be removed from the Internet Options security local intranet zone;

Go in there and remove the servers listed under sites.

More information:

https://support.microsoft.com/en-us/topic/fix-site-display-issues-with-compatibility-view-in-internet-explorer-11-9a0a3a6e-89be-518f-ff56-c491b528b302

https://hawaiianair.custhelp.com/app/answers/detail/a_id/2613/~/internet-explorer-compatibility-view-%28ie9%2C-10%2C-%26-11%29

 

Product:

Cognos Controller Web 10.4.2
Microsoft Windows 2019 server

Problem:
After login to database in Controller Web you get a error.

PRS-NOP-1056

The contents of the node operation “append” could not be parsed.

DetailsExpand

org.dom4j.DocumentException : Error on line 3 of document : Open quote is expected for attribute “name” associated with an element type “param”.

Possible Solution:
The ” is in the wrong format in the file variables_CCRWeb.xml

Start Notepad++ as administrator

Open D:\Program Files\ibm\cognos\analytics\templates\ps\portal\variables_CCRWeb.xml

Change to

<CRNenv c_cmd=”://controllerservername.domain.com:9080/#!/CamLogin”>
<cookies>
<param name=”_passport”/>
</cookies>
</CRNenv>

Save and restart the controller web services.

More information:

https://www.ibm.com/support/pages/how-configure-controller-web-use-cognos-cam-authentication