UI Designer allows names > 50 chars

Description

hi Philippe,

when using long page names I get a failure log as follows when trying to deploy the process.

Summarized to one point...

*Caused by: org.h2.jdbc.JdbcSQLException.: Value too long for column "NAME VARCHAR_IGNORECASE(50) NOT NULL": *

UI Designer should limit the length of the name automatically rather than allow > 50 char page names...

maybe use maxlength="10" parameter on the input statement? :0

regards
Seán

{{USERNAME=walter.bates | org.bonitasoft.engine.transaction.STransactionCommitException: bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown during beforeCompletion cycle caused transaction rollback
org.bonitasoft.engine.api.HTTPServerAPI.invokeMethod(HTTPServerAPI.java:143)
org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
com.sun.proxy.$Proxy67.deploy(Unknown Source)
org.bonitasoft.studio.engine.operation.DeployProcessOperation.deployProcess(DeployProcessOperation.java:193)
org.bonitasoft.studio.engine.operation.DeployProcessOperation.deploy(DeployProcessOperation.java:168)
org.bonitasoft.studio.engine.operation.DeployProcessOperation.run(DeployProcessOperation.java:121)
org.bonitasoft.studio.engine.operation.RunProcessOperation.run(RunProcessOperation.java:80)
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
< ========== Beginning of the server stack trace ========== >. ( )
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:146)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServletCall.doPost(HttpAPIServletCall.java:112)
org.bonitasoft.engine.api.internal.servlet.HttpAPIServlet.doPost(HttpAPIServlet.java:35)
javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.transaction.STransactionCommitException.: bitronix.tm.internal.BitronixRollbackException: RuntimeException thrown during beforeCompletion cycle caused transaction rollback ( )
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.commit(JTATransactionServiceImpl.java:209)
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.complete(JTATransactionServiceImpl.java:174)
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:328)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:443)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:278)
org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:131)
... 30 more. ( )
Caused by: bitronix.tm.internal.BitronixRollbackException.: RuntimeException thrown during beforeCompletion cycle caused transaction rollback ( )
bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:241)
bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:143)
org.bonitasoft.engine.transaction.JTATransactionServiceImpl.commit(JTATransactionServiceImpl.java:207)
... 35 more. ( )
Caused by: org.hibernate.exception.DataException.: could not execute statement ( )
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)
org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1159)
org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)
org.hibernate.engine.transaction.synchronization.internal.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:105)
org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:53)
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:532)
bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:235)
... 37 more. ( )
Caused by: org.h2.jdbc.JdbcSQLException.: Value too long for column "NAME VARCHAR_IGNORECASE(50) NOT NULL": "CAST('custompage_canweaddurlinsideadynamicallygeneratedTableTableWidgetwhichredirectstoprocessanewtask' AS VARCHAR_IGNORECASE) (96)"; SQL statement:
insert into page (name, displayName, description, installationDate, installedBy, provided, lastModificationDate, lastUpdatedBy, contentName, content, contentType, processDefinitionId, tenantId, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-170] ( ). ( )
org.h2.engine.SessionRemote.done(SessionRemote.java:568)
org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:181)
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156)
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142)
sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
com.sun.proxy.$Proxy66.executeUpdate(Unknown Source)
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186)
... 52 more. ( )
}}

Environment

Windows 10, Java - Latest

External Link

None

Workaround

None

Assignee

Antoine Mottier

Reporter

Sean McPoland

Affects versions

Reference

BS-18911

Fix versions

Configure