CogKnowHow

Product:
Cognos Planning 10.1.1. Fix pack 3 (version 10.1.6303.19-0)
Windows 2008 R2 Server
Oracle database

Symptom:
When you start Cognos Planning Administration Console on a client you get a error message.
When opening the CAC the following error occurs:
“An error has occurred while starting IBM Cognos Planning Administrator.
Main form failed to initialize.
Error Details:
Unable to determine if the Planning Tables exist in Content Manager. Please ensure the Planning Service is running.”

Unexpected: missing HRESULT parameter”

When opening Analyst the following error occurs:
“Analyst failed to communicate with the Content Manager database. This can happen if the Cognos 10 Planning service is not running. Please check that the service is running.”

Error was:

DISP_E_EXCEPTION
Failed HRESULT [0x80020009] Exception occurred.”
Cause:
The gateway url in Cognos Configuration is not the same as the gateway url on the Cognos BI server for authentication.

Solution:
Log on to the Cognos Planning BI server.
Start Cognos Configuration.
Copy the value for Gateway URI under environment section.
Go to the client computer where you have CAC and Cognos Planning Analyst installed.
Start Cognos Configuration
Paste the value for Gateway URI under Gateway settings.
Click on Save
Exit Cognos Configuration
Try to start the IBM Cognos Planning – Contributor Administrator Console.

Can also be other causes;
http://www-01.ibm.com/support/docview.wss?uid=swg21621002

Product:
Cognos Planning 10.1.1
Windows 2008 R2 server
Oracle database

Symptom:
When doing a GTP you get the PREPARE_ACCESS_BLOCKS to say QUEUING all the time. Why ?

Cause:
The Cognos Planning solution is setup with one JOB server and one ADMIN server.
The PREPARE ACCESS BLOCKS step is a change in the Cognos Planning application that is done from the job server. The other steps of a GTP is update of the Cognos Planning store database, that is accessed with the settings defined in Cognos Configuration. So Cognos Planning use different parts to access the databases.

Solution:
For access to oracle database to work you need to have a correct TNSNAMES.ORA file in your \oracle\client\network\admin folder on your Planning servers.

In this case the issue was solved by adding the tnsnames.ora file to the job server, there it was missing, the tnsnames.ora file was on the ADMIN server only, therefor some GTP task worked, that does not need a tnsnames.ora file.

Access defined in Cognos Configuration can be setup for oracle to direct define and access the server.

Product:
Cognos Planning 10.1.1
(PLANSRVR_version=PLANSRVR-AW32-ML-RTM-10.1.6235.51-0)
C8BISRVR-AW32-ML-RTM-10.1.6304.10-0 = IBM Cognos Business Intelligence Server Update, PLANSRVR-AW32-ML-RTM-10.1.6303.19-0 = Planning Server Update
Windows 2008 R2 server
Oracle Database

Symptom:
Error when you try to Start Cognos Planning service.

Error message in Planningerrorlog.csv file:
E6525D43-48B1-4123-8C99-7BFA5DFA2515} 14 2014-04-09 16:57:09.832 UTC +120 epPlanningService 10.1.4074.0 default ThreadSystemConnectionPool.cpp RefreshConnectionPool 260 OraOLEDB -2147467259 Unable to open connection using connection string of Provider=OraOLEDB.Oracle;Data Source=server.DOMAIN.COM;User ID=SERVICEACCOUNT;Password=*********; and timeout of 15 seconds.~~~~ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA DOMAIN\UserAccount DOMAIN\SERVER DOMAIN\UserAccount DOMAIN\SERVER 3408 4968
{E6525D43-48B1-4123-8C99-7BFA5DFA2515} 15 2014-04-09 16:57:09.847 UTC +120 epPlanningService 10.1.4074.0 default ThreadSystemConnectionPool.cpp Run 138 OraOLEDB -2147467259 Unable to open connection using connection string of Provider=OraOLEDB.Oracle;Data Source=server.DOMAIN.COM;User ID=SERVICEACCOUNT;Password=*********; and timeout of 15 seconds.~~~~ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA DOMAIN\UserAccount DOMAIN\SERVER DOMAIN\UserAccount DOMAIN\SERVER 3408 4968

Possible Cause:
This can happen when you restart the Cognos Planning service, from Cognos configuration or direct from windows services.

And the planning store settings inside Cognos configuration for oracle is set to advance and you use this syntax;
databasehostname.domain.COM:1521/oracleserverid.domain.COM

instead of this syntax;
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databaseserver.domain.COM)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oraclename.domain.COM)))

Redo the access syntax in Cognos Configuration and try to start Cognos again.
Both syntax of access to Oracle work for Cognos Content Store, but not for Cognos Planning Store.

