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

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › 5.3问题.
返回列表 发新帖
查看: 1772|回复: 3

[结贴] 5.3问题.

[复制链接]

89

主题

1377

帖子

1837

积分

金牌会员

Rank: 6Rank: 6

积分
1837
QQ
发表于 2014-10-24 16:54:45 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
  1. 2014-10-24 16:54:19 action:<?xml version="1.0" encoding="UTF-8"?>
  2. <action process="/SA/OPM/system/systemProcess" activity="mainActivity" name="loginAction" executeContext="" content-type="application/xml"><parameters><parameter name="pwd"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">E10ADC3949BA59ABBE56E057F20F883E</xbiz:simple></parameter><parameter name="name"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">system</xbiz:simple></parameter><parameter name="loginDate"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#Date">2014-10-24</xbiz:simple></parameter><parameter name="lang"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">zh_CN</xbiz:simple></parameter><parameter name="options"><xbiz:map xmlns:xbiz="http://www.justep.com/xbiz#"><item key="DeviceType"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">Computer</xbiz:simple></item><item key="OperatingSystem"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">WINDOWS_7</xbiz:simple></item></xbiz:map></parameter><parameter name="ip"><xbiz:simple xmlns:xbiz="http://www.justep.com/xbiz#" type="http://www.w3.org/2001/XMLSchema#String">0:0:0:0:0:0:0:1</xbiz:simple></parameter></parameters></action>
  3. java.lang.reflect.InvocationTargetException
  4.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  5.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  6.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  7.         at java.lang.reflect.Method.invoke(Method.java:606)
  8.         at com.justep.system.action.Engine.invokeActions(Native Method)
  9.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  10.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  11.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  12.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  13.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  14.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  15.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  16.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  17.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  18.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  19.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  20.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  21.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  22.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  23.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  24.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  25.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  26.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  27.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  28.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  29.         at java.lang.Thread.run(Thread.java:745)
  30. Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180040; 提示: 查询用户出错
  31.         at com.justep.system.util.BizSystemException.create(Unknown Source)
  32.         at com.justep.system.opm.OrgUtils.select(Unknown Source)
  33.         at com.justep.system.opm.OrgUtils.login(Native Method)
  34.         at com.justep.system.opm.OrgUtils.login1(Unknown Source)
  35.         at OPMProcedure.login(OPMProcedure.java:115)
  36.         at OPMProcedure.login(OPMProcedure.java:100)
  37.         ... 26 more
  38. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, 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
  39.         at com.justep.exception.BusinessException.create(Unknown Source)
  40.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  41.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  42.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
  43.         at com.justep.system.data.KSQL.select(Unknown Source)
  44.         ... 31 more
  45. Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行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, binds: [SYSTEM, 1, SYSTEM, 2, 3, SYSTEM, SYSTEM, 1]出错
  46.         at com.justep.exception.BusinessException.create(Unknown Source)
  47.         at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
  48.         ... 35 more
  49. Caused by: java.sql.SQLException: ORA-00904: "P"."SPHOTOLASTMODIFIED": 标识符无效

  51.         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  52.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  53.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  54.         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  55.         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
  56.         at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
  57.         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
  58.         at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
  59.         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
  60.         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
  61.         at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
  62.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  63.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
  64.         ... 36 more
复制代码

我的数据库已经配置好了. 但是登录时遇到这样的问题,登录页面上显示"查询用户出错"
回复

使用道具 举报

396

主题

2433

帖子

4863

积分

论坛元老

Rank: 8Rank: 8

积分
4863
QQ
发表于 2014-10-24 17:16:30 | 显示全部楼层
错误在"P"."SPHOTOLASTMODIFIED"，数据库中没有SPHOTOLASTMODIFIED这个字段

评分

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

查看全部评分

QQ67886387
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35942
发表于 2014-10-24 17:27:23 | 显示全部楼层
目前还没有提供数据库升级程序，可以先自己到数据库中添加一下字段

SA_OPPerson中加一个sPhotoLastModified字段，类型是Date
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

89

主题

1377

帖子

1837

积分

金牌会员

Rank: 6Rank: 6

积分
1837
QQ
 楼主| 发表于 2014-10-25 09:03:51 | 显示全部楼层
jishuang 发表于 2014-10-24 17:27
目前还没有提供数据库升级程序，可以先自己到数据库中添加一下字段

SA_OPPerson中加一个sPhotoLastModifie ...

恩 好的.多谢
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2024-5-17 11:16 , Processed in 0.089122 second(s), 29 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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