Sunbird-cQube / community

Community repo for cQube where documentation, discussions, etc are enabled.
MIT License
3 stars 7 forks source link

Regression Defect - User Engegement Report showing no data available #715

Closed chetandg123 closed 2 years ago

chetandg123 commented 2 years ago

After processing yesterday summary data file to diksha , still we are not able to see data in user engegement machine - demo3 Bucket - qa10

Image

padmanabha1234 commented 2 years ago

@PavitraIR The data is processed with latest date, query is not returning any data. please look into this

PavitraIR commented 2 years ago

@chetandg123 The collection name and district id in diksha_total_content table and diksha_tpd_agg table doesn't match and in the query we are joining these two tables using those columns.

So please emit appropriate data file into diksha_total_content and dikha_tpd_agg with matching data for collection_name, and district_id ,

chetandg123 commented 2 years ago

@devu1454 can you check above update

chetandg123 commented 2 years ago

@htvenkatesh @padmanabha1234 Data present in the data base and in output files are generated with null

devu1454 commented 2 years ago

Re-processsed the same data again. Data is displayed