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.

Product:
IBM Cognos Planning 10.1.1
Windows 2008 R2 terminal server
Oracle database

Symptom:
When user starts Planning Analyst on the Terminal Server, it crash with a error message before login.

Error message:
epAnalystOopHost has stopped working
A problem caused the program to stop working
correctly, Please close the program.

or

Analyst failed to communicate with the Content Manager database.
This can happen if the IBM Cognos 10 Planning services is not running.
please check that this service is running.

Error was:
Unable to retrieve user information for the user that has logged on.

Background:
Cognos Planning 10.1.1 is integrated with Cognos BI 10.1.1 for CAM security.
Oracle database is used for BI content store and planning store.
It looks like the issue goes away if the Analyst user is also part of the system administrator group in Cognos BI, and not only Planning Rights Administrators.

Solution:
Change the specifications on how you connect to the oracle database to be long advance format instead of short format inside Cognos Configuration on the Cognos BI/Planning server.

Go from (host:port/database_sid) to

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host-servername.domain.com)(PORT=1521))(CONNECT_DATA= (SERVER=DEDICATED)(SERVICE_NAME=instancename.domain.com)))

Save and restart the Cognos BI service.
Cognos Planning does not connect to the oracle database in the same way as Cognos BI therefore you must use other methods to connect to the database.

Product:
Cognos Planning 10.1.1
Windows 2008 R2 Server

Symptom:
New installed Cognos Planning Job server the Data Movement part is missing in Cognos Configuration.

Problem:
After installation only Cognos Planning Server ( from file pln_srv_10.1.1_win_ml.tar) on a new Windows server that is to be used as a planning job server, inside IBM Cognos configuration program under Environment – IBM Cognos service
there is only these components properties to set to true or false:

Dispatcher service enabled?
Planning administration console service enabled?
Planning data service enabled?
Planning job service enabled?
Planning Web service enabled?

Solution:
Install also Cognos Planning Admin tools (like analyst from file pln_adm_10.1.1_win_ml.tar) on the same folder.

Then when you start IBM Cognos Configuration you have “Data movement service enabled?”
under IBM Cognos services – Component Properties.

Recommend to only have these three components on a dedicated Cognos planning job server active:

-Data movement service
-dispatcher service
-planning job service

In case you will be using admin links to import data from Cognos framework manager packages, then you also need to install the Cognos BI files on the Cognos Planning job server. Then you also need to have more Cognos services enabled on the Planning job server.

Product:
Cognos Planning 10.1.1 32 bit
Windows 2008 R2 server 64 bit
Microsoft SQL 2008 R2 64 bit

Symptom:
Error when starting cognos analyst after new install of Cognos Planning 10.1.1
There are different errors in the applications.

If cognos planning service is run as local system then the planningerrorlog.csv file is found under \windows\temp, but if the plannig service is run as a service account, then the planningerrorlog.csv file is found under C:\Users\service_account\AppData\Local\Temp folder.

Error message:
Database Errors: Source: Microsoft SQL Server Native Client 10.0 Description: Invalid object name ‘cognos_planningstore..P_PAD’. Number: -2147217865 SQLState: 42S02 NativeError: 208
found in ..\windows\temp\planningerrorlog.csv file

Planning – Analyst:
There was a problem login on. Please ensure you can access IBM Cognos Connection using Gateway URI specified in IBM Cognos Configuration.

Planning – Contributor Administration:

An error has occurred while starting IBM Cognos Planning – Administrator.
Main form failed to initialize.
Error Details:
ActiveX component can’t create object.

Solution:
Install Cognos Planning 10.1.1 Fix Pack 2 from IBM
http://www-01.ibm.com/support/docview.wss?uid=swg24033577

Log on to Windows 2008 server as administrator
Start Internet Information Service (IIS) Manager from Administrative Tools
Expand Application Pools
Create a new application pool called COGNOS
Click on Advanced Settings for application pool COGNOS
Set “enable 32-bit applications” to true
Set “process model identity” to ApplicationPoolIdentity
(if it does not work try next time with LocalSystem)
Set “Idle time-out (minutes)” to 60

If the cognos plannig program is installed to non default folder , like d:\, then you need to check and ensure that the IIS and Cognos service account have access to that folder.

Go to Windows Explorer to see the file system.
Right click on cognos folder and select properties.
Select security tab.
Add local group IIS_IUSRS and give it read and execute rights.
Click OK and close the dialog.

Right click on inetpub folder and select properties.
Select security tab.
Add local group IIS_IUSRS and give it read and execute rights.
Click OK and close the dialog.

Right click on your Computer icon and select Manage
Expand Configuration and local users and groups
Click on group IIS_IUSRS
Click add
Add the service account that will run the cognos services

Click on group administrators
Add the service account used for cognos services.

Ensure that you have the cognos planning servern name is part of local intranet zone in Internet Explorer on the server.

Then restart the iis with iisreset command in cmd.
And test again.

If that does not help also check below:

Ensure that you have installed the following roles on the Microsoft 2008 server before you install Cognos Planning:
+Application Server
+File Server
+Web Server (IIS)

Add “COM+Network Access” under select Role Services is not needed, cognos planning 10.1.l does not create a COM+ object anymore.

Also ensure that you have Data Execution Prevention off on the Windows 2008 Server.
Cognos planning requires that the option “Turn on DEP for essential windows programs and services only” is selected
And that any anti-virus software is turned off during installation.

Reinstall cognos planning 10.1.1