Home
Follow us on Twitter


Countries

48.2%United States United States
7.4%India India
7%United Kingdom United Kingdom
5.6%Canada Canada
5.4%Australia Australia

Visitors

Today: 103
Yesterday: 498
This Week: 1682
Last Week: 2793
This Month: 9023
Last Month: 12507
Total: 690078


Cognos Planning Contributor Administration Console (CAC) add new JOB SERVERS to your job server cluster gives an error PDF Print E-mail
Written by Roger   

Product:
Cognos Planning 10.1.1
Windows 2008 R2 Server
Oracle Database

Symptom:
Have setup new servers, and try to from inside Cognos Planning Contributor Administration Console (CAC) add new JOB SERVERS to your job server cluster, you get a error.

Error message:
Errors occurred while trying to communicate with each of the following servers:   xxxxx

Communication failure could result from:
-The server is not running
-Planning is not installed on the server
-The servers firewall is blocking requests xxxxx


Error in planningerrorlog files:
{4904905A-9BAF-4B99-B054-E41891C9E36C} 2 2014-05-08 19:33:44.433 UTC +120 EAdminDB_10 10.1.4074.0 JobServer GetEnabledAndNameLocal 100 Factory_10 70 Unable to create the object with ProgID 'epPlanningService_10.JobExecManager' (request was for 'epPlanningService_%v.JobExecManager')~~~~Permission denied domain\serviceaccount domain\servername domain\serviceaccount domain\servername  1744 5020

Error in windows event log:
Log Name: System
Source: Microsoft-Windows-DistributedCOM
Date: 5/8/2014 6:46:16 PM
Event ID: 10016
Task Category: None
Level: Error
Keywords: Classic
User: domain\serviceaccount
Computer: servername
Description:
The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{7B59D7CC-3FD8-41A4-9F2A-40D2D6B5590A}
and APPID
{324E655C-61EF-4500-85D1-2791358B531E}
to the user domain\serviceaccount SID (S-1-5-21-3598516276-3377520961-430964465-92766) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">;
<System>
<Provider Name="Microsoft-Windows-DistributedCOM" Guid="{1B562E86-B7AA-4131-BADC-B6F3A001407E}" EventSourceName="DCOM" />
<EventID Qualifiers="49152">10016</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-05-08T16:46:16.000000000Z" />
<EventRecordID>14320</EventRecordID>
<Correlation />
<Execution ProcessID="0" ThreadID="0" />
<Channel>System</Channel>
<Computer>servername</Computer>
<Security UserID="S-1-5-21-3598516276-3377520961-430964465-92766" />
</System>
<EventData>
<Data Name="param1">machine-default</Data>
<Data Name="param2">Local</Data>
<Data Name="param3">Activation</Data>
<Data Name="param4">{7B59D7CC-3FD8-41A4-9F2A-40D2D6B5590A}</Data>
<Data Name="param5">{324E655C-61EF-4500-85D1-2791358B531E}</Data>
<Data Name="param6">domain</Data>
<Data Name="param7">serviceaccount</Data>
<Data Name="param8">S-1-5-21-3598516276-3377520961-430964465-92766</Data>
<Data Name="param9">LocalHost (Using LRPC)</Data>
</EventData>
</Event>



Solution:

The service account set to run the IBM Cognos Planning service on the Microsoft Windows 2008 Server is not set to be local admin on the server.

Go to Manage – Configuration – Local user and groups – Groups
Click on Administrators
Click ADD to add the windows service account to this group on your Planning server.

Save and restart the Cognos Planning servers.
Then you can test again.

You can also test this with change back to local system to run the Cognos Planning service, if it works then to add as job server then it is the rights for the windows service account that is the case.

www.cogknowhow.com

 

 
User is not able to execute a event task from Cognos connection PDF Print E-mail
Written by Roger   
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.

www.cogknowhow.com
 
When log in to TM1 application Web the session loops in Internet Explorer 8 PDF Print E-mail
Written by Roger   
Product:
LICENSE_TM1-AW64-ML-RTM-10.2.5200.2-0
SWTAG_TM1-AW64-ML-RTM-10.2.5200.1-0
PLANANALYTICS-AW64-ML-RTM-10.2.5200.234-0
IBM Cognos TM1 10.2.2

Symptom:
When log in to TM1 application Web the session loops in Internet Explorer 8.

