开发环境没有错误，在BeX5_V3.9-ent的生产环境中报错

李红伟

在程序部署到  BeX5_V3.9-ent  生产环境中后，报 下面的错误，如图所示，但是用开发环境不报错，在 BeX5_V3.9-runtime  也不报错。

jishuang

数据库也是同一个数据？现在的报错就是字段类型不一致

如果是Date关系类型就设置为Date

李红伟

我在数据库里面定义的字段类型，还有在 ontology  定义的类型，都是 date ，我没有找到有 datetime 的地方。在我开发环境中都是不报错的。

李红伟

我在 Bex5 的关系定义中，以及数据库表中的字段定义，都没有问题，都是date 类型。如图所示。

jishuang

报错的 不是这个列，看报错的提示是LOT_UPTO_VALID_DATE

李红伟

李红伟

程序中，多个地方都报类似的错误。

jishuang

开发环境和企业版用的数据库是同一个吗？

看tomcat控制台完整的错误信息

李红伟

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:741)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: com.justep.exception.BusinessException: 编码: JUSTEP150138; 提示: 列"AUDIT_DATE"的类型不一致, 定义的类型是"DateTime", 当前给出的是"Date"
        at so_sale_headers.AuditSoSaleHeader(so_sale_headers.java:2064)
        ... 40 more
Caused by: java.lang.RuntimeException: com.justep.exception.BusinessException: 编码: JUSTEP150138; 提示: 列"AUDIT_DATE"的类型不一致, 定义的类型是"DateTime", 当前给出的是"Date"
        at so_sale_headers.IvStorehouseAndInLocatorForSoSaleHeaders(so_sale_headers.java:1507)
        at so_sale_headers.AuditSoSaleHeader(so_sale_headers.java:2044)
        ... 40 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150138; 提示: 列"AUDIT_DATE"的类型不一致, 定义的类型是"DateTime", 当前给出的是"Date"
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.data.impl.RowImpl.check(Unknown Source)
        at com.justep.system.data.impl.RowImpl.getDate(Unknown Source)
        at so_sale_headers.IvStorehouseAndInLocatorForSoSaleHeaders(so_sale_headers.java:1338)
        ... 41 more

jishuang

开发环境和企业版用的数据库是同一个吗？