起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 6327|回复: 12

[结贴] 界面加载报错

[复制链接]

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
发表于 2013-9-26 11:48:48 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
如图,有时候近这个界面的时候就加载报错,有时候又正常。什么情况?

  1. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  2.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  3.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  4.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  5.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  6.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  7.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  8.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  9.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  10.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  11.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  12.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  13.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  14.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  15.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  16.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  17.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  18.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  19.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  20.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  21.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  22.         at java.lang.Thread.run(Thread.java:595)
  23. Caused by: java.lang.reflect.InvocationTargetException
  24.         at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
  25.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  26.         at java.lang.reflect.Method.invoke(Method.java:592)
  27.         at com.justep.system.action.Engine.invokeActions(Native Method)
  28.         ... 21 more
  29. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT V_HR_OG_OrgIndex.*  FROM V_HR_OG_OrgIndex V_HR_OG_OrgIndex WHERE ((not(fOrgKind = 'psn' or fOrgKind = 'psp')) AND (fParent IS NULL OR fParent='')) ORDER BY fSequence ASC LIMIT 0, -1时出错!
  30.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  31.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  32.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  33.         at com.justep.system.data.BizData.query(Unknown Source)
  34.         at BizProcedure.query(BizProcedure.java:12)
  35.         ... 25 more
  36. Caused by: com.justep.model.exception.ModelException: 执行sql:SELECT  V_HR_OG_OrgIndex.VERSION AS version, V_HR_OG_OrgIndex.fParent AS fParent, V_HR_OG_OrgIndex.FSEQUENCE AS fSequence, V_HR_OG_OrgIndex.FORGKINDSEQUENCE AS fOrgKindSequence, V_HR_OG_OrgIndex.FORGKIND AS fOrgKind, V_HR_OG_OrgIndex.FORGKINDNAME AS fOrgKindName, V_HR_OG_OrgIndex.FCODE AS fCode, V_HR_OG_OrgIndex.FNAME AS fName, V_HR_OG_OrgIndex.FURL AS fURL, V_HR_OG_OrgIndex.FCODEURL AS fCodeURL, V_HR_OG_OrgIndex.FDISPLAYURL AS fDisplayURL, V_HR_OG_OrgIndex.FEMPSTATUS AS fEmpStatus, V_HR_OG_OrgIndex.FEMPSTATUSNAME AS fEmpStatusName, V_HR_OG_OrgIndex.FSEX AS fSex, V_HR_OG_OrgIndex.FIDCARD AS fIDCard, V_HR_OG_OrgIndex.FUSESTATUSNAME AS fUseStatusName, V_HR_OG_OrgIndex.fID AS V_HR_OG_OrgIndex FROM V_HR_OG_OrgIndex V_HR_OG_OrgIndex  WHERE  ( NOT ( (fOrgKind = ?) OR (fOrgKind = ?) )) AND ( (fParent IS NULL) OR (fParent = ?) )   ORDER BY fSequence ASC, binds:[psn, psp, ]出错!
  37.         at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
  38.         ... 30 more
  39. Caused by: java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
  40.         at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
  41.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
  42.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
  43.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  44.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  45.         ... 31 more
  46. Caused by: java.net.SocketException: Connection reset by peer: socket write error
  47.         at java.net.SocketOutputStream.socketWrite0(Native Method)
  48.         at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
  49.         at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  50.         at java.io.DataOutputStream.write(DataOutputStream.java:90)
  51.         at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
  52.         at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
  53.         at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
  54.         at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
  55.         ... 35 more
  56. 2013-09-26 11:45:33 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
  57. <action direct-execute="true" process="/TCERP/employee/process/employeeBasicInfomation/employeeBasicInfomationList/employeeBasicInfomationListProcess" activity="empInfoListActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="queryV_HR_OG_OrgIndexAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(not(fOrgKind = 'psn' or fOrgKind = 'psp')) AND (fParent IS NULL OR fParent='')]]></xbiz:simple></parameter><parameter name="offset"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">0</xbiz:simple></parameter><parameter name="limit"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Integer">-1</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fParent,fSequence,fOrgKindSequence,fOrgKind,fOrgKindName,fCode,fName,fURL,fCodeURL,fDisplayURL,fEmpStatus,fEmpStatusName,fSex,fIDCard,fUseStatusName,V_HR_OG_OrgIndex]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fSequence ASC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-tree" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="V_HR_OG_OrgIndex" sequence="fName,space-column,version,fParent,fSequence,fOrgKindSequence,fOrgKind,fOrgKindName,fCode,fURL,fCodeURL,fDisplayURL,fEmpStatus,fEmpStatusName,fSex,fIDCard,fUseStatusName"><tree-option virtual-root="_is_root_" virtual-root-label="组织机构"/></rows-config></translate-parameter></action>
  58. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  59.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  60.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  61.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  62.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  63.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  64.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  65.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  66.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  67.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  68.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  69.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  70.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  71.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  72.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  73.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  74.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  75.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  76.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  77.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  78.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  79.         at java.lang.Thread.run(Thread.java:595)
  80. Caused by: java.lang.reflect.InvocationTargetException
  81.         at sun.reflect.GeneratedMethodAccessor130.invoke(Unknown Source)
  82.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  83.         at java.lang.reflect.Method.invoke(Method.java:592)
  84.         at com.justep.system.action.Engine.invokeActions(Native Method)
  85.         ... 21 more
  86. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT V_HR_OG_OrgIndex.*  FROM V_HR_OG_OrgIndex V_HR_OG_OrgIndex WHERE ((not(fOrgKind = 'psn' or fOrgKind = 'psp')) AND (fParent IS NULL OR fParent='')) ORDER BY fSequence ASC LIMIT 0, -1时出错!
  87.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  88.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  89.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  90.         at com.justep.system.data.BizData.query(Unknown Source)
  91.         at BizProcedure.query(BizProcedure.java:12)
  92.         ... 25 more
  93. Caused by: com.justep.model.exception.ModelException: 执行sql:SELECT  V_HR_OG_OrgIndex.VERSION AS version, V_HR_OG_OrgIndex.fParent AS fParent, V_HR_OG_OrgIndex.FSEQUENCE AS fSequence, V_HR_OG_OrgIndex.FORGKINDSEQUENCE AS fOrgKindSequence, V_HR_OG_OrgIndex.FORGKIND AS fOrgKind, V_HR_OG_OrgIndex.FORGKINDNAME AS fOrgKindName, V_HR_OG_OrgIndex.FCODE AS fCode, V_HR_OG_OrgIndex.FNAME AS fName, V_HR_OG_OrgIndex.FURL AS fURL, V_HR_OG_OrgIndex.FCODEURL AS fCodeURL, V_HR_OG_OrgIndex.FDISPLAYURL AS fDisplayURL, V_HR_OG_OrgIndex.FEMPSTATUS AS fEmpStatus, V_HR_OG_OrgIndex.FEMPSTATUSNAME AS fEmpStatusName, V_HR_OG_OrgIndex.FSEX AS fSex, V_HR_OG_OrgIndex.FIDCARD AS fIDCard, V_HR_OG_OrgIndex.FUSESTATUSNAME AS fUseStatusName, V_HR_OG_OrgIndex.fID AS V_HR_OG_OrgIndex FROM V_HR_OG_OrgIndex V_HR_OG_OrgIndex  WHERE  ( NOT ( (fOrgKind = ?) OR (fOrgKind = ?) )) AND ( (fParent IS NULL) OR (fParent = ?) )   ORDER BY fSequence ASC, binds:[psn, psp, ]出错!
  94.         at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
  95.         ... 30 more
  96. Caused by: java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
  97.         at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
  98.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
  99.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
  100.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  101.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  102.         ... 31 more
  103. Caused by: java.net.SocketException: Connection reset by peer: socket write error
  104.         at java.net.SocketOutputStream.socketWrite0(Native Method)
  105.         at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
  106.         at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  107.         at java.io.DataOutputStream.write(DataOutputStream.java:90)
  108.         at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
  109.         at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
  110.         at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
  111.         at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
  112.         ... 35 more
