by ·0 Comments

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.

by ·0 Comments

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

by ·0 Comments

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.

by ·0 Comments

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

by ·0 Comments

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

by ·0 Comments

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.

by ·0 Comments

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.

by ·0 Comments

Product:
Cognos Controller FAP 10.1.1
Microsoft Windows 2008 R2 server
Cognos BI 10.1.1

Symptom:
Error to start Cognos BI service.
No error in Cogserver.log file, you find any errors in file catalina.2014-03-27.log

Cause:
When publish in FAP you get error C8ITKShared (not found in java.library.path) after you have changed TM1 from native security to use CAM (Cognos BI) security on the FAP cube.
You added the folder to TM1 Bin folder to PATH, c:\program files\ibm\cognos\tm1_64\bin
This disturbs Cognos Bi, and it will not start the service.

Solution:
Remove the folder to tm1 bin from the Windows PATH environment variable.

Copy two files from folder c:\program files\ibm\cognos\tm1_64\bin to the folder c:\program files(x86)\ibm\cognos\c10\server\fap folder.

C8ITKproxy.dll
C8ITKshared.dll

Restart the Cognos FAP service.
Test to do an Initial Publish in FAP again.

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

by ·0 Comments

Product:
Cognos BI 10.2.1 fix pack 2
Windows 2008 R2 Server

Problem:
How to make new portal tabs for existing users?
Possible workaround:
When you setup Cognos BI for the first time, create 10 hidden portal tabs that you later can use.
Create some common portal tabs:
Create a folder called portal under Public Folder in Cognos Connection.
Set that all users have read/execute/traverse rights to the folder portal.
This is done by click on MORE to the right of the folder in Cognos Connection.
Click on SET PROPERTIES and select PERMISSIONS tab.
Ensure that the Override the access permissions acquired from the parent entry is NOT marked.
Ensure that the Cognos group that the users belongs to are listed with read/execute/traverse rights. If not, click on ADD to add that user group.
Click OK to get back to Cognos Connection.
Click on the PORTAL folder to go down a level and create the portal pages.
Click on icon NEW PAGE
Enter a name for the portal page, like PORTAL ONE.
Click FINISH.
Repeat this for TEN pages.
Click on the SET PROPERTIES icon for the PORTAL ONE page.
Go to the PERMISSION tab.
Mark Override the access permissions acquired from the parent entry.
Mark all user group and click on REMOVE.
Add/leave only user group for SystemAdministrators here.
Only The SystemAdministrators should have read/write/execute/set policy/traverse on the portal page.

You can create a template folder and create the portal page under that template folder, and then you can copy that template portal page to the portal folder and only rename it. This is much faster to create more portals with the same settings.
Add the portals to the default profile in Cognos Connection:
Go to LAUNCH – IBM COGNOS ADMINISTRATION
Click on SECURITY tab and select Users, Groups, and Roles.
Click on the Cognos namespace.
Click on the EDIT DEFAULT USER PROFILE icon.
Click on the PORTAL TABS tab.
Click ADD.
Go to the Portal folder and mark all the new PORTAL PAGES you created.
Click on the Arrow icon and click OK.
Now all the portals pages are ready for the new users.
To make the tabs not visible, you have to change the system.xml file in folder
C:\Program Files\ibm\cognos\c10_64\templates\ps\portal\
Log on to the Cognos BI server (this change must be done on all Cognos BI servers)
Copy the C:\Program Files\ibm\cognos\c10_64\templates\ps\portal\system.xml file to a backup folder like d:\temp\backup
Open the C:\Program Files\ibm\cognos\c10_64\templates\ps\portal\system.xml in notepad.
Change the =”hideInaccessibleTabs” from false to true, so it looks like this:

true Save the system.xml file to the desktop.
Drag the system.xml file from desktop to the windows explorer window, showing you the folder C:\Program Files\ibm\cognos\c10_64\templates\ps\portal\
Replace the system.xml file.
Repeat on the Others Cognos BI servers.
Stop all Cognos BI windows services.
Start the Cognos BI service that run the Content Manager function first.
Start the other Cognos BI services on the Microsoft Windows servers.
Log in as an other user that is not System Administrator and he should not see the tabs.
This will only work for new users; users that have already accessed Cognos Connection are not affected by this setup.
This is how you erase a user profile in Cognos Connection:
Go to Administer IBM Cognos content
Click on SECURITY tab
Click on the AD namespace (the company namespace – not the Cognos)
Click on SEARCH icon
Select to search in “Name or description field”
Enter the name of the user and click SEARCH
Click on MARK for that user
Click on action “Delete this user’s profile”
Click OK on the question if you are sure you want to delete the user profile.
Logout from Cognos Connection ( close Internet Explorer ).
Login as the new user to Cognos Connection.
Go to MY HOME.
Check how many portal pages you see.

This is how to add users to the tabs (portal page), so they show up for the user in Cognos Connection:
Go to the template – portal folder.
Click on SET PROPERTIES icon for the portal you want to be visible for the user.
Click on PERMISSIONS tab.
Click on ADD
Click on AD ( the name of the company namespace )
Click on SEARCH
Enter the name of the user and click SEARCH.
When you find him, mark and click on the ARROW icon to add him to the list.
Click OK.
Mark the new user, and select so he gets read/execute/traverse rights on the portal page.
Click OK.
Close Internet Explorer and login as the new user to test if the PORTAL PAGE is visible.
Now you control what PORTAL TABS the users see by adding and removing the Cognos Security groups that the user belong to the pre-created portal tabs.
If the user goes into the Set preferences – portals tab he can see the names of the portal tabs – but there is an icon saying “cannot access page” for the portals he have no access to.
If you are a System Administrator in Cognos Connection, then you see all the tabs.
But you cannot add the tabs to a person who have already logged in to Cognos Connection. Then you have to erase his profile in Cognos Connection and he has to login again – or that you use a Cognos SDK script to copy a PORTAL TAB to his profile in Cognos.
More information:
http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id36310CustomizetheUserInterfaceBasedonGroupandR.html
http://www-01.ibm.com/support/docview.wss?uid=swg21351056
http://www-01.ibm.com/support/docview.wss?uid=swg21504740

by ·0 Comments

Product:
IBM Cognos BI 10.2.1
Microsoft Windows 2008 R2 server

Symptom:
User is not able to execute a event task from Cognos connection.

Error message:
CNC-ASV-0048 Error building report template: {0} CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2014-05-21-17:34:46.790-#24
Above is because you do not have any capability on the event.

CM-REQ-4012 You do not have the appropriate permissions to update or delete the object “/Transient/2014-05-21T13:44:32.295Z/ eventname” or a related object.

RSV-DST-0014 Unable to deliver the output of the report. See the run history details for more information. Ensure that the required services are started. Ensure that the user account is configured to distribute the output in the requested manner. CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2014-05-21-16:01:43.170-#2

Above because you do not have WRITE rights on the event object.

QE-DEF-0157 The Model or package /content/folder xxx does not exist or you are not allowed to use it because of security settings.

Above because you do not have rights on the framework package that is used by the event.

Solution:
Add the user to the Cognos groups for security or capabilities that will give rights to use Event Studio.

You also need to have WRITE rights on the event itself in Cognos Connection.
Go to the folder where you have your Event task, click on more.
Click set properties
Click on permissions
Ensure that the group the user is member of is here, and that it is Granted the;
Read, Write, Execute and Traverse rights.

Click OK and test with the user again.
You may have to logout and login again to make the security changes take affect.