Home
Follow us on Twitter


Countries

48.3%United States United States
7.3%India India
7%United Kingdom United Kingdom
5.5%Canada Canada
5.4%Australia Australia

Visitors

Today: 139
Yesterday: 351
This Week: 1225
Last Week: 3836
This Month: 10244
Last Month: 7936
Total: 770166


When starting FAP service, Could not login to TM1 PDF Print E-mail
Written by Roger   
Wednesday, 25 March 2015 20:49

Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2 Server

Problem:
When starting the FAP service, where we use Cognos BI CAM authentication, we get a error in the logs that say:
"Could not login to TM1, host: <servername>, server name: <FAP Service>, user name: <namespace\username>"
C8ITKShared (C:\Program Files\IBM\cognos\TM1_64\bin64\ C8ITKShared.dll is not a valid Win32 application.)

Background:
TM1 10.2.2 64 bit server installed to same Windows server as the Controller FAP Service.
The Windows FAP Service are 32 bit and uses 32 bit dll.
The new FAP client is 64 bit and uses the 64 bit dll and database drivers.
Default install of TM1 10.2.2 only install 64 bit dll files for TM1.

Solution:
Install TM1 Architect in 32 bit version to the server.
Add the path to the C8ITKShared.dll to the system path e.g. C:\Program Files (x86)\IBM\cognos\TM1\bin.
Right click on My Computer and select properties
Click on Advance System Settings
Click Environment Variables
Select PATH and click Edit
Update the path and save.
Click OK to exit dialog.
Restart the Server.

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

www.cogknowhow.com

 
Cognos planning login issue HTTP Error 401.1 - Unauthorized PDF Print E-mail
Written by Roger   
Saturday, 14 March 2015 15:37

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.

www.cogknowhow.com

 

 

 
On CAC monitoring tab, runtime error 13, type mismatch PDF Print E-mail
Written by Roger   

 

Product:
IBM Cognos Planning 10.1.1 Fix Pack 3
Microsoft Windows 2008 R2 server
Oracle Database

Symptom:
When user in CAC (Cognos Planning Administration Console) click on Monitoring Console tab to Monitor a Deployment they get a error message. When they click OK on error message the CAC is closed down.


Error message:
'Runtime Error 13'
'Type Mismatch'


Solution:
Stop the Cognos BI and Cognos Planning services in Windows on all Planning servers.
Log into the Planning Store database with SQL developer ( or TOAD ).
Ensure you have a backup of the oracle database.
Run this commands to truncate the two tables:

truncate table p_pnrequestprogress;
truncate table p_pnrequest;

Start Cognos Configuration for the server that contain Content Manager first.
Start the Cognos services here first - both BI and Cognos Planning.
After they are up, then go to next server - the Cognos Planning Job server.
Start Cognos Configuration for the Planning Job server and start that as second.
When all the Planning services are up, go into CAC and test again.

The start order of the Cognos BI and Planning servers are important.

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

 

www.cogknowhow.com

 

 

 
User cannot replace a report in a folder because there the report is set with only READ access and not READ/WRITE PDF Print E-mail
Written by Roger   
Saturday, 14 March 2015 15:10

 

Product:

 

Cognos BI 10.2.1 Cognos Connection

Problem:

User cannot replace a report in a folder with a different report he copied from a different folder. This is because the report to be pasted has different security settings for the user than the report in the target.

In the source folder you only have read, this means you can see reports and use them in report studio.

In the target folder you also have write access, this means you can create folders and paste reports there. But you cannot replace a report with a identical report from the source folder, because there the report is set with only READ access and not READ/WRITE.

Solution:

In the target folder you must have SET POLICY to be able to paste a report with other rights that the report you try to replace.

Workaround is to erase the report first, and then paste a new report into the folder. A new report does not change policy, and therefore can you save a report in a folder where you have write access.

If you only add new object to the target folder in Cognos Connection, you can manage with WRITE rights.

 

To work with a report or package you need to have READ, EXECUTE and TRAVERSE rights. If you only have EXECUTE and TRAVERSE you can run the report, or use the FM package in a report, but you cannot edit it in a Report Studio.

 

www.cogknowhow.com

 
How do I copy a cube from on TM1 server to another TM1 server in a different environment? PDF Print E-mail
Written by Roger   
Friday, 27 February 2015 19:12

 

Product:
Cognos TM1 10.2.2
Windows 2008 R2 Server

Issue:
How do I copy a cube from on TM1 server to another TM1 server in a different environment? The 2 TM1 servers are part of two different BI installations, they use the same Active Directory for authentication, and there are no firewall issues between the servers.

Possible Solution:
Use a ODBO connection in Cognos TM1 Architect to create the copy.
Start TM1 Architect and log in to the receiving TM1 server.
Right click and select to create a new process.
Select Datasource type: ODBO – cube.
In connection you need to enter this information:
ODBO Provider: IBM Cognos TM1 OLE DB MD Provider
ODBO Location: servername.domain.com (servername of the windows host that have TM1 admin service)
ODBO Datasource: FAP  (name of the TM1 server where you want to get data from)
ODBO Catalog:
ODBO UserID: username   (name of the admin user in TM1 application)
ODBO Password: password
Additional Connection Parameters: Provider String=”CAMNamespace=CDS”
The additional Connection Parameters is only if you have a TM1 application that use CAM/BI authentication – enter the name of the Cognos BI namespace, in our example CDS.
Click on CONNECT button – if no errors then you wrote the correct values above.
Go to Load ODBO Cube dialog tab
Select ODBO Cube to load from: FAPMonthlyCompanyDetails  (or any other cube you want to import)
Select TM1 Cube to load to: FAPMonth (or any other name you have for it)
Cube Type: Physical Cube
TM1 Cube Action: Create Cube
Data Action: Store Values
Click on Cube Dimensions dialog tab
Here you can change what dimensions the values should connect to, or let the import create the new dimensions in your TM1 receiving server.
Click on MDX Query tab
Here you should be possible to adjust the MDX if you need to.
Click SAVE icon to save the process, give it a name like: FAP import from external server
Run the process.
Depending on the size of the TM1 Cube this can take some time.
When done you should have a copy of the cube and the dimensions.

More Information:
http://blog.tm1tutorials.com/2012/07/27/automating-data-transfers-between-tm1-servers/
http://blog.tm1tutorials.com/tag/odbo/

 

 

www.cogknowhow.com

 

 
«StartPrev12345NextEnd»

 

CogKnowHow Newsletter

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

Polls

Do you use an additional administration tool for Cognos?