FineBI 5.1.0添加sql数据集可以预览但是保存失败

我是社区第496368位番薯,欢迎点我头像关注我哦~
保存返回结果
{"errorCode":"500","errorMsg":"com.fr.transaction.ConfigException: java.lang.RuntimeException: com.fr.third.org.hibernate.exception.DataException: error executing work\r\n\tat com.fr.transaction.FineConfigurationHelper$3.call(Unknown Source)\r\n\tat com.fr.transaction.FineConfigurationHelper$3.call(Unknown Source)\r\n\tat com.fr.retry.AttemptTimeLimiters$NoAttemptTimeLimit.call(Unknown Source)\r\n\tat com.fr.retry.Retryer.call(Unknown Source)\r\n\tat com.fr.config.utils.Configs.execute(Unknown Source)\r\n\tat com.fr.transaction.FineConfigurationHelper.modify(Unknown Source)\r\n\tat com.fr.transaction.FineConfigurationHelper.update(Unknown Source)\r\n\tat com.fr.transaction.Configurations.update(Unknown Source)\r\n\tat com.fr.decision.webservice.v10.datasource.dataset.processor.impl.DataSetProcessorFactory.addTableDataSet(Unknown Source)\r\n\tat com.fr.decision.webservice.v10.datasource.dataset.ServerDataSetService.addServerDataSet(Unknown Source)\r\n\tat com.fr.web.controller.decision.api.dataset.DataSetResource.addDataSet(Unknown Source)\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 com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)\r\n\tat com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)\r\n\tat com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)\r\n\tat com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)\r\n\tat com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)\r\n\tat com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n\tat com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)\r\n\tat com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)\r\n\tat com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)\r\n\tat com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n\tat com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat com.fr.decision.base.DecisionServletInitializer$6.doFilterInternal(Unknown Source)\r\n\tat com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown Source)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)\r\n\tat com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n\tat org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)\r\n\tat org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n\tat org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)\r\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)\r\n\tat org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n\tat java.lang.Thread.run(Thread.java:748)\r\nCaused by: java.lang.RuntimeException: com.fr.third.org.hibernate.exception.DataException: error executing work\r\n\tat com.fr.config.dao.impl.BatchSubmitEntityDao$1.doInServer(Unknown Source)\r\n\tat com.fr.config.dao.impl.BatchSubmitEntityDao$1.doInServer(Unknown Source)\r\n\tat com.fr.config.dao.HibernateTemplate.doQuery(Unknown Source)\r\n\tat com.fr.config.dao.impl.BatchSubmitEntityDao.onSubmit(Unknown Source)\r\n\tat com.fr.config.dao.impl.HibernateObserver.fireCommit(Unknown Source)\r\n\tat com.fr.transaction.HibernateTransactor.fireCommit(Unknown Source)\r\n\tat com.fr.transaction.HibernateTransactor.commit(Unknown Source)\r\n\t... 60 more\r\nCaused by: com.fr.third.org.hibernate.exception.DataException: error executing work\r\n\tat com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118)\r\n\tat com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)\r\n\tat com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)\r\n\tat com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)\r\n\tat com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:368)\r\n\tat com.fr.third.org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2165)\r\n\tat com.fr.third.org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2150)\r\n\tat com.fr.stable.db.session.SessionManager$DBSessionImpl.doWork(Unknown Source)\r\n\t... 67 more\r\nCaused by: java.sql.BatchUpdateException: data exception: string data, right truncation;  table: FINE_CONF_ENTITY column: VALUE\r\n\tat com.fr.third.org.hsqldb.jdbc.JDBCStatement.executeBatch(JDBCStatement.java:1120)\r\n\tat com.fr.third.alibaba.druid.pool.DruidPooledStatement.executeBatch(DruidPooledStatement.java:575)\r\n\tat com.fr.config.submit.hanlder.NormalEntityHandler.process(Unknown Source)\r\n\tat com.fr.config.dao.impl.BatchSubmitEntityDao$1$1.execute(Unknown Source)\r\n\tat com.fr.third.org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)\r\n\tat com.fr.third.org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2146)\r\n\tat com.fr.third.org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2143)\r\n\tat com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:363)\r\n\t... 70 more\r\n"}
编辑于 2020-9-25 15:45  

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

0回帖数 1关注人数 2579浏览人数
最后回复于:2020-9-25 15:45

返回顶部 返回列表