复制代码
QQ截图20130926114553.png
天天就知道打酱油打酱油,有点出息行么。QQ:497923435

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2013-9-26 11:49:16 | 显示全部楼层
后台异常信息
天天就知道打酱油打酱油,有点出息行么。QQ:497923435
回复 支持 反对

使用道具 举报

45

主题

4492

帖子

3960

积分

论坛元老

Rank: 8Rank: 8

积分
3960
QQ
发表于 2013-9-26 12:06:17 | 显示全部楼层
KSQL语句,WHERE条件中在关系名前加概念名称。
向前进,向前进,我们……
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35944
发表于 2013-9-26 13:15:17 | 显示全部楼层
确认数据库联系是否正确,这个是视图确认是否权限设置的不对
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2013-9-26 14:21:28 | 显示全部楼层
jishuang 发表于 2013-9-26 13:15
确认数据库联系是否正确,这个是视图确认是否权限设置的不对

具体 怎么确认。
天天就知道打酱油打酱油,有点出息行么。QQ:497923435
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35944
发表于 2013-9-26 15:06:26 | 显示全部楼层
数据库中执行一下视图看看是否正确
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2013-9-26 15:22:31 | 显示全部楼层
jishuang 发表于 2013-9-26 15:06
数据库中执行一下视图看看是否正确

没问题
天天就知道打酱油打酱油,有点出息行么。QQ:497923435
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35944
发表于 2013-9-26 15:25:55 | 显示全部楼层
上面报错的sql拿到数据库中执行也是正确的?
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2013-9-26 15:27:52 | 显示全部楼层
jishuang 发表于 2013-9-26 15:25
上面报错的sql拿到数据库中执行也是正确的?

对啊。没问题。错误是有时候报有时候又不报,不知道什么时候出现。
天天就知道打酱油打酱油,有点出息行么。QQ:497923435
回复 支持 反对

使用道具 举报

998

主题

4330

帖子

1万

积分

论坛元老

Rank: 8Rank: 8

积分
10732
QQ
发表于 2013-9-26 15:55:43 | 显示全部楼层
数据库连接有问题,
数据库连接.jpg

评分

参与人数 1 +3 收起 理由
jishuang + 3 赞一个!

查看全部评分

孤舟蓑笠翁,独钓寒江雪。
X5牛刀交流民间第一群:30057529
提供有偿服务,联系WX:18332024
bex5疑难问题解决方案
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-20 17:23 , Processed in 0.082920 second(s), 32 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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