[ABI 5.1] 运行SQL没有变化

57
6

lin786682931 初学数据Lv2

发表于2021-2-23 17:02

悬赏1

已解决

楼主
我主题表设置的不是下面那段SQL,为啥运行出来是我这段,这个分析报表是从老的写好的报表复制出来的,下面的SQL是原报表的,请问是哪里连接有问题么,或者数据源绑定有问题?


2021-02-23 16:59:50 开始计算报表:COPYOF_B69033(内存情况:FREE=36.2M TOTAL=210M MAX=228M)

使用主题表:采购订单未交预警的内存缓存数据
获取主题表:采购订单未交预警的数据并加载到内存中进行缓存
开始加载SQL主题采购订单未交预警数据到内存
结束加载SQL主题:采购订单未交预警数据到内存,耗时:23毫秒(开始时间:2021-02-23 16:59:50.764,结束时间:2021-02-23 16:59:50.787),共尝试加载911条数据到ESISCGDDWJYJ
2021-02-23 16:59:50.654 使用主题表:采购订单未交预警的内存缓存数据
2021-02-23 16:59:50.654 获取主题表:采购订单未交预警的数据并加载到内存中进行缓存
2021-02-23 16:59:50.764 开始加载SQL主题采购订单未交预警数据到内存
2021-02-23 16:59:50.764 结束加载SQL主题:采购订单未交预警数据到内存,耗时:23毫秒(开始时间:2021-02-23 16:59:50.764,结束时间:2021-02-23 16:59:50.787),共尝试加载911条数据到ESISCGDDWJYJ
2021-02-23 16:59:50 引用的主题表: 采购订单未交预警, 进料检验完成待入库
2021-02-23 16:59:50 查询的数据级次范围:没有做限制。
2021-02-23 16:59:50 001开始多表格各分析区并行计算
2021-02-23 16:59:50 [GRID2(0.0.10.1)]正在生成SQL...
2021-02-23 16:59:50 [GRID2(0.0.10.1)]计算表格GRID2
2021-02-23 16:59:50 [GRID2(0.0.10.1)]生成SQL耗时14毫秒
2021-02-23 16:59:50 [GRID2(0.0.10.1)]当前连接池为【e10】,执行SQL:
select top 100000 a.A1 as A1,b.C1 as C1,b.D1 as D1,b.E1 as E1,b.F1 as F1,b.G1 as G1,b.H1 as H1,b.I1 as I1,b.J1 as J1
from (
select MAX(a.col10) as A1
from (SELECT              
A.DOC_NO AS col01,              
ITEM.ITEM_CODE AS col02,              
ITEM.ITEM_NAME AS col03,              
ITEM.ITEM_SPECIFICATION AS col04 ,  
ITEM_LOT.LOT_CODE AS col11,            
B.BUSINESS_QTY AS col05,              
(B.ACCEPTED_BUSINESS_QTY+B.SP_RECEIPT_BUSINESS_QTY -B.RECEIPTED_BUSINESS_QTY )AS col06,              
ISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col07,              
ISNULL(SUPPLIER_NAME,'') AS col08,              
CONVERT(varchar(100), PO_QC_RESULT.CreateDate,23) AS col09,              
ISNULL(WAREHOUSE.WAREHOUSE_CODE ,'')AS col10,              
datediff(second, PO_QC_RESULT.CreateDate,GETDATE()) as col12              
FROM              
PURCHASE_ARRIVAL AS A              
LEFT JOIN PURCHASE_ARRIVAL_D AS B              
ON B.PURCHASE_ARRIVAL_ID = A.PURCHASE_ARRIVAL_ID              
LEFT JOIN ITEM               
ON ITEM.ITEM_BUSINESS_ID=B.ITEM_ID              
LEFT JOIN SUPPLIER              
ON SUPPLIER.SUPPLIER_BUSINESS_ID=A.SUPPLIER_ID              
LEFT JOIN PLANT               
ON PLANT.PLANT_ID=A.RECEIVE_Owner_Org_ROid              
LEFT JOIN dbo.WAREHOUSE              
ON WAREHOUSE.WAREHOUSE_ID=B.WAREHOUSE_ID   
left join ITEM_LOT
ON ITEM_LOT.ITEM_LOT_ID=B.ITEM_LOT_ID   
left join PO_QC_RESULT
on PO_QC_RESULT.SOURCE_ID_ROid=B.PURCHASE_ARRIVAL_D_ID  
left join PO_QC_RESULT_D
on PO_QC_RESULT.PO_QC_RESULT_ID=PO_QC_RESULT_D.PO_QC_RESULT_ID   
WHERE A.ApproveStatus='Y'              
AND (B.ACCEPTED_BUSINESS_QTY+B.SP_RECEIPT_BUSINESS_QTY -B.RECEIPTED_BUSINESS_QTY ) >0              
AND B.RECEIPT_CLOSE='0'              
AND PLANT_CODE='1'
) a) a
,(
select MAX(a.DOC_NO) as C1,MAX(a.PROJECT_CODE) as D1,MAX(a.ITEM_CODE) as E1,MAX(a.ITEM_NAME) as F1,MAX(a.ITEM_SPECIFICATION) as G1,sum(a.BUSINESS_QTY) as H1,sum(a.WDHL) as I1,MAX(a.PLAN_ARRIVAL_DATE) as J1
from ESISCGDDWJYJ a) b
java.lang.RuntimeException: 对象名 'ESISCGDDWJYJ' 无效。
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
  at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
  at com.esen.jdbc.pool.PooledStatement.executeQuery(PooledStatement.java:44)
  at com.esen.jdbc.pool.impl.mssql.MssqlPooledStatement.executeQuery(MssqlPooledStatement.java:20)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.queryData(OlapResultMultImpl.java:421)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.doit(OlapResultMultImpl.java:237)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.(OlapResultMultImpl.java:104)
  at com.esen.ebibase.rptbase.calc.db.top.CalcOlapResult.calcGroupOlap(CalcOlapResult.java:78)
  at com.esen.ebibase.rptbase.calc.impl.GroupOlapEngine.calc(GroupOlapEngine.java:35)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.calcOlap(OLTPResultManager.java:533)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpResult(OLTPResultManager.java:522)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData4AutoOlap(OLTPResultManager.java:155)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData(OLTPResultManager.java:88)
  at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportCalc.getOltpData(FxBaseAnalyseReportCalc.java:494)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.getOltpData(FloatFxqCalc.java:253)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.getOltpData(FloatFxqInnerCalc.java:79)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1173)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_zbsInFxq(FloatFxqInnerCalc.java:480)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult(FloatFxqInnerCalc.java:154)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.calc(FloatFxqInnerCalc.java:58)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:249)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FixRectInFxqResultImpl.processResult(FixRectInFxqResultImpl.java:44)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.processResult(RectsInFxqResultImpl.java:101)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqResultImpl.processResult(FloatFxqResultImpl.java:93)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:86)
  at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)
  at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:105)
  at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
  at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
  at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
  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)
