Steps to follow when data does not sync real time to custom reports

Issue : QMetry custom reports (Visual Report / Advance Query Report) does not show real-time data.

Steps to be verified : 

• Go to QMetry > Customization > Insight Configuration > Database Configuration -
  • Verify the relevant settings are configured properly > click on Test to ensure a successful connection.
  • Go to "Sync Data" tab > perform the report sync.
• Once completed, create a new test case and check if you're able to pull the test case detail in the custom reports.

Once the above steps succeed and still, data does not show then collect the Report Server Logs and send it to QMetry Support to investigate the cause of the issue. 

To fix this issue, you can follow the below steps on the QMetry app server :

1. Connect to the QMetry application database server.
   • docker exec -it qmetry_rds_1 bash
   • mysql -uroot -pqmetry
2. Drop the `qmetrycdc` database schema using the below command.
   • drop database qmetrycdc;
3. Connect to the QMetry report server and restart the report docker services (will only affect custom reports for about one minute).
   • docker restart qmetry-reports-db qmetry-reports
4. Run report sync from the UI again (QMetry > Customization > Insight Configuration > Sync Data).

This should fix the issue with the data that does not sync real-time to custom reports.