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

QQ登录

只需一步,快速开始

查看: 3459|回复: 1

[结贴] 模式三打包后点登录没反应

[复制链接]

506

主题

1631

帖子

3395

积分

论坛元老

Rank: 8Rank: 8

积分
3395
QQ
发表于 2017-8-21 14:09:52 | 显示全部楼层 |阅读模式
模式三打包后点登录没反应,没有跳到首页
  1. 2017-08-21 14:09:45 加载模块:/UI2/portal/base/login ...
  2. 2017-08-21 14:09:45 加载模块:/UI2/system/service/common ...
  3. 2017-08-21 14:09:45 加载模块:/UI2/system/resources ...
  4. 2017-08-21 14:09:45 加载模块:/UI2/system/resources
  5. 2017-08-21 14:09:45 加载模块:/UI2/system/service/common
  6. 2017-08-21 14:09:45 加载模块:/UI2/portal/base/login
  7. 2017-08-21 14:09:45 加载模块:/system/logic/code/interceptor ...
  8. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select case when UPPER(p.sLoginName)=:name then 1 when UPPER(p.sCode)=:name then 2 else 3 end as odr , mo, mo.sFID, mo.sFName, mo.sFCode, p.* from SA_OPPerson p join SA_OPOrg mo ON p.sMainOrgID = mo where (UPPER(p.sLoginName)=:name or UPPER(p.sCode)=:name) and p.sValidState=1 order by odr
  9.   --> sql:SELECT  CASE WHEN UPPER(p.SLOGINNAME) =  ?  THEN ? WHEN UPPER(p.SCODE) =  ?  THEN ? ELSE ? END  AS odr, mo.sID, mo.sFID AS sFID, mo.sFName AS sFName, mo.SFCODE AS sFCode, p.sID AS p, p.SNAME AS sName, p.SCODE AS sCode, p.SIDCARD AS sIDCard, p.SNUMB AS sNumb, p.SLOGINNAME AS sLoginName, p.SPASSWORD AS sPassword, p.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, p.SPASSWORDMODIFYTIME AS sPasswordModifyTime, p.SMAINORGID AS sMainOrgID, p.SSAFELEVELID AS sSafeLevelID, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.SDESCRIPTION AS sDescription, p.SPHOTO AS sPhoto, p.SPHOTOLASTMODIFIED AS sPhotoLastModified, p.SSEX AS sSex, p.SBIRTHDAY AS sBirthday, p.SJOINDATE AS sJoinDate, p.SHOMEPLACE AS sHomePlace, p.SCOUNTRY AS sCountry, p.SPROVINCE AS sProvince, p.SCITY AS sCity, p.SDEGREE AS sDegree, p.SGRADUATESCHOOL AS sGraduateSchool, p.SSPECIALITY AS sSpeciality, p.SSCHOOLLENGTH AS sSchoolLength, p.STITLE AS sTitle, p.SMARRIAGE AS sMarriage, p.SCARDNO AS sCardNO, p.SCARDKIND AS sCardKind, p.SFAMILYADDRESS AS sFamilyAddress, p.SZIP AS sZip, p.SMSN AS sMsn, p.SQQ AS sQQ, p.SMAIL AS sMail, p.SMOBILEPHONE AS sMobilePhone, p.SFAMILYPHONE AS sFamilyPhone, p.SOFFICEPHONE AS sOfficePhone, p.SENGLISHNAME AS sEnglishName, p.VERSION AS version FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID  WHERE  ( (UPPER(p.SLOGINNAME) =  ? ) OR (UPPER(p.SCODE) =  ? ) ) AND (p.SVALIDSTATE = ?)   ORDER BY odr ASC
  10. --> binds:[SYSTEM, 1, SYSTEM, 2, 3, SYSTEM, SYSTEM, 1]
  11. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT p, p.sName AS pname, p.sCode AS pcode, mo, mo.sFID as m_sfid, mo.sFName as m_sfname, mo.sFCode as m_sfcode , a.sOrgFName as agt_fname, a.sOrgFID as agt_fid, a.sProcess as agt_process  FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.sMainOrgID = mo JOIN SA_OPOrg pm ON pm.sValidState = 1 AND pm.sPersonID = p AND pm.sOrgKindID = 'psm' JOIN SA_OPAgent a ON a.sOrgFID = pm.sFID AND a.sAgentID = 'PSN01' AND a.sValidState = 1 AND (:now >= a.sStartTime OR a.sStartTime IS NULL) AND (a.sFinishTime IS NULL OR a.sFinishTime >= :now)
  12.   --> sql:SELECT  p.sID, p.SNAME AS pname, p.SCODE AS pcode, mo.sID, mo.sFID AS m_sfid, mo.sFName AS m_sfname, mo.SFCODE AS m_sfcode, a.SORGFNAME AS agt_fname, a.SORGFID AS agt_fid, a.SPROCESS AS agt_process FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID JOIN SA_OPOrg pm ON  (pm.SVALIDSTATE = ?) AND (pm.SPERSONID = p.sID) AND (pm.SORGKINDID = ?)  JOIN SA_OPAgent a ON  (a.SORGFID = pm.sFID) AND (a.SAGENTID = ?) AND (a.SVALIDSTATE = ?) AND ( ( ?  >= a.SSTARTTIME) OR (a.SSTARTTIME IS NULL) ) AND ( (a.SFINISHTIME IS NULL) OR (a.SFINISHTIME >=  ? ) )
  13. --> binds:[1, psm, PSN01, 1, 2017-08-21 14:09:46.063, 2017-08-21 14:09:46.063]
  14. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.*  from SA_OPOrg pm  OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%')  JOIN SA_OPRole r ON (au.sAuthorizeRoleID=r AND r.sValidState = 1)  OPTIONAL JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID=r  and perm1.sValidState=1)  WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
  15.   --> sql:SELECT  pm.sFID AS pm_fid, pm.sFName AS pm_fname, pm.SFCODE AS pm_fcode, r.sID, r.SCODE AS r_sCode, r.SNAME AS r_sName, perm1.sID AS perm1, perm1.sPermissionRoleID AS sPermissionRoleID, perm1.SPROCESS AS sProcess, perm1.SACTIVITYFNAME AS sActivityFName, perm1.SACTIVITY AS sActivity, perm1.SACTIONSNAMES AS sActionsNames, perm1.SACTIONS AS sActions, perm1.SSEMANTICDP AS sSemanticDP, perm1.SPERMISSIONKIND AS sPermissionKind, perm1.SDESCRIPTION AS sDescription, perm1.SSEQUENCE AS sSequence, perm1.SVALIDSTATE AS sValidState, perm1.VERSION AS version FROM SA_OPOrg pm LEFT JOIN SA_OPAuthorize au ON pm.sFID LIKE au.SORGFID + ? JOIN SA_OPRole r ON  (au.sAuthorizeRoleID = r.sID) AND (r.SVALIDSTATE = ?)  LEFT JOIN SA_OPPermission perm1 ON  (perm1.sPermissionRoleID = r.sID) AND (perm1.SVALIDSTATE = ?)   WHERE  (pm.SVALIDSTATE = ?) AND (pm.SPERSONID =  ? ) AND (pm.SORGKINDID =  ? )
  16. --> binds:[%, 1, 1, 1, PSN01, psm]
  17. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: select o.sFID, o.sFName, o.sFCode from SA_OPOrg o where o.sValidState=1 and o.sPersonID=:personId
  18.   --> sql:SELECT  o.sFID AS sFID, o.sFName AS sFName, o.SFCODE AS sFCode FROM SA_OPOrg o  WHERE  (o.SVALIDSTATE = ?) AND (o.SPERSONID =  ? )
  19. --> binds:[1, PSN01]
  20. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: select r, par, par.sCode as p_sCode, par.sName as p_sName, p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND r IN ('84696197F4FD4D60ACDFE27ACF9C7B07', 'E9FD20DF69784331A0CE6C401B84D658', 'RL03-demo', '48EB2EAD286044B28EBC03DD29231B50', '29945A90F2414C50B96D88AE1970A8C0', '6DB068CEC83148B3845C8A13663D7879', 'RL-SYSTEM', 'RL-USER')
  21.   --> sql:SELECT  r.sID, par.sID, par.SCODE AS p_sCode, par.SNAME AS p_sName, p.sID AS p, p.sPermissionRoleID AS sPermissionRoleID, p.SPROCESS AS sProcess, p.SACTIVITYFNAME AS sActivityFName, p.SACTIVITY AS sActivity, p.SACTIONSNAMES AS sActionsNames, p.SACTIONS AS sActions, p.SSEMANTICDP AS sSemanticDP, p.SPERMISSIONKIND AS sPermissionKind, p.SDESCRIPTION AS sDescription, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.VERSION AS version FROM SA_OPRole par LEFT JOIN SA_OPPermission p ON  (p.sPermissionRoleID = par.sID) AND (par.SVALIDSTATE = ?) AND (p.SVALIDSTATE = ?)  JOIN (SA_OPRole r LEFT JOIN SA_OPParentRole SA_OPParentRole__1 ON r.sID = SA_OPParentRole__1.sRoleID  ) ON  (par.sID = SA_OPParentRole__1.sParentRoleID) AND ( r.sID IN (?, ?, ?, ?, ?, ?, ?, ?) )
  22. --> binds:[1, 1, 84696197F4FD4D60ACDFE27ACF9C7B07, E9FD20DF69784331A0CE6C401B84D658, RL03-demo, 48EB2EAD286044B28EBC03DD29231B50, 29945A90F2414C50B96D88AE1970A8C0, 6DB068CEC83148B3845C8A13663D7879, RL-SYSTEM, RL-USER]
  23. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:0ms, exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/PSN01@ORG01.psm' like concat(m.sOrgFID, '%')
  24.   --> sql:SELECT  m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m.SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID  WHERE ? LIKE m.SORGFID + ?
  25. --> binds:[/ORG01.ogn/PSN01@ORG01.psm, %]
  26. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:5ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState=1
  27.   --> sql:SELECT  SA_OPPerson.sID, SA_OPPerson.SNAME AS sName FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SVALIDSTATE = ?
  28. --> binds:[1]
  29. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:11ms, exec KSQL: select DISTINCT o.sPersonID as SA_OPPerson, o.sName from SA_OPOrg o where o.sValidState=1 and o.sOrgKindID='psm'
  30.   --> sql:SELECT  DISTINCT  o.SPERSONID AS SA_OPPerson, o.SNAME AS sName FROM SA_OPOrg o  WHERE  (o.SVALIDSTATE = ?) AND (o.SORGKINDID = ?)
  31. --> binds:[1, psm]
  32. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:4ms, exec KSQL: select SA_OPPerson, SA_OPPerson.sName from SA_OPPerson SA_OPPerson where SA_OPPerson.sValidState > 0
  33.   --> sql:SELECT  SA_OPPerson.sID, SA_OPPerson.SNAME AS sName FROM SA_OPPerson SA_OPPerson  WHERE SA_OPPerson.SVALIDSTATE > ?
  34. --> binds:[0]
  35. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:2ms, exec KSQL: select SA_OPOrgVer.* from SA_OPOrgVer SA_OPOrgVer
  36.   --> sql:SELECT  SA_OPOrgVer.sID AS SA_OPOrgVer, SA_OPOrgVer.SNAME AS sName, SA_OPOrgVer.VERSION AS version, SA_OPOrgVer.SCODE AS sCode FROM SA_Code SA_OPOrgVer WHERE SA_OPOrgVer.sType = 'orgVersion'
  37. --> binds:[]
  38. 2017-08-21 14:09:46 加载模块:/portal2/process/portal ...
  39. 2017-08-21 14:09:46 加载模块:/portal2/process ...
  40. 2017-08-21 14:09:46 加载模块:/portal2 ...
  41. 2017-08-21 14:09:46 加载模块:/portal2/logic/code ...
  42. 2017-08-21 14:09:46 加载模块:/portal2/logic ...
  43. 2017-08-21 14:09:46 加载模块:/portal2/data ...
  44. 2017-08-21 14:09:46 加载模块:/portal2/ontology ...
  45. 2017-08-21 14:09:46 加载模块:/portal2/logic/action ...
  46. 2017-08-21 14:09:46 [SQL Time]sql 执行时间:1ms, exec KSQL: SELECT s1.* FROM Portal2Profiles s1 where s1.sPersonID=:personID and s1.sPublishType=:type
  47.   --> sql:SELECT  s1.sID AS s1, s1.VERSION AS version, s1.SPERSONID AS sPersonID, s1.STHEMEACTIVITY AS sThemeActivity, s1.SFUNCTREE AS sFunctree, s1.SPORTAL AS sPortal, s1.SOTHER AS sOther, s1.SPUBLISHTYPE AS sPublishType, s1.STHEMENAME AS sThemeName FROM SA_Portal2Profiles s1  WHERE  (s1.SPERSONID =  ? ) AND (s1.SPUBLISHTYPE =  ? )
  48. --> binds:[PSN01, person4portal3]
复制代码


91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36187
发表于 2017-8-21 16:47:41 | 显示全部楼层
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-7-21 04:44 , Processed in 0.123604 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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