Caused by: com.esen.jdbc.pool.impl.mssql.MssqlPooledSQLException: 对象名 'ESISCGDDWJYJ' 无效。
  ... 42 more



页面地址为:【[url=]/abi/ebibase/js/reqmgr.do?action=calcnew;taskid=1b6537ab18464f50b7f812d207753bdc;exttype=rpttpl;rptcontent="{""id"":""TTU73WPSNK35UEBTUOC74LJUFSTCTYUK"",""tagname"":""page"",""option"":{""bgimg_repeat"":""no-repeat"",""maxcount"":57,""maxgridcount"":2,""grp"":""EANA$1$9978aee77af547c4a44ec172e07d80a6"",""childindexs"":""WidgetPageLayout91,PAGEFLOAT"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""top"":""0px"",""left"":""0px"",""ismini"":""false"",""isextend"":""false"",""menutemplate"":""blank.txt"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""databack"":""false"",""disabled"":false,""oldpagebar"":true,""taskid"":""1b6537ab18464f50b7f812d207753bdc"",""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""COPYOF_B69033"",""caption"":""采购订单未交预警"",""type"":""pagetpl""},""childnodes"":{""WidgetPageLayout91"":{""id"":""WidgetPageLayout91"",""tagname"":""WidgetPageLayout"",""option"":{""bgimg_repeat"":""no-repeat"",""enableSelect"":""false"",""vertalign"":""top"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""WidgetPageLayout""},""childnodes"":{""toparea"":{""id"":""toparea"",""tagname"":""WidgetArea"",""option"":{""bgimg_repeat"":""no-repeat"",""Cross_border"":10,""vertalign"":""top"",""horzindent"":0,""borderbottom"":{""width"":1,""style"":""solid"",""color"":""#f4f4f4""},""zindex"":0,""borderset"":""rect"",""top"":""0"",""left"":""0"",""ismini"":""false"",""horzgap"":10,""simpleModePos"":""end"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""Vertical_border"":5,""height"":""100%"",""autosize"":""content"",""borderleft"":null,""bordertop"":null,""borderright"":null,""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":"""",""conditionArr"":""""},""attribute"":{""name"":""TOPAREA""}},""bodyarea"":{""id"":""bodyarea"",""tagname"":""WidgetPageArea"",""option"":{""bgimg_repeat"":""no-repeat"",""bordertop"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""childindexs"":""WidgetLayout90"",""vertalign"":""top"",""zindex"":0,""borderset"":""rect"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":"""",""rptthemecaption"":""""},""attribute"":{""name"":""BODYAREA""},""childnodes"":{""WidgetLayout90"":{""id"":""WidgetLayout90"",""tagname"":""WidgetLayout"",""option"":{""bgimg_repeat"":""no-repeat"",""rowcount"":""8"",""vtype"":""1"",""layouttype"":""layout5"",""vertalign"":""relate"",""htype"":""2"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#0a0f27"",""top"":""0"",""colcount"":""1"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1441,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""isStretch"":false,""height"":866,""autosize"":""none"",""foldline"":true,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH8""},""childnodes"":{""WidgetSheet46"":{""id"":""WidgetSheet46"",""tagname"":""WidgetSheet"",""option"":{""bgimg_repeat"":""no-repeat"",""defborder"":{""width"":1,""style"":""dotted"",""color"":""#9d9797""},""childindexs"":""WidgetContainer37"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""cell_padding"":""2,2,2,2"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH9""},""childnodes"":{""WidgetContainer37"":{""id"":""WidgetContainer37"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""30"",""childindexs"":""WidgetImage66,WidgetText37"",""vertalign"":""top"",""lastleft"":""191"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""150px"",""height"":""100%"",""autosize"":""full"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH25""},""childnodes"":{""WidgetImage66"":{""id"":""WidgetImage66"",""tagname"":""WidgetImage"",""option"":{""bgimg_repeat"":""no-repeat"",""src"":""vfs/root/products/ebi/sys/picture/头部.png"",""vertalign"":""center"",""lastleft"":""0"",""stretch"":false,""zindex"":0,""borderset"":""none"",""top"":""33"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""center"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""1371"",""height"":""60px"",""autosize"":""horz"",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH19""}},""WidgetText37"":{""id"":""WidgetText37"",""tagname"":""WidgetText"",""option"":{""bgimg_repeat"":""no-repeat"",""borderleft"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""lineheight"":""1.1"",""pid"":""WidgetContainer37"",""valign"":""top"",""align"":""left"",""bordertop"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""vertalign"":""center"",""borderbottom"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""zindex"":0,""borderset"":""rect"",""top"":""41"",""draggable"":false,""left"":""579"",""ismini"":""false"",""isextend"":""false"",""width"":""278px"",""horzalign"":""center"",""borderradius"":""5"",""borderright"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""disabled"":false,""height"":""43px"",""autosize"":""content"",""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH33""},""text"":[{""t"":""采购订单交期预警"",""stl"":{""sz"":34,""cl"":""#4EB9FF""}}]}}}}},""WidgetSheet32"":{""id"":""WidgetSheet32"",""tagname"":""WidgetSheet"",""option"":{""bgimg_repeat"":""no-repeat"",""defborder"":{""width"":1,""style"":""dotted"",""color"":""#9d9797""},""childindexs"":""WidgetContainer76"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""cell_padding"":""2,2,2,2"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH11""},""childnodes"":{""WidgetContainer76"":{""id"":""WidgetContainer76"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""196"",""childindexs"":""WidgetTplGrid64,WidgetTplGrid81"",""vertalign"":""top"",""lastleft"":""227"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""150px"",""height"":""100%"",""autosize"":""full"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH23""},""childnodes"":{""WidgetTplGrid64"":{""id"":""WidgetTplGrid64"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""40"",""zindex"":0,""borderset"":""none"",""top"":""60"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1305,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""583"",""height"":67,""autosize"":""horz"",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""GRID2""},""defthemeset"":{""defstl"":{""editor"":""input"",""dec"":2,""indent"":""2.1.2.1"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""valign"":2,""ishorz"":true,""type"":""N"",""colspan"":1,""len"":50,""rowspan"":1,""halign"":2,""bkcl"":""transparent"",""wrap"":false},""cellborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""gridborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""}},""grid"":{""cells"":[[{""colspan"":1,""hasDisplayExp"":true,""editor"":""date"",""dec"":""3"",""len"":""23"",""indent"":""2.1.2.1"",""displayexp"":""(@txt/3600)+'小时'"",""rowspan"":1,""type"":""D"",""exp"":""JLJYWCDRK.col10"",""stl"":0},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""iszb"":true,""visible"":"""",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""selecttype"":""1"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.SUPPLIER_NAME"",""stl"":1},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""2.1.2.1"",""expppt.font.color"":"""",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.DOC_NO"",""stl"":2},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.PROJECT_CODE"",""stl"":3},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""5.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_CODE"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""60"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_NAME"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""255"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_SPECIFICATION"",""stl"":3},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""16"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":""28"",""exp"":""CGDDWJYJ.BUSINESS_QTY"",""stl"":4},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""17"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.wdhl"",""stl"":3},{""hasDisplayExp"":false,""editor"":""date"",""datetype"":"""",""dec"":""7"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""D"",""l"":""50"",""colspan"":1,""len"":""27"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.PLAN_ARRIVAL_DATE"",""stl"":3}]],""stylelist"":[{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#00ECFF"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true}],""rowborder"":[[0,1,1,1,1,1,1,1,1,1,1]],""colborder"":[[0,0],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1]],""borderlist"":[{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":10,""cols"":[{""col_autosize"":false,""size"":0},{""col_autosize"":false,""size"":158},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":160},{""col_autosize"":false,""size"":111},{""col_autosize"":false,""size"":95},{""col_autosize"":false,""size"":164},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":150}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[{""rect"":[0,0,0,9],""floatcell"":[]}],""form"":{}},""WidgetTplGrid81"":{""id"":""WidgetTplGrid81"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""62"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#065F98"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1305,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""727"",""height"":67,""autosize"":""horz"",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""GRID1""},""defthemeset"":{""defstl"":{""editor"":""input"",""dec"":2,""indent"":""2.1.2.1"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""valign"":2,""ishorz"":true,""type"":""N"",""colspan"":1,""len"":50,""rowspan"":1,""halign"":2,""bkcl"":""transparent"",""wrap"":false},""cellborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""gridborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""}},""grid"":{""cells"":[[{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""供应商简称"",""type"":"""",""stl"":0},{""colspan"":1,""len"":""50"",""indent"":""5.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""采购单号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""项目号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""料号"",""type"":"""",""stl"":0},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""品名"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""规格"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""采购数量"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""未到货数量"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""交期"",""type"":"""",""stl"":1}]],""stylelist"":[{""bkcl"":""transparent"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""cl"":""#000000""},{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":16,""stl"":""B"",""cl"":""#E4E9ED""}],""rowborder"":[[0,0,0,0,0,0,0,0,0,0]],""colborder"":[[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0]],""borderlist"":[{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":9,""cols"":[{""col_autosize"":false,""size"":158},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":160},{""col_autosize"":false,""size"":111},{""col_autosize"":false,""size"":95},{""col_autosize"":false,""size"":164},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":150}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[],""form"":{}}}}}}},""layout"":{""rows"":{""heights"":[""2%"",""13%"",""20%"",""13%"",""13%"",""13%"",""13%"",""13%""],""count"":8},""cols"":{""widths"":[""100%""],""count"":1},""cells"":[{""r"":1,""c"":1,""rowspan"":2,""colspan"":1,""linkid"":""WidgetSheet46""},{""r"":3,""c"":1,""rowspan"":6,""colspan"":1,""linkid"":""WidgetSheet32""}],""hgap"":3,""vgap"":3,""colStretched"":[]}}}}},""layout"":{""rows"":{""heights"":[34,867],""count"":2},""cols"":{""widths"":[1441],""count"":1},""cells"":[{""r"":1,""c"":1,""rowspan"":1,""colspan"":1,""linkid"":""toparea""},{""r"":2,""c"":1,""rowspan"":1,""colspan"":1,""linkid"":""bodyarea""}]}}},""rptthemename"":"""",""script"":{""jscript"":""/***\n**表格内容自动轮播脚本\n**@param tableDom 设置内容滚动的表格\n**@param visibleHeight 可视区的高度\n**@param refreshTime 定时刷新的时间\n***/\nfunction autoScrollTable(tableDom, visibleHeight, refreshTime) {\n var marqueesHeight = visibleHeight;\n var beginTime = new Date().getTime();\n var endTime = beginTime + refreshTime;\n var isEnd = false;\n var stopscroll = false;\n var scrollElem = tableDom;\n var preTop = 0;\n var currentTop = 0;\n var stoptime = 0;\n with (scrollElem) {\n style.height = parseFloat(marqueesHeight) + \""px\"";\n style.overflow = 'hidden';\n noWrap = true;\n }\n var scrollUp = function () {\n if (stopscroll) {\n setTimeout(scrollUp, 50);\n return;\n }\n currentTop += 1;\n if(isEnd && new Date().getTime() >= endTime){\n g_rptpage.cmd_calcReport();\n return;\n }\n if (currentTop == (marqueesHeight + 1)) {\n stoptime += 1;\n currentTop -= 1;\n if (stoptime == 1) {\n currentTop = 0;\n stoptime = 0;\n }\n } else {\n preTop = scrollElem.scrollTop;\n scrollElem.scrollTop += 1;\n if (preTop == scrollElem.scrollTop) {\n isEnd = true;\n if(new Date().getTime() >= endTime){\n g_rptpage.cmd_calcReport();\n return;\n } else {\n scrollElem.scrollTop = 0;\n scrollElem.scrollTop += 1;\n }\n }\n }\n setTimeout(scrollUp, 50);\n };\n var restartScroll = function () {\n scrollElem.scrollTop = 0;\n setTimeout(scrollUp, 50);\n };\n jQuery(tableDom).hover(function () {\n stopscroll = true;\n }, function () {\n stopscroll = false;\n });\n setTimeout(restartScroll, 2000);\n}\nautoScrollTable(document.getElementById('GRID2'),document.getElementById('HHH23').clientHeight-document.getElementById('GRID1').clientHeight,8000);""},""analyseoption"":{""bbqoption_caption"":""全部数据期""},""print"":{""zoomHeaderFontSizeByViewRate"":""false"",""fix_floatColCount"":""0"",""footer"":""none"",""zoomCellFontSizeByViewRate"":""false"",""cellFontSizeRate"":""100"",""printColor"":""true"",""printDirection"":""portrait"",""printZero"":""false"",""subfield_fixRowColCount"":""0"",""fix_fixRowCount"":""0"",""pageMarginBottom"":""10"",""fillRowCol"":""false"",""fix_floatRowCount"":""0"",""layoutAutoSize"":""false"",""pageMarginRight"":""10"",""headerFontSizeRate"":""100"",""printType"":""proportion"",""pageMarginLeft"":""10"",""gridHeadFoot"":""firstheadendfoot"",""printSize"":""100"",""subfield_fieldSpacing"":""0"",""pageMarginTop"":""10"",""subfield_eachFieldRowColCount"":""0"",""header"":""none"",""pagingType"":""single"",""fix_fixColCount"":""0"",""subfield_direction"":""right"",""centerSet"":""false"",""printPage"":""A4"",""subfield_count"":""0""}}";group=EANA$1$9978aee77af547c4a44ec172e07d80a6;olddesignid=EANA$2$2$1$1b6537ab18464f50b7f812d207753bdc$4c5c54bbe0a646d48463df38029ba029.rpttpl;startindex=0[/url]

JavaScript StackTrace:
Error: 对象名 'ESISCGDDWJYJ' 无效。
--detailmessage--
2021-02-23 16:59:50 开始计算报表:COPYOF_B69033(内存情况:FREE=36.2M TOTAL=210M MAX=228M)
使用主题表:采购订单未交预警的内存缓存数据
获取主题表:采购订单未交预警的数据并加载到内存中进行缓存
开始加载SQL主题采购订单未交预警数据到内存
结束加载SQL主题:采购订单未交预警数据到内存,耗时:23毫秒(开始时间:2021-02-23 16:59:50.764,结束时间:2021-02-23 16:59:50.787),共尝试加载911条数据到ESISCGDDWJYJ
2021-02-23 16:59:50.654 使用主题表:采购订单未交预警的内存缓存数据
2021-02-23 16:59:50.654 获取主题表:采购订单未交预警的数据并加载到内存中进行缓存
2021-02-23 16:59:50.764 开始加载SQL主题采购订单未交预警数据到内存
2021-02-23 16:59:50.764 结束加载SQL主题:采购订单未交预警数据到内存,耗时:23毫秒(开始时间:2021-02-23 16:59:50.764,结束时间:2021-02-23 16:59:50.787),共尝试加载911条数据到ESISCGDDWJYJ
2021-02-23 16:59:50 引用的主题表: 采购订单未交预警, 进料检验完成待入库
2021-02-23 16:59:50 查询的数据级次范围:没有做限制。
2021-02-23 16:59:50 001开始多表格各分析区并行计算
2021-02-23 16:59:50 [GRID2(0.0.10.1)]正在生成SQL...
2021-02-23 16:59:50 [GRID2(0.0.10.1)]计算表格GRID2
2021-02-23 16:59:50 [GRID2(0.0.10.1)]生成SQL耗时14毫秒
2021-02-23 16:59:50 [GRID2(0.0.10.1)]当前连接池为【e10】,执行SQL:
select top 100000 a.A1 as A1,b.C1 as C1,b.D1 as D1,b.E1 as E1,b.F1 as F1,b.G1 as G1,b.H1 as H1,b.I1 as I1,b.J1 as J1
from (
select MAX(a.col10) as A1
from (SELECT              
A.DOC_NO AS col01,              
ITEM.ITEM_CODE AS col02,              
ITEM.ITEM_NAME AS col03,              
ITEM.ITEM_SPECIFICATION AS col04 ,  
ITEM_LOT.LOT_CODE AS col11,            
B.BUSINESS_QTY AS col05,              
(B.ACCEPTED_BUSINESS_QTY+B.SP_RECEIPT_BUSINESS_QTY -B.RECEIPTED_BUSINESS_QTY )AS col06,              
ISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col07,              
ISNULL(SUPPLIER_NAME,'') AS col08,              
CONVERT(varchar(100), PO_QC_RESULT.CreateDate,23) AS col09,              
ISNULL(WAREHOUSE.WAREHOUSE_CODE ,'')AS col10,              
datediff(second, PO_QC_RESULT.CreateDate,GETDATE()) as col12              
FROM              
PURCHASE_ARRIVAL AS A              
LEFT JOIN PURCHASE_ARRIVAL_D AS B              
ON B.PURCHASE_ARRIVAL_ID = A.PURCHASE_ARRIVAL_ID              
LEFT JOIN ITEM               
ON ITEM.ITEM_BUSINESS_ID=B.ITEM_ID              
LEFT JOIN SUPPLIER              
ON SUPPLIER.SUPPLIER_BUSINESS_ID=A.SUPPLIER_ID              
LEFT JOIN PLANT               
ON PLANT.PLANT_ID=A.RECEIVE_Owner_Org_ROid              
LEFT JOIN dbo.WAREHOUSE              
ON WAREHOUSE.WAREHOUSE_ID=B.WAREHOUSE_ID   
left join ITEM_LOT
ON ITEM_LOT.ITEM_LOT_ID=B.ITEM_LOT_ID   
left join PO_QC_RESULT
on PO_QC_RESULT.SOURCE_ID_ROid=B.PURCHASE_ARRIVAL_D_ID  
left join PO_QC_RESULT_D
on PO_QC_RESULT.PO_QC_RESULT_ID=PO_QC_RESULT_D.PO_QC_RESULT_ID   
WHERE A.ApproveStatus='Y'              
AND (B.ACCEPTED_BUSINESS_QTY+B.SP_RECEIPT_BUSINESS_QTY -B.RECEIPTED_BUSINESS_QTY ) >0              
AND B.RECEIPT_CLOSE='0'              
AND PLANT_CODE='1'
) a) a
,(
select MAX(a.DOC_NO) as C1,MAX(a.PROJECT_CODE) as D1,MAX(a.ITEM_CODE) as E1,MAX(a.ITEM_NAME) as F1,MAX(a.ITEM_SPECIFICATION) as G1,sum(a.BUSINESS_QTY) as H1,sum(a.WDHL) as I1,MAX(a.PLAN_ARRIVAL_DATE) as J1
from ESISCGDDWJYJ a) b
java.lang.RuntimeException: 对象名 'ESISCGDDWJYJ' 无效。
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
  at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
  at com.esen.jdbc.pool.PooledStatement.executeQuery(PooledStatement.java:44)
  at com.esen.jdbc.pool.impl.mssql.MssqlPooledStatement.executeQuery(MssqlPooledStatement.java:20)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.queryData(OlapResultMultImpl.java:421)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.doit(OlapResultMultImpl.java:237)
  at com.esen.ebibase.rptbase.calc.db.top.OlapResultMultImpl.(OlapResultMultImpl.java:104)
  at com.esen.ebibase.rptbase.calc.db.top.CalcOlapResult.calcGroupOlap(CalcOlapResult.java:78)
  at com.esen.ebibase.rptbase.calc.impl.GroupOlapEngine.calc(GroupOlapEngine.java:35)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.calcOlap(OLTPResultManager.java:533)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpResult(OLTPResultManager.java:522)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData4AutoOlap(OLTPResultManager.java:155)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.OLTPResultManager.getOltpData(OLTPResultManager.java:88)
  at com.esen.ebibase.rptbase.calc.impl.cache.FxBaseAnalyseReportCalc.getOltpData(FxBaseAnalyseReportCalc.java:494)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.getOltpData(FloatFxqCalc.java:253)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.getOltpData(FloatFxqInnerCalc.java:79)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.getOltpData(FloatFxqInnerCalc.java:1173)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult_zbsInFxq(FloatFxqInnerCalc.java:480)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.QueryRectsResult_Impl.collectResult(FloatFxqInnerCalc.java:154)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqInnerCalc.calc(FloatFxqInnerCalc.java:58)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:249)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FixRectInFxqResultImpl.processResult(FixRectInFxqResultImpl.java:44)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.RectsInFxqResultImpl.processResult(RectsInFxqResultImpl.java:101)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqResultImpl.processResult(FloatFxqResultImpl.java:93)
  at com.esen.ebibase.rptbase.calc.impl.cache.floatfxq2.FloatFxqCalc.calc(FloatFxqCalc.java:86)
  at com.esen.ebibase.rptbase.calc.impl.FxCalc.calc(FxCalc.java:34)
  at com.esen.ebibase.rptbase.calc.impl.cache.RequestTask_FxqCalc.doRun(RequestTask_FxqCalc.java:105)
  at com.esen.ebibase.req.AbstractRequestTask.call(AbstractRequestTask.java:87)
  at com.esen.ethreadpool.req.RequestTaskFutureImpl.call(RequestTaskFutureImpl.java:100)
  at com.esen.scheduling.LocaleTask.call(LocaleTask.java:56)
  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)
Caused by: com.esen.jdbc.pool.impl.mssql.MssqlPooledSQLException: 对象名 'ESISCGDDWJYJ' 无效。
  ... 42 more



页面地址为:【[url=]/abi/ebibase/js/reqmgr.do?action=calcnew;taskid=1b6537ab18464f50b7f812d207753bdc;exttype=rpttpl;rptcontent="{""id"":""TTU73WPSNK35UEBTUOC74LJUFSTCTYUK"",""tagname"":""page"",""option"":{""bgimg_repeat"":""no-repeat"",""maxcount"":57,""maxgridcount"":2,""grp"":""EANA$1$9978aee77af547c4a44ec172e07d80a6"",""childindexs"":""WidgetPageLayout91,PAGEFLOAT"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""top"":""0px"",""left"":""0px"",""ismini"":""false"",""isextend"":""false"",""menutemplate"":""blank.txt"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""databack"":""false"",""disabled"":false,""oldpagebar"":true,""taskid"":""1b6537ab18464f50b7f812d207753bdc"",""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""COPYOF_B69033"",""caption"":""采购订单未交预警"",""type"":""pagetpl""},""childnodes"":{""WidgetPageLayout91"":{""id"":""WidgetPageLayout91"",""tagname"":""WidgetPageLayout"",""option"":{""bgimg_repeat"":""no-repeat"",""enableSelect"":""false"",""vertalign"":""top"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""WidgetPageLayout""},""childnodes"":{""toparea"":{""id"":""toparea"",""tagname"":""WidgetArea"",""option"":{""bgimg_repeat"":""no-repeat"",""Cross_border"":10,""vertalign"":""top"",""horzindent"":0,""borderbottom"":{""width"":1,""style"":""solid"",""color"":""#f4f4f4""},""zindex"":0,""borderset"":""rect"",""top"":""0"",""left"":""0"",""ismini"":""false"",""horzgap"":10,""simpleModePos"":""end"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""Vertical_border"":5,""height"":""100%"",""autosize"":""content"",""borderleft"":null,""bordertop"":null,""borderright"":null,""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":"""",""conditionArr"":""""},""attribute"":{""name"":""TOPAREA""}},""bodyarea"":{""id"":""bodyarea"",""tagname"":""WidgetPageArea"",""option"":{""bgimg_repeat"":""no-repeat"",""bordertop"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""childindexs"":""WidgetLayout90"",""vertalign"":""top"",""zindex"":0,""borderset"":""rect"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":"""",""rptthemecaption"":""""},""attribute"":{""name"":""BODYAREA""},""childnodes"":{""WidgetLayout90"":{""id"":""WidgetLayout90"",""tagname"":""WidgetLayout"",""option"":{""bgimg_repeat"":""no-repeat"",""rowcount"":""8"",""vtype"":""1"",""layouttype"":""layout5"",""vertalign"":""relate"",""htype"":""2"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#0a0f27"",""top"":""0"",""colcount"":""1"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1441,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""isStretch"":false,""height"":866,""autosize"":""none"",""foldline"":true,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH8""},""childnodes"":{""WidgetSheet46"":{""id"":""WidgetSheet46"",""tagname"":""WidgetSheet"",""option"":{""bgimg_repeat"":""no-repeat"",""defborder"":{""width"":1,""style"":""dotted"",""color"":""#9d9797""},""childindexs"":""WidgetContainer37"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""cell_padding"":""2,2,2,2"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH9""},""childnodes"":{""WidgetContainer37"":{""id"":""WidgetContainer37"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""30"",""childindexs"":""WidgetImage66,WidgetText37"",""vertalign"":""top"",""lastleft"":""191"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""150px"",""height"":""100%"",""autosize"":""full"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH25""},""childnodes"":{""WidgetImage66"":{""id"":""WidgetImage66"",""tagname"":""WidgetImage"",""option"":{""bgimg_repeat"":""no-repeat"",""src"":""vfs/root/products/ebi/sys/picture/头部.png"",""vertalign"":""center"",""lastleft"":""0"",""stretch"":false,""zindex"":0,""borderset"":""none"",""top"":""33"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""center"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""1371"",""height"":""60px"",""autosize"":""horz"",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH19""}},""WidgetText37"":{""id"":""WidgetText37"",""tagname"":""WidgetText"",""option"":{""bgimg_repeat"":""no-repeat"",""borderleft"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""lineheight"":""1.1"",""pid"":""WidgetContainer37"",""valign"":""top"",""align"":""left"",""bordertop"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""vertalign"":""center"",""borderbottom"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""zindex"":0,""borderset"":""rect"",""top"":""41"",""draggable"":false,""left"":""579"",""ismini"":""false"",""isextend"":""false"",""width"":""278px"",""horzalign"":""center"",""borderradius"":""5"",""borderright"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""disabled"":false,""height"":""43px"",""autosize"":""content"",""bgcolor"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH33""},""text"":[{""t"":""采购订单交期预警"",""stl"":{""sz"":34,""cl"":""#4EB9FF""}}]}}}}},""WidgetSheet32"":{""id"":""WidgetSheet32"",""tagname"":""WidgetSheet"",""option"":{""bgimg_repeat"":""no-repeat"",""defborder"":{""width"":1,""style"":""dotted"",""color"":""#9d9797""},""childindexs"":""WidgetContainer76"",""vertalign"":""relate"",""zindex"":0,""borderset"":""none"",""cell_padding"":""2,2,2,2"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""height"":""100%"",""autosize"":""none"",""foldline"":true,""bgcolor"":"""",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH11""},""childnodes"":{""WidgetContainer76"":{""id"":""WidgetContainer76"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""196"",""childindexs"":""WidgetTplGrid64,WidgetTplGrid81"",""vertalign"":""top"",""lastleft"":""227"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""left"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""150px"",""height"":""100%"",""autosize"":""full"",""foldline"":true,""bgcolor"":"""",""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""padding"":"""",""border"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""HHH23""},""childnodes"":{""WidgetTplGrid64"":{""id"":""WidgetTplGrid64"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""40"",""zindex"":0,""borderset"":""none"",""top"":""60"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1305,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""583"",""height"":67,""autosize"":""horz"",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""GRID2""},""defthemeset"":{""defstl"":{""editor"":""input"",""dec"":2,""indent"":""2.1.2.1"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""valign"":2,""ishorz"":true,""type"":""N"",""colspan"":1,""len"":50,""rowspan"":1,""halign"":2,""bkcl"":""transparent"",""wrap"":false},""cellborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""gridborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""}},""grid"":{""cells"":[[{""colspan"":1,""hasDisplayExp"":true,""editor"":""date"",""dec"":""3"",""len"":""23"",""indent"":""2.1.2.1"",""displayexp"":""(@txt/3600)+'小时'"",""rowspan"":1,""type"":""D"",""exp"":""JLJYWCDRK.col10"",""stl"":0},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""iszb"":true,""visible"":"""",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""selecttype"":""1"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.SUPPLIER_NAME"",""stl"":1},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""2.1.2.1"",""expppt.font.color"":"""",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.DOC_NO"",""stl"":2},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.PROJECT_CODE"",""stl"":3},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""0"",""indent"":""5.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_CODE"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""60"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_NAME"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""255"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.ITEM_SPECIFICATION"",""stl"":3},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""16"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":""28"",""exp"":""CGDDWJYJ.BUSINESS_QTY"",""stl"":4},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""17"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.wdhl"",""stl"":3},{""hasDisplayExp"":false,""editor"":""date"",""datetype"":"""",""dec"":""7"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""D"",""l"":""50"",""colspan"":1,""len"":""27"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""CGDDWJYJ.PLAN_ARRIVAL_DATE"",""stl"":3}]],""stylelist"":[{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#00ECFF"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true}],""rowborder"":[[0,1,1,1,1,1,1,1,1,1,1]],""colborder"":[[0,0],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1],[1,1]],""borderlist"":[{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":10,""cols"":[{""col_autosize"":false,""size"":0},{""col_autosize"":false,""size"":158},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":160},{""col_autosize"":false,""size"":111},{""col_autosize"":false,""size"":95},{""col_autosize"":false,""size"":164},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":150}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[{""rect"":[0,0,0,9],""floatcell"":[]}],""form"":{}},""WidgetTplGrid81"":{""id"":""WidgetTplGrid81"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""62"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#065F98"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":1305,""horzalign"":""relate"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""727"",""height"":67,""autosize"":""horz"",""border"":null,""borderleft"":null,""bordertop"":null,""borderright"":null,""borderbottom"":null,""bgimg"":"""",""bgimg_position"":""""},""attribute"":{""name"":""GRID1""},""defthemeset"":{""defstl"":{""editor"":""input"",""dec"":2,""indent"":""2.1.2.1"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""valign"":2,""ishorz"":true,""type"":""N"",""colspan"":1,""len"":50,""rowspan"":1,""halign"":2,""bkcl"":""transparent"",""wrap"":false},""cellborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},""gridborder"":{""color"":""#CCCCCC"",""width"":1,""style"":""solid""}},""grid"":{""cells"":[[{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""供应商简称"",""type"":"""",""stl"":0},{""colspan"":1,""len"":""50"",""indent"":""5.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""采购单号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""项目号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""料号"",""type"":"""",""stl"":0},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""品名"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""规格"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""采购数量"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""未到货数量"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""交期"",""type"":"""",""stl"":1}]],""stylelist"":[{""bkcl"":""transparent"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""cl"":""#000000""},{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":16,""stl"":""B"",""cl"":""#E4E9ED""}],""rowborder"":[[0,0,0,0,0,0,0,0,0,0]],""colborder"":[[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0],[0,0]],""borderlist"":[{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":9,""cols"":[{""col_autosize"":false,""size"":158},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":140},{""col_autosize"":false,""size"":160},{""col_autosize"":false,""size"":111},{""col_autosize"":false,""size"":95},{""col_autosize"":false,""size"":164},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":150}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[],""form"":{}}}}}}},""layout"":{""rows"":{""heights"":[""2%"",""13%"",""20%"",""13%"",""13%"",""13%"",""13%"",""13%""],""count"":8},""cols"":{""widths"":[""100%""],""count"":1},""cells"":[{""r"":1,""c"":1,""rowspan"":2,""colspan"":1,""linkid"":""WidgetSheet46""},{""r"":3,""c"":1,""rowspan"":6,""colspan"":1,""linkid"":""WidgetSheet32""}],""hgap"":3,""vgap"":3,""colStretched"":[]}}}}},""layout"":{""rows"":{""heights"":[34,867],""count"":2},""cols"":{""widths"":[1441],""count"":1},""cells"":[{""r"":1,""c"":1,""rowspan"":1,""colspan"":1,""linkid"":""toparea""},{""r"":2,""c"":1,""rowspan"":1,""colspan"":1,""linkid"":""bodyarea""}]}}},""rptthemename"":"""",""script"":{""jscript"":""/***\n**表格内容自动轮播脚本\n**@param tableDom 设置内容滚动的表格\n**@param visibleHeight 可视区的高度\n**@param refreshTime 定时刷新的时间\n***/\nfunction autoScrollTable(tableDom, visibleHeight, refreshTime) {\n var marqueesHeight = visibleHeight;\n var beginTime = new Date().getTime();\n var endTime = beginTime + refreshTime;\n var isEnd = false;\n var stopscroll = false;\n var scrollElem = tableDom;\n var preTop = 0;\n var currentTop = 0;\n var stoptime = 0;\n with (scrollElem) {\n style.height = parseFloat(marqueesHeight) + \""px\"";\n style.overflow = 'hidden';\n noWrap = true;\n }\n var scrollUp = function () {\n if (stopscroll) {\n setTimeout(scrollUp, 50);\n return;\n }\n currentTop += 1;\n if(isEnd && new Date().getTime() >= endTime){\n g_rptpage.cmd_calcReport();\n return;\n }\n if (currentTop == (marqueesHeight + 1)) {\n stoptime += 1;\n currentTop -= 1;\n if (stoptime == 1) {\n currentTop = 0;\n stoptime = 0;\n }\n } else {\n preTop = scrollElem.scrollTop;\n scrollElem.scrollTop += 1;\n if (preTop == scrollElem.scrollTop) {\n isEnd = true;\n if(new Date().getTime() >= endTime){\n g_rptpage.cmd_calcReport();\n return;\n } else {\n scrollElem.scrollTop = 0;\n scrollElem.scrollTop += 1;\n }\n }\n }\n setTimeout(scrollUp, 50);\n };\n var restartScroll = function () {\n scrollElem.scrollTop = 0;\n setTimeout(scrollUp, 50);\n };\n jQuery(tableDom).hover(function () {\n stopscroll = true;\n }, function () {\n stopscroll = false;\n });\n setTimeout(restartScroll, 2000);\n}\nautoScrollTable(document.getElementById('GRID2'),document.getElementById('HHH23').clientHeight-document.getElementById('GRID1').clientHeight,8000);""},""analyseoption"":{""bbqoption_caption"":""全部数据期""},""print"":{""zoomHeaderFontSizeByViewRate"":""false"",""fix_floatColCount"":""0"",""footer"":""none"",""zoomCellFontSizeByViewRate"":""false"",""cellFontSizeRate"":""100"",""printColor"":""true"",""printDirection"":""portrait"",""printZero"":""false"",""subfield_fixRowColCount"":""0"",""fix_fixRowCount"":""0"",""pageMarginBottom"":""10"",""fillRowCol"":""false"",""fix_floatRowCount"":""0"",""layoutAutoSize"":""false"",""pageMarginRight"":""10"",""headerFontSizeRate"":""100"",""printType"":""proportion"",""pageMarginLeft"":""10"",""gridHeadFoot"":""firstheadendfoot"",""printSize"":""100"",""subfield_fieldSpacing"":""0"",""pageMarginTop"":""10"",""subfield_eachFieldRowColCount"":""0"",""header"":""none"",""pagingType"":""single"",""fix_fixColCount"":""0"",""subfield_direction"":""right"",""centerSet"":""false"",""printPage"":""A4"",""subfield_count"":""0""}}";group=EANA$1$9978aee77af547c4a44ec172e07d80a6;olddesignid=EANA$2$2$1$1b6537ab18464f50b7f812d207753bdc$4c5c54bbe0a646d48463df38029ba029.rpttpl;startindex=0[/url]
at Object.throwError (http://192.168.100.40:7071/abi/eui/eui.js:2583:19)
at CalcReqTask.AbstractReqObj.onqueryobjfinish (http://192.168.100.40:7071/abi/eui/eui.js:6594:9)
at QueryObj._AbstractReqObj_onQueryFinish (http://192.168.100.40:7071/abi/eui/eui.js:6657:8)
at QueryObj._onreadystatechange (http://192.168.100.40:7071/abi/eui/eui.js:3588:11)
at XMLHttpRequest.hp.onreadystatechange (http://192.168.100.40:7071/abi/eui/eui.js:3619:10)

最近看过此主题的会员

xxxl

yangm

admin

zhaodong

最佳答案
由于主题表字段没有同步修改sql生成并且原主题表字段名称有一个为小写,修改sql并新建sql主题表问题解决。
6个回答

只看楼主

xxxl 数据领袖Lv6

发表于2021-2-23 17:09

只看该作者

取消 关注该作者的回复

沙发

先清除一下缓存再试试吧

lin786682931 初学数据Lv2

发表于2021-2-23 17:21

只看该作者

取消 关注该作者的回复

板凳

xxxl 发表于 2021-2-23 17:09
先清除一下缓存再试试吧

请教下如何清除?

xxxl 数据领袖Lv6

发表于2021-2-23 17:22

只看该作者

取消 关注该作者的回复

地板


您这里写的sql是写在哪里 sql数据源 sql主题表?

lin786682931 初学数据Lv2

发表于2021-2-23 17:26

只看该作者

取消 关注该作者的回复

5#

xxxl 发表于 2021-2-23 17:22
您这里写的sql是写在哪里 sql数据源 sql主题表?

数据集-主题表

xxxl 数据领袖Lv6

发表于2021-2-24 10:16

只看该作者

取消 关注该作者的回复

6#


那就是sql主题表对吧依据这个修改一下缓存的方式
截图202102241016383331.png

yangm 数据达人Lv4

发表于2021-2-23 17:02

只看该作者

取消 关注该作者的回复

7#

由于主题表字段没有同步修改sql生成并且原主题表字段名称有一个为小写,修改sql并新建sql主题表问题解决。

登录后可回答问题,请登录注册

快速回复 返回顶部 返回列表

小时

全天响应

分钟

快速处理问题

工程师强势助力

明星产品
解决方案
联系合作

渠道咨询电话:137-0120-6790

技术支持QQ:400-0011-866(工作日9:00-18:00)

产品建议邮箱yixin@esensoft.com

关注我们

扫TA学习更多干货

进群交流、一对一指导

©2021ESENSOFT北京亿信华辰软件有限责任公司版权所有:京ICP备07017321号京公网安备11010802016281号