by ·0 Comments

Product:
Cognos Controller FAP version 8.5.1
Microsoft Windows 2008 server

Symptom:
When doing a IP (initial publish) for datamart in FAP get error “Could not login to TM1, host …. Server name: …. User name: …

If you have the mouse pointer over the error message a screen tip will say
SystemServerConnectionFailed

Cause:
FAP service can not connect to the TM1 server on port 5495 and 12345 (or what port you have setup for TM1 server)

Port number is defined in the tm1s.cfg file at line PortNumber=12366

Possible Solution:
Open the needed ports in the Windows Firewall on the TM1 server.

by ·0 Comments

Product:
Cognos Planning version 8.4.1

Symptom:
The handles are not expandable inside the Cognos Planning Contributor client.

Cause:
Rich Client Contributor front-end have the expand/collapse (plus/minus) handles for hierarchies.

This is controlled by this Hierarchical Dimensions in Analyst

For a dimension to be shown as a hierarchy in Analyst, the following requirements need to be met:
• The dimension must not be a time dimension.
• The dimension’s items must all be detail or simple sums.
• Do not use weighted or time averages.
• Do not use the Force to Zero calculation option.
• Priorities can only be 0 or 10.
• Do not use any formatting.

Solution:
Recreate your Cognos Planning application to only use above allowed values / properties.

by ·0 Comments

Product:
TM1web version 9.5.1
Windows 2003 or 2008 x64 version

Symptom:
User attempts to export to PDF from TM1Web and receives an error.

Message:
Export in process, Please wait…
‘PDFcamp Printer’ was not installed properly

Cause:
PDF camp Printer was not installed properly – it needs to be default printer for that windows account that runs the TM1 Excel Service.

Solution:
Make sure that the PDFcamp Printer is set as default and then restart the TM1ExcelService, even if the printer was set as default.
If this does not resolve it, uninstall PDFCamp by using the 64-bit uninstaller executable at \bin\PDFcamp\unpdfxp64.exe
Then reinstall the PDFcamp Printer using the installer executable at \bin\PDFcamp\setupx64.exe.
Set the PDFcamp Printer as default and restart the TM1ExcelService again.

by ·0 Comments

Product:
Cognos BI 10.1.1
Windows 2008 R2

Symptom:
Error message when you import a report into Microsoft Excel.

Problem:
M:OperationFailed :PRS-REQ-0760 The operation “/” “” “xts.run is invalid

Solution:
Ensure that allowPathInfo=”true” as set in the IIS web.config file for cognos.cgi or cognosisapi.dll in you \cgi-bin\ folder on the Cognos BI gateway server.

The allowPathInfo=”true” parameter will allow the IBM Cognos for Microsoft Office to work.

Note:
If you get the error COC-ERR-2005 then you have missed the ” ” around true in allowPathInfo=”true”.

by ·0 Comments

Product:
TM1 9.5.1 Contributor

Symptom:
Can not log into TM1 Contributor

Problem:
When logging into TM1 Contributor with integrated CAM authentication, after putting in your credentials you receive the following error: PRS-PRH-0221 The Portal/variables_plan.xml could not be opened.

Cause:
Two main reasons can be the source of this error:
1- The appropriate files have not been moved to the proper directory.
2- In a distributed environment, the files from the CAdmin folder in the TM1 installation directory are on the wrong server.

Resolving the problem
In a distributed Cognos environment where the Gateway and Application servers are on different machines:

1- Ensure that the pmpsvc.war file is on the C8\webapps folder on the Application servers.

2- Ensure that the planning.html, variables_plan.xml, and the icon_active_application.gif are in the C8\webcontent, C8\templates\ps\portal and C8\webcontent\ps\portal\images respectively on the Gateway server.

These files can be found under the TM1 install directory in the \Cadmin and \Cadmin\gateway folders.

NOTE:
If the gateway and dispatcher are on different servers, copy the variables_plan.xml to the dispatcher server.

3- Also, it is occasionally required that the CAMPortalVariableFile parameter in the tm1s.cfg file be changed from:
CAMPortalVariableFile=templates\ps\portal\variables_TM1.xml
to:
CAMPortalVariableFile=portal\variables_TM1.xml

Restart the TM1 server to activate the change in parameters.

by ·0 Comments

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.

by ·0 Comments

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.

by ·0 Comments

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.

by ·0 Comments

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 );

by ·0 Comments

Product:
Cognos Controller 8.5.1
Windows 2008 R2

Symptom:
FAP service is started but the FAP service manager give error that the FAP service is not started.
You have rebooted the server, but it has not helped.
There are no error log files in the C:\Program Files (x86)\Cognos\c8\Server\FAP folder.

Error Message:
It seems that no FAPService is running or FABdb is started/restarted after FAPService.
Start/restart FAPService to make FAP work correctly.

Cause:
Can be that the CCR_JAVA_HOME is pointing to a 64 bit jre instead of a 32 bit jre.
Ensure that the CCR_JAVA_HOME is pointing to a JRE folder.

You get a FAPFatalError.log like below when the FAP service is setup to point to a different database than the one you enter when you login in to the FAP Connect

Thu Oct 27 10:12:34 CEST 2011 – Fatal error when starting or running FAPService. Connection exceptionCould not connect to: jdbc:JSQLConnect://sslwin/database=controllerfap

Possible Solution:
Unpack jre.zip from the Controller folder C:\Program Files (x86)\cognos\c8\webcontent\ccr
to a folder on the FAP server named C:\Program Files (x86)\Cognos\java60\jre
Go to System and click on Advance system settings
Select Advance tab
Click on Environment Variables
Click on New system variables
Enter name: CCR_JAVA_HOME
Enter value: C:\Program Files (x86)\Cognos\java60\jre
Click OK
Click OK
Restart the FAP service.

The other issue is solve as below:

Open the FAPService.properties file in notepad and ensure that there is right database server name and database enter into the file. Save the file after changes and restart the FAP service.

Below an example.

IBM SOURCE CODE HEADER START
# =====================================================================
# OCO Source Materials
#
# BI and PM: ccr
#
# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved
#
# The source code for this program is not published or
# otherwise divested of its trade secrets, irrespective of
# what has been deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END
db=controllerfap
host=servername
dbType=sqlserver
user=cognos
passwd=cognos
#clientcamuri=http:///cognos8/cgi-bin/cognos.cgi