BSAE: No data in the compliance universe / force nightly compliance job to run

When creating a report in BASE using the SA Compliance universe it produces no data. The compliance universe is calculated with a nightly job and as such data is not immediately available after load. There may be an error message that states that the query results cannot be null.

The Business Service Automation Essentials (BSAE) compliance data is not generated real time. Due to the complexity of the calculations the data is produced with a nightly job that runs as part of the BSAE job scheduler at midnight each night by default.

If you are trying to look at data that has been generated before the nightly job runs, it will not be available. There are reasons that the nightly job could fail if for example the database has been brought down for maintenance or a backup.

It is possible to manually run the nightly compliance job through the BSAE jmx-console utility using the following process.

1. Open a supported browser to the url "https://host:8443/jmx-console" where host is the hostname or ip address of the BASE application server

2. Login to the jmx-console with the BSA Essentials admin user and password

3. Scroll to the very bottom of that page to the section named "omdb.system"

4. Click on the link "service=SchedulerConfigurator"

5. Scroll to the very bottom of that page

6. Click on the invoke button under the section "java.lang.String printJobs()"

7. Note the number in the ID column for the job named "BO Data Job".

8. Click on the "Back to MBean View" link towards the top of the screen

9. Find the section titled "boolean forceRunOfJob()"

10. Put the number from the ID column of the "BO Data Job" into the "ParamValue" text box under the "boolean forceRunOfJob()" section.

11. Click on the invoke button at the bottom of the "boolean forceRunOfJob()" section.

12. Click on the "Back to MBean View" link towards the top of the screen

13. Scroll to the very bottom of that page

14. Click on the invoke button under the section "java.lang.String printJobs()"

15. Note the value in the "Last Run" and "Last Run Status". They should be the current time and the status should be successful. If they have not been updated yet, click on the "Back to MBean View" and repeat until the "Last Run" and "Last Run Status" are updated.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s