Product:
Cognos Planning 10.1.1
(PLANSRVR_version=PLANSRVR-AW32-ML-RTM-10.1.6235.51-0)
C8BISRVR-AW32-ML-RTM-10.1.6304.10-0 = IBM Cognos Business Intelligence Server Update, PLANSRVR-AW32-ML-RTM-10.1.6303.19-0 = Planning Server Update
Windows 2008 R2 server
Oracle Database

Symptom:
Error when you try to Start Cognos Planning service.

Error msg:
02E05353-AF07-4C9D-B859-9CF2760616A4} 17 2014-04-09 17:35:09.522 UTC +120 epPlanningService 10.1.4074.0 default ThreadSystemConnectionPool.cpp ThreadProc 104 OraOLEDB -2147467259 Process exception DOMAIN\SERVICEACCOUNTNAME DOMAIN\SERVERNAME DOMAIN\SERVICEACCOUNTNAME DOMAIN\SERVERNAME 3880 1312
{481087D0-09B5-48E0-A685-A28D2E363A44} 1 2014-04-09 17:39:23.194 UTC +120 epPlanningService 10.1.4074.0 default Poller.cpp ManageErrorLogging 345 epPlanningService::default::Poller.cpp::ManageErrorLogging::345 0 Database Errors: Source: OraOLEDB Description: ORA-00942: table or view does not exist Number: -2147467259 SQLState: NativeError: 942 Source: OraOLEDB Description: ORA-00942: table or view does not exist Number: -2147217865 SQLState: NativeError: 942 DOMAIN\SERVICEACCOUNTNAME DOMAIN\SERVERNAME None\None None\None 3456 368
{B16556CC-68A9-40E0-92BA-4CF7C75D61B6} 1 2014-04-09 17:39:25.034 UTC +120 epPlanningService 10.1.4074.0 default Poller.cpp ManageErrorLogging 345 epPlanningService::default::Poller.cpp::ManageErrorLogging::345 0 Database Errors: Source: OraOLEDB Description: ORA-00942: table or view does not exist Number: -2147467259 SQLState: NativeError: 942 Source: OraOLEDB Description: ORA-00942: table or view does not exist Number: -2147217865 SQLState: NativeError: 942 DOMAIN\SERVICEACCOUNTNAME DOMAIN\SERVERNAME None\None None\None 3456 3872

Possible Cause:
The database is new and you have only installed Cognos planning and started the services.
You have not run the Cognos planning contributor admin console, to create the Cognos planning store with all its tables.

During startup in Cognos Configuration, the Cognos Planning service checks for tables in the planning store database.

Product:
IBM Cognos Planning 10.1.1
Microsoft Windows 2008 R2 server

Problem:
Macro does not run, no error messages, but if you do a GTP manually it works.
You have several Cognos Planning servers, where some are dedicated Cognos Planning Job servers.

Solution:
Ensure that all Cognos Planning servers are added to the Cognos Planning JOB cluster in Cognos Contributor Administration Console (CAC). Not only the dedicated Job servers should be in the cluster, add also the Cognos Planning Admin servers. Set the number of Maximum of Concurrent job to 0 (zero) on the Cognos planning servers.
For Cognos Planning Job servers the number of maximum concurrent jobs should be one less than the number of cpu cores on the Cognos planning server. On a 4 cpu core server the value should be 3.
Start CAC
Login as administrator
Right click on cluster icon for Job Server and select Add Job Server.
From the dropdown list you should see all the Cognos Planning servers you can choose.
(All in list need to be added). But servers that are not JOB servers should have value 0 for maximum concurrent jobs.
Also add all the applications, by click on the ADD button under Monitored objects, on the Job server cluster level in CAC.
After you added all the job servers, you can test to run the macros again.
More Information:
Please note that for Cognos Planning 10.1.1 to work you should install both Cognos BI 10.1.1 and Cognos Planning 10.1.1 to the same folder. Then you do not need to enter a value in the Cognos Configuration for IBM Cognos BI installation location.
This versions will work together (there are other version that will also work)
tl-BISRVR-10.1-6235.144-
tl-PLANSRVR-10.1-6235.51-
tl-UPDATE_BISRVR-10.1-6304.10-
tl-UPDATE_PLANNING-10.1-6303.19-
(Above versions number from folder C:\Program Files (x86)\ibm\cognos\c10\instlog)
On the Cognos Planning Admin server only the QUERY Service enabled? is set to FALSE in the Cognos Configuration under Environment for IBM Cognos Service.
On the Cognos Planning Job servers only the Dispatcher Service enabled? and Planning Job Service enabled? is set to TRUE in the Cognos Configuration under Environment for IBM Cognos Service. The rest is set to FALSE.
There are other possibilities of configuration that will work for Cognos Planning.
http://www-01.ibm.com/support/docview.wss?uid=swg21507327
http://www-01.ibm.com/support/docview.wss?uid=swg21597536

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.

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

Product:
IBM Cognos Planning 10.1.1
Windows 2008 R2 terminal Server (citrix)

