为什么发布到服务器的程序使用一段时间就会报错，重新...

dr琅琊人

为什么发布到服务器的程序使用一段时间就会报错，重新把程序拷一遍又好了？每次报的错都如下图，用一阵子就会再报错，很奇怪

liufanx5

你把 sql:  后面的sql语句弄出来直接到数据库运行一下，看看是不是有哪个条件导致查询出错了

dr琅琊人

liufanx5 发表于 2017-10-30 09:28
你把 sql:  后面的sql语句弄出来直接到数据库运行一下，看看是不是有哪个条件导致查询出错了 ...

不是，这种情况出现了好多次了，语句没问题，程序也没问题，就是要重新拷下程序发布，莫名其妙的

jishuang

看tomcat控制台完整的错误信息

dr琅琊人

jishuang 发表于 2017-10-30 10:46
看tomcat控制台完整的错误信息

tomcat做成了服务，错误信息该怎么看呢？

jishuang

看tomcat的bin或者日志目录是是否有日志，没有到操作系统日志中查找

看model同级的logs中是否有日志文件生成

dr琅琊人

jishuang 发表于 2017-10-30 15:34
看tomcat的bin或者日志目录是是否有日志，没有到操作系统日志中查找

看model同级的logs中是否有日志文件生 ...

2017-10-30 08:42:24 excute stream action, params:{"accept":"application/json","action":"queryHX_ProjectApplyAction","actionFlag":"__action_0__","activity":"LoanCompleteActivity","contentType":"json","executeContext":"","executor":"","parameters":{"aggregateColumns":"ConValue,IRR,Margin,QMGZK,SXRZE","columns":"HX_ProjectApply,WSZJ,YSZLF,fAttachment,fBLDYRY,fBLDYSJ,fBZJCLFS,fBusinessType,fConHireDate,fContact,fContactValue,fContractDate,fContractMode,fContractNo,fContractPerson,fCustomCode,fCustomName,fCustomShortName,fDYDJSBH,fDYHTBH,fDeviceNo,fDevicePrice,fDuration,fEndDate,fEndFlag,fFirstPayment,fFirstPaymentRatio,fFlag,fGuaranteeType,fGuarantor,fGuarantorID,fHanding,fHandingRate,fHireDate,fIntentCode,fLoanCompleteMark,fLoanType,fMQFKR,fMargin,fMarginRate,fMortgage,fPrefix,fProcessName,fProjectCode,fQMGZK,fRFXL,fRepayCyc,fResidence,fSBFZDD,fSBGG,fSBLX,fSBMC,fSBSCS,fSBXH,fSBXSS,fSSBZ,fSXRZE,fSupShortName,fSupplier,fSupplierNo,fTrackNo,fValue,fYJIRR,fZLQMCLFS,version","filter":"(HX_ProjectApply.fFlag ='1' and HX_ProjectApply.fEndFlag ='0' and HX_ProjectApply.fLoanType ='分次放款' and HX_ProjectApply.fLoanCompleteMark ='0')","limit":-1,"offset":0,"variables":{}},"process":"/FinancialLease/HD/process/Lease/leaseProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"HX_ProjectApply","sequence":"HX_ProjectApply,WSZJ,YSZLF,fAttachment,fBLDYRY,fBLDYSJ,fBZJCLFS,fBusinessType,fConHireDate,fContact,fContactValue,fContractDate,fContractMode,fContractNo,fContractPerson,fCustomCode,fCustomName,fCustomShortName,fDYDJSBH,fDYHTBH,fDeviceNo,fDevicePrice,fDuration,fEndDate,fEndFlag,fFirstPayment,fFirstPaymentRatio,fFlag,fGuaranteeType,fGuarantor,fGuarantorID,fHanding,fHandingRate,fHireDate,fIntentCode,fLoanCompleteMark,fLoanType,fMQFKR,fMargin,fMarginRate,fMortgage,fPrefix,fProcessName,fProjectCode,fQMGZK,fRFXL,fRepayCyc,fResidence,fSBFZDD,fSBGG,fSBLX,fSBMC,fSBSCS,fSBXH,fSBXSS,fSSBZ,fSXRZE,fSupShortName,fSupplier,fSupplierNo,fTrackNo,fValue,fYJIRR,fZLQMCLFS,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

dr琅琊人

jishuang 发表于 2017-10-30 15:34
看tomcat的bin或者日志目录是是否有日志，没有到操作系统日志中查找

看model同级的logs中是否有日志文件生 ...

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT HX_ProjectApply.*,SQL.isnull((select  sum(FI_RentWriteOff.fIncome) from FI_RentWriteOff FI_RentWriteOff  where  FI_RentWriteOff.fXJLID in (select  HX_YJXJL from HX_YJXJL HX_YJXJL  where  HX_YJXJL.fLXID = HX_ProjectApply AND HX_YJXJL.fQC <> 0 ) ), 0) as YSZLF,  SQL.isnull((select   sum(HX_YJXJL.fZLFSQ) + sum(HX_YJXJL.fQMGZF)  from HX_YJXJL HX_YJXJL  where HX_YJXJL.fLXID = HX_ProjectApply), 0) - SQL.isnull((select  sum(FI_RentWriteOff.fIncome) from FI_RentWriteOff FI_RentWriteOff  where  FI_RentWriteOff.fXJLID in (select  HX_YJXJL from HX_YJXJL HX_YJXJL  where  HX_YJXJL.fLXID = HX_ProjectApply AND HX_YJXJL.fQC <> 0 ) ), 0)  - SQL.isnull((select  sum(FI_LawRentOff.fHMJE) from FI_LawRentOff FI_LawRentOff  where  FI_LawRentOff.fZJZFBID in (select  HX_YJXJL from HX_YJXJL HX_YJXJL  where  HX_YJXJL.fLXID = HX_ProjectApply AND HX_YJXJL.fQC <> 0 ) ), 0)  as WSZJ  FROM HX_ProjectApply HX_ProjectApply WHERE ((HX_ProjectApply.fFlag ='1' and HX_ProjectApply.fEndFlag ='0' and HX_ProjectApply.fLoanType ='分次放款' and HX_ProjectApply.fLoanCompleteMark ='0')) LIMIT 0, -1
--> sql: SELECT  HX_ProjectApply.fID AS HX_ProjectApply, ( ( isnull((SELECT  ( SUM(HX_YJXJL.FZLFSQ) + SUM(HX_YJXJL.FQMGZF) ) FROM HX_YJXJL HX_YJXJL  WHERE HX_YJXJL.FLXID = HX_ProjectApply.fID), ?) - isnull((SELECT  SUM(FI_RentWriteOff.FINCOME) FROM FI_RENTWRITEOFF FI_RentWriteOff  WHERE FI_RentWriteOff.FXJLID IN (SELECT  HX_YJXJL.fID FROM HX_YJXJL HX_YJXJL  WHERE  (HX_YJXJL.FLXID = HX_ProjectApply.fID) AND (HX_YJXJL.FQC <> ?) )), ?) ) - isnull((SELECT  SUM(FI_LawRentOff.FHMJE) FROM FI_LAWRENTOFF FI_LawRentOff  WHERE FI_LawRentOff.FZJZFBID IN (SELECT  HX_YJXJL.fID FROM HX_YJXJL HX_YJXJL  WHERE  (HX_YJXJL.FLXID = HX_ProjectApply.fID) AND (HX_YJXJL.FQC <> ?) )), ?) ) AS WSZJ, isnull((SELECT  SUM(FI_RentWriteOff.FINCOME) FROM FI_RENTWRITEOFF FI_RentWriteOff  WHERE FI_RentWriteOff.FXJLID IN (SELECT  HX_YJXJL.fID FROM HX_YJXJL HX_YJXJL  WHERE  (HX_YJXJL.FLXID = HX_ProjectApply.fID) AND (HX_YJXJL.FQC <> ?) )), ?) AS YSZLF, HX_ProjectApply.FATTACHMENT AS fAttachment, HX_ProjectApply.FBLDYRY AS fBLDYRY, HX_ProjectApply.FBLDYSJ AS fBLDYSJ, HX_ProjectApply.FBZJCLFS AS fBZJCLFS, HX_ProjectApply.FBUSINESSTYPE AS fBusinessType, HX_ProjectApply.FCONHIREDATE AS fConHireDate, HX_ProjectApply.FCONTACT AS fContact, HX_ProjectApply.FCONTACTVALUE AS fContactValue, HX_ProjectApply.FCONTRACTDATE AS fContractDate, HX_ProjectApply.FCONTRACTMODE AS fContractMode, HX_ProjectApply.FCONTRACTNO AS fContractNo, HX_ProjectApply.FCONTRACTPERSON AS fContractPerson, HX_ProjectApply.FCUSTOMCODE AS fCustomCode, HX_ProjectApply.FCUSTOMNAME AS fCustomName, HX_ProjectApply.FCUSTOMSHORTNAME AS fCustomShortName, HX_ProjectApply.FDYDJSBH AS fDYDJSBH, HX_ProjectApply.FDYHTBH AS fDYHTBH, HX_ProjectApply.FDEVICENO AS fDeviceNo, HX_ProjectApply.FDEVICEPRICE AS fDevicePrice, HX_ProjectApply.FDURATION AS fDuration, HX_ProjectApply.FENDDATE AS fEndDate, HX_ProjectApply.FENDFLAG AS fEndFlag, HX_ProjectApply.FFIRSTPAYMENT AS fFirstPayment, HX_ProjectApply.FFIRSTPAYMENTRATIO AS fFirstPaymentRatio, HX_ProjectApply.FFLAG AS fFlag, HX_ProjectApply.FGUARANTEETYPE AS fGuaranteeType, HX_ProjectApply.FGUARANTOR AS fGuarantor, HX_ProjectApply.FGUARANTORID AS fGuarantorID, HX_ProjectApply.FHANDING AS fHanding, HX_ProjectApply.FHANDINGRATE AS fHandingRate, HX_ProjectApply.FHIREDATE AS fHireDate, HX_ProjectApply.FINTENTCODE AS fIntentCode, HX_ProjectApply.FLOANCOMPLETEMARK AS fLoanCompleteMark, HX_ProjectApply.FLOANTYPE AS fLoanType, HX_ProjectApply.FMQFKR AS fMQFKR, HX_ProjectApply.FMARGIN AS fMargin, HX_ProjectApply.FMARGINRATE AS fMarginRate, HX_ProjectApply.FMORTGAGE AS fMortgage, HX_ProjectApply.FPREFIX AS fPrefix, HX_ProjectApply.FPROCESSNAME AS fProcessName, HX_ProjectApply.FPROJECTCODE AS fProjectCode, HX_ProjectApply.FQMGZK AS fQMGZK, HX_ProjectApply.FRFXL AS fRFXL, HX_ProjectApply.FREPAYCYC AS fRepayCyc, HX_ProjectApply.FRESIDENCE AS fResidence, HX_ProjectApply.FSBFZDD AS fSBFZDD, HX_ProjectApply.FSBGG AS fSBGG, HX_ProjectApply.FSBLX AS fSBLX, HX_ProjectApply.FSBMC AS fSBMC, HX_ProjectApply.FSBSCS AS fSBSCS, HX_ProjectApply.FSBXH AS fSBXH, HX_ProjectApply.FSBXSS AS fSBXSS, HX_ProjectApply.FSSBZ AS fSSBZ, HX_ProjectApply.FSXRZE AS fSXRZE, HX_ProjectApply.FSUPSHORTNAME AS fSupShortName, HX_ProjectApply.FSUPPLIER AS fSupplier, HX_ProjectApply.FSUPPLIERNO AS fSupplierNo, HX_ProjectApply.FTRACKNO AS fTrackNo, HX_ProjectApply.FVALUE AS fValue, HX_ProjectApply.FYJIRR AS fYJIRR, HX_ProjectApply.FZLQMCLFS AS fZLQMCLFS, HX_ProjectApply.VERSION AS version FROM HX_ProjectApply HX_ProjectApply  WHERE  (HX_ProjectApply.FFLAG = ?) AND (HX_ProjectApply.FENDFLAG = ?) AND (HX_ProjectApply.FLOANTYPE = ?) AND (HX_ProjectApply.FLOANCOMPLETEMARK = ?)
--> binds: [0, 0, 0, 0, 0, 0, 0, 1, 0, 分次放款, 0]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 27 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 1932
        at net.sourceforge.jtds.jdbc.TdsData.readData(TdsData.java:767)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsRowToken(TdsCore.java:2968)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2236)
        at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:761)
        at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:593)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
        ... 32 more

jishuang

这个是数组越界的错误，确认每次都是报的错误吗？