异常报错。

whlakj

<action direct-execute="true" process="/OA/survey/process/surveyAnswer/surveyAnswerProcess" activity="surveyAnswerActivity" action-flag="__action_0__" executor="" execute-context="" name="queryOAVSAnswerAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"><xbiz:map/></parameter><parameter name="filter"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[(V_OA_VS_Answer.fPerID = 'PSN01')]]></xbiz:simple></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[fPaperID,fPerID,fPerName,fPerFID,fPerFName,fDeptFName,fTaskID,fSState,fFinishTime,fSendTime,fTitle,fEndTime,fPState,fCreateDeptName,fCreatePsnName,version,V_OA_VS_Answer]]></xbiz:simple></parameter><parameter name="orderBy"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[fSendTime DESC]]></xbiz:simple></parameter></parameters><translate-parameter data-type="row-list" transform-idcolumn="true" use-namespace="true" cellname-by-relation="false"><rows-config concept="V_OA_VS_Answer" sequence="recNo,fTitle,fSState,fCreateDeptName,fCreatePsnName,fSendTime,fFinishTime,space-column,fPaperID,fPerID,fPerName,fPerFID,fPerFName,fDeptFName,fTaskID,fEndTime,fPState,version"/></translate-parameter></action>

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

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.BusinessServerServlet.execService(Unknown Source)

at com.justep.business.server.BusinessServerServlet.service(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

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

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:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Thread.java:595)

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT V_OA_VS_Answer.*  FROM V_OA_VS_Answer V_OA_VS_Answer WHERE ((V_OA_VS_Answer.fPerID = 'PSN01')) ORDER BY fSendTime DESC LIMIT 0, 20

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.BizData.query(Unknown Source)

at BizProcedure.query(BizProcedure.java:12)

... 26 more

Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

at java.sql.Timestamp.valueOf(Timestamp.java:161)

at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:460)

at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796)

at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:250)

at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:250)

at com.justep.system.data.impl.TableUtilsImplement.fillRow(Unknown Source)

... 31 more

whlakj

检查过数据库日期时间字段格式是dataTime类型的！

zxzhzqx

Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff   日期类型 格式化下   

whlakj

zxzhzqx 发表于 2014-6-28 17:25
Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff   日期类型 格式化下

日期类型是本体里面默认的。新增数据的时候直接默认输入的。

yinlun

V_OA_VS_Answer是视图吧，这个sql语句直接在数据库里执行会报错吗？

fpj

你的KSQL在查询时，数据类型或者格式，与数据库中的数据类型或者 格式，不一致引起的。

你的KSQL参数，在传入KSQL时， 将参考进行格式一下即可。日期时间的使用可参考下面的贴子；
http://bbs.justep.com/thread-40996-1-1.html

whlakj

fpj 发表于 2014-6-30 08:13
你的KSQL在查询时，数据类型或者格式，与数据库中的数据类型或者 格式，不一致引起的。

你的KSQL参数，在 ...

利用默认的action没有自己定义！

whlakj

yinlun 发表于 2014-6-29 23:44
V_OA_VS_Answer是视图吧，这个sql语句直接在数据库里执行会报错吗？

数据库执行没有报错！

lixin_justep

检查一下数据源是否正确

whlakj

lixin_justep 发表于 2014-6-30 08:42
检查一下数据源是否正确

起步OA里面的问卷调查功能，其他页面没有问题 单独这个页面执行查询报错。