Project

General

Profile

Actions

Defect #2754

closed

Wrong message for character limit on the role request detail

Added by Ondřej Kopr almost 3 years ago. Updated over 2 years ago.


Description

Use case:
  • user put description for his new role request,
  • the description contains to many characters,
  • after role request save/execute will be shown message about some duplicit.

Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:136)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
    ... 214 common frames omitted

Beware in older version IdM will be removed whole request.


Files

message.png (40.9 KB) message.png Ondřej Kopr, 04/14/2021 05:07 PM
Actions #1

Updated by Radek Tomiška almost 3 years ago

  • Assignee changed from Radek Tomiška to Vít Švanda
Actions #2

Updated by Vít Švanda almost 3 years ago

  • Assignee changed from Vít Švanda to Ondrej Husník
  • Target version set to 11.1.0
Actions #3

Updated by Ondrej Husník almost 3 years ago

  • Estimated time set to 4.00 h

The goal is to extend limit to 2000 chars in flyway and set correct error message

Actions #5

Updated by Ondrej Husník almost 3 years ago

  • Status changed from New to In Progress
Actions #6

Updated by Ondrej Husník almost 3 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Ondrej Husník to Radek Tomiška
  • % Done changed from 0 to 90

The wrong message is not necessary to be solved. It's treated by setting FE validation. Beside this without FE validation a message with the proper description would be also displayed thanks to the added size annotation. Flyway script was tested also in mssql.

Please could you provide me the feedback?
https://github.com/bcvsolutions/CzechIdMng/commit/74a8fcc3c2379c2bcfa277413bb3d3c2a3be2662

Actions #7

Updated by Radek Tomiška almost 3 years ago

  • Assignee changed from Radek Tomiška to Vít Švanda
Actions #8

Updated by Vít Švanda over 2 years ago

  • Status changed from Needs feedback to Resolved
  • Assignee changed from Vít Švanda to Ondrej Husník

I did review and tested it. Works well. Thanks for that.

Actions #9

Updated by Radek Tomiška over 2 years ago

  • Status changed from Resolved to Closed
  • % Done changed from 90 to 100
Actions

Also available in: Atom PDF