永洪社区

标题: 执行数据失败，Column index out of range [打印本页]

作者: yhdata_Te8SgPrq 时间: 2022-7-6 09:21
标题: 执行数据失败，Column index out of range
永洪制作的报告时长出现执行数据报错，报错情况见下图，报错日志见图下方，重启永洪后恢复常。

[2022-07-06 08:58:21.145] |-[ERROR] |-[ca60afe29c8b4895836c7d0486116661] |-[SYSTEM] |-[g5.GSetting.loadSetting(GSetting.java:412)] |-[OTHER: Invalid global setting path: global_bi.properties]
[2022-07-06 08:58:27.153] |-[ERROR] |-[d3c1ed3de8224c0fa4d7bbbe14aee37c] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.getAssetRef(ShareDBRep.java:159)] |-[OTHER: ShareDBRep getAssetRef ftype is invalidate: .properties]
[2022-07-06 08:58:27.154] |-[ERROR] |-[898798a577514654a572d85bc32970b7] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.getAssetRef(ShareDBRep.java:159)] |-[OTHER: ShareDBRep getAssetRef ftype is invalidate: .properties]
[2022-07-06 08:58:27.914] |-[ERROR] |-[b75be1cc5b0a444796f86ff51a0d4e39] |-[SYSTEM] |-[g5.dc.impl.DCUtil.init(DCUtil.java:118)] |-[OTHER: Master slave mode and naming-backup is not supported in x-suite.]
[2022-07-06 08:58:42.700] |-[ERROR] |-[6e79b498198e4c849829643c1c85cabb] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.595] |-[ERROR] |-[8899a8bc17be444f80daa7a4a5f6d663] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.596] |-[ERROR] |-[aab55d90203b44d1a533b14d364dc396] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.597] |-[ERROR] |-[f8b0e8abb06944f5aa575fc2df92e34d] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.598] |-[ERROR] |-[be35d363d9454cd981edc9bfbb3d63be] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.601] |-[ERROR] |-[9026a8e38896458db53f860f058b26eb] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.603] |-[ERROR] |-[15c2ad13c6ef47558bdbe5fc623adadb] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.604] |-[ERROR] |-[ffb9c9d32b4c484ab8dd4523d8918f17] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.605] |-[ERROR] |-[5cbea4c8f52f4e4eb384148e4d2649e9] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.606] |-[ERROR] |-[37f622ea23314d6f8c6676929bf8e768] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.608] |-[ERROR] |-[9c3395b0d0ed4f169d5ee4e1447419ba] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.609] |-[ERROR] |-[6249f7cb7c114d48857e915a91f93254] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.609] |-[ERROR] |-[2701655442cb463684cb5ca8e283fe7c] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.610] |-[ERROR] |-[f7199d761aaf4c3f9ab9428e36dec51c] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.611] |-[ERROR] |-[a4a37f2210794f189994a2c44cf8872a] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.613] |-[ERROR] |-[bc80917e2feb4ca3ae22c6ac3d237a2b] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.614] |-[ERROR] |-[3fe3ec1df0304ee2a313c6354d0e7419] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.615] |-[ERROR] |-[6d5d789ef8b4469ea63c426216fc3491] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:58:44.616] |-[ERROR] |-[099daa11df74458d82752265af910f18] |-[SYSTEM] |-[g5.db.rep.ShareDBRep.updateDBid(ShareDBRep.java:864)] |-[OTHER: share db id is invalidate]
[2022-07-06 08:59:26.249] |-[ERROR] |-[b21c5a6159754904927e049fb5254bc8] |-[200009135432694515] |-[g5.common.script.ScriptUtil.addConstants(ScriptUtil.java:63)] |-[DASHBOARD: [home20220706085926-417<新全寿命周期_PC/home.db>]  Constants defined already: EXCEL, cls=class g5.qry.QueryAsset, val=16905, oval=26]
[2022-07-06 08:59:26.250] |-[ERROR] |-[b21c5a6159754904927e049fb5254bc8] |-[200009135432694515] |-[g5.common.script.ScriptUtil.addConstants(ScriptUtil.java:63)] |-[DASHBOARD: [home20220706085926-417<新全寿命周期_PC/home.db>]  Constants defined already: MONGO, cls=class g5.qry.QueryAsset, val=16907, oval=12]
[2022-07-06 08:59:26.250] |-[ERROR] |-[b21c5a6159754904927e049fb5254bc8] |-[200009135432694515] |-[g5.common.script.ScriptUtil.addConstants(ScriptUtil.java:63)] |-[DASHBOARD: [home20220706085926-417<新全寿命周期_PC/home.db>]  Constants defined already: CALC, cls=class g5.qry.QueryAsset, val=16911, oval=g5.script.helper.CalcHelper@1929630b]
[2022-07-06 08:59:26.251] |-[ERROR] |-[b21c5a6159754904927e049fb5254bc8] |-[200009135432694515] |-[g5.common.script.ScriptUtil.addConstants(ScriptUtil.java:63)] |-[DASHBOARD: [home20220706085926-417<新全寿命周期_PC/home.db>]  Constants defined already: NEO4J, cls=class g5.qry.QueryAsset, val=16913, oval=44]
[2022-07-06 08:59:30.870] |-[ERROR] |-[e3a64aba921c4457a5d83d3cbff85b2f] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2000091354326945151655208743219' to length 30.]
[2022-07-06 08:59:37.712] |-[ERROR] |-[a51d688f8af648ab93b69c16cead3767] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 08:59:42.802] |-[ERROR] |-[d615f4a450a14d29ae02b0a399934d5b] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 08:59:58.993] |-[ERROR] |-[9c4300b3f70e41ebb81ff735d009cf1d] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:00:07.065] |-[ERROR] |-[f22e286ad7e74f6188a4b8f1b03653e2] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:00:12.412] |-[ERROR] |-[3dfd737cffb647bd8350a5c283eed4e6] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:00:32.309] |-[ERROR] |-[3e0a1a5c9bad4d2680ff15b65ee4ab2e] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:00:34.339] |-[ERROR] |-[bda39ef5ad2d4df3b91768ae01c0d23d] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home20220706090028-1189<新全寿命周期_PC/home.db>]  [autoSave] ref: path-新全寿命周期_PC/home, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:00:34.339] |-[ERROR] |-[bda39ef5ad2d4df3b91768ae01c0d23d] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home20220706090028-1189<新全寿命周期_PC/home.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:00:42.412] |-[ERROR] |-[8bc84d1e7d72444e8034ff83ba96051e] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:00:44.255] |-[ERROR] |-[9282e964e5d94149b654406aa079b77a] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home20220706090038-1691<新全寿命周期_PC/home.db>]  [autoSave] ref: path-新全寿命周期_PC/home, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:00:44.256] |-[ERROR] |-[9282e964e5d94149b654406aa079b77a] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home20220706090038-1691<新全寿命周期_PC/home.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:00:52.057] |-[ERROR] |-[585733cec34c4860bcbbe97f7c70597f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home20220706090047-1341<新全寿命周期_PC/home.db>]  [autoSave] ref: path-新全寿命周期_PC/home, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:00:52.058] |-[ERROR] |-[585733cec34c4860bcbbe97f7c70597f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home20220706090047-1341<新全寿命周期_PC/home.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:00:52.413] |-[ERROR] |-[1b9ea20e5ed64860948ab36869b9581b] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:00:55.896] |-[ERROR] |-[0d7808f3d11247aaa640d4842e7887ac] |-[262462214438025387] |-[g5.qry.QDepFinder.parseTokens(QDepFinder.java:117)] |-[ERROR: [ErrCode: 8192]  引号'不匹配。]
g5.util.GRTException: 引号'不匹配。
at g5.meta.exp.AExpLexer.preparse(AExpLexer.java:139) ~[product.jar:?]
at g5.qry.QDepFinder$ExpLexer.parse(QDepFinder.java:268) ~[product.jar:?]
at g5.qry.QDepFinder.parseTokens(QDepFinder.java:114) [product.jar:?]
at g5.qry.QDepFinder.fill(QDepFinder.java:40) [product.jar:?]
at g5.db.Dashboard.processScript(Dashboard.java:4331) [product.jar:?]
at g5.db.Dashboard.processElemDep(Dashboard.java:3152) [product.jar:?]
at g5.db.Dashboard.fillDepended(Dashboard.java:324) [product.jar:?]
at g5.db.Dashboard.depended(Dashboard.java:411) [product.jar:?]
at g5.db.Dashboard.depended(Dashboard.java:382) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:153) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:154) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:154) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:154) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:154) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadPermission(AbstractAuthorizationWrapper.java:154) [product.jar:?]
at g5.sv.standardsso.secure.AbstractAuthorizationWrapper.recursionAddReadAccess(AbstractAuthorizationWrapper.java:118) [product.jar:?]
at g5.sv.standardsso.secure.AuthorityUtil.setReadPermission(AuthorityUtil.java:70) [product.jar:?]
at g5.sv.standardsso.secure.AuthorityUtil.initAuthority(AuthorityUtil.java:47) [product.jar:?]
at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:92) [product.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.43]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:9.0.43]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.43]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.43]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [catalina.jar:9.0.43]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.43]
at java.lang.Thread.run(Thread.java:834) [?:?]
[2022-07-06 09:00:58.295] |-[ERROR] |-[5ec46a15e35e453d8f3fb493027a47ef] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:01:00.220] |-[ERROR] |-[0262d77ba83546bc84407e49a53fac0a] |-[admin] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [预览: 工程项目基本信息20220706090053-349<新全寿命周期_PC/工程项目/预览: 工程项目基本信息.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/预览: 工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:00.221] |-[ERROR] |-[0262d77ba83546bc84407e49a53fac0a] |-[admin] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [预览: 工程项目基本信息20220706090053-349<新全寿命周期_PC/工程项目/预览: 工程项目基本信息.db>]  [autoSave] convertAutoSave ref: path-dashboard/admin/新全寿命周期_PC/工程项目/预览: 工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:02.507] |-[ERROR] |-[7e93e9cd93c64b40ac42f5eb4b09abe1] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [1执行项目(二级查询页面)122320220706090056-1413<新全寿命周期_PC/4项目状态管理/4执行管理/1执行项目(二级查询页面)1223.db>]  [autoSave] ref: path-新全寿命周期_PC/4项目状态管理/4执行管理/1执行项目(二级查询页面)1223, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:02.508] |-[ERROR] |-[7e93e9cd93c64b40ac42f5eb4b09abe1] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [1执行项目(二级查询页面)122320220706090056-1413<新全寿命周期_PC/4项目状态管理/4执行管理/1执行项目(二级查询页面)1223.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/4项目状态管理/4执行管理/1执行项目(二级查询页面)1223, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:03.002] |-[ERROR] |-[67d738f5d5804136a3c42bfe0872b757] |-[262462214438025387] |-[g5.sv.ServletHelper.service(ServletHelper.java:105)] |-[ERROR: [ErrCode: 0]  null]
java.lang.NullPointerException: null
at g5.sv.db.DBImageProc.service(DBImageProc.java:134) ~[product.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:101) [product.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:486) [product.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:117) [product.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.43]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:9.0.43]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.43]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.43]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [catalina.jar:9.0.43]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.43]
at java.lang.Thread.run(Thread.java:834) [?:?]
[2022-07-06 09:01:04.292] |-[ERROR] |-[f92a15ac55c147fd8c4523b6cc32aafd] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:01:06.573] |-[ERROR] |-[c37689c2a95b40aa97db6cb06099e386] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [5执行项目(三级项目详情)122820220706090102-1383<新全寿命周期_PC/4项目状态管理/4执行管理/5执行项目(三级项目详情)1228.db>]  [autoSave] ref: path-新全寿命周期_PC/4项目状态管理/4执行管理/5执行项目(三级项目详情)1228, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:06.573] |-[ERROR] |-[c37689c2a95b40aa97db6cb06099e386] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [5执行项目(三级项目详情)122820220706090102-1383<新全寿命周期_PC/4项目状态管理/4执行管理/5执行项目(三级项目详情)1228.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/4项目状态管理/4执行管理/5执行项目(三级项目详情)1228, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:10.513] |-[ERROR] |-[a37c4e1ecaf647d19df82ac5cfa9b683] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home20220706090108-1440<新全寿命周期_PC/home.db>]  [autoSave] ref: path-新全寿命周期_PC/home, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:10.514] |-[ERROR] |-[a37c4e1ecaf647d19df82ac5cfa9b683] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home20220706090108-1440<新全寿命周期_PC/home.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:12.434] |-[ERROR] |-[5c8edbc4ab9249158e64a5a7944463ff] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:01:15.609] |-[ERROR] |-[8bb0182340be4825ae69fe5c5e9e26a5] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home_副本20220706090113-846<新全寿命周期_PC/home_副本.db>]  [autoSave] ref: path-新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:15.610] |-[ERROR] |-[8bb0182340be4825ae69fe5c5e9e26a5] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home_副本20220706090113-846<新全寿命周期_PC/home_副本.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:17.754] |-[ERROR] |-[b81b1bb9f55e47638e43c7fd2e0f5bff] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:01:18.222] |-[ERROR] |-[6e0235b35b034267a939da3675dbde7e] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090115-1441<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:18.223] |-[ERROR] |-[6e0235b35b034267a939da3675dbde7e] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090115-1441<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:22.861] |-[ERROR] |-[2a15ec8b58df4707a78f3409e7183867] |-[admin] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [工程项目基本信息20220706090113-1079<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-3]
[2022-07-06 09:01:22.861] |-[ERROR] |-[2a15ec8b58df4707a78f3409e7183867] |-[admin] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [工程项目基本信息20220706090113-1079<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] convertAutoSave ref: path-dashboard/admin/新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:28.438] |-[ERROR] |-[e03b734c71054e9281699b56410429a6] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [工程项目基本信息20220706090118-727<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:28.439] |-[ERROR] |-[e03b734c71054e9281699b56410429a6] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [工程项目基本信息20220706090118-727<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:34.443] |-[ERROR] |-[67f729e2e3a7498380fe207633a0d240] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home_副本20220706090131-1253<新全寿命周期_PC/home_副本.db>]  [autoSave] ref: path-新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:34.444] |-[ERROR] |-[67f729e2e3a7498380fe207633a0d240] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home_副本20220706090131-1253<新全寿命周期_PC/home_副本.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:36.615] |-[ERROR] |-[374df498f1fd4de88bfbec8bf866a2f2] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:01:36.867] |-[ERROR] |-[42b45f0855964ed78f7fb9ce3a2ea426] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090134-1111<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:36.868] |-[ERROR] |-[42b45f0855964ed78f7fb9ce3a2ea426] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090134-1111<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:41.636] |-[ERROR] |-[c20ee3341fc94a24b5755062f3fb63e2] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '1764691669214626371635736691459' to length 30.]
[2022-07-06 09:01:45.893] |-[ERROR] |-[e2a6c1d2493f45d9ad06d5bee111e33e] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [工程项目基本信息20220706090136-4<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:45.894] |-[ERROR] |-[e2a6c1d2493f45d9ad06d5bee111e33e] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [工程项目基本信息20220706090136-4<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:50.089] |-[ERROR] |-[7dfd84f2f0c447109d4795cbac22cd5c] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home_副本20220706090148-991<新全寿命周期_PC/home_副本.db>]  [autoSave] ref: path-新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:50.089] |-[ERROR] |-[7dfd84f2f0c447109d4795cbac22cd5c] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home_副本20220706090148-991<新全寿命周期_PC/home_副本.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:51.049] |-[ERROR] |-[158b86543c184e879e68f21ef9a10640] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:01:52.787] |-[ERROR] |-[ea0f5be83899468586584d13520a35c5] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090150-1551<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:01:52.787] |-[ERROR] |-[ea0f5be83899468586584d13520a35c5] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [1工程项目(二级查询页面)122320220706090150-1551<新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/1工程项目(二级查询页面)1223, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:01:56.061] |-[ERROR] |-[c90d136068d64b27ae6f5e785f829ba5] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]
[2022-07-06 09:02:03.107] |-[ERROR] |-[a63aaa52e758487f8ee7f4b6c4e0512f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [工程项目基本信息20220706090152-1495<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] ref: path-新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:02:03.107] |-[ERROR] |-[a63aaa52e758487f8ee7f4b6c4e0512f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [工程项目基本信息20220706090152-1495<新全寿命周期_PC/工程项目/工程项目基本信息.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/工程项目/工程项目基本信息, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:02:09.985] |-[ERROR] |-[5bf5aed23125437183cf1d18d8fdce8f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:60)] |-[DASHBOARD: [home_副本20220706090206-1589<新全寿命周期_PC/home_副本.db>]  [autoSave] ref: path-新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-1]
[2022-07-06 09:02:09.986] |-[ERROR] |-[5bf5aed23125437183cf1d18d8fdce8f] |-[262462214438025387] |-[g5.db.impl.AutoSaveMgr.exists(AutoSaveMgr.java:62)] |-[DASHBOARD: [home_副本20220706090206-1589<新全寿命周期_PC/home_副本.db>]  [autoSave] convertAutoSave ref: path-dashboard/陆艺伟/新全寿命周期_PC/home_副本, type-16640, token--1, desc-null, access-0]
[2022-07-06 09:02:14.263] |-[ERROR] |-[83568de3d71a4fb8aaf4ecc7c716b690] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '2624622144380253871649922839830' to length 30.]

