Bi查询的时候命中了mcMCQA功能报错
Bi查询的时候命中了mcMCQA功能报错
现象: 客户在使用阿里云数据源的时候抽取的时候没有命中mcMCQA导致报错
报错信息:
<#9f1444b5> java.sql.SQLException: Fail to run sql:select * from (\nSELECT \n sum(sc.collect_count) / sum(sc.delivery_count) AS "揽收率" \nFROM \n snt_clairvoyant_express_order_delivery_statistics sc \nWHERE \n sc.partner_type = '${partnertype}' \n AND sc.region_name = '${regionname}' \n AND sc.warehouse_name = '${warehousename}' \n AND sc.accountperiod >= '${accountperiod.get(0)}' \n AND sc.accountperiod <= '${accountperiod.get(1)}'\n) user_defined_view limit 0;, Error:com.aliyun.odps.OdpsException: ODPS-1800001: Session exception - F <skipped> at com.aliyun.odps.jdbc.OdpsStatement.runSQL(OdpsStatement.java:922) at com.aliyun.odps.jdbc.OdpsStatement.executeQuery(OdpsStatement.java:334) at c.n.y.d.ContextHandler.executeQuery(ContextHandler.java:107) at c.n.y.d.w.a.t.TimerAspect.doAround(TimerAspect.java:36) at c.n.y.d.d.BaseDaoImpl.executeQuery(BaseDaoImpl.java:806) Caused by: <#ce1cc801> com.aliyun.odps.OdpsException: ODPS-1800001: Session exception - Failed to submit sub-query in session because:Prepaid project run out of free query quota. at com.aliyun.odps.sqa.SQLExecutorImpl.handleSessionException(SQLExecutorImpl.java:503) at com.aliyun.odps.sqa.SQLExecutorImpl.runInSessionWithRetry(SQLExecutorImpl.java:727) at com.aliyun.odps.sqa.SQLExecutorImpl.runQueryInternal(SQLExecutorImpl.java:766) at com.aliyun.odps.sqa.SQLExecutorImpl.run(SQLExecutorImpl.java:466) at com.aliyun.odps.jdbc.OdpsStatement.runSQLInSession(OdpsStatement.java:862)
解决方式:是因为MCQA客户没有充钱,每天只有一些免费额度.需要在有数数据连接处配置参数 回退到正常任务. 在对应的数据连接处提添加该参数alwaysFallback即可
配置方式:在有数对应的数据连接处配置参数然后保存即可 如下图
以上内容对您是否有帮助?