Commodore
Commodore
1146 views

Data Mart DM_TestStatus table has no data

Hi All,

We are trying to create some reports using the "Reporting Data Mart".  We queried the below tables and found that there were no data at all.  We had been able to executed some automated test cases from Silk Central and there should be some data available.

DM_TestStatus, RV_TestStatusExtended, RV_LatestTestStatus, RV_MaxTestRunID, RV_ExecutionPlanStatusPerBuild

We also ran http://<server>:<port>/sctm/check/db with fix option to check the DM_TestStatus table, and we found there were some errors in the report.

We are wondering how to debug and resolve this issue further.  Thank you for any sharing!

0 Likes
2 Replies
Absent Member.
Absent Member.

Hi kkyy,

Thanks for the question.

Without the latest log files it would be hard to pinpoint the exact cause of this issue. What we can do is force a recycle of this process.

To do this please follow these instructions:

1. Stop the Silk Central Application Server

2. Execute the following query on your database:

DELETE FROM DM_DataLoads

3. Start the Application Server process.

This will force the repopulation of the datamart tables.

The process itself can take some time depending on resources and load on your environment, so you should let this run for some time.

To verify this has resolved your issue you can run the following query:

SELECT Action_pk, StartTime, EndTime, LoadFrom, LoadTo, LoadState

FROM DM_DataLoads

The LoadState column should read complete once finished.

If you do have any further issues with this just log a support incident, attaching your system diagnostic report and we can look into this issue further for you.

Thanks,

Matthew

0 Likes
Commodore
Commodore

Thank you!

0 Likes
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.