Bug 1020318 - creation of custom info key with long key label fails with ISE
creation of custom info key with long key label fails with ISE
Status: NEW
Product: Red Hat Satellite 5
Classification: Red Hat
Component: WebUI (Show other bugs)
Unspecified Unspecified
unspecified Severity low
: ---
: ---
Assigned To: Tomas Lestach
Red Hat Satellite QA List
Depends On:
Blocks: 462714
  Show dependency treegraph
Reported: 2013-10-17 08:41 EDT by Jiří Mikulka
Modified: 2015-08-10 15:45 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Jiří Mikulka 2013-10-17 08:41:59 EDT
Description of problem:
When creating custom info key in WebUI with long key label (tested with 4000 chars long string), the action fails with ISE + traceback in catalina.out but positive info message is shown "Successfully added 1 custom key.".

Version-Release number of selected component (if applicable):
Satellite 5.6.0 @ EmbPostgreSQL @ RHEL6 x86_64 (Satellite-5.6.0-RHEL6-re20130927.0)

How reproducible:

Steps to Reproduce:
1. in WebUI: create new Custom Info Key (Systems -> Custom System Info -> create new key)
2. key label - something long (more than 64 characters)
3. check the webUI (ISE but info message saying that custom key has been created) + logs (traceback in catalina.out log)

Actual results:
Caused by: 
org.postgresql.util.PSQLException: ERROR: value too long for type character varying(64)
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2265)
	... 31 more

Expected results:
no ISE, but error message concerning about the length of key label
no traceback

Additional info:

Note You need to log in before you can comment on or make changes to this bug.