Skip to content

Problem while saving map details #11136

@tdipisa

Description

@tdipisa

Description

After recent tests a bug was notified while saving map details. It seems I cannot reproduce so far on both DEV and QA when I created maps linked below but sometimes yes on the MS binary 2025.01.xx. To be investigated.

This bug seems reproducible only in the homepage by saving twice the About section without closing the panel and including an embedded image or a long text (eg: the one provided in the step below). Here a video:

  • The map is named Map-test-details- (#/viewer/55378)
details-error.mp4

How to reproduce

Expected Result

Details are saved without problems

Current Result

The following error sometime occurs

Image

When happening in the binary the following is logged which lead to think the problem is on the DB schema but it should not be because the details should not be saved in a resource attribute

        Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "ATTRIBUTE_TEXT VARCHAR(255)": "STRINGDECODE('<p>La mappa, realizzata dall''Ufficio SIT del Comune di Genova, permette di consultare i dati delle elezioni.</p>\... (411614)"; SQL statement:
insert into public.gs_attribute (attribute_date, name, attribute_number, resource_id, attribute_text, attribute_type, id) values (?, ?, ?, ?, ?, ?, ?) [22001-175]
                at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
                at org.h2.message.DbException.get(DbException.java:172)
                at org.h2.table.Column.validateConvertUpdateSequence(Column.java:317)
                at org.h2.table.Table.validateConvertUpdateSequence(Table.java:713)
                at org.h2.command.dml.Insert.insertRows(Insert.java:152)
                at org.h2.command.dml.Insert.update(Insert.java:115)
                at org.h2.command.CommandContainer.update(CommandContainer.java:79)
                at org.h2.command.Command.executeUpdate(Command.java:253)
                at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154)
                at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140)
                at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
                at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
                ... 146 more

  • Not browser related
Browser info (use this site: https://www.whatsmybrowser.org/ for non expert users)
Browser Affected Version
Internet Explorer
Edge
Chrome
Firefox
Safari

Other useful information

Metadata

Metadata

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions