请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
商鞅(uid:239475)
坚持即是胜利 职业资格认证:FCA-FineBI | FCP-报表开发工程师 | FCA-简道云
  • finebi安装好后,启动连接自定义数据库报错完整log如下,貌似是报 fine_conf_entity 表不存在导入数据失败收起信息返回重试com.fr.third.org.hibernate.exception.SQLGrammarException: could not execute statement at com.fr.third.org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) 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.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:91) at com.fr.third.org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:60) at com.fr.third.org.hibernate.hql.internal.ast.exec.DeleteExecutor.execute(DeleteExecutor.java:111) at com.fr.third.org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:429) at com.fr.third.org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:374) at com.fr.third.org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1360) at com.fr.third.org.hibernate.internal.QueryImpl.executeUpdate(QueryImpl.java:102) at com.fr.decision.migration.manager.AbstractTransferManager.truncateTable(AbstractTransferManager.java:433) at com.fr.decision.migration.manager.AbstractTransferManager.truncateTables(AbstractTransferManager.java:332) at com.fr.decision.migration.manager.AbstractTransferManager.transfer(AbstractTransferManager.java:239) at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(AbstractTransferManager.java:92) at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(MigrationContext.java:368) at com.fr.decision.migration.MigrationContext$1.run(MigrationContext.java:126) at java.lang.Thread.run(Thread.java:748)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'finedb.fine_conf_entity' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:403) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2136) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2070) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5187) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2055) at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255) at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204) ... 14 more
  • 各位大佬们好,目前我遇到一个业务上的问题,我们公司开发的业务系统 A。客户经理添加了客户,会在 MySQL 数据库里记录一条记录,记录了客户经理、客户、两者之间的状态(1有效,0无效),创建时间,修改时间。假如说客户把客户经理删了,会把这条记录的状态置为0,但记录始终只有一条。现在有一个业务需求,是展示客户经理近一月每天的客户总数趋势。按照目前数据的记录方法,怎么算都是有问题。目前我打算做的是:客户经理和客户之间每有一种操作导致状态变化,都会新增记录,但总感觉这么处理不太方便和优雅。各位大佬们有什么好的意见吗?
  • 如图所示

3

8

3

10

没有更多
个人成就
内容被浏览58,276
加入社区4年332天
返回顶部