CogKnowHow

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

Product:
Cognos Planning 10.1.1
Windows 2008 R2 server
Microsoft SQL 2008 R2

Symptom:
Error when starting cognos service after new install of Cognos Planning 10.1.1
No errors in windows event log or cogserver.log file are created.

Error message:
CLASS NOT REGISTERED

Solution:

Register CFGAPICOM.dll from the /bin directory of Cognos 10 :
– In Windows Explorer, go to c:\windows\system32,
– Right-click “cmd.exe” and select “Run as Administrator”
– Go to folder ..\program files (x86)\ibm\cognos\c10\bin\
– Run the DOS command:
regsvr32.exe CFGAPICOM.dll

If that does not help, try below:

Log on to Windows server as local administrator
Go to folder ..\cognos\c10\bin
Create a text file and enter the following line:

FOR %%1 IN (*.DLL) DO REGSVR32 /S %%1

Save the file as regdll.cmd
Start a commando prompt by right click on command prompt and select run as administrator
change to the ..\bin folder
enter regdll to start the script
(it will now registered all the dll files in that folder again)
Wait a few minutes until it is finished.

Then try again to start the Cognos services.

Product:
Cognos Planning 10.1.1
Cognos BI 10.1.1
Windows 2008 R2 server

Symptom:
In your environment, you have installed Cognos product in VMWARE servers, and now you want to make a test environment from you working Cognos product environment.
You have copied the Cognos Windows server image to a new VMWARE image on other VMWARE host machine. You have renamed the Windows server that run the Cognos products and give it a new IP address. When you start Cognos Configuration you get a error.
When you press OK, Cognos configuration exit.

Error message:
CAM-CRP-1280 An error occurred while trying to decrypt using the system protection key. Reason: javax.crypto.BadPaddingException: Given final block not properly padded

Solution:
Export a unencrypted cogstartup.xml file from the previous Cognos Configuration program in you original Cognos server.
Start Cognos Configuration on the old server.
Select File – Export As
Enter a name of the file e.g. backup_cogstartup.xml and save the file to d:\
Copy that backup_cogstartup.xml file to you new Cognos server, to folder c:\program files\ibm\cognos\c10\configuration.
Rename the none working the cogstartup.xml file to cogstartup_org.xml.
Replace it with the unencrypted cogstartup.xml file, by rename the backup_cogstartup.xml to cogstartup.xml
On the new Cognos Server, start Cognos Configuration.
When it start, you have to change server name to reflect the new server name inside Cognos Configuration. This to make it work in the new Cognos solution, and not point to old servers.
Also change Content Store connections, so they point to the new database server.

If above does not help to allow you to start Cognos Configuration, you can try this:
Delete the caSerial and cogconfig.prefs files in the configuration directory.
Also delete the three subdirectories: csk, encryptkeypair, and signkeypair.
Start IBM Cognos Configuration again.

If you copy a vmware image with Cognos installed, and change the name of the server, it is many places that need to be updated. So I recommend that you install a fresh Windows 2003 R2 server instead, and then if you have fast dedicated CPU and ram in your system, you install Cognos software again to the new server. That can be a fast way to setup a test environment.

Product:
Cognos Planning 10.1.1
Analyst on Microsoft Windows 7 64 bit

Symptom:
When you start ODBC Data source administrator to add ODBC connections to xls files you get a error on your brand new Windows 7 computer.

You need to add ODBC connection to be able to import xls files into Cognos Analyst for Planning. Inside Analyst how you selected New D-Link and then click on source, and selected ODBC (SQL) database. But then there are no connections to select, you have to create the connections in the ODBC tool.

Problem:
The setup routines for the Microsoft Excel Driver (xls xlsx xlsm xlsb) ODBC driver could not be found. Please reinstall the driver.

Cause:
In windows 7 the odbc icon in administrative tools are for 64 bit connections, and cognos planning use only 32 bit connections.

Solution:
Create a shortcut to the file c:\windows\syswow64\odbcad32.exe

Use this icon to edit the ODBC connection for Excel to be used in Cognos Planning.

Product:
IBM Cognos Planning 10.1.1
Windows 2008 R2 server

Symptom:
When you start Cognos Analyst you get a login message from the IIS server.
You have setup to use SSO together with Active Directory in Cognos Configuration on the Cognos server.

You have created a global security group for you Cognos Planning users in your Microsoft Active Directory, that you call GlobalCognosUsers.
You have added the GlobalCognosUsers group to the Planning Rights Administrators group in Cognos Connection.
You have also try to add this GlobalCognosUsers group to the System Administrators group in Cognos Connection.

Message:
Windows Security
connecting to servername
user:
password:
domain: corp
remember my credentials
OK CANCEL

Possible Solution:
The cognos planning user does not have rights to the cognos planning folder on the windows IIS server. Do this steps to solve the issue.

Start Internet information Service Manager
Click on default web site in the left side
Click on authentication in the middle
Ensure only “Windows Authentication” and “Anonymous Authentication” are enabled.

Click on IBMCOGNOS in the left side in Internet Information Service Manager.
Click on authentication in the middle
Ensure only “Windows Authentication” are enabled.

Start Windows Explorer
Go to the INETPUB folder on the hard disk
Right click on the folder and select properties
Click on the Security tab
Click EDIT button
Click ADD button
Enter GlobalCognosUsers at “Enter the object names to select ” and click on check names
Click OK
Now you have added the ad group with cognos users to the folder
Click OK
Click OK

Go to the COGNOS folder on the hard disk (where the cognos planning program is installed)
Right click on the folder and select properties
Click on the Security tab
Click EDIT button
Click ADD button
Enter GlobalCognosUsers at “Enter the object names to select ” and click on check names
Click OK
Now you have added the ad group with cognos users to the folder
Click OK
Click OK

Try to start the analyst client again.

Try to surf to the windows server (Http://servername) from Internet Explorer to find if that connection is working at all first. This need to be working before Planning Analyst will work.