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

QQ登录

只需一步,快速开始

12
返回列表 发新帖
楼主: tianhaoweiUp

[处理中3] 企业微信集成访问首页出错!麻烦给看下 急

[复制链接]

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-3 18:50:54 | 显示全部楼层
jishuang 发表于 2020-9-3 17:53
/UI2/SA/weixin/src/com/justep/weixin/cp/WxHelper.java 中是执行action的代码,跟踪一下看看,确认config ...

现在有开始报组织同步问题
select  SA_OPOrg,SA_OPOrg.sName,SA_OPOrg.sParent,(select a.sWxDeptID from SA_OPOrg a where a = SA_OPOrg.sParent) AS wxParentDeptID FROM SA_OPOrg SA_OPOrg where  (SA_OPOrg.sWxDeptID  is null or SA_OPOrg.sWxDeptID = '')   and SA_OPOrg.sValidState = 1 and SA_OPOrg.sOrgKindID in ('ogn','dpt') and length(SA_OPOrg.sSequence) = 4 order by SA_OPOrg.sSequence
2020-09-03 18:53:31 api forbidden, hint: [1599129963_56_c292f4c38b74c9b5aefca5fa2cf8110a], from ip: 125.33.244.172, more info at https://open.work.weixin.qq.com/devtool/query?e=48002
2020-09-03 18:53:31 api forbidden, hint: [1599129963_54_9211cde8d805a239bf9a4897876cd5f1], from ip: 125.33.244.172, more info at https://open.work.weixin.qq.com/devtool/query?e=48002
select  SA_OPOrg,SA_OPOrg.sName,SA_OPOrg.sParent,(select a.sWxDeptID from SA_OPOrg a where a = SA_OPOrg.sParent) AS wxParentDeptID FROM SA_OPOrg SA_OPOrg where  (SA_OPOrg.sWxDeptID  is null or SA_OPOrg.sWxDeptID = '')   and SA_OPOrg.sValidState = 1 and SA_OPOrg.sOrgKindID in ('ogn','dpt') and length(SA_OPOrg.sSequence) = 8 order by SA_OPOrg.sSequence
2020-09-03 18:53:31 action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/SA/weixin/process/weixin/weixinProcess" activity="mainActivity" name="orgSynchToWeixinAction" execute-context="configKey=ww03061d01fbbd2aa21000002;" content-type="application/xml"><parameters><parameter name="AccountType"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">人员编码</xbiz:simple></parameter></parameters></action>
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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)
Caused by: java.lang.NullPointerException
        at orgSynchronizeToWeixin.InsertwxDepart(orgSynchronizeToWeixin.java:370)
        at orgSynchronizeToWeixin.orgSynchToWeixin(orgSynchronizeToWeixin.java:149)
        ... 30 more


回复 支持 反对

使用道具 举报

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-3 18:51:34 | 显示全部楼层
jishuang 发表于 2020-9-3 17:53
/UI2/SA/weixin/src/com/justep/weixin/cp/WxHelper.java 中是执行action的代码,跟踪一下看看,确认config ...

2020-09-03 18:53:31

java.lang.RuntimeException: null

        at Synchweixin.doExec(Synchweixin.java:49)

        at Synchweixin.execute(Synchweixin.java:24)

        at com.justep.ui.JavaServer.runJava(Unknown Source)

        at com.justep.ui.JavaServer.doJ(Unknown Source)

        at com.justep.ui.JavaServer.service(Native Method)

        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        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)

2020-09-03 18:53:31 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/Synchweixin.j)执行失败

javax.servlet.ServletException: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/Synchweixin.j)执行失败

        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        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)

Caused by: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/Synchweixin.j)执行失败

        at com.justep.ui.exception.UIException.create(Unknown Source)

        at com.justep.ui.JavaServer.doJ(Unknown Source)

        at com.justep.ui.JavaServer.service(Native Method)

        ... 20 more

Caused by: java.lang.RuntimeException: null

        at Synchweixin.doExec(Synchweixin.java:49)

        at Synchweixin.execute(Synchweixin.java:24)

        at com.justep.ui.JavaServer.runJava(Unknown Source)

        ... 22 more

九月 03, 2020 6:53:31 下午 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet main-servlet threw exception

java.lang.RuntimeException: null

        at Synchweixin.doExec(Synchweixin.java:49)

        at Synchweixin.execute(Synchweixin.java:24)

        at com.justep.ui.JavaServer.runJava(Unknown Source)

        at com.justep.ui.JavaServer.doJ(Unknown Source)

        at com.justep.ui.JavaServer.service(Native Method)

        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        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)
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2020-9-4 09:03:34 | 显示全部楼层
Caused by: java.lang.NullPointerException
        at orgSynchronizeToWeixin.InsertwxDepart(orgSynchronizeToWeixin.java:370)
        at orgSynchronizeToWeixin.orgSynchToWeixin(orgSynchronizeToWeixin.java:149)

