Home
Follow us on Twitter


Countries

48.2%United States United States
7.2%India India
7%United Kingdom United Kingdom
5.5%Canada Canada
5.4%Australia Australia

Visitors

Today: 163
Yesterday: 116
This Week: 279
Last Week: 1210
This Month: 163
Last Month: 5655
Total: 799605


"Data movement service enabled" in the list of services for the Cognos server PDF Print E-mail
(2 votes, average 5.00 out of 5)
Written by Roger   
Wednesday, 25 March 2015 21:10

 


Product:
Cognos Planning 10.1.1 fix pack 3
Windows 2008 R2 Server

Symptom:
After installation of Cognos program, there is not a "Data movement service enabled" in the list of services for the Cognos server.

Recommendation from Cognos Support is to on all Cognos Planning Job servers have this 3 services enabled;
-Data movement service
-Dispatcher service
-Planning job service

Solution:
You must install Cognos Planning Analyst and the other Admin tools on the Cognos Planning server, to get this value inside Cognos Configuration.

So the Client tools, like CAC and Analyst, must be installed on the Cognos Planning servers.
Media to use are:
pln_svr_10.1.1_win_ml  (ver 10.1-6235.51)
pln_adm_10.1.1_win_ml (ver 10.1-6235.51)
up_planning_win32_10.1.6303.19_ml


More Information:
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ds_inst.10.2.1.doc/
t_ds_inst_enableordisabledatamanagernetworkservices.html%23ds_inst_
EnableorDisableDataManagerNetworkServices

www.cogknowhow.com
 
Multiserver setup, no login from TM1 Architect server PDF Print E-mail
Written by Roger   
Wednesday, 25 March 2015 20:54
Product:
Cognos Controller FAP 10.1.1
Windows 2008 R2 Server
Cognos TM1 10.2.2
Oracle database

Issue:
In a multi server setup, when you try to connect to the TM1 server from a terminal server where Cognos TM1 Architect is installed, you get the list of TM1 servers, but when you click on ONE TM1 server ( for example the one called FAP ) then there is no login. Only a not responding message for some time, and then you are back inside TM1 Architect.
If you use TM1 Architect on the same server as where TM1 is installed, then it works fine.

Possible Solution:
There are two networks cards in the TM1 server machine. One network card for access by clients, and the other network card for the company backup routines.
TM1 server will bind and only use the first network card found on the Microsoft Windows 2008 server. And if that is not the card used by clients, you will get this issue.
Go to Control Panel
Go to Network and Sharing Center
Click Change adapter settings
Press the ALT key to get menus on top in the dialog
Select Advance – advance settings from the menu
In adaptor and bindings dialog for connections you see two networks listed
Mark the one that belongs to the client network ( it may start with ip 10 ) and click on the up arrow icon on the right.
Click OK
Close the dialog.
Restart the TM1 services, and test again from TM1 Architect on the Terminal server or client computer.

www.cogknowhow.com

 
When starting FAP service, Could not login to TM1 PDF Print E-mail
Written by Roger   
Wednesday, 25 March 2015 20:49

Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2 Server

Problem:
When starting the FAP service, where we use Cognos BI CAM authentication, we get a error in the logs that say:
"Could not login to TM1, host: <servername>, server name: <FAP Service>, user name: <namespace\username>"
C8ITKShared (C:\Program Files\IBM\cognos\TM1_64\bin64\ C8ITKShared.dll is not a valid Win32 application.)

Background:
TM1 10.2.2 64 bit server installed to same Windows server as the Controller FAP Service.
The Windows FAP Service are 32 bit and uses 32 bit dll.
The new FAP client is 64 bit and uses the 64 bit dll and database drivers.
Default install of TM1 10.2.2 only install 64 bit dll files for TM1.