Error message:
No error message.
The URL in Internet Explorer is something like this;
http://ServerName3002.CompanyDomainName.com/ibmcognos/cgi-bin/cognosisapi.dll?b_action=xts.run&m=
portal/bridge.xts&c_env=portal/variables_plan.xml&c_cmd=../planning.html&ps= http%3A%2F%2FServer.
CompanyDomainName.com%3A9510&pg=%2Fapplications.jsp
http://ServerName3002.CompanyDomainName.com/ibmcognos/planning.html?cam_passport=
MTsxMDE6MThkODU1N2EtZGQ4ZS05YzVkLTUxZTktNDZlMmZjOGUxZDEzOjIyMjgwMjg1ODU7MDszOzA7&CRN= contentLocale%3Den%26columnsPerPage%3D3%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2F
constants%2FbiDirectionalOptionEnum %23biDirectionalFeaturesEnabled%3Dfalse%26productLocale%3Den%
26showOptionSummary%3Dtrue%26showWelcomePage%3Dtrue%26skin%3Dcorporate%26linesPerPage%
3D15%26http%3A%2F%2Fdeveloper.cognos.com%2Fceba%2Fconstants%2FsystemOptionEnum
%3Dfalse%26listViewSeparator%3Dbackground%26displayMode%3Dlist%26timeZoneID%3DEurope%
252FStockholm%26format%3DHTML% 26showHiddenObjects%3Dfalse%26useAccessibilityFeatures%
26automaticPageRefresh%3D30%26&pg=%2fapplications.jsp&ps=http%3a%2f %2fServerName0015.
CompanyDomainName.com%3a9510 

Solution:
Erase values in file fpmsvc_config.xml to start over again. It points to wrong BI server.
fpmsvc_config.xml file is found in folder C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration on the server where IBM Cognos TM1 Application Server (TM1WEB) is installed.
You must only point to the BI Content Manager as <dispatcher uri=.
When setting up TM1 10.2.2 with Cognos BI 10.2.1 security you need to have this files updated;
TM1 server C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ fpmsvc_config.xml
TM1 server C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ pmpsvc_config.xml
Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\ planning.html
Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\ pmhub.html
Cognos BI Gateway server C:\Program Files\ibm\cognos\c10_64\webcontent\tm1\web tm1web.html
Cognos BI report server C:\Program Files\ibm\cognos\c10_64\templates\ps\portal variables_TM1.xml
Cognos BI report server C:\Program Files\ibm\cognos\c10_64\templates\ps\portal variables_plan.xml
On Cognos BI report server open tm1_contribution.atom file in notepad from folder C:\Program Files\ibm\cognos\c10_64\ configuration\icd\contributions\contrib\ tm1_contribution.atom to add the TM1 application.
On Cognos BI report server open tm1_en.properties file in notepad from folder C:\Program Files\ibm\cognos\c10_64\ configuration\icd\contributions\contrib\ tm1_en.properties to add the Title of TM1 application to show in Cognos Workspace tool.
The files are updated with values like this;
In tm1web.html you need to add the TM1 Application Web server.
// Update the following to point to the location of the TM1Web service(s)
var tm1webServices = ["http://ServerName0015.CompanyDomainName.com:9510"];
In variables_TM1.xml you need to add the TM1 Application Web server.
<urls>
<url is-regex="true">http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebLogin.aspx</url>
<url is-regex="true">http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebLoginHandler.aspx</url>
<url is-regex="true">http://ServerName0015.CompanyDomainName.com:9510/TM1Web/TM1WebMain.aspx</url>

<url>../tm1/web/tm1web.html</url> 
</urls>
In variables_plan.xml is not changed by you, but it is different than previous TM1 version.
In pmhub.html you need to add the TM1 Application Web server.
// Update the following to point to the location of the pmhub service(s)
var pmhubURLs = ["http://ServerName0015:9510","http://ServerName0015.CompanyDomainName.com:9510"];
In planning.html you need to add the TM1 Application Web server.
// Update the following to point to the location of the planning service(s)
var planningServices = ["http://ServerName0015.CompanyDomainName.com:9510"];
In fpmsvc_config.xml you normal not need to add anything as it is updated the first time you surf to http://tm1webservername:9510/pmpsvc, but it can look like this;
<?xml version="1.0" encoding="UTF-8"?><fpm_config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="fpmsvc_config.xsd">
<service forceQualifiedPaths="true">
<businessViewpoint enabled="false" uri="http://ServerName0015.CompanyDomainName.com:9410/bv"/>
<scorecarding enabled="true"/>
<provisioning allowInstalls="false" allowUpdates="false" uri=""/>
<resource path=""/>
<users path=""/>
<external uri="http://ServerName0015.CompanyDomainName.com:9510"/>
<session timeout="65"/>
</service>
<tm1>

<gateway uri="http://ServerName3002.CompanyDomainName.com/ibmcognos/cgi-bin/cognosisapi.dll"/>

<alternate_gateway_uris>
<alternate_gateway uri="*"/>
</alternate_gateway_uris>
<dispatcher uri="http://ServerName0014.CompanyDomainName.com:9300/p2pd/servlet/dispatch"/>
<admin_host name="SERVERNAME0020.CompanyDomainName.com">
<servers>
<server name="Tm1 application name ..."/>
</servers>
</admin_host>
</tm1>

