For a course do_11420352388390912013- user assessment entry is not getting created in assessment_aggregator table

[Raghavms03]

Test steps:

1. Login with a valid user
2. Search for the course do_11420352388390912013 and join
3. Consume the course completely
4. Check for the assessment_aggregator table.
5. Assessment entry is not available in the assessment_aggregator table.

Note: For other courses, we are getting assessment scores. Only for this course aren't we getting the score.

[jeraldfernandes28]

@Raghavms03
Could you please let us know which version of Sunbird ed you are using? Additionally, please check and share the primaryCategory of the assessment used in the course. If needed, you can paste the full content read response here.

[jeraldfernandes28]

And did the discussion 837 about this same issue got resolved?

[suraj-tekdi]

@JeraldJF No the https://github.com/orgs/Sunbird-Ed/discussions/837 is not resolved yet.
please check the response in json format

response_do_11420352388390912013.json
leafnodes_response_do_11420352388390912013.json

[jeraldfernandes28]

Hi @suraj-tekdi, as requested in Discussion #837 (comment), could you please attach a JSON file with the course hierarchy read response that includes the course assessment and successfully updates the record to the assessment_aggregator table?

[suraj-tekdi]

response_course_heirarchy.json

[jeraldfernandes28]

Hi @suraj-tekdi, this is the course experiencing the issue, correct? Could you also share the course hierarchy read response of a working course—specifically one that contains a course assessment and successfully updates user entries in the assessment_aggregator table? The purpose is to compare the payloads of both the working and non-working courses.

[suraj-tekdi]

response_success_course_heirarchy.json

[Raghavms03]

@JeraldJF I have tested both the below-mentioned scenarios. In both cases, the user record is written to the assessment aggregator table.

[jeraldfernandes28]

@Raghavms03 OK. Can you verify if this issue persists in the production or non prod cluster?

A couple of things to check @suraj-tekdi :

1. For the courses where user details aren't updating in the assessment aggregator table, what are the created on and updated on values for that courses?
2. If a different user consumes the exact same course, does the issue still happen?

[suraj-tekdi]

@JeraldJF
Created on: 10 December 2024

Updated on: 25 July 2025

[suraj-tekdi]

@JeraldJF Even for different user assessment aggregator table is not updating.

[jeraldfernandes28]

@suraj-tekdi So you are facing issue for only 2 courses in dev right?

[Raghavms03]

Yes, I have verified in prod as well. It was working fine i.e. user score record is written to the assessment aggregator table.

[jeraldfernandes28]

@Raghavms03 @suraj-tekdi
If this is a blocker, please refer to this discussion thread. It addresses the same issue in this version of Sunbird and should provide a resolution.

[suraj-tekdi]

@JeraldJF We have checked the content state API is getting called every time with success response. we are not getting inconsistent response like this
401 Unauthorized
400 Bad Request
200 OK

Every time we are getting 200 success response.

[suraj-tekdi]

@JeraldJF but even if criteria is not match. The marks should be updated in assessment_aggregator table.

[jeraldfernandes28]

OK. @chethann007 Can you look into this.

[chethann007]

Hi @suraj-tekdi , I'll first go through the thread. In the meantime, it would be helpful if you could share the repository link for the data-pipeline (assessment aggregator/activity aggregator Flink job), along with the exact branch/tag that's currently deployed. That will help me debug the issue once I've gone through the thread.

[jona-r]

Hi @chethann007 as requested

Job Name: activity aggregator Flink job
Deployed Image: knowledge-platform-jobs:release-4.10.0_RC1_7a458002_11
Gihub Link: https://github.com/Sunbird-Knowlg/knowledge-platform-jobs/tree/release-4.10.0_RC1

Job Name: assessment aggregator Flink job
Deployed Image: sunbird-datapipeline:release-4.9.0_RC2_5de198eca_11
Gihub link: https://github.com/Sunbird-Obsrv/sunbird-data-pipeline/tree/release-4.9.0_RC2

[chethann007]

Hi @jona-r, thanks for sharing the details. I'll need some time to debug the issue. I'll get back to you with an update once I've investigated it.