作者: Il.Mare 时间: 2022-7-6 09:44
字段太长了，2624622144380253871649922839830' to length 30，超出30了，检查下这个字段呢

作者: yhdata_Te8SgPrq 时间: 2022-7-6 10:18

永洪tech-ab 发表于 2022-7-6 09:44
字段太长了，2624622144380253871649922839830' to length 30，超出30了，检查下这个字段呢 ...

自己数据库里面没有值呀，从日志能不能看出这个报错出自哪个地方，让我知道从哪排查。

作者: Fiona 时间: 2022-7-6 10:36
发的日志没包含：Column index out of range
这个错误看起来是数据库抛出来的，您把报告导出我看一下

作者: yhdata_Te8SgPrq 时间: 2022-7-6 10:39

Fiona 发表于 2022-7-6 10:36
发的日志没包含：Column index out of range
这个错误看起来是数据库抛出来的，您把报告导出我看一下 ...

但重启永洪后就没有这个报错，这是最主要的

报告可以导出来，数据库文件需要吗？

作者: Il.Mare 时间: 2022-7-6 10:39

yhdata_Te8SgPrq 发表于 2022-7-6 10:18
自己数据库里面没有值呀，从日志能不能看出这个报错出自哪个地方，让我知道从哪排查。 ...

您这边是什么表呢？写了什么脚本或者计算列之类的？SQL语句是怎么写的？

作者: yhdata_Te8SgPrq 时间: 2022-7-6 10:42

Fiona 发表于 2022-7-6 10:36
发的日志没包含：Column index out of range
这个错误看起来是数据库抛出来的，您把报告导出我看一下 ...

报告文件

作者: Il.Mare 时间: 2022-7-6 10:55

yhdata_Te8SgPrq 发表于 2022-7-6 10:42
报告文件

稍等

作者: Il.Mare 时间: 2022-7-6 14:12

yhdata_Te8SgPrq 发表于 2022-7-6 10:42
报告文件

麻烦把日志导出来看下呢

欢迎光临永洪社区 (https://club.yonghongtech.com/)