表映射问题

ly201026

如图，数据源引用的是StorageBaseCode概念。而在建概念StorageBaseCode的时候映射的是HR_Pub_BaseCode基础表。为什么在界面加载后会有图3中错误提示，SQL直接查的是StorageBaseCode

jishuang

控制台详细的错误信息发一下看看
queryAction是执行的KSQL，是查的概念，不直接查数据库中的表

ly201026

jishuang 发表于 2013-10-9 16:12
控制台详细的错误信息发一下看看
queryAction是执行的KSQL，是查的概念，不直接查数据库中的表 ...

1. 
   
2. 2013-10-09 16:14:43 invokeActions error！
   
3. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
   
4.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
5.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
6.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
7.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
8.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
   
9.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
   
10.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
11.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
12.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
13.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
14.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
15.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
16.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
17.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
18.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
19.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
20.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
21.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
22.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
23.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
24.         at java.lang.Thread.run(Thread.java:595)
    
25. Caused by: java.lang.reflect.InvocationTargetException
    
26.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
27.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
28.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
29.         at java.lang.reflect.Method.invoke(Method.java:592)
    
30.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
31.         ... 21 more
    
32. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT StorageBaseCode.*  FROM StorageBaseCode StorageBaseCode ORDER BY fSequence ASC LIMIT 0, 20时出错！
    
33.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
34.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
35.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
36.         at com.justep.system.data.BizData.query(Unknown Source)
    
37.         at BizProcedure.query(BizProcedure.java:12)
    
38.         ... 26 more
    
39. Caused by: com.justep.model.exception.ModelException: 模型/TCERP/Storage/data下未找到概念StorageBaseCode的Store配置！
    
40.         at com.justep.util.Utils.check(Unknown Source)
    
41.         at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source)
    
42.         at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
    
43.         at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
    
44.         at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
    
45.         at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
46.         at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
47.         at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
    
48.         ... 31 more
    
49. 2013-10-09 16:14:43 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
    
50. <action direct-execute="true" process="/TCERP/storageBaseCode/process/storageBaseCode/storageBaseCodeProcess" activity="baseCodeActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="queryStorageBaseCodeAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></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">20</xbiz:simple></parameter><parameter name="columns"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[version,fCode,fName,fDescription,fSequence,fUseStatus,fUseStatusName,fParentCode,fLevel,fURL,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime,StorageBaseCode]]></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-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="StorageBaseCode" sequence="fUseStatusName,fSequence,fCode,fName,fDescription,space-column,version,fUseStatus,fParentCode,fLevel,fURL,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime"/></translate-parameter></action>
    
51. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
    
52.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
53.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
54.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
55.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
56.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
57.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
58.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
59.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
60.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
61.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
62.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
63.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
64.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
65.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
66.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
67.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
68.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
69.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
70.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
71.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
72.         at java.lang.Thread.run(Thread.java:595)
    
73. Caused by: java.lang.reflect.InvocationTargetException
    
74.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
75.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
76.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
77.         at java.lang.reflect.Method.invoke(Method.java:592)
    
78.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
79.         ... 21 more
    
80. Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT StorageBaseCode.*  FROM StorageBaseCode StorageBaseCode ORDER BY fSequence ASC LIMIT 0, 20时出错！
    
81.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
82.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
83.         at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
    
84.         at com.justep.system.data.BizData.query(Unknown Source)
    
85.         at BizProcedure.query(BizProcedure.java:12)
    
86.         ... 26 more
    
87. Caused by: com.justep.model.exception.ModelException: 模型/TCERP/Storage/data下未找到概念StorageBaseCode的Store配置！
    
88.         at com.justep.util.Utils.check(Unknown Source)
    
89.         at com.justep.system.ksql.ConceptMapping.getConceptMapping(Unknown Source)
    
90.         at com.justep.system.ksql.parser.AbstractParser.confirmSymTable(Unknown Source)
    
91.         at com.justep.system.ksql.parser.AbstractParser.handleAllRelation(Unknown Source)
    
92.         at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
    
93.         at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
94.         at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
    
95.         at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
    
96.         ... 31 more
    

复制代码

jishuang

模型/TCERP/Storage/data下未找到概念StorageBaseCode的Store配置

引用其他模块的？http://bbs.justep.com/forum.php?mod=viewthread&tid=40985

ly201026

jishuang 发表于 2013-10-9 16:26
模型/TCERP/Storage/data下未找到概念StorageBaseCode的Store配置

引用其他模块的？http://bbs.justep.co ...

是要引用HR_Pub_BaseCode基础数据表的目录么？.w文件中只用到这个概念，但是我引用了还是没效果啊

jishuang

action所在目录的model.config.xml中引用概念所在的data目录

ly201026

jishuang 发表于 2013-10-9 17:11
action所在目录的model.config.xml中引用概念所在的data目录

引用了。还是不行

ly201026

已解决，重新生成了一下Action。