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