Garth Colasurdo

Thanks for those suggestions. The PDFs seem to be formatted correctly by that example. The PDF engine is both Edge and Reader- I downloaded the extension to see if that had an effect. I got kind of excited that maybe FireFox would be different. But it still renders with the same issue. I might try Safari/Apple Preview out of curiosity. I'll have the developer try removing formatting by layers to see if we can see where the anomaly comes in.

Thanks for the feedback. It is a very weird and specific bug. I was hoping someone else may have come across it.

When I make a simple test against the Cars sample, I don't get the dropped parenthesis either. However, for our suite of financial reports it started showing up. This makes it hard to share with support. We can't tell if it is an interaction with the PDF engine, style sheets, or a change to the FOCUS code.

After upgrading to 9.2.3 (from 9.0.1) we are having a problem with the display of negative numbers that use the formatting D12.2CB. It drops the trailing ')' from the right most column in a sub or grand total. It only happens on PDFs. HTML and Excel display correctly. Further it only seems to affect the second column after another negative column. The code is written in App Studio and has been working for many years. Has anyone experienced this or behavior like this?

Hi, I've been having trouble with this error too, but I'm trying to connect to our Azure DevOps site. Maybe its the same because it is also private. Toby, I must have breezed past that log, so thanks for pointing that out. I'll see if I can utilize that for a more details from the error. Also, I'd be keen to hear more about the api.

Update 2: thanks for the great suggestions. They all would have been THE solution, but, indeed we are using external Active Directory groups to manage the Security Groups. I was able to get my lists with Powershell (learned something new). However, I will have to match the WF Security Groups by hand. 😥

Thank you Patrick for the link to your tutorial and channel. There is a lot of great stuff in there. However, it seems that my UOA tables are not populated with the data that reflects our environment. For what ever reason, it only has a hand full of the links between users and groups, though it does have all the users and groups. I have a case open to see why that is and if we can get that UOA_GROUPSUSERS re-populated.

This is really good, but I am having a hard time figuring out how to connect the UOA_USERS to UOA_GROUPS. I tried to use UOA_GROUPUSERS, but that table only has 40 rows and would have been expecting several hundred, eg User records x Groups per user. Or are they connected through a different tables? It would seem that the WebFOCUS Client adapter can do it (see below, but I can't get it to work currently).

This looks fantastic and I'd love to use more of this. However, after configuring the adapter (only WebFOCUS Client REST was available on our 9.0.1) I was able to successfully test in the configuration screen, but it failed elsewhere with a 403 - Access Denied. Is there a Role or Rule a signed in user needs to access example.com/ibi_apps/rs for example?

Thanks for those methods and details. It is funny how I've assumed that select/copy-paste always works on a web interface. :) Also, the information in the Repository is pretty amazing- though I forget about it all the time. When we audit the security groups and who is in each of them, I'm definitely going this route.

Update. I have access to the Repository and made my queries there for the list I need. I suppose I could create a report to share with the Admins. We are on a tight deadline and I panicked. Maybe this will help someone.

I can't copy and paste the list from the web. I'd do it by hand, but over three enviornments we have several thousands of users.The License audit only has Name, but this is our IDs from Active Directory. Someone will ask for full names. It would also be super nice to get the Security Groups they belong to, but that is a stretch. This is for WF 9.0 and 8207.

Just following up, we determined that we do need to update the Repository Database URL to accomodate the Oracle jdbc string connection. However, to do so, we need to contact Customer Support to make the change (can't be made by with the Administrative Config page). So the new string needs to be in the form of: jdbc:oracle:thin:@{host}:{port}/{service name} The old form is: jdbc:oracle:thin:@{host}:{port}:{SID}

Our DBAs are migrating our Oracle servers to Multi-Tenant. Not sure what that all means, but it changes some of the connection configs. Specifically it uses the Service Name rather than the SID in the JDBC string, as well as having changes to the syntax of the string. On the Oracle side I think it consolidates database resources and makes management easier. I have not seen it referenced in the install documentation, or if this is supported, but I wondered if anyone has done such a configuration. It has worked with most of our other ERP systems, but we did have one system require a lot of reconfiguration and updating to make work.

I did find this after some digging: https://docs.tibco.com/products/tibco-webfocus-client-9-0-0 It has release notes, install guides, migration guides, user guide, etc, all updated for 9. For upgrade purposes, we were trying to figure out if this was a nicer name for a .29 upgrade or a whole new version of WF. Seems like it is a nice feature and marketing upgrade. But Id like to hear more opinions.