Solution:
Install TM1 Architect in 32 bit version to the server.
Add the path to the C8ITKShared.dll to the system path e.g. C:\Program Files (x86)\IBM\cognos\TM1\bin.
Right click on My Computer and select properties
Click on Advance System Settings
Click Environment Variables
Select PATH and click Edit
Update the path and save.
Click OK to exit dialog.
Restart the Server.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21450399

www.cogknowhow.com

 
Cognos planning login issue HTTP Error 401.1 - Unauthorized PDF Print E-mail
Written by Roger   
Saturday, 14 March 2015 15:37

Product:

Cognos Planning 10.1.1 fix pack 3
Windows 2008 R2 Server
Oracle Database

Symptom:
User get login dialog from Windows when they start Cognos Planning Analyst, or try to surf to the Cognos Connection page for Cognos Planning installation.
When they enter name and password, they are prompted with the same login dialog as before.

If you change the Internet Option - Advance - Enable Integrated Windows Authentication from checked (active) to blank (not used) and restart IE, then it works to come into the Cognos BI portal. Then it is not Cognos BI that is wrong, it is something with Windows IIS.

Error message if you press cancel:
server Error in Application "COGNOS/IBMPLAN/CGI-BIN"
HTTP Error 401.1 - Unauthorized
You do not have permission to view this directory or page using the credentials that you supplied.
WindowsAuthentication
AuthenticateRequest
....

In Cogplanningerrorlog.csv file you can find entries like this that tell you that the Cognos Planning server have been rebooted.
2014-12-16 02:06:12.851 UTC +60 epPlanningService 10.1.4074.0 default Poller.cpp PollUntilCredentialPathIsValid 579 epPlanningService::default::Poller.cpp::PollUntilCredentialPathIsValid::579 0 Credential Path in Content Manager is invalid. Jobs and Macros will not run until it is reset. Please open the Contributor Admin Console and reset the Credential Path.


Solution:
In a multiserver installation, where the Cognos Planning Gateway is located on a separate server from the Cognos Planning Content Manager and the Cognos Planning Job Servers, the restart of the Cognos Planning Gateway server was the solution.

The Cognos Planning Gateway (that run under IIS) was not working with authentication as it should, even do it looks like in IIS Manager that the integrated authentication is turned on for the correct folders.
During the night the Windows servers was restarted to apply a software update, but something have gone wrong on the IIS server, and therefore making the Cognos gateway not allow you to login.

Restart of the Cognos BI and Planning services, did not help, you had restart the physical Cognos Planning gateway server. Then probably the Windows update made it self correct and the SSO login is working.

www.cogknowhow.com

 

 

 
On CAC monitoring tab, runtime error 13, type mismatch PDF Print E-mail
Written by Roger   

 

Product:
IBM Cognos Planning 10.1.1 Fix Pack 3
Microsoft Windows 2008 R2 server
Oracle Database

Symptom:
When user in CAC (Cognos Planning Administration Console) click on Monitoring Console tab to Monitor a Deployment they get a error message. When they click OK on error message the CAC is closed down.


Error message:
'Runtime Error 13'
'Type Mismatch'


Solution:
Stop the Cognos BI and Cognos Planning services in Windows on all Planning servers.
Log into the Planning Store database with SQL developer ( or TOAD ).
Ensure you have a backup of the oracle database.
Run this commands to truncate the two tables:

truncate table p_pnrequestprogress;
truncate table p_pnrequest;

Start Cognos Configuration for the server that contain Content Manager first.
Start the Cognos services here first - both BI and Cognos Planning.
After they are up, then go to next server - the Cognos Planning Job server.
Start Cognos Configuration for the Planning Job server and start that as second.
When all the Planning services are up, go into CAC and test again.

The start order of the Cognos BI and Planning servers are important.

http://www-01.ibm.com/support/docview.wss?uid=swg21694467

 

www.cogknowhow.com

 

 

 
«StartPrev123456NextEnd»

 

CogKnowHow Newsletter

Newsletter
Please register to the site before you can sign for a list.
No account yet? Register
Banner

Polls

Do you use an additional administration tool for Cognos?