Postman Collection Fails at "Set Setting - orgTypeConfig", Causing All Subsequent APIs to Fail

[Aparnadeloitte]

While executing the Postman collection, the request fails at the second step "Set Setting - orgTypeConfig" with a server error indicating that the system_settings table is unconfigured. As a result, all subsequent APIs in the collection are also failing.

API ENDPOINT: POST https://{{host}}/api/data/v1/system/settings/set

REQUEST:

curl --location 'https://{{host}}/api/data/v1/system/settings/set'
--header 'Authorization: Bearer xxxxxxxxxx'
--header 'x-authenticated-user-token: xxxxxxxxxxxxxxxxxx'
--header 'Content-Type: application/json'
--data '{
"request": {
"id": "orgTypeConfig",
"field": "orgTypeConfig",
"value": "{"fields":[{"name":"School","value":2,"description":"School","displayName":"School","flagNameList":["isSchool"]},{"name":"Board","value":5,"description":"Board","displayName":"Board","flagNameList":["isBoard"]}]}"
}
}'

RESPONSE:
{
"id": "api.system.settings.set",
"ver": "v1",
"ts": "2026-02-18 08:00:24:101+0000",
"params": {
"resmsgid": "1086de08dbf4e8b2a4103c2aafb9c37a",
"msgid": "1086de08dbf4e8b2a4103c2aafb9c37a",
"err": "UOS_SYSCRTUOS_0069",
"status": "FAILED",
"errmsg": "unconfigured table system_settings"
},
"responseCode": "SERVER_ERROR",
"result": {}
}

Additional Details: v8.1.0

[aimansharief]

Hey @Aparnadeloitte

Before we dive deeper into this issue, I’d like to understand your deployment setup. Could you please share:

• Which cloud provider is being used?
• How the deployment was performed
• The exact steps you followed during installation

One possible cause of this issue is that the required table may not have been created in Cassandra. In our standard installation process, a job named cassandra-migration-job runs to initialize all necessary database schemas.

Sharing your installation steps will help us better understand the situation and assist you more effectively.

[Aparnadeloitte]

Hi @aimansharief

Deployment Details:

1. We are deploying the platform on AWS cloud infrastructure.

2. The deployment is being performed on AWS using install.sh automation script, which provisions the infrastructure and installs all required services.

Installation Steps Followed:

1. Configured the SSL certificate using Let’s Encrypt for secure HTTPS access.

2. Updated the values.yaml file with the required AWS access credentials.

3. Provisioned the AWS infrastructure and Kubernetes cluster.

4. Executed the install.sh script, which deployed all platform services and supporting components.

Also attaching the logs of run-cassandra-migration-29524035 job from the sunbird namespace for your reference.
sunbird-run-cassandra-migration-29525475-jvt76-1771581314840861888.log

[aimansharief]

@Aparnadeloitte The one you’re referring to performs a different task. Please check the logs specifically for the learnbb-cassandra-migration-job. Let’s do this: redeploy LearnBB using the command time ./install.sh install_component learnbb. This will retrigger the job, after which we can review its logs.

[aimansharief]

@Aparnadeloitte If the logs indicate that the migration is complete, then retrigger the /system/settings/set API. If you still face any issues, we can connect and investigate further.