J. J.

Some "dashboards" are data intensive and we do not want to run automatically. Also, our customers want us to provide rich text instructions or details on some dashboards. The Designer tool Text option does not support rich formatting so we do this in an HTML file. Unfortunately, when we uncheck the auto load feature, it does not load the HTML instructions/details page. We looked at using an Interaction, but it does not an option to trigger content load based on the "page loaded" event. We are now trying to leverage JavaScript to load the HTML content in a container while leaving the data output blank until the submit event. We found that adding the panelContainer.ibaObject.addContent('IBFS:/WFC/Repository/<workspace>/<content>', 'Title', true); works, but stops the filters from appearing on the page.

Hi @Patrick Huebgen, Thank you for this feedback. This has been helpful. We are trying to load specific content once the page loads. We found that the following function will do it. panelContainer.ibaObject.addContent('IBFS:/WFC/Repository/<workspace>/<content>', 'Title', true); However, using this will prevent filters from loading. We reached out to IBI Support to get their feedback. They indicated that any JavaScript, even the documented API, is not supported by IBI. Have you ever used JavaScript to load content on a page?

I met with IBI Support (Escalation) again and found a new possible issue that they were not even aware of. I have a number of departments that run ReportCaster with a service account as the Execution ID. It was always our understanding that ReportCaster executed the particular task as whatever user is in the Execution ID. My scenario is that a schedule would run in Environment #1 but not Environment #2. The task called a FEX that contained a SQL Passthru statement and had a service account (UserSVC) as the Execution ID. The Service Account has a WebFOCUS user profile with connection information to a database. The profiles and schedules appeared to be configured the same. I could not understand how the schedule would run in Environment #1 since it did not have the required grants on the database. I found in the logs that the associated user with the schedule had an individual user's account (UserA) and not the service account (UserSVC) assigned as the Execution ID. Come to find out, ReportCaster is using the CASTER_USER value found in BOTSCHED. This value is the owner of the schedule. The EDAPRINT log also reflects that the UserA executed the report and not the UserSVC. I created a schedule to call a FEX with "-? &" to return all the variables. I changed the ownership of the schedule to UserA with the Execution ID as UserSVC. I ran the job and checked what variables are captured. Not one variable showed the Execution ID of UserSVC. The reason it did not work in Environment #2 is because UserSVC is the owner/CASTER_USER. UserA had the correct grants but the UserSVC did not. UserA is really not happy since they have elevated system grants and the job was running under them the entire time and not the service account. I could use some feedback on this. First, am I crazy to think that the Execution ID should be used? Second, anyone know how to get the Execution ID that is assigned to a task?

@Clayton Peacock, this works for Scenario #1 that I mentioned. It does not work when the Execution ID does not match the owner. Scenario #2 is our issue at the moment. Our case (02258034) was escalated in April. The escalations representative declared it a defect in early May. Unfortunately, there was a misunderstanding and they did not actually report the defect. I had to re-escalate again in July because of Scenario #2. The escalations representative has kept the case and made sure to report it as a defect. Unlike Scenario #1, they presented no way to work around Scenario #2 and have given no timeline on when they will fix.

Anyone using ReportCaster in WebFOCUS 9.3 yet? I found a couple issues that IBI Support have indicated are a defect and do not have an ETA on resolution. Scenario #1 I log into WebFOCUS as user123. When I create a schedule, I make an Execution ID for user123. If the password happens to be incorrect, it will throw an error that looks like JavaScript. The logs indicate an invalid username/password combination. IBI and I found that correcting the password fixes this. Scenario #2 I log into WebFOCUS as user123. When I create a schedule, I use a service account instead of user123. I configure the service account to be owned by user123 and set the correct username/password combination. ReportCaster throws the same error as Scenario #1. The logs indicate the same invalid username/password combination. However, in this case the username and password are correct. IBI has no solution for allow the usage of a Service Account with WebFOCUS 9.3. The alternative is granting the service account roles within WebFOCUS which means it can log in and bypass the security built around the unique user login. Has anyone experienced this and have you found a better solution to creating shared logins?

Has anyone leveraged JavaScript within the WebFOCUS Designer tool (9.x) and is there any good documentation? IBI directs me to the documentation. I point out that it isn't good and there are no solid examples. They tell me they will pass along the feedback to their leadership. The WebFOCUS webinars mention that JavaScript can be used but never spend any time speaking about it? I am just curious if anyone is using it.

Hi @Clayton Peacock, This is great. Thanks for pointing me in this direction.

Does anyone have a query that will allow me to return all repository objects owned by a specific user. Support wants me to drop and recreate a user. They told me to change the ownership of all objects owned by the user, but refuse to give guidance on how to find the objects. Thanks.

@Jason Parker, I have just begun digging into these tables. I would be interested in any insights you have to offer. We are looking to answer essentially the same questions. Thanks!