[ABI 5.1] 计算报错

看一下计算详情

2021-02-23 15:08:38 开始计算报表：COPYOF_COPYOF_B69030（内存情况：FREE=37.4M TOTAL=216M MAX=228M）
使用主题表：机加工生产进度表的内存缓存数据
获取主题表：机加工生产进度表的数据并加载到内存中进行缓存
java.lang.RuntimeException: Table 'abi.mo' doesn't exist
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  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:2486)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
  at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
  at com.esen.jdbc.pool.impl.mysql.MysqlPooledStatement.executeQuery(MysqlPooledStatement.java:21)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlSubjectDataRequestImpl.getTotalCount(SqlSubjectDataRequestImpl.java:274)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlSubjectDataRequestImpl.send(SqlSubjectDataRequestImpl.java:65)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlDataFetcher.fetch(SqlDataFetcher.java:37)
  at com.esen.edatasubject.business.impl.interfacesubject.InterfaceDataCalcerImpl.getInterfaceDataResult(InterfaceDataCalcerImpl.java:107)
  at com.esen.edatasubject.util.InterfaceSubjectDataUtil.getResult(InterfaceSubjectDataUtil.java:151)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.prepareInterfaceSubjectData(ReportPageAnalyse.java:1369)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:783)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:570)
  at com.esen.ebibase.rpttpl.calc.ReportCalc_calc_rpttpl.calcAnalyseResult(ReportCalc_calc_rpttpl.java:64)
  at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc_analyseResult(ReportCalc_calc_abs.java:293)
  at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc(ReportCalc_calc_abs.java:122)
  at com.esen.ebibase.req.RequestTask_Calc.calc(RequestTask_Calc.java:95)
  at com.esen.ebibase.req.RequestTask_Calc.innerRun(RequestTask_Calc.java:63)
  at com.esen.ebibase.req.RequestTask_Calc_Abstract.doRun(RequestTask_Calc_Abstract.java:59)
  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.mysql.MysqlPooledSQLException: Table 'abi.mo' doesn't exist
  ... 37 more



