4.4.3 Managing Dashboard Data

The information displayed in the dashboard is maintained through service executions and API registrations.

Refreshing Dashboard Information

By default, tenant statistics are gathered daily at 00:00 AM (UTC). If required, users can also trigger this on demand from the UI or through the scheduler service by defining a batch (select component name as "Tenant Dashboard") and task.

To update the Storage stats and ECPU count, execute the following batch components:
  1. Navigate to the Batch Maintenance screen.
  2. Select the batch associated with Tenant DB Info Refresh..
  3. Trigger the execution.

    This process refreshes statistics for all schemas listed in the List of Schema to Gather Storage Stats.

Dashboard data is automatically refreshed by a pre-seeded, non-editable batch that runs on a fixed schedule:

Table 4-14 Dashboard data

Parameter Value
Batch ID PBSM_TENANT_STATISTICS
Batch Name PBSM_TENANT_STATISTICS
Task ID DATABASESTATISTICS
Task Name DatabaseStatistics
Run Frequency Daily at 00:00 AM (UTC)
The following schemas are scanned during each execution:
  • OFSAAMETA
  • PBSMDD
  • OFSAACONF
  • OFSAALOGS
  • CUSTOM
  • OFSAAMETACONF
  • OFSAA_ANALYTICS_PUB

Note:

Only objects of type TABLE are scanned for storage data. The batch frequency and scheduled time cannot be changed by users.

Viewing Execution Logs

View the last execution logs:

Table 4-15 Viewing Execution Logs

Field Description
Batch Run ID Unique identifier generated for the execution.
Task ID The specific task executed (for example, DATABASESTATISTICS).
Status Execution result: SUCCESS, ERROR, or IN PROGRESS.
Start Time Timestamp when the execution began.
End Time Timestamp when the execution completed.
Executed By The user account or scheduler that triggered the run.
Snapshot Date The as-of date for which statistics were gathered.

Troubleshooting

Use the table below to resolve common issues with the Tenant DB Dashboard:

Table 4-16 Troubleshooting Issues

Issue Resolution
Dashboard shows no data Verify that the PBSM_TENANT_STATISTICS batch has run at least once. Use Gather Tenant Info for an on-demand execution.
Historical trend chart is empty The chart requires at least one historical data point. Data is shown for the last 6 months only.
Dynamically created table not visible Register the table using the POST /tenant-dashboard/v1/registerTablesToCategory API with a valid schema and categoryId.
Tenant Statistics menu not visible Confirm your account has the RLTENANTSTATSVIEW role and the TENANTSTATISTICSVIEW function assigned.
Stale statistics warning on a table Informational only. Trigger a new batch run to refresh table statistics.
400 error from Registration API Verify that the schema and categoryId values in your request are from the supported lists.