License Expiration - No Data Displayed

Problem

Sometimes, when accessing the License Expiration page, no data is displayed.

No data displayed in License Expiration

Resolution

Use any of the following suggestions to troubleshoot the issue.

Check the Configured Core Server Database Path

Follow these instructions to check if the configured Core Server database path is correct:

1. Go to the Configuration page under the Administration tab of the Analysis Server web interface.

2. Look for the configuration key Root.Etl.CoreDatabasePath.

3. Verify that the value of the key is correct.

   

   Check Core Server Database Path

   
   

4. If the value is incorrect, update the configuration key and execute the command RunEtl using the Analysis Server console.

Check if License Status Data is Processed Successfully

Follow these instructions to check the status of the License Status processing:

1. Go to the Analysis Server Log directory, which is by default in C:\Program Files\OpeniT\Analysis Server\Log.

2. Open the OpeniT.Server.Etl.Console.log log file.

3. Look for the latest execution of the job SyncLicenseStatusLabelJob.

   Example

   2022-12-05 19:31:08,005 +08:00 INFO SyncLicenseStatusLabelJob - Open iT Analysis
   Server Version: 9.12.1 (6c4c0256)
   2022-12-05 19:31:08,008 +08:00 INFO SyncLicenseStatusLabelJob - Job started.
   Running as SVG\jdoe
   2022-12-05 19:31:08,013 +08:00 INFO Config - License file is
   valid. "core" valid until
   2021-12-15 (374 days), "server_license" valid until 2021-12-15 (374 days),
   "server_olapreports" valid until 2022-12-15 (9 days)
   2022-12-05 19:31:08,014 +08:00 INFO SyncDataTypeJob - Open iT Analysis
   Server Version: 9.12.1 (6c4c0256)
   2022-12-05 19:31:08,016 +08:00 INFO SyncDataTypeJob - Job started.
   Running as SVG\jdoe
   2022-12-05 19:31:08,190 +08:00 INFO SyncDataTypeJob - Scanning core
   server data type 999 from
   \\desktop123win_storage\data-db-customer-001\license-status
   2022-12-05 19:31:08,197 +08:00 INFO SyncDataTypeJob - Packet size: 32764.
   Batch size: 30000
   2022-12-05 19:31:08,206 +08:00 INFO SqlTableCreator - Table LicenseData
   exists in the database.
   2022-12-05 19:31:08,211 +08:00 INFO SqlTableCreator - Checking column
   definitions for table LicenseData
   2022-12-05 19:31:08,321 +08:00 INFO SyncDataTypeJob - Loading 0 files...
   2022-12-05 19:31:08,328 +08:00 INFO SyncDataTypeJob - Loaded a total
   of 0 records. Average
   throughput for datatype 999: 0 records/min
   2022-12-05 19:31:08,331 +08:00 INFO SyncDataTypeJob - Job done.
   Duration 00.31s
   2022-12-05 19:31:08,439 +08:00 INFO SyncLicenseStatusLabelJob - Finished running
   procedure
   ProcessLicenseData. Affected rows: 992.
   2022-12-05 19:31:08,442 +08:00 INFO SyncLicenseStatusLabelJob - Job done.
   Duration 00.43s

4. Verify that the job is successful and has loaded the data.

5. If errors occurred, try to execute the command SyncLicenseStatus /reload again. If errors persist, please send the log file to support@openit.com for a response.

Check if License Status Data is Available

Follow these instructions to check if the License Status data is available in the Core Server database:

1. Go to the Configuration page under the Analysis Server Administration tab.

2. Look for the configuration key Root.Etl.CoreDatabasePath.

3. Navigate to the value of the configuration key.

   

   Check Core Server Database Path

   
   

4. Open the license-status folder and verify if a .gz file is available.

   

   Check License Status File

   
   

5. If not available, check the Core Server to see why it is not generating license status data.

Check for Web Browser Console Errors

Follow these instructions to check for errors in the web browser console:

1. Right-click anywhere inside the Home page, then click Inspect.

   

   Inspect Web Browser

   
   

   The Developer Tools will appear.

2. Choose Console from the available tabs of the tool.

3. The Console lists web browser transactions, including errors.

   

   Check Web Browser Console Errors

   
   

4. Errors in the Console may sometimes be too technical. For immediate response, send the error details to support@openit.com.