dhis2-devs team mailing list archive

[Preeti Ajgaonkar <apreeti@xxxxxxxxxxxxxxxx>]

Looping in Marta.

On Wed, Dec 20, 2017 at 3:27 PM, Preeti Ajgaonkar <apreeti@xxxxxxxxxxxxxxxx>
wrote:

> Hi,
>
> In DHIS 2.26 and DHIS 2.27, we encountered the following error in the POST
> call while creating an event report with a data element that has many
> options in the filter.
>
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"
> status":"ERROR","message":"ERROR: value too long for type character
> varying(255)"}
>
> We were only able to add 21 options to the filter and save the report in
> our case. Adding more than 21 options displayed the above error. We are
> suspecting that this is caused by the 'filter' parameter, when it crosses
> the 255 characters threshold (see below).
>
> rows
> :[{dimension: "aee50bae73b", items: [],…}]
>
> 0:{dimension: "aee50bae73b", items: [],…}
>
> dimension:"aee50bae73b"
> filter:"IN:ae5824ee166;af88bde6615;a4e5da8828d;a342292ba70;a8b2ff2daf1;
> ab81f48f895;a0c83d60c8d;a440a1a53ec;af99d73c133;af80977531e;af430c7dd91;
> aecabb2c41d;a31fd3b9ffd;a8be7cafaeb;ad4969e1f34;a76e39e60dc;ab99d76f26c;
> aecdba37c76;af294a21e9f;a4b890e3441;a5c5340a7ee;a0d75d2c0b6"
> items:[]
> name:"Primary Diagnosis at ICU  Discharge - Discharge - Intensive Care
> Ward"
>
>
> We also tried to replicate this in DHIS play. Though we were not able to
> create the event report in DHIS play as well, the error reported was
> different (See attached screenshot). Could you please confirm if this is a
> bug?
>
> --
> Thanks
> Preeti Ajgaonkar
>