Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Datamart Wrong or Missing Data

Datamart Wrong or Missing Data


When querying data from a data mart table or view, the listed results are not up to date or missing.


The data mart tables and views are updated periodically in the background, but not in real time. Due to
this, it can take a few seconds up to a few minutes for the data to be loaded into the data mart tables. If
your system is running a heavy load, this influences the performance of the background process which is
loading the data. The reason is that other processes are prioritized higher and may temporarily block the
DataMartUpdater background job. Run your query again later to retrieve updated data.

If you are logged in as a system administrator, you can check the current state of the data loading process
by navigating to http://<server>:<port>/sctm/check/db and checking the DM_TestStatus Table.

Note: Tests and depending test runs are removed from the data mart if a test is deleted. This also
applies to deleted tests due to cleaning up test packages.


Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2015-04-30 15:42
Updated by:
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.