Symptom:
When user open node in Cognos Planning Contributor client it crash the 5 or 10 time he tries to open a node. The client works fine on a Microsoft Windows 7 workstation.

Error message:
Contributor has stopped working
A problem caused the program to stop working
correctly. Please close the program
-> Close the program.

Error message found in Microsoft Windows event log on Citrix server:

Faulting application name: contributor.exe, version: 10.1.4029.0, time stamp: 0x52a844e3
Faulting module name: WS2_32.dll, version: 6.1.7601.17514, time stamp: 0x4ce7ba68
Exception code: 0xc0000005
Fault offset: 0x000013c0
Faulting process id: 0x2b98
Faulting application start time: 0x01cfc6b721482f24
Faulting application path: C:\Program Files (x86)\ibm\cognos\c10plan\crcp\CognosRCP\rcp\applications\contributor_10.1\bins\bin_10.1.4308.0\contributor.exe
Faulting module path: C:\Windows\syswow64\WS2_32.dll
Report Id: 5fc3d1fc-32aa-11e4-aab7-fc15b4166e04

Solution:
Right-Click on My Computer and select properties.

Click on “Advanced system settings”
On the Advanced tab- click on Settings button for Performance.
Click on “Data Execution Prevention” tab
Select “Turn on DEP for essential Windows programs and services only”
Click OK
Restart the Windows server.

http://pic.dhe.ibm.com/infocenter/op/v6r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.Upgrade_Guide.6.2.0.doc%2Ft_shi_enabling_dep_windows.html

Product:
Cognos Planning 10.1.1
(PLANSRVR_version=PLANSRVR-AW32-ML-RTM-10.1.6235.51-0)
C8BISRVR-AW32-ML-RTM-10.1.6304.10-0 = IBM Cognos Business Intelligence Server Update, PLANSRVR-AW32-ML-RTM-10.1.6303.19-0 = Planning Server Update
Windows 2008 R2 server
Oracle Database

Symptom:
Error when you try to Start Cognos Planning service.

Error msg:
Start Service]
16:37:53, ‘LogService’, ‘StartService’, ‘SUCCESS’.
16:37:53, ‘LogService’, ‘StartService’, ‘Success’.
16:37:54, CAF input validation enabled.
16:37:54, CAF Third Party XSS checking disabled.
16:37:59, ‘AuditDatabaseConnection’, ‘Execute’, ‘Success’.
16:37:57, CM-SYS-2215 A Content Manager internal PRECACHEINITACTIONS task started.
16:37:59, ‘relationalMetadataService’, ‘StartService’, ‘Success’.
16:37:59, CM-SYS-5159 Content Manager is running in active mode.
16:37:59, ‘ContentManagerService’, ‘StartService’, ‘Success’.
16:37:58, CM-SYS-2215 A Content Manager internal CMUPGRADESCRIPT task started.
16:37:58, CM-SYS-2216 A Content Manager internal POSTINITACTIONS task is complete.
16:37:58, CM-SYS-2215 A Content Manager internal POSTINITACTIONS task started.
16:37:57, CM-SYS-2216 A Content Manager internal PRECACHEINITACTIONS task is complete.
16:37:59, DPR-DPR-1002 Successfully registered the dispatcher http://servername.domain.com:9300/p2pd in Content Manager.
16:38:31, ‘camAsyncService’, ‘StartService’, ‘Success’.
16:38:31, Start a CAM_LPSvr because the active process count 0 is less than the limit 1.
16:38:31, ‘com.cognos.pogo.services.DefaultHandlerService’, ‘pogo’, ‘Failure’.
DPR-DPR-1035 Dispatcher detected an error.
java.io.FileNotFoundException: D:\data\cognos\data\ehcache\output.data (Access is denied.)
16:38:39, ‘planningRuntimeService’, ‘StartService’, ‘Success’.
16:38:39, ‘SystemService’, ‘StartService’, ‘Success’.
16:38:39, ‘buxService’, ‘StartService’, ‘Success’.
16:38:39, ‘Fragment Server Service’, ‘StartService’, ‘Success’.
16:38:39, ‘BatchReportService’, ‘StartService’, ‘Success’.
16:38:39, ‘com.cognos.pogo.services.DefaultHandlerService’, ‘pogo’, ‘Failure’.
DPR-DPR-1035 Dispatcher detected an error.
D:\data\cognos\temp\plugin-workspace\.config\config.ini (Access is denied.)
16:38:39, ‘planningAdministrationConsoleService’, ‘StartService’, ‘Success’.

[Start Service]
[ ERROR ] CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.

Possible Cause:
This can happen when you restart the Cognos Planning service, from Cognos configuration or direct from windows services.

Cognos BI service (content manager) was not started.
In a multi server environment – you must start the Cognos BI Content Manager first, before you start any other Cognos servers, like Cognos Planning Job servers.