<!--
The Cognos Insight publish feature enforces a set of minimum system requirements that are required to perform a publish. These are requirements on the system running 
the TM1 Applications service where the new TM1 servers will be created. To change these system requirement settings add the <insight_publish> element.
maximumCDDDataMB - The maximum amount of TM1 data that can be sent in a publish request
maximumTM1ServersAllowed - The maximum number of servers that can run on this machine. This is the maximum number of servers that are registered with the tm1Admin service.
minimumFreeDiskSpaceMbRequired - The amount of disk space that must be available on the drive where the Tm1 data is published.
minimumFreeDiskSpaceMbRequired - The amount of free memory that must be available on the publish server.
-->
<!--
<insight_publish enabled="true" maximumCDDDataMB="100"> 
<system_requirements maximumTM1ServersAllowed="10" minimumFreeDiskSpaceMbRequired="5000" minimumFreeMemoryMbRequired="500"/>
</insight_publish>
-->
<!-- If low on disk space you can set a different drive for the published TM1 server data as an alternative to reducing minimumFreeDiskSpaceMbRequired -->
<!--
<insight_publish enabled="true" maximumCDDDataMB="100"> 
<tm1Data path="E:\PublishedServers"/>
<system_requirements maximumTM1ServersAllowed="10" minimumFreeDiskSpaceMbRequired="5000" minimumFreeMemoryMbRequired="500"/>
</insight_publish>
-->


<insight pmpsvcPingTime="30"/>
<insight_publish enabled="false"/>
</fpm_config>
You should only change <session timeout="65"/> to a higher value than the timeout in Cognos BI server.

 

www.cogknowhow.com

 

 
Lifecycle Manager HTTP Status 500 error PDF Print E-mail
(1 vote, average 5.00 out of 5)
Written by Roger   

 

Product:
Cognos Lifecycle manager
Microsoft Windows 2008 R2

Symptom:
Error when try to create a new project in Lifecycle Manager

Error message:
An error has occured in Lifecycle Manager.
Could not create a new project
HTTP Status 500 -

Cause:
Check that the tomcat service have started. In the DOS window there can be text like filenotfoundexception. ... \logs\catalina,2014-02-25.log (the system cannot find the path.... show that the tomcat service never started correct.
If you check the logs folder under tomcat directory, this folder is empty. The Windows server is looked down - the normal user do not have rights to files under c:\program files folders.

Solution:
Uninstall Lifecycle Manager.
Install it to a different folder on your server - e.g. d:\ibm\cognos\Lifecyclemanager\
Where the user have more access rights and can create temp files.

Then start Lifecycle manager again and surf to http://localhost:4797/LifecycleManager


More Information
http://www.ibm.com/developerworks/data/library/cognos/upgrade_and_migration/bi/page579.html

 

www.cogknowhow.com

 

 

 
How change the TEMP variable for a service account PDF Print E-mail
(1 vote, average 4.00 out of 5)
Written by Roger   

Product:

IBM Cognos Planning 10.1.1
Microsoft Windows 2008 R2 Server


Problem:
How change the TEMP variable for a service account, without logging in as the user on the Windows Server?

Solution:

Create the service account in the Domain.
Ensure the service account is part of the local administration group on the planning server.
Go to the Administration tools - services.
(you can start it by type services.msc in Run dialog)
Double Click on  your IBM Cognos 10 Planning service and select Log On tab.
Select this account and browse to your service account, in our example named cogplan.
Enter Password and click OK to save the change.
Click OK on message that the account have been added to "log on as a service" function.
Right Click on the service IBM Cognos 10 Planning and select RESTART.
Ensure that Cognos planning service have started.

The planningerrorlog.csv file is created in folder \users\cogplan\appdata\local\temp

Start REGEDIT
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
Check the last number in list - it is possible your service account.
You should see it on the ProfileImagePath value who would be : C:\Users\cogplan
Note the number if the user down
Go to HKEY_USERS\S-1-5-21-2298123480-4089459362-31738xxxxx-1001\Environment
(the number should be the number of the user you found under ProfileList.)
Double click on TEMP to change the value from
%USERPROFILE%\APPDATA\LOCAL\TEMP
to
D:\TEMP
Click OK
Repeat the change for TMP
Close REGEDIT

Restart the Cognos Planning service.

Now the log file is in the D:\TEMP folder.

 

www.cogknowhow.com

 
«StartPrev1234NextEnd»

 

CogKnowHow Newsletter

Newsletter
Please register to the site before you can sign for a list.
No account yet? Register
Banner

Polls

How many users are working on your Cognos environment?