页面地址为：【/abi/ebibase/js/reqmgr.do?action=calcnew;taskid=1b6537ab18464f50b7f812d207753bdc;exttype=rpttpl;rptcontent="{""id"":""TTU73WPSNK35UEBTUOC74LJUFSTCTYUK"",""tagname"":""page"",""option"":{""bgimg_repeat"":""no-repeat"",""maxcount"":69,""maxgridcount"":3,""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_COPYOF_B69030"",""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"",""customstyle"":""calcnow=true"",""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"":""WidgetContainer21"",""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"":{""WidgetContainer21"":{""id"":""WidgetContainer21"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""26"",""childindexs"":""WidgetImage72,WidgetText14"",""vertalign"":""top"",""lastleft"":""127"",""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"":""HHH28""},""childnodes"":{""WidgetImage72"":{""id"":""WidgetImage72"",""tagname"":""WidgetImage"",""option"":{""bgimg_repeat"":""no-repeat"",""src"":""vfs/root/products/ebi/sys/picture/头部02.png"",""vertalign"":""center"",""lastleft"":""183"",""stretch"":false,""zindex"":0,""borderset"":""none"",""top"":""37"",""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"":""HHH29""}},""WidgetText14"":{""id"":""WidgetText14"",""tagname"":""WidgetText"",""option"":{""bgimg_repeat"":""no-repeat"",""borderleft"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""lineheight"":""1.1"",""pid"":""WidgetContainer21"",""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"":""45"",""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"":""HHH30""},""text"":[{""t"":""机加工生产进度表"",""stl"":{""sz"":34,""cl"":""#21BF37""}}]}}}}},""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"":""690px"",""customstyle"":""overflow:hidden"",""lasttop"":""0"",""childindexs"":""WidgetTplGrid64,WidgetTplGrid81"",""vertalign"":""center"",""lastleft"":""0"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""center"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""1335px"",""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"",""customstyle"":""overflow:hidden"",""vertalign"":""relate"",""lastleft"":""40"",""zindex"":0,""borderset"":""none"",""top"":""60"",""left"":""48"",""ismini"":""false"",""isextend"":""false"",""width"":1771,""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"":false,""editor"":""input"",""dec"":""0"",""len"":""40"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""C"",""l"":""40"",""exp"":""WGRK.col10"",""stl"":0},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""visible"":"""",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""selecttype"":""1"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.DOC_NO"",""stl"":1},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""expppt.font.color"":"""",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PROJECT_CODE"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ITEM_CODE"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""0.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""60"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ITEM_NAME"",""stl"":2},{""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"":""JJGSCJDB.ITEM_SPECIFICATION"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""16"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PLAN_QTY"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""datetype"":"""",""iszb"":false,""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""linkexp"":"""",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""bbqoption"":"""",""rowspan"":1,""dsparams"":"""",""exp"":""JJGSCJDB.OPERATION_NAME"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""16"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ISSUED_QTY"",""stl"":2},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""16"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":16,""exp"":""JJGSCJDB.COLLECT_QTY"",""stl"":2},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""17"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":17,""exp"":""JJGSCJDB.zzl"",""stl"":2},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""7"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""D"",""l"":""50"",""colspan"":1,""len"":""27"",""picprefix"":"""",""needswph"":""1"",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PLAN_COMPLETE_DATE"",""stl"":2}]],""stylelist"":[{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#0CFF3D"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""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}],""rowborder"":[[0,1,1,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],[1,1],[1,1]],""borderlist"":[{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":12,""cols"":[{""col_autosize"":false,""size"":0},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":180}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[{""rect"":[0,0,0,11],""floatcell"":[{""type"":""C"",""cellname"":""B1"",""value"":""=JJGSCJDB.DOC_NO"",""stl"":{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#0CFF3D"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},""wrap"":true,""indent"":""2.1.2.1"",""dec"":""0"",""selecttype"":""1"",""len"":""20"",""rect"":[0,1,0,11],""cell"":""B1"",""rectbkcolor"":""if(self.isodd,'#041C42','#082557')"",""floatdir"":""vert"",""floattype"":""float"",""customgroup"":{""grouptype"":0},""groupstype"":""0"",""dimfilter"":""0""}]}],""form"":{}},""WidgetTplGrid81"":{""id"":""WidgetTplGrid81"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""62"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#17831D"",""top"":""0"",""left"":""45"",""ismini"":""false"",""isextend"":""false"",""width"":1771,""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"":""4.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""项目号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""0.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""产品号"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""15.1.0.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"":0},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""工艺名称"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""28.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""投入量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""完成量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""在制量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""预计完工日"",""type"":"""",""stl"":1}]],""stylelist"":[{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""stl"":""B"",""cl"":""#E4E9ED""},{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":14,""stl"":""B"",""cl"":""#E4E9ED""},{""bkcl"":""transparent"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""cl"":""#000000""}],""rowborder"":[[0,0,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],[0,0],[0,0]],""borderlist"":[{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":11,""cols"":[{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":180}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[],""form"":{}}}}}}},""layout"":{""rows"":{""heights"":[""4%"",""12%"",""19%"",""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"":"""",""datasource"":{""rs1"":{""sqlcolunm"":""col01;col02;col03;col04;col05;col06;col07;col08;col09;col10;"",""tagname"":""sql"",""sqlcontent"":""SELECT\t\t\t\t\t\t\nA.DOC_NO AS col01,\t\t\t\t\t\t\nITEM.ITEM_CODE AS col02,\t\t\t\t\t\t\nITEM.ITEM_NAME AS col03,\t\t\t\t\t\t\nITEM.ITEM_SPECIFICATION AS col04 ,\t\t\t\t\t\t\nB.REQUEST_QTY AS col05,\t\t\t\t\t\t\nISNULL(ADMIN_UNIT.ADMIN_UNIT_NAME,'') AS col06,\t\t\t\t\t\t\nCONVERT(varchar(100), A.ApproveDate,23) AS col07,\t\t\t\t\t\t\nISNULL(WAREHOUSE.WAREHOUSE_CODE ,'')AS col08,\t\t\t\t\t\t\nISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col09,\nISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col10\t\t\t\t\t\t\t\nFROM dbo.MO_RECEIPT_REQUISTION AS A\t\t\t\t\t\t\nLEFT JOIN dbo.MO_RECEIPT_REQUISTION_D AS B\t\t\t\t\t\t\nON B.MO_RECEIPT_REQUISTION_ID = A.MO_RECEIPT_REQUISTION_ID\t\t\t\t\t\t\nLEFT JOIN ITEM \t\t\t\t\t\t\nON ITEM.ITEM_BUSINESS_ID=B.ITEM_ID\t\t\t\t\t\t\nLEFT JOIN dbo.ADMIN_UNIT\t\t\t\t\t\t\nON ADMIN_UNIT.ADMIN_UNIT_ID=A.Owner_Dept\t\t\t\t\t\t\nLEFT JOIN dbo.WAREHOUSE\t\t\t\t\t\t\nON WAREHOUSE.WAREHOUSE_ID=B.WAREHOUSE_ID\t\t\t\t\t\t\nLEFT JOIN PLANT\t\t\t\t\t\t\nON PLANT.PLANT_ID=A.Owner_Org_ROid\t\t\t\t\t\t\nWHERE A.ApproveStatus='Y'\t\t\t\t\t\t\nAND B.REQUEST_QTY >0\t\t\t\t\t\t\nAND B.[CLOSE]='0'\t\t\t\t\t\t\nAND PLANT_CODE='HJ01'\t\t\t\t\t\t\nAND B.INSPECTION_STATUS <>'2'"",""dbserver"":""e10""}},""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$51b0424ac75d4f6e8d7b900a25cad66a.rpttpl;startindex=0】

JavaScript StackTrace:
Error: Table 'abi.mo' doesn't exist
--detailmessage--
2021-02-23 15:08:38 开始计算报表：COPYOF_COPYOF_B69030（内存情况：FREE=37.4M TOTAL=216M MAX=228M）
使用主题表：机加工生产进度表的内存缓存数据
获取主题表：机加工生产进度表的数据并加载到内存中进行缓存
java.lang.RuntimeException: Table 'abi.mo' doesn't exist
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  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:2486)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
  at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
  at com.esen.jdbc.pool.PooledStatement.getQureyResultSet(PooledStatement.java:54)
  at com.esen.jdbc.pool.impl.mysql.MysqlPooledStatement.executeQuery(MysqlPooledStatement.java:21)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlSubjectDataRequestImpl.getTotalCount(SqlSubjectDataRequestImpl.java:274)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlSubjectDataRequestImpl.send(SqlSubjectDataRequestImpl.java:65)
  at com.esen.edatasubject.business.impl.interfacesubject.SqlDataFetcher.fetch(SqlDataFetcher.java:37)
  at com.esen.edatasubject.business.impl.interfacesubject.InterfaceDataCalcerImpl.getInterfaceDataResult(InterfaceDataCalcerImpl.java:107)
  at com.esen.edatasubject.util.InterfaceSubjectDataUtil.getResult(InterfaceSubjectDataUtil.java:151)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.prepareInterfaceSubjectData(ReportPageAnalyse.java:1369)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:783)
  at com.esen.ebibase.rptbase.analyse.ReportPageAnalyse.compile(ReportPageAnalyse.java:570)
  at com.esen.ebibase.rpttpl.calc.ReportCalc_calc_rpttpl.calcAnalyseResult(ReportCalc_calc_rpttpl.java:64)
  at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc_analyseResult(ReportCalc_calc_abs.java:293)
  at com.esen.ebibase.rptbase.calc.impl.ReportCalc_calc_abs.calc(ReportCalc_calc_abs.java:122)
  at com.esen.ebibase.req.RequestTask_Calc.calc(RequestTask_Calc.java:95)
  at com.esen.ebibase.req.RequestTask_Calc.innerRun(RequestTask_Calc.java:63)
  at com.esen.ebibase.req.RequestTask_Calc_Abstract.doRun(RequestTask_Calc_Abstract.java:59)
  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.mysql.MysqlPooledSQLException: Table 'abi.mo' doesn't exist
  ... 37 more



