[overlord-issues] [JBoss JIRA] (RTGOV-359) "Value too long" error when storing resubmit failure result

[Michael Clay (JIRA)]

    [ https://issues.jboss.org/browse/RTGOV-359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12948596#comment-12948596 ] 

Michael Clay commented on RTGOV-359:
------------------------------------

i think option 2 is the way to go but why not also increase the column length because 250 chars are not much for a stacktrace? pls note that there are already 2 result properties to differentiate between successful (resubmitResult = OK )and 'erroneous' resubmit (resubmitFailure = stacktrace)
                
> "Value too long" error when storing resubmit failure result
> -----------------------------------------------------------
>
>                 Key: RTGOV-359
>                 URL: https://issues.jboss.org/browse/RTGOV-359
>             Project: RTGov (Run Time Governance)
>          Issue Type: Bug
>          Components: User Interface
>            Reporter: Gary Brown
>            Assignee: Michael Clay
>
> Related to RTGOV-332.
> When a failure occurs resubmitting the message, the result is stored in a property associated with the situation. However there is a length restriction of VARCHAR(255) on this field:
> 10:08:01,249 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-3) Value too long for column "VALUE VARCHAR(255)": "STRINGDECODE('org.overlord.rtgov.ui.client.model.UiException: org.switchyard.HandlerException: SWITCHYARD014000: Validator ''org... (12795)"; SQL statement:
> insert into RTGOV_SITUATION_PROPERTIES (id, name, value) values (?, ?, ?) [22001-168]
> The original intention of the result field was to report whether the message had been resubmitted successfully or not. Therefore we have a few options:
> 1) Just report 'successful' or 'failed' in this field - however this doesn't give an indication of why the resubmit failed. Although the failure is reported at the time when the resubmit is performed, so just depends whether we actually want the resubmission error to be persisted?
> 2) Truncate the error message - probably 250 characters would be enough anyway? However we should prefix the result with "Failed: ".
> Probably option 2 is best, although need to also ensure that a 'Successful' result is also recorded.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira