求助：外置数据库部署，导入数据时失败。

image.png

image.png

15:51:22 localhost-startStop-1 ERROR [standard] LOCAL_ENV is not exist for service !

15:51:23 Thread-11 ERROR [standard] /opt/tomcat-8.5.43/webapps/webroot/WEB-INF/assist/phantomjs can not found

15:51:23 CommonExecutor-1-thread-1 ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] testOnBorrow is true, validationQuery not set

15:51:24 localhost-startStop-1 ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] testOnBorrow is true, validationQuery not set

15:51:39 localhost-startStop-1 ERROR [standard] /opt/tomcat-8.5.43/webapps/webroot/WEB-INF/assist/phantomjs can not found

15:54:03 login_info-15-thread-1 ERROR [standard]

java.lang.NullPointerException

        at com.fr.plugin.decision.usage.utils.CommonUtils.getMACAddress(Unknown Source)

        at com.fr.plugin.decision.usage.utils.LoginInfoService.addInternal(Unknown Source)

        at com.fr.plugin.decision.usage.utils.LoginInfoService$1.run(Unknown Source)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        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)

15:56:57 Thread-49 ERROR [standard] could not execute statement

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.spi.id.TableBasedDeleteHandlerImpl.execute(TableBasedDeleteHandlerImpl.java:122)

        at com.fr.third.org.hibernate.hql.internal.ast.exec.MultiTableDeleteExecutor.execute(MultiTableDeleteExecutor.java:44)

        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)

...skipping...

15:56:57 Thread-49 ERROR [standard] could not execute statement

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.spi.id.TableBasedDeleteHandlerImpl.execute(TableBasedDeleteHandlerImpl.java:122)

        at com.fr.third.org.hibernate.hql.internal.ast.exec.MultiTableDeleteExecutor.execute(MultiTableDeleteExecutor.java:44)

        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:328)

        at com.fr.decision.migration.manager.AbstractTransferManager.truncateTables(AbstractTransferManager.java:241)

        at com.fr.decision.migration.manager.AbstractTransferManager.transfer(AbstractTransferManager.java:144)

        at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(AbstractTransferManager.java:63)

        at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(MigrationContext.java:255)

        at com.fr.decision.migration.MigrationContext$1.run(MigrationContext.java:107)

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

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'finebi.HT_fine_output_email' doesn't exist

        at sun.reflect.GeneratedConstructorAccessor148.newInstance(Unknown Source)

        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:425)

        at com.mysql.jdbc.Util.getInstance(Util.java:408)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)

        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)

        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)

        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)

        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)

        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)

        at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)

        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)

        at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:252)

        at com.fr.third.org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)

        ... 13 more
FineBI twoyang0917 发布于 2019-8-1 16:07 （编辑于 2019-8-1 16:21）
1min目标场景问卷 立即参与
回答问题
悬赏：5 F币 + 添加悬赏
举报
提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知
共3回答
最佳回答
0
JosieLinLv5见习互助
发布于2019-8-4 19:38

看这条：ERROR [com.fr.third.alibaba.druid.pool.DruidDataSource] testOnBorrow is true, validationQuery not set  阿里的druid连接池，显示testOnBorrow是正确的，但没有设置validationQuery

