Value Type 'Long Text' is 255 characters ?

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

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@gmail.com 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

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@gmail.com wrote:

Please consider following pull request regarding above : https://github.com/dhis2/dhis2-core/pull/1009

Regards

harsh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 5 July 2017 at 15:30, Harsh Atal harsh.atal@gmail.com 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


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@gmail.com

Skype: calle_hedberg


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

···

On 5 July 2017 at 21:36, Calle Hedberg calle.hedberg@gmail.com 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@gmail.com wrote:

Please consider following pull request regarding above : https://github.com/dhis2/dhis2-core/pull/1009

Regards

harsh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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@gmail.com

Skype: calle_hedberg


On 5 July 2017 at 15:30, Harsh Atal harsh.atal@gmail.com 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