{"action":"closed","issue":{"url":"https://api.github.com/repos/thingsboard/thingsboard/issues/355","repository_url":"https://api.github.com/repos/thingsboard/thingsboard","labels_url":"https://api.github.com/repos/thingsboard/thingsboard/issues/355/labels{/name}","comments_url":"https://api.github.com/repos/thingsboard/thingsboard/issues/355/comments","events_url":"https://api.github.com/repos/thingsboard/thingsboard/issues/355/events","html_url":"https://github.com/thingsboard/thingsboard/issues/355","id":266073970,"number":355,"title":"Unexpected error during ThingsBoard installation","user":{"login":"ohalushchak","id":12072661,"avatar_url":"https://avatars1.githubusercontent.com/u/12072661?v=4","gravatar_id":"","url":"https://api.github.com/users/ohalushchak","html_url":"https://github.com/ohalushchak","followers_url":"https://api.github.com/users/ohalushchak/followers","following_url":"https://api.github.com/users/ohalushchak/following{/other_user}","gists_url":"https://api.github.com/users/ohalushchak/gists{/gist_id}","starred_url":"https://api.github.com/users/ohalushchak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ohalushchak/subscriptions","organizations_url":"https://api.github.com/users/ohalushchak/orgs","repos_url":"https://api.github.com/users/ohalushchak/repos","events_url":"https://api.github.com/users/ohalushchak/events{/privacy}","received_events_url":"https://api.github.com/users/ohalushchak/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-10-17T10:31:56Z","updated_at":"2017-10-31T07:50:05Z","closed_at":"2017-10-31T07:50:05Z","author_association":"NONE","body":"I tried to install development environment and during execution of \"ThingsboardInstallApplication\" I have got an exception:\r\n\r\n`org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement\r\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:263)\r\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)\r\n\tat org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)\r\n\tat org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)\r\n\tat org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)\r\n\tat org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)\r\n\tat org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)\r\n\tat org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n\tat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)\r\n\tat com.sun.proxy.$Proxy89.save(Unknown Source)\r\n\tat org.thingsboard.server.dao.sql.JpaAbstractDao.save(JpaAbstractDao.java:62)\r\n\tat org.thingsboard.server.dao.sql.component.JpaBaseComponentDescriptorDao.saveIfNotExist(JpaBaseComponentDescriptorDao.java:69)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:498)\r\n\tat org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)\r\n\tat org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)\r\n\tat com.sun.proxy.$Proxy92.saveIfNotExist(Unknown Source)\r\n\tat org.thingsboard.server.dao.component.BaseComponentDescriptorService.saveComponent(BaseComponentDescriptorService.java:54)\r\n\tat org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.scanAndPersistComponent(AnnotationComponentDiscoveryService.java:146)\r\n\tat org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.persist(AnnotationComponentDiscoveryService.java:82)\r\n\tat org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.registerComponents(AnnotationComponentDiscoveryService.java:70)\r\n\tat org.thingsboard.server.service.component.AnnotationComponentDiscoveryService.discoverComponents(AnnotationComponentDiscoveryService.java:171)\r\n\tat org.thingsboard.server.install.ThingsboardInstallService.performInstall(ThingsboardInstallService.java:127)\r\n\tat org.thingsboard.server.ThingsboardInstallApplication.main(ThingsboardInstallApplication.java:44)\r\nCaused by: org.hibernate.exception.DataException: could not execute statement\r\n\tat org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)\r\n\tat org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)\r\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)\r\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)\r\n\tat org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)\r\n\tat org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)\r\n\tat org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2897)\r\n\tat org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3397)\r\n\tat org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)\r\n\tat org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)\r\n\tat org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)\r\n\tat org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)\r\n\tat org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)\r\n\tat org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)\r\n\tat org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)\r\n\tat org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)\r\n\tat org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)\r\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)\r\n\tat org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)\r\n\tat org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)\r\n\tat org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)\r\n\tat org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)\r\n\tat org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:61)\r\n\tat org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)\r\n\t... 30 common frames omitted\r\nCaused by: java.sql.SQLDataException: data exception: string data, right truncation;  table: COMPONENT_DESCRIPTOR column: CONFIGURATION_DESCRIPTOR\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)\r\n\tat org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)\r\n\tat org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)\r\n\t... 49 common frames omitted\r\nCaused by: org.hsqldb.HsqlException: data exception: string data, right truncation;  table: COMPONENT_DESCRIPTOR column: CONFIGURATION_DESCRIPTOR\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.Table.enforceTypeLimits(Unknown Source)\r\n\tat org.hsqldb.Table.generateAndCheckData(Unknown Source)\r\n\tat org.hsqldb.Table.insertSingleRow(Unknown Source)\r\n\tat org.hsqldb.StatementDML.insertSingleRow(Unknown Source)\r\n\tat org.hsqldb.StatementInsert.getResult(Unknown Source)\r\n\tat org.hsqldb.StatementDMQL.execute(Unknown Source)\r\n\tat org.hsqldb.Session.executeCompiledStatement(Unknown Source)\r\n\tat org.hsqldb.Session.execute(Unknown Source)\r\n\t... 52 common frames omitted\r\nCaused by: org.hsqldb.HsqlException: data exception: string data, right truncation\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.error.Error.error(Unknown Source)\r\n\tat org.hsqldb.types.CharacterType.convertToTypeLimits(Unknown Source)\r\n\t... 60 common frames omitted`"}}
{"actor":{"display_login":"ohalushchak"}}