Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Cannot access managed reporting via Dev Studio

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Cannot access managed reporting via Dev Studio
 Login/Join
 
Mike_Lombardi
Member
posted
We have recently upgraded to windows 7, which required a re-install of dev studio.
Since the re-install MR admins can no longer see Managed Reporting in Dev Studio. This is now stopping us promoting code up to the portal in dev studio.

Our install was as following
Dev Studio 7703
Dev Studio HotFix 5
Local Report Server upgrade to 7705

We can log into MR admin fine and we can log into Report Server (8121) fine, so I do not believe it to be a server issue.
This seems to be more of a local config issue that is stopping us connecting.

FYI we have single sign on enabled and use Active Directory as our authorisation/authentication.

This was all working prior to the re-installation.

I've tried raising this via InfoResponse but we've not found any solution to this so far.
Just wondered if anyone else had encountered this at all?

This message has been edited. Last edited by: Mike_Lombardi,


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Doug
Expert
posted Hide Post
Open a case with IB?!?!




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Mike_Lombardi
Member
posted Hide Post
Yeah have already raised a case. Will see what the outcome is.


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
smithec
Member
posted Hide Post
Make sure that your WebFOCUS IIS server name is a trusted site in your IE Internet Options. This is an issue with Single Sign On that is pretty common, but isn't well called out in the documentation.

As dev studio uses IE internally to connect to MRE this is a critical step in getting SSO to work in the windows world.

-Ed


77.0.3 to 8202, Windows/Linux, All Formats
 
Posts: 8 | Location: Pennsylvania | Registered: June 25, 2012Report This Post
Mike_Lombardi
Member
posted Hide Post
Apologies, I was out of the office yesterday. I will check out the trusted sites to see if this helps any further. Will let you know...


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Mike_Lombardi
Member
posted Hide Post
Trusted sites didn't make any difference. We went down this route when setting up SSO originally.

Just to confirm the checks we've done so far
- Trusted sites are ok
- IE browser settings are ok
- Dashboard access is fine
- Access to MR admin console is fine
- Access to report server (8121) is fine
- C:\ibi\DevStudio77\srv77\profiles\admin.cfg has been amended to ensure my id is used

Dev Studio behaves as if I do not have MR admin access. This leads me to believe that my logon credentials for the MR is not being used.

Is there a file that dictates the logon that is passed to MR via Dev Studio?


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Francis Mariani
Expert
posted Hide Post
Mike, please let us know how you sign-in in DevStudio. At one SSO client we had to add a DLL to DevStudio that gave us a different (from the default ones I suppose) authentication method. We selected this method to sign-in, then had to go back and select None to be able to really sign-in. Convoluted, but it worked.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Mike_Lombardi
Member
posted Hide Post
We have SSO set up whereby our windows account uses AD. We don't supply any logon details for our connections in Dev Studio.

web Component Authentication : None
webFOCUS client : No credentials supplied
Managed Reporting : No credentials supplied

I'm not so savvy on the configuration that was used to get SSO set up, but I can try and get these details if it helps.


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Mike_Lombardi
Member
posted Hide Post
We've ruled out the following so far
- Installation is correct. DevStudio 7703, HF5 and RS 7705 upgrade
- Windows 7 is not the cause as the same behaviour occurs on XP
- SSO works for MR admin, Report Server Console, BID
- EDASERVE connection in DS is working fine
- localhost is able to run once the admin.cfg file was amended to include me as
the admin
- Traces in MR Realm show that my role memberships are coming through correctly,
ie MR Admin
- The logon of the IT account that installed the product is not being used when
connecting to MR.

I have a consultant on site to get to the bottom of this. Will hopefully be able to provide an update on this soon.


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
CLH
Platinum Member
posted Hide Post
Hi,

For setting up SSO with developer studio in our environment we had to configure the dssso.xml located in the bin directory for our SSO method. Then had to tell developer studio to use the one we configured. You select it in the environment settings for dev studio.

Crystal


Webfocus 8.0.7 on Windows
 
Posts: 176 | Location: Ohio | Registered: October 26, 2006Report This Post
Mike_Lombardi
Member
posted Hide Post
Hi Crystal

I have tried to locate the dssso.xml but cannot find it in C:\ibi or in ..\AppData\Roaming\Information Builders

Are you able to give me the location of this file on my local pc?

We do actually have SSO working...it is just the communication to MR via DevStudio that seems to be the issue.


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
Mike_Lombardi
Member
posted Hide Post
Looks like we've found the solution!

Our security is linked to Active Directory for both authenticaion and authorisation.

The root cause was down to our the priveleges group in AD that handles mapping application folders to domains.

For Example
ibimr-priv_appname_folder1%20folder2%folder3

The name of the group should have included an = sign
ibimr-priv_appname=folder1%20folder2%folder3
Whereas the pre-win2000 name still needs to remain as
ibimr-priv_appname_folder1%20folder2%folder3

Unfortunately none of the webfocus traces picked this up, so was the main reason for why it was hard to spot.
AD set up with webfocus can be "flakey" at times so I think the traces should be enhanced in version 7.
I've been told that 8 wouldn't have this issue...but will wait and see.

Thanks guys for helping me debug this issue.


WebFOCUS : Report Server 7705. Dev studio 7703 running 7705 report server.
Platform : SQL Server 2005, SSAS 2005
Reports : Dashboard, Self Service (Active, InfoAssist, InfoMini), HTML Composer
 
Posts: 28 | Location: Peterborough | Registered: May 11, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Cannot access managed reporting via Dev Studio

Copyright © 1996-2020 Information Builders