页面地址为：【/abi/ebibase/js/reqmgr.do?action=calcnew;taskid=1b6537ab18464f50b7f812d207753bdc;exttype=rpttpl;rptcontent="{""id"":""TTU73WPSNK35UEBTUOC74LJUFSTCTYUK"",""tagname"":""page"",""option"":{""bgimg_repeat"":""no-repeat"",""maxcount"":69,""maxgridcount"":3,""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_COPYOF_B69030"",""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"",""customstyle"":""calcnow=true"",""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"":""WidgetContainer21"",""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"":{""WidgetContainer21"":{""id"":""WidgetContainer21"",""tagname"":""WidgetContainer"",""option"":{""bgimg_repeat"":""no-repeat"",""lastheight"":""150px"",""lasttop"":""26"",""childindexs"":""WidgetImage72,WidgetText14"",""vertalign"":""top"",""lastleft"":""127"",""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"":""HHH28""},""childnodes"":{""WidgetImage72"":{""id"":""WidgetImage72"",""tagname"":""WidgetImage"",""option"":{""bgimg_repeat"":""no-repeat"",""src"":""vfs/root/products/ebi/sys/picture/头部02.png"",""vertalign"":""center"",""lastleft"":""183"",""stretch"":false,""zindex"":0,""borderset"":""none"",""top"":""37"",""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"":""HHH29""}},""WidgetText14"":{""id"":""WidgetText14"",""tagname"":""WidgetText"",""option"":{""bgimg_repeat"":""no-repeat"",""borderleft"":{""color"":""#CCCCCC"",""width"":1,""style"":""none""},""lineheight"":""1.1"",""pid"":""WidgetContainer21"",""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"":""45"",""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"":""HHH30""},""text"":[{""t"":""机加工生产进度表"",""stl"":{""sz"":34,""cl"":""#21BF37""}}]}}}}},""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"":""690px"",""customstyle"":""overflow:hidden"",""lasttop"":""0"",""childindexs"":""WidgetTplGrid64,WidgetTplGrid81"",""vertalign"":""center"",""lastleft"":""0"",""zindex"":0,""borderset"":""none"",""top"":""0"",""left"":""0"",""ismini"":""false"",""isextend"":""false"",""width"":""100%"",""horzalign"":""center"",""borderradius"":""5"",""disabled"":false,""lastwidth"":""1335px"",""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"",""customstyle"":""overflow:hidden"",""vertalign"":""relate"",""lastleft"":""40"",""zindex"":0,""borderset"":""none"",""top"":""60"",""left"":""48"",""ismini"":""false"",""isextend"":""false"",""width"":1771,""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"":false,""editor"":""input"",""dec"":""0"",""len"":""40"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""C"",""l"":""40"",""exp"":""WGRK.col10"",""stl"":0},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""visible"":"""",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""selecttype"":""1"",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.DOC_NO"",""stl"":1},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""expppt.font.color"":"""",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PROJECT_CODE"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""40"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ITEM_CODE"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":""0"",""indent"":""0.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""colspan"":1,""len"":""60"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ITEM_NAME"",""stl"":2},{""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"":""JJGSCJDB.ITEM_SPECIFICATION"",""stl"":3},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""16"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PLAN_QTY"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""datetype"":"""",""iszb"":false,""dec"":""0"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""C"",""l"":""50"",""linkexp"":"""",""colspan"":1,""len"":""20"",""picprefix"":"""",""nulltozero"":false,""bbqoption"":"""",""rowspan"":1,""dsparams"":"""",""exp"":""JJGSCJDB.OPERATION_NAME"",""stl"":2},{""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""N"",""l"":""50"",""colspan"":1,""len"":""16"",""picprefix"":"""",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.ISSUED_QTY"",""stl"":2},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""16"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":16,""exp"":""JJGSCJDB.COLLECT_QTY"",""stl"":2},{""colspan"":1,""hasDisplayExp"":false,""editor"":""input"",""dec"":6,""len"":""17"",""indent"":""2.1.2.1"",""rowspan"":1,""type"":""N"",""l"":17,""exp"":""JJGSCJDB.zzl"",""stl"":2},{""hasDisplayExp"":false,""editor"":""date"",""dec"":""7"",""indent"":""2.1.2.1"",""picsuffix"":"""",""type"":""D"",""l"":""50"",""colspan"":1,""len"":""27"",""picprefix"":"""",""needswph"":""1"",""nulltozero"":false,""rowspan"":1,""exp"":""JJGSCJDB.PLAN_COMPLETE_DATE"",""stl"":2}]],""stylelist"":[{""bkcl"":""transparent"",""sz"":12,""fn"":""微软雅黑"",""cl"":""#000000"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#0CFF3D"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#E4E9ED"",""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}],""rowborder"":[[0,1,1,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],[1,1],[1,1]],""borderlist"":[{""color"":""#CCCCCC"",""width"":1,""style"":""solid""},{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":12,""cols"":[{""col_autosize"":false,""size"":0},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":180}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[{""rect"":[0,0,0,11],""floatcell"":[{""type"":""C"",""cellname"":""B1"",""value"":""=JJGSCJDB.DOC_NO"",""stl"":{""bkcl"":""transparent"",""sz"":14,""fn"":""微软雅黑"",""cl"":""#0CFF3D"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":true},""wrap"":true,""indent"":""2.1.2.1"",""dec"":""0"",""selecttype"":""1"",""len"":""20"",""rect"":[0,1,0,11],""cell"":""B1"",""rectbkcolor"":""if(self.isodd,'#041C42','#082557')"",""floatdir"":""vert"",""floattype"":""float"",""customgroup"":{""grouptype"":0},""groupstype"":""0"",""dimfilter"":""0""}]}],""form"":{}},""WidgetTplGrid81"":{""id"":""WidgetTplGrid81"",""tagname"":""WidgetTplGrid"",""option"":{""bgimg_repeat"":""no-repeat"",""isbackfill"":""false"",""vertalign"":""relate"",""lastleft"":""62"",""zindex"":0,""borderset"":""none"",""bgcolor"":""#17831D"",""top"":""0"",""left"":""45"",""ismini"":""false"",""isextend"":""false"",""width"":1771,""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"":""4.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""项目号"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""0.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""产品号"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""15.1.0.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"":0},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""工艺名称"",""type"":"""",""stl"":1},{""colspan"":1,""len"":""50"",""indent"":""28.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""投入量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""完成量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""rowspan"":1,""text"":""在制量"",""type"":"""",""stl"":2},{""colspan"":1,""len"":""50"",""indent"":""2.1.2.1"",""picprefix"":"""",""rowspan"":1,""picsuffix"":"""",""text"":""预计完工日"",""type"":"""",""stl"":1}]],""stylelist"":[{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""stl"":""B"",""cl"":""#E4E9ED""},{""bkcl"":""transparent"",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":14,""stl"":""B"",""cl"":""#E4E9ED""},{""bkcl"":""transparent"",""stl"":"""",""valign"":2,""ishorz"":true,""halign"":2,""wrap"":false,""fn"":""微软雅黑"",""sz"":12,""cl"":""#000000""}],""rowborder"":[[0,0,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],[0,0],[0,0]],""borderlist"":[{""color"":""#000000"",""width"":0,""style"":""solid""}],""rowcount"":1,""colcount"":11,""cols"":[{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":180},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":72},{""col_autosize"":false,""size"":180}],""rows"":[{""col_autosize"":false,""size"":60}]},""floatfxqs"":[],""form"":{}}}}}}},""layout"":{""rows"":{""heights"":[""4%"",""12%"",""19%"",""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"":"""",""datasource"":{""rs1"":{""sqlcolunm"":""col01;col02;col03;col04;col05;col06;col07;col08;col09;col10;"",""tagname"":""sql"",""sqlcontent"":""SELECT\t\t\t\t\t\t\nA.DOC_NO AS col01,\t\t\t\t\t\t\nITEM.ITEM_CODE AS col02,\t\t\t\t\t\t\nITEM.ITEM_NAME AS col03,\t\t\t\t\t\t\nITEM.ITEM_SPECIFICATION AS col04 ,\t\t\t\t\t\t\nB.REQUEST_QTY AS col05,\t\t\t\t\t\t\nISNULL(ADMIN_UNIT.ADMIN_UNIT_NAME,'') AS col06,\t\t\t\t\t\t\nCONVERT(varchar(100), A.ApproveDate,23) AS col07,\t\t\t\t\t\t\nISNULL(WAREHOUSE.WAREHOUSE_CODE ,'')AS col08,\t\t\t\t\t\t\nISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col09,\nISNULL(WAREHOUSE.WAREHOUSE_NAME,'') AS col10\t\t\t\t\t\t\t\nFROM dbo.MO_RECEIPT_REQUISTION AS A\t\t\t\t\t\t\nLEFT JOIN dbo.MO_RECEIPT_REQUISTION_D AS B\t\t\t\t\t\t\nON B.MO_RECEIPT_REQUISTION_ID = A.MO_RECEIPT_REQUISTION_ID\t\t\t\t\t\t\nLEFT JOIN ITEM \t\t\t\t\t\t\nON ITEM.ITEM_BUSINESS_ID=B.ITEM_ID\t\t\t\t\t\t\nLEFT JOIN dbo.ADMIN_UNIT\t\t\t\t\t\t\nON ADMIN_UNIT.ADMIN_UNIT_ID=A.Owner_Dept\t\t\t\t\t\t\nLEFT JOIN dbo.WAREHOUSE\t\t\t\t\t\t\nON WAREHOUSE.WAREHOUSE_ID=B.WAREHOUSE_ID\t\t\t\t\t\t\nLEFT JOIN PLANT\t\t\t\t\t\t\nON PLANT.PLANT_ID=A.Owner_Org_ROid\t\t\t\t\t\t\nWHERE A.ApproveStatus='Y'\t\t\t\t\t\t\nAND B.REQUEST_QTY >0\t\t\t\t\t\t\nAND B.[CLOSE]='0'\t\t\t\t\t\t\nAND PLANT_CODE='HJ01'\t\t\t\t\t\t\nAND B.INSPECTION_STATUS <>'2'"",""dbserver"":""e10""}},""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$51b0424ac75d4f6e8d7b900a25cad66a.rpttpl;startindex=0】
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)

数据库版本和系统环境是什么呢

其他的都正常的，就这个运算错误。   我操作就是从老的样式复制了一份，然后把里面字段替换了下，其他啥也没干，好久没用有点忘记了。然后主题里计算是没有问题的

数据库是否为mysql
如果是的话按照这个方法改改
在 linux 下，MySQL的参数 lower_case_table_names 缺省值为 0
在 Windows 下，该参数缺省值为 1
这个参数表示是否区分表名的大小写，0 表示区分大小写，1 表示不区分大小写


本 Bug 中，出问题的是小写的表名的表，因为BI在查询该表的定义时，用了大写形式的表名，所以无法获取表结构，
导致无法获取该表的id字段等信息，从而引起一连串的问题。

修改MySQL的该参数即可。

修改方法：
用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1，重启MYSQL服务

SQL的

还有我的表结构全部是大写的，为啥会变成小写的了？

该问题参考帖子https://bbs.esensoft.com/thread-138738-1-1.html
由于主题表字段没有同步修改sql生成并且原主题表字段名称有一个为小写，修改sql并新建sql主题表问题解决。