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

QQ登录

只需一步,快速开始

查看: 5153|回复: 6

[结贴] JUSTEP150146, 设置将列"XXX"的值为"0"时出错,新增数据失败!

[复制链接]

27

主题

125

帖子

347

积分

中级会员

Rank: 3Rank: 3

积分
347
QQ
发表于 2018-10-22 14:02:44 | 显示全部楼层 |阅读模式
版本: 其它(帖子中说明) 小版本号: 5569
数据库: MS SQLServer 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 其它 浏览器: Chrome
从弹窗选择物资库存信息到物资盘点窗口(主窗口),在选定来记录后按“确定”返回主窗口时出现如下提示:
JUSTEP150146, 设置将列"IncNumWCL"的值为"0"时出错,新增数据失败!


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 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: 编码: JUSTEP150146; 提示: 设置将列"IncNumWCL"的值为"0"时出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.RowImpl.setValue(Unknown Source)
at com.justep.system.data.BizData.create(Unknown Source)
at BizProcedure.create(BizProcedure.java:22)
... 27 more
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal
... 30 more

url:/UI/system/service/common/bizAction.j
param:{"process":"/XXXXX/EOA/process/eoa_mat_war_xxx_check/eoa_mat_war_xxx_checkProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"createEoa_mat_war_che_listAction","parameters":{"table":{"@type":"table","userdata":{"concept":"eoa_mat_war_che_list","relations":"EXPRESS,eoa_mat_war_che_list.CheTypeWCL,eoa_mat_war_che_list.MatCodeWCL,eoa_mat_war_che_list.MatNameWCL,eoa_mat_war_che_list.SpecWCL,eoa_mat_war_che_list.UnitWCL,eoa_mat_war_che_list.BNumWCL,eoa_mat_war_che_list.WarNumWCL,eoa_mat_war_che_list.WarMonWCL,eoa_mat_war_che_list.CheNumWCL,eoa_mat_war_che_list.CheMonWCL,eoa_mat_war_che_list.IncNumWCL,eoa_mat_war_che_list.IncMonWCL,eoa_mat_war_che_list.ExpWCL,eoa_mat_war_che_list.MID_WCI_WCL,EXPRESS,eoa_mat_war_che_list.version,eoa_mat_war_che_list.MatFidWCL,eoa_mat_war_che_list.PriWCL,eoa_mat_war_che_list.FactoryWCL","model":"/XXXXX/EOA/data","conceptAlias":"eoa_mat_war_che_list","idColumnName":"eoa_mat_war_che_list","idColumnType":"String","idColumnDefine":"eoa_mat_war_che_list","relationAlias":"序号,CheTypeWCL,MatCodeWCL,MatNameWCL,SpecWCL,UnitWCL,BNumWCL,WarNumWCL,WarMonWCL,CheNumWCL,CheMonWCL,IncNumWCL,IncMonWCL,ExpWCL,MID_WCI_WCL,space-column,version,MatFidWCL,PriWCL,FactoryWCL","relationTypes":"Object,String,String,String,String,String,String,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,String,String,Object,Integer,String,String,String","updateMode":"whereVersion"},"rows":[{"userdata":{"recordState":"new"},"序号":{"value":null,"originalValue":null,"changed":"1"},"CheTypeWCL":{"value":"库存内","originalValue":"库存内","changed":"1"},"MatCodeWCL":{"value":"XHCL001001001001010","originalValue":"XHCL001001001001010","changed":"1"},"MatNameWCL":{"value":"模拟量输入卡 mA/V 16路","originalValue":"模拟量输入卡 mA/V 16路","changed":"1"},"SpecWCL":{"value":"369B1841G0130","originalValue":"369B1841G0130","changed":"1"},"UnitWCL":{"value":"块","originalValue":"块","changed":"1"},"BNumWCL":{"value":"","originalValue":"","changed":"1"},"WarNumWCL":{"value":"6.0000","originalValue":"6.0000","changed":"1"},"WarMonWCL":{"value":"0.00","originalValue":"0.00","changed":"1"},"CheNumWCL":{"value":"6.0000","originalValue":"6.0000","changed":"1"},"CheMonWCL":{"value":null,"originalValue":null,"changed":"1"},"IncNumWCL":{"value":null,"originalValue":null,"changed":"1"},"IncMonWCL":{"value":null,"originalValue":null,"changed":"1"},"ExpWCL":{"value":null,"originalValue":null,"changed":"1"},"MID_WCI_WCL":{"value":null,"originalValue":null,"changed":"1"},"space-column":{"value":null,"originalValue":null,"changed":"1"},"version":{"value":null,"originalValue":null,"changed":"1"},"MatFidWCL":{"value":"F4B39C6C982B4D2EABBEC0AABC303DCA","originalValue":"F4B39C6C982B4D2EABBEC0AABC303DCA","changed":"1"},"PriWCL":{"value":null,"originalValue":null,"changed":"1"},"FactoryWCL":{"value":null,"originalValue":null,"changed":"1"}}]},"defaultValues":{"CheTypeWCL":"'库存外'","MID_WCI_WCL":"'C499640E55A9412A983471EE4E965964'"}},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"eoa_mat_war_che_list","sequence":"序号,CheTypeWCL,MatCodeWCL,MatNameWCL,SpecWCL,UnitWCL,BNumWCL,WarNumWCL,WarMonWCL,CheNumWCL,CheMonWCL,IncNumWCL,IncMonWCL,ExpWCL,MID_WCI_WCL,space-column,version,MatFidWCL,PriWCL,FactoryWCL"}}}Error: {"message":"设置将列\"IncNumWCL\"的值为\"0\"时出错,新增数据失败! ","reason":"","code":"JUSTEP150146","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150146; 提示: 设置将列\"IncNumWCL\"的值为\"0\"时出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.RowImpl.setValue(Unknown Source)\r\n\tat com.justep.system.data.BizData.create(Unknown Source)\r\n\tat BizProcedure.create(BizProcedure.java:22)\r\n\t... 27 more\r\nCaused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal\r\n\t... 30 more\r\n","messages":["编码: JUSTEP150146; 提示: 设置将列\"IncNumWCL\"的值为\"0\"时出错","java.lang.Integer cannot be cast to java.math.BigDecimal"],"url":"/UI/system/service/common/bizAction.j","param":"{\"process\":\"/XXXXX/EOA/process/eoa_mat_war_xxx_check/eoa_mat_war_xxx_checkProcess\",\"activity\":\"mainActivity\",\"actionFlag\":\"__action_0__\",\"executor\":\"\",\"executeContext\":\"\",\"action\":\"createEoa_mat_war_che_listAction\",\"parameters\":{\"table\":{\"@type\":\"table\",\"userdata\":{\"concept\":\"eoa_mat_war_che_list\",\"relations\":\"EXPRESS,eoa_mat_war_che_list.CheTypeWCL,eoa_mat_war_che_list.MatCodeWCL,eoa_mat_war_che_list.MatNameWCL,eoa_mat_war_che_list.SpecWCL,eoa_mat_war_che_list.UnitWCL,eoa_mat_war_che_list.BNumWCL,eoa_mat_war_che_list.WarNumWCL,eoa_mat_war_che_list.WarMonWCL,eoa_mat_war_che_list.CheNumWCL,eoa_mat_war_che_list.CheMonWCL,eoa_mat_war_che_list.IncNumWCL,eoa_mat_war_che_list.IncMonWCL,eoa_mat_war_che_list.ExpWCL,eoa_mat_war_che_list.MID_WCI_WCL,EXPRESS,eoa_mat_war_che_list.version,eoa_mat_war_che_list.MatFidWCL,eoa_mat_war_che_list.PriWCL,eoa_mat_war_che_list.FactoryWCL\",\"model\":\"/XXXXX/EOA/data\",\"conceptAlias\":\"eoa_mat_war_che_list\",\"idColumnName\":\"eoa_mat_war_che_list\",\"idColumnType\":\"String\",\"idColumnDefine\":\"eoa_mat_war_che_list\",\"relationAlias\":\"序号,CheTypeWCL,MatCodeWCL,MatNameWCL,SpecWCL,UnitWCL,BNumWCL,WarNumWCL,WarMonWCL,CheNumWCL,CheMonWCL,IncNumWCL,IncMonWCL,ExpWCL,MID_WCI_WCL,space-column,version,MatFidWCL,PriWCL,FactoryWCL\",\"relationTypes\":\"Object,String,String,String,String,String,String,Decimal,Decimal,Decimal,Decimal,Decimal,Decimal,String,String,Object,Integer,String,String,String\",\"updateMode\":\"whereVersion\"},\"rows\":[{\"userdata\":{\"recordState\":\"new\"},\"序号\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"CheTypeWCL\":{\"value\":\"库存内\",\"originalValue\":\"库存内\",\"changed\":\"1\"},\"MatCodeWCL\":{\"value\":\"XHCL001001001001010\",\"originalValue\":\"XHCL001001001001010\",\"changed\":\"1\"},\"MatNameWCL\":{\"value\":\"模拟量输入卡 mA/V 16路\",\"originalValue\":\"模拟量输入卡 mA/V 16路\",\"changed\":\"1\"},\"SpecWCL\":{\"value\":\"369B1841G0130\",\"originalValue\":\"369B1841G0130\",\"changed\":\"1\"},\"UnitWCL\":{\"value\":\"块\",\"originalValue\":\"块\",\"changed\":\"1\"},\"BNumWCL\":{\"value\":\"\",\"originalValue\":\"\",\"changed\":\"1\"},\"WarNumWCL\":{\"value\":\"6.0000\",\"originalValue\":\"6.0000\",\"changed\":\"1\"},\"WarMonWCL\":{\"value\":\"0.00\",\"originalValue\":\"0.00\",\"changed\":\"1\"},\"CheNumWCL\":{\"value\":\"6.0000\",\"originalValue\":\"6.0000\",\"changed\":\"1\"},\"CheMonWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"IncNumWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"IncMonWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"ExpWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"MID_WCI_WCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"space-column\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"version\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"MatFidWCL\":{\"value\":\"F4B39C6C982B4D2EABBEC0AABC303DCA\",\"originalValue\":\"F4B39C6C982B4D2EABBEC0AABC303DCA\",\"changed\":\"1\"},\"PriWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"},\"FactoryWCL\":{\"value\":null,\"originalValue\":null,\"changed\":\"1\"}}]},\"defaultValues\":{\"CheTypeWCL\":\"'库存外'\",\"MID_WCI_WCL\":\"'C499640E55A9412A983471EE4E965964'\"}},\"translateParameter\":{\"dataType\":\"row-list\",\"transformIdcolumn\":true,\"useNamespace\":true,\"cellnameByRelation\":false,\"rowsConfig\":{\"concept\":\"eoa_mat_war_che_list\",\"sequence\":\"序号,CheTypeWCL,MatCodeWCL,MatNameWCL,SpecWCL,UnitWCL,BNumWCL,WarNumWCL,WarMonWCL,CheNumWCL,CheMonWCL,IncNumWCL,IncMonWCL,ExpWCL,MID_WCI_WCL,space-column,version,MatFidWCL,PriWCL,FactoryWCL\"}}}"}
at Object.errorMessage (http://127.0.0.1:8080/x5/v_a0eb4 ... guage=zh_CN:1:98831)
at Object.callback (http://127.0.0.1:8080/x5/v_351aa ... guage=zh_CN:1:44456)
at cbf (http://127.0.0.1:8080/x5/v_a0eb4 ... guage=zh_CN:1:82870)
at Object.sendRequest2 (http://127.0.0.1:8080/x5/v_a0eb4 ... guage=zh_CN:1:83114)
at Object.sendBizRequest2 (http://127.0.0.1:8080/x5/v_a0eb4 ... guage=zh_CN:1:56339)
at Object.doNewData (http://127.0.0.1:8080/x5/v_351aa ... guage=zh_CN:1:43817)
at Object.newData (http://127.0.0.1:8080/x5/v_351aa ... guage=zh_CN:1:41365)
at _xbl_JSClassDefine_windowDialog.justep.WindowDialog.onReceiveByMapping (http://127.0.0.1:8080/x5/UI/v_5e ... nguage=zh_CN:445:32)
at _xbl_JSClassDefine_windowDialog.justep.WindowDialog.ensure (http://127.0.0.1:8080/x5/UI/v_5e ... anguage=zh_CN:227:7)
at Function.justep.WindowReceiver.windowEnsure (http://127.0.0.1:8080/x5/UI/v_e8 ... nguage=zh_CN:120:41)

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36198
发表于 2018-10-22 16:29:57 | 显示全部楼层
IncNumWCL的关系类型是什么?
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

27

主题

125

帖子

347

积分

中级会员

Rank: 3Rank: 3

积分
347
QQ
 楼主| 发表于 2018-10-22 20:12:31 | 显示全部楼层
jishuang 发表于 2018-10-22 16:29
IncNumWCL的关系类型是什么?

类型:Decimal;默认值:0;长度12;精度:0;单值
莫非这样不行?这是一个数量字段,在使用中该值不会出现小数。
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36198
发表于 2018-10-23 09:09:58 | 显示全部楼层
0是在ontology中给关系设置的默认值吧?目前版本中有这个缺陷

如果不会出现小数,可以把关系类型设置为Integer类型的
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

27

主题

125

帖子

347

积分

中级会员

Rank: 3Rank: 3

积分
347
QQ
 楼主| 发表于 2018-10-23 09:21:55 | 显示全部楼层
jishuang 发表于 2018-10-23 09:09
0是在ontology中给关系设置的默认值吧?目前版本中有这个缺陷

如果不会出现小数,可以把关系类型设置为Int ...

原来如此。谢谢!
问题已解决了,结贴吧
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36198
发表于 2018-10-23 11:49:29 | 显示全部楼层
Decimal类型的在ontology中设置默认值为0是如下设置:
toDecimal(0)
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



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

使用道具 举报

27

主题

125

帖子

347

积分

中级会员

Rank: 3Rank: 3

积分
347
QQ
 楼主| 发表于 2018-10-24 00:34:09 | 显示全部楼层
jishuang 发表于 2018-10-23 11:49
Decimal类型的在ontology中设置默认值为0是如下设置:
toDecimal(0)

谢谢!
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-8-28 10:30 , Processed in 0.076167 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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