调试看看什么空指针了
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-4 09:10:49 | 显示全部楼层
jishuang 发表于 2020-9-4 09:03
Caused by: java.lang.NullPointerException
        at orgSynchronizeToWeixin.InsertwxDepart(orgSynchr ...

select  SA_OPOrg,SA_OPOrg.sName,SA_OPOrg.sParent,(select a.sWxDeptID from SA_OPOrg a where a = SA_OPOrg.sParent) AS wxParentDeptID FROM SA_OPOrg SA_OPOrg where  (SA_OPOrg.sWxDeptID  is null or SA_OPOrg.sWxDeptID = '')   and SA_OPOrg.sValidState = 1 and SA_OPOrg.sOrgKindID in ('ogn','dpt') and length(SA_OPOrg.sSequence) = 4 order by SA_OPOrg.sSequence

select  SA_OPOrg,SA_OPOrg.sName,SA_OPOrg.sParent,(select a.sWxDeptID from SA_OPOrg a where a = SA_OPOrg.sParent) AS wxParentDeptID FROM SA_OPOrg SA_OPOrg where  (SA_OPOrg.sWxDeptID  is null or SA_OPOrg.sWxDeptID = '')   and SA_OPOrg.sValidState = 1 and SA_OPOrg.sOrgKindID in ('ogn','dpt') and length(SA_OPOrg.sSequence) = 8 order by SA_OPOrg.sSequence

是这个 两句sql 查不到 是空的
回复 支持 反对

使用道具 举报

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-4 09:27:32 | 显示全部楼层
jishuang 发表于 2020-9-4 09:03
Caused by: java.lang.NullPointerException
        at orgSynchronizeToWeixin.InsertwxDepart(orgSynchr ...

select a.sWxDeptID from SA_OPOrg a where a = SA_OPOrg.sParent


sWxDeptID这个字值是空的,请问这个字段值是怎么来的
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2020-9-4 11:19:02 | 显示全部楼层
为空的数据会去做处理,确认是不是微信中有的部门平台中没有
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-4 11:36:08 | 显示全部楼层
jishuang 发表于 2020-9-4 11:19
为空的数据会去做处理,确认是不是微信中有的部门平台中没有

组织同步现在可以了,就访问工作台首页的时候还是报错
回复 支持 反对

使用道具 举报

111

主题

293

帖子

879

积分

高级会员

Rank: 4

积分
879
QQ
 楼主| 发表于 2020-9-4 11:37:16 | 显示全部楼层
jishuang 发表于 2020-9-4 11:19
为空的数据会去做处理,确认是不是微信中有的部门平台中没有


jishuang 发表于 2020-9-2 19:39
看tomcat控制台完整的错误信息

2020-09-03 11:58:04
java.lang.RuntimeException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; 文件提前结束。
        at WeixinCallback.doExecute(WeixinCallback.java:51)
        at WeixinCallback.execute(WeixinCallback.java:23)
        at com.justep.ui.JavaServer.runJava(Unknown Source)
        at com.justep.ui.JavaServer.doJ(Unknown Source)
        at com.justep.ui.JavaServer.service(Native Method)
        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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)
2020-09-03 11:58:04 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/weixinCallback.j)执行失败
javax.servlet.ServletException: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/weixinCallback.j)执行失败
        at com.justep.ui.servlet.MainServlet.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 com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.ui.filter.MicroServiceAdminFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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)
Caused by: com.justep.ui.exception.UIException: 编码: JUSTEP002026; 提示: .J(/UI2/SA/weixin/weixinCallback.j)执行失败
        at com.justep.ui.exception.UIException.create(Unknown Source)
        at com.justep.ui.JavaServer.doJ(Unknown Source)
        at com.justep.ui.JavaServer.service(Native Method)
        ... 20 more
Caused by: java.lang.RuntimeException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; 文件提前结束。
        at WeixinCallback.doExecute(WeixinCallback.java:51)
        at WeixinCallback.execute(WeixinCallback.java:23)
        at com.justep.ui.JavaServer.runJava(Unknown Source)
        ... 22 more

这个错误 没有头绪
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2020-9-4 13:30:45 | 显示全部楼层
http://bbs.wex5.com/forum.php?mo ... 5&pid=165659845


看action执行的时候参数什么的是否正确,看返回的是什么
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-11-25 13:54 , Processed in 0.105112 second(s), 21 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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