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

QQ登录

只需一步,快速开始

查看: 3372|回复: 3

[结贴] 我开了一个x5 2.7 ,后来关了之后又登录了另一个x5 2.7 ...

[复制链接]

6

主题

24

帖子

284

积分

中级会员

Rank: 3Rank: 3

积分
284
QQ
发表于 2021-2-1 23:09:17 | 显示全部楼层 |阅读模式
我开了一个x5 2.7  ,后来关了之后又登录了另一个x5  2.7    然后就报错


<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:justep="http://www.justep.com/x5#" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xbiz="http://www.justep.com/xbiz#" name="selectPortalProfilesAction" process="/SA/theme/portalProfiles/portalProfilesProcess" activity="mainActivity">
<parameters>
<parameter name="name"><simple type="http://www.w3.org/2001/XMLSchema#string">SHORTCUTS</simple></parameter>
<parameter name="personID"><simple type="http://www.w3.org/2001/XMLSchema#string">81E94563C7BE411BACACE5E5506CDF38</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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT s1.sValue FROM SA_PortalProfiles s1 where s1.sName=:name and s1.sPersonID=:personID
--> sql: SELECT  s1.sValue AS sValue FROM SA_PortalProfiles s1  WHERE  (s1.sName =  ? ) AND (s1.sPersonID =  ? )
--> binds: [SHORTCUTS, 81E94563C7BE411BACACE5E5506CDF38]
        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.KSQL.select(Unknown Source)
        at com.justep.portal.PortalProfilesControl.selectPortalProfiles(PortalProfilesControl.java:45)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  s1.sValue AS sValue FROM SA_PortalProfiles s1  WHERE  (s1.sName =  ? ) AND (s1.sPersonID =  ? ) , binds: [SHORTCUTS, 81E94563C7BE411BACACE5E5506CDF38]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 35 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
        at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 36 more
2021-02-01 22:55:55 freemarker.core.InvalidReferenceException: Expression shortCuts is undefined on line 236, column 59 in root file.
javax.servlet.ServletException: com.justep.ui.exception.UIException: freemarker.core.InvalidReferenceException: Expression shortCuts is undefined on line 236, column 59 in root file.
        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: freemarker.core.InvalidReferenceException: Expression shortCuts is undefined on line 236, column 59 in root file.
        at com.justep.ui.serializer.FreeMarker.execute(Unknown Source)
        at com.justep.ui.WindowServer.freemarker(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        ... 20 more
Caused by: freemarker.core.InvalidReferenceException: Expression shortCuts is undefined on line 236, column 59 in root file.
        at freemarker.core.TemplateObject.a(Unknown Source)
        at freemarker.core.Expression.a(Unknown Source)
        at freemarker.core.Expression.a(Unknown Source)
        at freemarker.core.u.accept(Unknown Source)
        at freemarker.core.Environment.a(Unknown Source)
        at freemarker.core.U.accept(Unknown Source)
        at freemarker.core.Environment.a(Unknown Source)
        at freemarker.core.Environment.process(Unknown Source)
        at freemarker.template.Template.process(Unknown Source)
        at com.justep.ui.serializer.FreeMarker.freemarkerProcess(Unknown Source)
        at com.justep.ui.serializer.FreeMarker.freemarkerProcess(Unknown Source)
        at com.justep.ui.serializer.FreeMarker.generateView4w(Unknown Source)
        ... 23 more
二月 01, 2021 10:55:55 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception

Expression shortCuts is undefined on line 236, column 59 in root file.
The problematic instruction:
----------
==> ${shortCuts} [on line 236, column 57 in root file]
----------



这个    root file.   和 ${shortCuts}     是哪的

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35920
发表于 2021-2-2 09:22:01 | 显示全部楼层
报错是表和视图不存在,确认连的系统库是否正确
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

6

主题

24

帖子

284

积分

中级会员

Rank: 3Rank: 3

积分
284
QQ
 楼主| 发表于 2021-2-2 10:00:34 | 显示全部楼层
jishuang 发表于 2021-2-2 09:22
报错是表和视图不存在,确认连的系统库是否正确

我从新安装了   环境什么的   从新解压了一份     还是报错    而且看了链接的数据源   就是之前链接的   没动过   之前还能登录    我这是不是需要从新编译一下?我看你以前也回复过一个   但是那个帖子没说怎么弄的
http://bbs.wex5.com/forum.php?mo ... idReferenceExceptio
回复 支持 反对

使用道具 举报

6

主题

24

帖子

284

积分

中级会员

Rank: 3Rank: 3

积分
284
QQ
 楼主| 发表于 2021-2-2 11:43:06 | 显示全部楼层
结贴吧   缺了个表
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-5-3 15:07 , Processed in 0.064330 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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