dhis2-devs team mailing list archive

[Preeti Ajgaonkar <apreeti@xxxxxxxxxxxxxxxx>]

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

Attachment: Screen Shot 2017-12-20 at 3.17.59 PM.png
Description: PNG image