[BUG]

[chenquanhao]

Bug描述
不定时，有实体获取不到数据

日志
Logger: custom_components.china_southern_power_grid_stat.sensor
Source: custom_components/china_southern_power_grid_stat/sensor.py:401
Integration: China Southern Power Grid Statistics (documentation, issues)
First occurred: 2023年11月23日 21:38:09 (18 occurrences)
Last logged: 13:38:29

Error fetching data in coordinator: API error, function get_month_daily_cost_detail, <CSGAPIError sta=02 message=深圳电费日历查询返回:营销接口异常：营销系统：10001-服务调用异常,执行数据库查询出错!查询语句： SELECT F.YHBH PARAM1, F.DJBBBH, F.DJDM, F.JLDBH PARAM2, TRUNC(F.CSRQ-1, 'DD') PARAM3, NVL(F.JFDL, 0) - NVL(NVL((SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM4, NVL(F.ZDF, 0) - NVL(NVL((SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM5, NVL(F.ZDF,0) PARAM6, NVL(F.JFDL,0) PARAM7, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('11','21') AND X.DFLBDM = '10') PARAM20, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('12', '22') AND X.DFLBDM = '10') PARAM21, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('13', '23') AND X.DFLBDM = '10') PARAM22, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM23, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM24, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM25, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM26, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM27, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM28, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM29, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM30, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM31, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM32, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM33, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM34 , F.CBRQ PARAM35, (SELECT TRUNC(A.CBSJ) FROM LC_SCCBXX A WHERE A.DQBM = F.DQBM AND A.YHBH = F.YHBH) PARAM36 FROM HS_FK_JLDXX@null F WHERE F.DQBM = ? AND F.YHBH = ? AND F.JLDBH = ? AND F.CSRQ >= ? AND F.CSRQ <= ? ORDER BY F.CSRQ ，查询参数：[030900, 0309160061328903, 1111111118030663, 2023-11-01 00:00:00.0, 2023-12-01 00:00:00.0][WEB:server173jk2;EJB:serverejb42_wbjcear4]>
Error fetching data in coordinator: API error, function get_month_daily_cost_detail, <CSGAPIError sta=02 message=深圳电费日历查询返回:营销接口异常：营销系统：10001-服务调用异常,执行数据库查询出错!查询语句： SELECT F.YHBH PARAM1, F.DJBBBH, F.DJDM, F.JLDBH PARAM2, TRUNC(F.CSRQ-1, 'DD') PARAM3, NVL(F.JFDL, 0) - NVL(NVL((SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM4, NVL(F.ZDF, 0) - NVL(NVL((SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM5, NVL(F.ZDF,0) PARAM6, NVL(F.JFDL,0) PARAM7, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('11','21') AND X.DFLBDM = '10') PARAM20, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('12', '22') AND X.DFLBDM = '10') PARAM21, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('13', '23') AND X.DFLBDM = '10') PARAM22, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM23, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM24, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM25, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM26, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM27, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM28, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM29, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM30, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM31, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM32, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM33, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM34 , F.CBRQ PARAM35, (SELECT TRUNC(A.CBSJ) FROM LC_SCCBXX A WHERE A.DQBM = F.DQBM AND A.YHBH = F.YHBH) PARAM36 FROM HS_FK_JLDXX@null F WHERE F.DQBM = ? AND F.YHBH = ? AND F.JLDBH = ? AND F.CSRQ >= ? AND F.CSRQ <= ? ORDER BY F.CSRQ ，查询参数：[030900, 0309160061328903, 1111111118030663, 2023-11-01 00:00:00.0, 2023-12-01 00:00:00.0][WEB:server173jk4;EJB:serverejb42_wbjcear6]>
Error fetching data in coordinator: API error, function get_month_daily_cost_detail, <CSGAPIError sta=02 message=深圳电费日历查询返回:营销接口异常：营销系统：10001-服务调用异常,执行数据库查询出错!查询语句： SELECT F.YHBH PARAM1, F.DJBBBH, F.DJDM, F.JLDBH PARAM2, TRUNC(F.CSRQ-1, 'DD') PARAM3, NVL(F.JFDL, 0) - NVL(NVL((SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM4, NVL(F.ZDF, 0) - NVL(NVL((SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM5, NVL(F.ZDF,0) PARAM6, NVL(F.JFDL,0) PARAM7, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('11','21') AND X.DFLBDM = '10') PARAM20, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('12', '22') AND X.DFLBDM = '10') PARAM21, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('13', '23') AND X.DFLBDM = '10') PARAM22, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM23, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM24, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM25, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM26, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM27, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM28, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM29, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM30, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM31, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM32, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM33, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM34 , F.CBRQ PARAM35, (SELECT TRUNC(A.CBSJ) FROM LC_SCCBXX A WHERE A.DQBM = F.DQBM AND A.YHBH = F.YHBH) PARAM36 FROM HS_FK_JLDXX@null F WHERE F.DQBM = ? AND F.YHBH = ? AND F.JLDBH = ? AND F.CSRQ >= ? AND F.CSRQ <= ? ORDER BY F.CSRQ ，查询参数：[030900, 0309160061328903, 1111111118030663, 2023-11-01 00:00:00.0, 2023-12-01 00:00:00.0][WEB:server56jk3;EJB:serverejb41_wbjcear2]>
Error fetching data in coordinator: API error, function get_month_daily_cost_detail, <CSGAPIError sta=02 message=深圳电费日历查询返回:营销接口异常：营销系统：10001-服务调用异常,执行数据库查询出错!查询语句： SELECT F.YHBH PARAM1, F.DJBBBH, F.DJDM, F.JLDBH PARAM2, TRUNC(F.CSRQ-1, 'DD') PARAM3, NVL(F.JFDL, 0) - NVL(NVL((SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM4, NVL(F.ZDF, 0) - NVL(NVL((SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM5, NVL(F.ZDF,0) PARAM6, NVL(F.JFDL,0) PARAM7, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('11','21') AND X.DFLBDM = '10') PARAM20, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('12', '22') AND X.DFLBDM = '10') PARAM21, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('13', '23') AND X.DFLBDM = '10') PARAM22, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM23, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM24, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM25, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM26, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM27, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM28, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM29, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM30, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM31, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM32, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM33, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM34 , F.CBRQ PARAM35, (SELECT TRUNC(A.CBSJ) FROM LC_SCCBXX A WHERE A.DQBM = F.DQBM AND A.YHBH = F.YHBH) PARAM36 FROM HS_FK_JLDXX@null F WHERE F.DQBM = ? AND F.YHBH = ? AND F.JLDBH = ? AND F.CSRQ >= ? AND F.CSRQ <= ? ORDER BY F.CSRQ ，查询参数：[030900, 0309160061328903, 1111111118030663, 2023-11-01 00:00:00.0, 2023-12-01 00:00:00.0][WEB:server173jk2;EJB:serverejb41_wbjcear2]>
Error fetching data in coordinator: API error, function get_month_daily_cost_detail, <CSGAPIError sta=02 message=深圳电费日历查询返回:营销接口异常：营销系统：10001-服务调用异常,执行数据库查询出错!查询语句： SELECT F.YHBH PARAM1, F.DJBBBH, F.DJDM, F.JLDBH PARAM2, TRUNC(F.CSRQ-1, 'DD') PARAM3, NVL(F.JFDL, 0) - NVL(NVL((SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.JFDL) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM4, NVL(F.ZDF, 0) - NVL(NVL((SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = F.CSRQ - 1 AND B.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ), (SELECT SUM(B.ZDF) FROM HS_FK_JLDXX@null B WHERE B.YHBH = F.YHBH AND B.JLDBH = F.JLDBH AND B.CSRQ = (SELECT MAX(C.CSRQ) FROM HS_FK_JLDXX@null C WHERE C.YHBH = F.YHBH AND C.JLDBH = F.JLDBH AND C.CSRQ <= F.CSRQ - 1 AND C.CSRQ > F.SCCBRQ AND B.SCCBRQ = F.SCCBRQ))),0) PARAM5, NVL(F.ZDF,0) PARAM6, NVL(F.JFDL,0) PARAM7, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('11','21') AND X.DFLBDM = '10') PARAM20, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('12', '22') AND X.DFLBDM = '10') PARAM21, (SELECT NVL(MAX(X.DL),0) FROM HS_FK_LJFMX@null X WHERE F.GZDBH = X.GZDBH AND X.JLDBH = F.JLDBH AND X.DQBM = F.DQBM AND X.DLFDDM IN ('13', '23') AND X.DFLBDM = '10') PARAM22, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM23, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM24, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM25, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '11' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM26, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '12' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM27, (SELECT NVL(SUM(T.DJ),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '13' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM28, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM29, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM30, (SELECT NVL(MAX(T.FZSX),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.DJGCDM = '10') PARAM31, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '21' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM32, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '22' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM33, (SELECT NVL(TO_CHAR(SUM(T.DJ),'FM9990.999'),0) FROM HS_DJMX T WHERE T.BBBH = F.DJBBBH AND T.DLFDDM = '23' AND T.DJDM = F.DJDM AND T.SDLX = '0' AND T.DJGCDM NOT IN ('20', '21')) PARAM34 , F.CBRQ PARAM35, (SELECT TRUNC(A.CBSJ) FROM LC_SCCBXX A WHERE A.DQBM = F.DQBM AND A.YHBH = F.YHBH) PARAM36 FROM HS_FK_JLDXX@null F WHERE F.DQBM = ? AND F.YHBH = ? AND F.JLDBH = ? AND F.CSRQ >= ? AND F.CSRQ <= ? ORDER BY F.CSRQ ，查询参数：[030900, 0309160061328903, 1111111118030663, 2023-11-01 00:00:00.0, 2023-12-01 00:00:00.0][WEB:server173jk2;EJB:serverejb41_wbjcear6]>

版本信息:

• HA2023.11.3
• 插件1.1.2

[d4rkblue]

最近我也出现这个情况，最早是11月26号出现的。

[luyueyi]

同样问题，基本上只能每天不定时有上一天的用电数，其它实体均显示为未知状态。坐标佛山，日志同样显示的是深圳的电费日历

[qcgzxw]

同样问题 月初出现 无法获取数据