SQL数据集更改字段类型后不能更新数据

提示com.finebi.common.exception.WrongTypeException

我是将原来的数据类型改成文本类型后,就不能更新数据集了

14:13:30 table-load-pool-3-thread-2 ERROR [standard] catch exception

com.finebi.common.exception.WrongTypeException: 类型不匹配,当前类型{R1}不是{R2}

at com.finebi.common.internalimp.config.driver.persist.utils.CheckAnalysisDriverTypeUtils.checkAnalysisDriverType(CheckAnalysisDriverTypeUtils.java:31)

at com.fr.engine.analysis.table.AnalysisTableSavaProcedure.saveTableInDistribute(AnalysisTableSavaProcedure.java:35)

at com.fr.engine.analysis.table.AnalysisTableSavaProcedure.process(AnalysisTableSavaProcedure.java:31)

at com.fr.engine.distribute.local.timerjob.task.load.FullLoad.load(FullLoad.java:79)

at com.fr.engine.distribute.local.timerjob.task.load.AbstractLoad.loadWithResult(AbstractLoad.java:35)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

14:14:01 table-load-pool-3-thread-10 ERROR [standard] cannot execute save

com.fr.third.org.hibernate.exception.DataException: error executing work

at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118)

at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:368)

at com.fr.third.org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2165)

at com.fr.third.org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2150)

at com.fr.stable.db.session.SessionManager$DBSessionImpl.doWork(Unknown Source)

at com.fr.config.dao.impl.BatchSubmitEntityDao$1.doInServer(Unknown Source)

at com.fr.config.dao.impl.BatchSubmitEntityDao$1.doInServer(Unknown Source)

at com.fr.config.dao.HibernateTemplate.doQuery(Unknown Source)

at com.fr.config.dao.impl.BatchSubmitEntityDao.onSubmit(Unknown Source)

at com.fr.config.dao.impl.HibernateObserver.fireCommit(Unknown Source)

at com.fr.transaction.HibernateTransactionManager.commit(Unknown Source)

at com.fr.transaction.FineConfigurationHelper.update(Unknown Source)

at com.fr.transaction.Configurations.update(Unknown Source)

at com.fr.engine.distribute.local.timerjob.generateinfo.DSGenerateInfoManager.addFinish(DSGenerateInfoManager.java:66)

at com.fr.engine.distribute.local.timerjob.generateinfo.DSGenerateInfoManager.putFinishDSGenerateInfo(DSGenerateInfoManager.java:58)

at com.fr.engine.distribute.local.timerjob.generateinfo.DSGenerateInfoManager.putDSGenerateInfo(DSGenerateInfoManager.java:50)

at com.fr.engine.distribute.local.timerjob.generateinfo.DSGenerateInfoManager.putDSGenerateInfo(DSGenerateInfoManager.java:32)

at com.finebi.spider.generate.DSGenerateInfoManagerDriver.putDSGenerateInfo(DSGenerateInfoManagerDriver.java:35)

at com.fr.engine.distribute.local.scheduler.taskListener.DSGenerateInfoTaskEventListener.success(DSGenerateInfoTaskEventListener.java:36)

at com.fr.engine.distribute.local.timerjob.task.load.FullLoad.commit(FullLoad.java:108)

at com.fr.engine.distribute.local.timerjob.task.load.AbstractLoad.loadWithResult(AbstractLoad.java:36)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation;  table: FINE_CONF_ENTITY column: VALUE

at com.fr.third.org.hsqldb.jdbc.JDBCStatement.executeBatch(JDBCStatement.java:1120)

at com.fr.third.alibaba.druid.pool.DruidPooledStatement.executeBatch(DruidPooledStatement.java:575)

at com.fr.config.submit.hanlder.NormalEntityHandler.process(Unknown Source)

at com.fr.config.dao.impl.BatchSubmitEntityDao$1$1.execute(Unknown Source)

at com.fr.third.org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)

at com.fr.third.org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2146)

at com.fr.third.org.hibernate.internal.SessionImpl$3.accept(SessionImpl.java:2143)

at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:363)

... 23 more


FineBI yazhou 发布于 2019-2-2 14:54 (编辑于 2019-2-2 14:55)
1min目标场景问卷 立即参与
回答问题
悬赏:5 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
yazhouLv6初级互助
发布于2019-2-2 16:00

BI5.0的1.10号的jar有问题 换成12.20的好了

最佳回答
0
皮卡皮卡丘Lv4中级互助
发布于2019-2-2 15:56

抽取的时候SQL处理或者公式对字段的处理检查一下

  • 1关注人数
  • 532浏览人数
  • 最后回答于:2019-2-2 16:00
    请选择关闭问题的原因
    确定 取消
    返回顶部