Error 500 on rest/settings/sync

[moshthepitt]

Encountering an error 500 from the rest/settings/sync endpoint.

My expectation is that we should not encounter 500 level errors but instead receive back 4xx level responses notifying us of the error.

Request details

Request URL: https://reveal-stage.smartregister.org/opensrp/rest/settings/sync Request Method: POST

Request body is attached.

settings.json.zip

[dubdabasoduba]

@moshthepitt @githengi It might be something that's affecting Malawi(GIZ) too. Looking at it. now.

[moshthepitt]

I suspect that my example above is failing because the payload is large. But, alas, with the way this works on the web app we need to be able to handle large payloads.

[dubdabasoduba]

I don't think it's the large payload. From the little investigation I have done it affects the global settings. The setting payload you are sending is a global one since it's not tied to any teamId, locationId, providerId or team

[dubdabasoduba]

@moshthepitt When do you need this?

[moshthepitt]

ASAP but can wait mid next week

[dubdabasoduba]

Fixed in v2.2.23-SNAPSHOT and v2.1.46-SNAPSHOT

[moshthepitt]

Seems like it is still happening

[dubdabasoduba]

Identified problem

• The insert many query is breaking because the payload surpassed the 32767 bind variables limit per statement on Postgres.

[dubdabasoduba]

I suspect that my example above is failing because the payload is large. But, alas, with the way this works on the web app we need to be able to handle large payloads.

@moshthepitt was right on this . The previous issue fixed wasn't the root cause in this case.