← Back to team overview

dhis2-devs team mailing list archive

Re: Value Type 'Long Text' is 255 characters ?

 

https://jira.dhis2.org/browse/DHIS2-1908

On 5 July 2017 at 21:36, Calle Hedberg <calle.hedberg@xxxxxxxxx> wrote:

> Harsh,
>
> That looks like a clear-cut bug, and it's not the first time we have
> discrepancies between what the API or UI will allow and what the database
> itself will allow.
>
> Please write a JIRA bug issue for it.
>
> Regards
> Calle
>
> On 5 July 2017 at 12:37, Harsh Atal <harsh.atal@xxxxxxxxx> wrote:
>
>> Please consider following pull request regarding above :
>> https://github.com/dhis2/dhis2-core/pull/1009
>>
>> Regards
>> harsh
>>
>> On 5 July 2017 at 15:30, Harsh Atal <harsh.atal@xxxxxxxxx> wrote:
>>
>>> Hi
>>>
>>> We have a tracked entity attribute which have a long description. The
>>> value type of that attribute is LONG TEXT. But when saving, it is not
>>> getting saved. Getting following error :
>>>
>>>
>>> httpStatus: "Conflict"
>>> httpStatusCode: 409
>>> message: "An error occurred, please check import summary."
>>> response: {responseType: "ImportSummaries", status: "ERROR", imported:
>>> 0, updated: 0, deleted: 0, ignored: 1,…}
>>> deleted: 0
>>> ignored: 1
>>> importOptions: {idSchemes: {}, dryRun: false, async: false,
>>> importStrategy: "CREATE_AND_UPDATE", mergeMode: "REPLACE",…}
>>> importSummaries: [{responseType: "ImportSummary", status: "ERROR",…}]
>>> 0: {responseType: "ImportSummary", status: "ERROR",…}
>>> conflicts: [,…]
>>> 0: {object: "Attribute.value", value: "Value length is greater than 255
>>> chars for attribute I2eCWfhryZH"}
>>> object: "Attribute.value"
>>> *value: "Value length is greater than 255 chars for attribute
>>> I2eCWfhryZH"*
>>> importCount: {imported: 0, updated: 0, ignored: 1, deleted: 0}
>>> importOptions: {idSchemes: {}, dryRun: false, async: false,
>>> importStrategy: "CREATE_AND_UPDATE", mergeMode: "REPLACE",…}
>>> reference: "C566538c153"
>>> responseType: "ImportSummary"
>>> status: "ERROR"
>>> imported: 0
>>> responseType: "ImportSummaries"
>>> status: "ERROR"
>>> updated: 0
>>> status: "ERROR"
>>>
>>>
>>> The length of column 'value' in trackedentityattributevalue table is
>>> 50000 characters but API does not accept more than 255 characters.
>>>
>>> Please look into this.
>>>
>>> Regards
>>> harsh
>>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>

References