Product:
Cognos Controller 8.5.1

Symptom:
Error message when running Optimize of database inside Cognos Controller Client.

Message:
Error occurred at removal of temporary VFP files. VFP DLL file missing.

Cause:
The password for the service account that runs Cognos Controller COM+ was changed.

But only the IBMCOGNOSCONTROLLER part was updated from the Cognos Controller Configuration program.
The separate IBMCOGNOSVFP part is not updated automatic.

Solution:
Login to the Cognos Controller Server
Go to Control panel – Administrative Tools – Component services
Expand the COM+ applications until you see two entry’s that begin with IBMCOGNOS….
Right Click on the IBMCOGNOSVFP and select properties
Select the Identity tab
Change the username and password to the correct one at “This user”.
Click OK
Restart the COM plus service.
Restart the COGNOS CONTROLLER BATCH SERVICE.
Try again to run optimize of the database.

Above is not on all Cognos Controller installations. Common is that you have only one IBMCOGNOSCONTROLLER com application.

Product:
Cognos Controller 8.5.1
Windows 2008 R2 Server

Symptom:
Change to Cognos 8 authentication in Cognos 8 Controller configuration, from Native authentication does not change it for the users.

Problem:
Controller users still get login dialog to enter username and password

Solution:
On the Windows 2008 server you must start Controller Configuration program by right click and select RUN AS ADMINISTRATOR to allow the changes to be saved.

You do not get a error, but the switch to Cognos 8 is not registered by Windows. Most changes are in newer Windows version not stored correct if you not run the Configuration program as a administrator.

Start Controller Configuration program with Run as Administrator, and change selected authentications method to Cognos 8
Click save.

Let the user try again.

Product:
Cognos Controller 10.1
Microsoft Windows 2008 R2

Symptom:
When you click on Report Server inside Cognos 8 Controller Configuration you get a Security alert message. Before you had installed SSL certificate and changed the Cognos Configuration to use HTTPS for Cognos Gateway and changed the Controller Configuration for Report Server and Client Distribution Server Configuration.

Error Message:
Revocation information for the security certificate for this site is not available. Do you want to proceed?
Yes – No – View

Cause:
Controller Configuration program ( e.g. IE ) can not access the certificate authority to valid the certificate. Can be because it is a private created certificate from a private CA.

Solution:
On the server ( and on clients ) go into Internet Explorer
Select Tools menu
Select Internet Options
Select Advance tab
remove check mark for “Check for server certificate revocation”
click ok
close internet explorer

Start Cognos Controller Configuration program again, and the message is gone.

Product:
Cognos TM1 10.2.2
Microsoft Windows 2012 R2 server

Symptom:
The TI function SCAN does not find a match of data in a variable in the TI process.
After checking with ASCIIOUTPUT found that the word is with small letters and we search for capital letters.

Cause:
The TM1 function SCAN is case sensitive.
Other functions that are case sensitive or space sensitive are;
TIMST are case sensitive. TIMST(366.0000, ‘\M \D, \Y’) returns ‘JAN 1, 1961’.
LONG and SUBST and Filter by Wildcard in subset editor is space sensitive.

Solution:
Add UPPER to your question.

Change from
nLOB = SCAN (‘_LoB’ , vITEM);
to
nLOB = SCAN (‘_LOB’, UPPER (vITEM));

More information:
From http://www.tm1forum.com/viewtopic.php?t=1683

Here are examples:
# Will return 4
l1 = Scan ( ‘def’, ‘abcdef’);

# Will return 0
l2 = Scan ( ‘def’, ‘ABCDEF’);

#Will return 0
l3 = Scan (‘def’, ‘a    b    c    d    e    f’);

# Will return Match
If ( ‘def’ @= ‘DEF’);
s1 = ‘Match’;
Else;
s1 = ‘No Match’;
EndIf;

# Will return Match
If ( ‘def’ @= ‘d e f ‘);
s2 = ‘Match’;
Else;
s2 = ‘No Match’;
EndIf;

#Proof
AsciiOutput (‘F:\Temp\Outputs.txt’, NumberToString (l1), NumberToString (l2), NumberToString (l3), s1, s2 );