BI外接数据库导入数据失败

image.png

com.fr.third.org.hibernate.exception.SQLGrammarException: could not execute statement at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) 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(Unknown Source) at com.fr.decision.migration.manager.AbstractTransferManager.truncateTables(Unknown Source) at com.fr.decision.migration.manager.AbstractTransferManager.transfer(Unknown Source) at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(Unknown Source) at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(Unknown Source) at com.fr.decision.migration.MigrationContext$1.run(Unknown Source) at java.lang.Thread.run(Thread.java:748) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'BBRDS.QRTZ_PAUSED_TRIGGER_GRPS'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:328) 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) ... 14 more

FineBI 爱吃皮蛋的瘦肉猪 发布于 2021-5-24 10:02
1min目标场景问卷 立即参与
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
zsh331Lv8专家互助
发布于2021-11-23 18:19

-- 外接数据库配置常见问题-https://help.fanruan.com/finebi/doc-view-529.html

————————————————

image.png

最佳回答
0
Z4u3z1Lv6专家互助
发布于2021-5-24 10:16

image.png你的SQL SERVER是不是没这张表?

  • 爱吃皮蛋的瘦肉猪 爱吃皮蛋的瘦肉猪(提问者) BBRDS库里没这张好像.
    2021-05-24 10:33 
  • Z4u3z1 Z4u3z1 回复 爱吃皮蛋的瘦肉猪(提问者) 不要好像,要确定。包括视图文件 确定没得就把它剔出去
    2021-05-24 10:39 
  • 爱吃皮蛋的瘦肉猪 爱吃皮蛋的瘦肉猪(提问者) 没这张表为什么会报这个错
    2021-05-24 10:39 
  • Z4u3z1 Z4u3z1 回复 爱吃皮蛋的瘦肉猪(提问者) 你要获取这张表的数据,但是又找不到这表。要保证数据的一致性报错是最简单的处理方式
    2021-05-24 10:44 
  • 2关注人数
  • 331浏览人数
  • 最后回答于:2021-11-23 18:19
    请选择关闭问题的原因
    确定 取消
    返回顶部