Issue at creating the course

[gow1998]

Hi All,
I am getting the issue while clicking the course. for your reference I shared the screenshots at the below. Please give the solution for this issue.

[Krishnaj20]

@vinukumar-vs @gandham-santhosh - Please check this thread and respond.

[gandham-santhosh]

@gow1998 can you please share logs from lms services with the errors while executing this usecase?

[gow1998]

@gandham-santhosh lms service - logs

2023-01-05 23:38:21,440 page_section cache size: 26
2023-01-05 23:38:21,440 DataCacheHandler:run: Cache refresh completed.
{"timestamp":"2023-01-06T03:38:21.441Z","msg":"DataCacheHandler:run: Cache refresh started.","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 03:38:21,441 DataCacheHandler:run: Cache refresh started.
{"timestamp":"2023-01-06T03:38:21.443Z","msg":"Total rows fetched from cassandra: 9","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 03:38:21,443 Total rows fetched from cassandra: 9
{"timestamp":"2023-01-06T03:38:21.444Z","msg":"page_management cache size: 7","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 03:38:21,444 page_management cache size: 7
{"timestamp":"2023-01-06T03:38:21.446Z","msg":"Total rows fetched from cassandra: 26","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
{"timestamp":"2023-01-06T03:38:21.446Z","msg":"page_section cache size: 26","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 03:38:21,446 Total rows fetched from cassandra: 26
{"timestamp":"2023-01-06T03:38:21.446Z","msg":"DataCacheHandler:run: Cache refresh completed.","lname":"defaultLogger","tname":"pool-6-thread-2","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 03:38:21,446 page_section cache size: 26
2023-01-06 03:38:21,446 DataCacheHandler:run: Cache refresh completed.
{}
2023-01-06 05:19:44,850 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"b8d60b45-0905-1085-0c3a-6c2fc23134df","type":"system","message":"CourseEnrolmentActor :: list :: UserId = aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672982384850,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"de1MHytRYPwHb9oQnZBrVXH4_MAMxnsW"},"mid":"LOG:24c085e1-323c-42b6-b657-82b226038494"}
{}
2023-01-06 05:19:44,851 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"b8d60b45-0905-1085-0c3a-6c2fc23134df","type":"system","message":"CourseEnrolmentActor :: getCachedEnrolmentList :: fetching data from cassandra with userId aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672982384851,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"de1MHytRYPwHb9oQnZBrVXH4_MAMxnsW"},"mid":"LOG:b0530ef9-8c89-4c6d-9d74-0c8c281c85e7"}
{"timestamp":"2023-01-06T05:19:44.854Z","msg":"Total rows fetched from cassandra: 0","lname":"defaultLogger","tname":"application-akka.actor.default-dispatcher-8","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 05:19:44,854 Total rows fetched from cassandra: 0
{}
2023-01-06 05:19:44,855 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"b8d60b45-0905-1085-0c3a-6c2fc23134df","type":"system","message":"CourseEnrolmentActor :: list size :: 0 :: UserId = aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672982384855,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"de1MHytRYPwHb9oQnZBrVXH4_MAMxnsW"},"mid":"LOG:5a267b21-5d05-4eba-b89e-0c0cef4594df"}
{"timestamp":"2023-01-06T07:38:21.447Z","msg":"DataCacheHandler:run: Cache refresh started.","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 07:38:21,447 DataCacheHandler:run: Cache refresh started.
{"timestamp":"2023-01-06T07:38:21.450Z","msg":"Total rows fetched from cassandra: 9","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 07:38:21,450 Total rows fetched from cassandra: 9
{"timestamp":"2023-01-06T07:38:21.450Z","msg":"page_management cache size: 7","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 07:38:21,450 page_management cache size: 7
{"timestamp":"2023-01-06T07:38:21.452Z","msg":"Total rows fetched from cassandra: 26","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 07:38:21,452 Total rows fetched from cassandra: 26
{"timestamp":"2023-01-06T07:38:21.452Z","msg":"page_section cache size: 26","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
{"timestamp":"2023-01-06T07:38:21.452Z","msg":"DataCacheHandler:run: Cache refresh completed.","lname":"defaultLogger","tname":"pool-6-thread-1","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
2023-01-06 07:38:21,452 page_section cache size: 26
2023-01-06 07:38:21,452 DataCacheHandler:run: Cache refresh completed.
{}
2023-01-06 09:15:26,000 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"067888d2-dc26-41ab-0c4a-f3a50c755956","type":"system","message":"CourseEnrolmentActor :: list :: UserId = aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672996526000,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"nBcTTNeIWspy-2XOnFLQkFRhW8b0-1HK"},"mid":"LOG:706702d2-f0b5-41fc-b9eb-58ed90c790d5"}
{}
2023-01-06 09:15:26,001 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"067888d2-dc26-41ab-0c4a-f3a50c755956","type":"system","message":"CourseEnrolmentActor :: getCachedEnrolmentList :: fetching data from cassandra with userId aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672996526001,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"nBcTTNeIWspy-2XOnFLQkFRhW8b0-1HK"},"mid":"LOG:4a6c1842-273a-4106-b550-35d989b766f2"}
{"timestamp":"2023-01-06T09:15:26.007Z","msg":"Total rows fetched from cassandra: 0","lname":"defaultLogger","tname":"application-akka.actor.default-dispatcher-9","level":"INFO","HOSTNAME":"lms-5d644b7c9c-mss7q","application.home":"/home/sunbird/lms/lms-service-1.0-SNAPSHOT"}
{}
2023-01-06 09:15:26,007 Total rows fetched from cassandra: 0
2023-01-06 09:15:26,007 {"actor":{"id":"aa2d2ec7-ebc0-4935-91fd-189b634476f3","type":"user"},"eid":"LOG","edata":{"level":"INFO","requestid":"067888d2-dc26-41ab-0c4a-f3a50c755956","type":"system","message":"CourseEnrolmentActor :: list size :: 0 :: UserId = aa2d2ec7-ebc0-4935-91fd-189b634476f3"},"ver":"3.0","ets":1672996526007,"context":{"channel":"course-service","pdata":{"ver":"1.0","pid":"course-service","id":"org.sunbird.course-service"},"env":"","did":"56475e6d811e85f196e2d7e21de35832","sid":"nBcTTNeIWspy-2XOnFLQkFRhW8b0-1HK"},"mid":"LOG:60c7069e-b68f-404f-b4be-b946e775da77"}

[gandham-santhosh]

@pallakartheekreddy can you please check this? cc: @AmiableAnil

[vinukumar-vs]

@gow1998 I would suggest to verify the objectCategoryDefination response

curl 'https://staging.sunbirded.org/action/object/category/definition/v1/read?fields=objectMetadata,forms,name'
---- headers
-'{"request":{"objectCategoryDefinition":{"objectType":"Collection","name":"Course","channel":"channel_id"}}}'
--compressed

with framework search API response

curl 'https://staging.sunbirded.org/content/composite/v1/search'
---- headers
-H 'ts: 2023-01-06T17:49:09+05:30'
--data-raw '{"request":{"filters":{"objectType":"Framework","status":["Live"],"type":["TPD"],"systemDefault":"Yes"}}}'
--compressed

There may configuration mismatch in the objectCategoryDefination. refer the below links to debug
selectFramework()

[pallakartheekreddy]

@gow1998 As @vinukumar-vs suggested please check in objectCategoryDefination response config.frameworkMetadata.orgFWType what values configured?
if config value is config.frameworkMetadata.orgFWType = ["K-12", "TPD"]. Please make sure you have system level one K-12 and TPD famework are created with systemDefault= Yes

[pallakartheekreddy]

@gow1998 This issue is resolved. Actually, this issue occurred due to data issue. I am updating the thread with issue details and solution, what we did to resolve.

1. We don't have any framework type(k-12) with systemDefault= Yes in the system.
2. We found that, there are two entries in the DB for framework with NCF & ncf. Due to this, when we try to update NCF framework with systemDefault= Yes it is not reflecting properly in the search.

To solve, We have removed one of the framework entry ncf from both Neo4J & ES databases and updated NCF framework with systemDefault= Yes.

@maheshkumargangula @Krishnaj20