Data Mart DM_TestStatus table has no data

[kkyy]

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!

[Matthew McGibbon]

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

[kkyy]

Thank you!