Anyone using Cognos business reporting with SSL enabled PDMLink?

[darunachalam]

We have some custom Cognos reports which were working fine with PDMLink. As a part of ProjectLink implementation, we have enabled SSL in PDMLink. To make Cognos reports to work with SSL enabled PDMLink, we tried the below TPI from PTC website:
https://www.ptc.com/appserver/cs/view/solution.jsp?n=kA1A00000000CbEKAU).

However we could not run the Cognos reports. We get an error 'The report server not responding' on the GUI and a large core file gets generated under Reporing/bin directory. Wehave beenworking with tech support for last few weeks to get a resolution for this issue.

Is there anyone using Cognos reports with SSL enabled PDMLink? Did you face similar issue? Please let me know, I would like to hear your suggestions.

Thank you!
Dhana.

[bellj]

I am trying to do the very same thing.
I don't get an error though. Nothing happens when I try to run a report from the PDMLink/Reports gui and the browser freezes when I try to run a report from the Cognos Administrator web gui.

Trying to install and configure Business Reporting has been very difficult.


joe bell
CM Application Administrator
Information Management & Technology Solutions
GSIMS - GPS Sustainment Information Management System
719-380-5932
bellj@gpssims.com<">mailto:bellj@gpssims.com>

[imendiola]

Hi,

check that only 2 properties in Cognos configuration has been changed from HTTP to HTTPS. Everything else must be configured as HTTP. Once yo have configured Cognos correctly and started it, these are the necessary properties in Windchill:

<property name="wt.reporting.thirdParty.enabled" overridable="true" targetfile="codebase/wt.properties" value="true"/">
<property name="wt.auth.trustedHosts" overridable="true" targetfile="codebase/wt.properties" value="localhost"/">
<property name="wt.cognos.namespace" overridable="true" targetfile="db/db.properties" value="AdministrativeLDAP"/">
<property name="wt.cognos.endpointUrl" overridable="true" targetfile="db/db.properties" value="http://&lt;CognosHostName">:9300/p2pd/servlet/dispatch"/>
<property name="wt.cognos.home" overridable="true" targetfile="db/db.properties" value="/opt/Reporting"/">
<property name="wt.cognos.model.dir.location" overridable="true" targetfile="db/db.properties" value="$(wt.cognos.home)/ptc/models/$(wt.cognos.model.name)"/">
<property name="wt.cognos.externalUrl" overridable="true" targetfile="db/db.properties" value="$(wt.webserver.protocol)://$(wt.rmi.server.hostname):$(wt.webserver.port)/cognos8/cgi-bin/cognos.cgi"/">
<property name="wt.cognos.admin.password" overridable="true" targetfile="db/db.properties" value="&lt;WCHAdminPassword">"/>
<property name="wt.cognos.admin.uid" overridable="true" targetfile="db/db.properties" value="&lt;WCHAdminUserName">"/>

<property name="wt.webserver.port" overridable="true" targetfile="codebase/wt.properties" value="443"/">
<property name="wt.webserver.protocol" overridable="true" targetfile="codebase/wt.properties" value="https"/">

Regards

Iker Mendiola

Prambanan IT Services
http://www.prambanan-it.com