validationQuery是用来验证数据库连接的查询语句，这个查询语句必须是至少返回一条数据的SELECT语句。mysql的验证语句是select 1，需要在阿里的druid连接池里设置一下，详见https://my.oschina.net/xzfx/blog/478482
举报 收起评论(8)
  • twoyang0917 twoyang0917(提问者) 这个是帆软代码里面用了阿里druid连接池的库吧，我在哪里配呢？官方文档也没写啊？ 反正我就在db.script找到了一下这么两条，改了一下也没卵用。 -INSERT INTO FINE_CONF_ENTITY VALUES(\'ConnectionConfig.connections.BI Demo.dbcpAttr.validationQuery\',\'__EMPTY__\') +INSERT INTO FINE_CONF_ENTITY VALUES(\'ConnectionConfig.connections.BI Demo.dbcpAttr.validationQuery\',\'SELECT 1\') -INSERT INTO FINE_CONF_ENTITY VALUES(\'ConnectionConfig.connections.FRDemo.dbcpAttr.validationQuery\',\'__EMPTY__\') +INSERT INTO FINE_CONF_ENTITY VALUES(\'ConnectionConfig.connections.FRDemo.dbcpAttr.validationQuery\',\'SELECT 1\')
    2019-08-05 11:58 
  • twoyang0917 twoyang0917(提问者) 不是说开箱即用做的很好么，需要debug到这种程度？还是说是商业策略啊，试用没付钱就不给开外置数据库？
    2019-08-05 12:04 
  • JosieLin JosieLin 回复 twoyang0917(提问者) 不会吧，应该是你的数据库问题，我都是正常的使用外置数据库啊，现在用的很顺～
    2019-08-05 18:52 
  • JosieLin JosieLin 回复 twoyang0917(提问者) 你用的阿里数据库吧～
    2019-08-05 18:54 
  • twoyang0917 twoyang0917(提问者) 回复 JosieLin 用的是UCloud提供云数据库UDB。找帆软的同志支持了一下，原因是UCloud的UDB使用了GTID主从复制模式，让UCloud后台帮我们关掉了就好了。数据库初始化的姿势与GTID冲突了。。。 19/08/05 15:44:49 WARN Helper: unable to drop temporary id table after use [Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.] mysql> show variables like \'%gtid%\'; +----------------------------------+-----------+ | Variable_name | Value | +----------------------------------+-----------+ | binlog_gtid_simple_recovery | ON | | enforce_gtid_consistency | OFF | | gtid_executed_compression_period | 1000 | | gtid_mode | OFF | | gtid_next | AUTOMATIC | | gtid_owned | | | gtid_purged | | | session_track_gtids | OFF | +----------------------------------+-----------+ 8 rows in set (0.00 sec) 帆软的同志是不是得更新一下文档了？免得后面的人再趟这个坑。
    2019-08-06 16:21 
最佳回答
0
TCHLv3初级互助
发布于2019-8-1 17:26

从报错看是数据库的问题，看一下数据库的版本号是不是BI所支持的

https://help.finebi.com/doc-view-437.html


而且这个报错跟这篇文档里面的很像，可以参考下

https://help.finebi.com/doc-view-529.html
举报 收起评论(4)
  • twoyang0917 twoyang0917(提问者) MySQL 5.7 小版本没有那么精确的要求吧？不知道小版本号，用的云服务，Ucloud提供的UDB。 是InnoDB mysql> show engines\\G *************************** 1. row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 2. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables Transactions: NO XA: NO Savepoints: NO *************************** 3. row *************************** Engine: CSV Support: YES Comment: CSV storage engine Transactions: NO XA: NO Savepoints: NO *************************** 4. row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. row *************************** Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO
    2019-08-01 18:24 
  • TCH TCH 回复 twoyang0917(提问者) InnoDB没问题，八成是masql的锅，5.7坂本太新了，，目前只支持5.7.1.6。建议按照文档里面的推荐版本号重新下载一个masql的对应版本，看看能不能用，排除环境的因素
    2019-08-01 18:31 
  • twoyang0917 twoyang0917(提问者) 别闹，大哥。 mysql> show tables; +-----------------------------+ | Tables_in_finedb | +-----------------------------+ | QRTZ_BLOB_TRIGGERS | | QRTZ_CALENDARS | | QRTZ_CRON_TRIGGERS | | QRTZ_FIRED_TRIGGERS | | QRTZ_JOB_DETAILS | | QRTZ_LOCKS | | QRTZ_PAUSED_TRIGGER_GRPS | | QRTZ_SCHEDULER_STATE | | QRTZ_SIMPLE_TRIGGERS | | QRTZ_SIMPROP_TRIGGERS | | QRTZ_TRIGGERS | | fine_auth_preference | | fine_authority | | fine_authority_object | | fine_backup_node | mysql> desc fine_conf_entity; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | id | varchar(255) | NO | PRI | NULL | | | value | longtext | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> select * from fine_conf_entity limit 1; +------------------------------+-------+ | id | value | +------------------------------+-------+ | AppearanceConfig.colorScheme | 2 | +------------------------------+-------+ 1 row in set (0.00 sec) 表都很多都建出来了，数据也插进去了，八成是数据库初始化的脚本写呲了吧。
    2019-08-01 18:35 
  • twoyang0917 twoyang0917(提问者) mysql> select version(); +-----------------------+ | version() | +-----------------------+ | 5.7.16-ucloudrel1-log | +-----------------------+ 1 row in set (0.00 sec) 刚好是5.7.16，呵呵。
    2019-08-01 18:37 
最佳回答
0
用户x7811770Lv3见习互助
发布于2021-3-9 00:56

我这边碰到问题是新建的数据库用的是utf8mb4,老报错 could not execute statement,  换成utf8就正常了
  • 5关注人数
  • 1904浏览人数
    • 最后回答于：2021-3-9 00:56
    活动推荐 更多
    热门课程 更多
    请选择关闭问题的原因
    确定 取消
    隐私政策
    帆软用户服务协议
    联系管理员
    联系帆软
    Copyright© 帆软软件有限公司 版权所有
    苏ICP备18065767号
    返回顶部