报销单上传飞机票提交报错
**问题描述:**
报销单上传飞机票提交报错,如下:
错误信息:nullCaused exception message is: Transaction[XID:020021008B628198656173383661707030332C5431363737353935383631363432/020021008B628198656173383661707030332C5431363737353935383631363432] has been marked ROLLBACK ONLY somewhere!错误详细堆栈信息:javax.transaction.RollbackException: null
at: com.apusic.connector.cxmgr.AbstractConnectionPool.isValidTx(AbstractConnectionPool.java:35)
at: com.kingdee.eas.cp.bc.util.InvoiceUtil.updateInvoiceStateReturnString(InvoiceUtil.java:301)
at: com.kingdee.eas.cp.bc.app.BizCollBillBaseControllerBean.doAfterSubmit(BizCollBillBaseControllerBean.java:938)
![downloadfile1.webp](/download/01002a8d53f2e8704a6987831e5fae2371a3.webp)
**问题分析:**
[ERROR][Running HTTPHandler-4] [PlaneInvoiceConverter]create data error.ORA-12899: 列 "DFDB"."T_TM_PLANEINVOICE"."FENDORSEMENT" 的值太大 (实际值: 46, 最大值: 40)
报销单提交报回滚错误一般是税务异常,这时可以在$\eas\server\profiles\server*\logs\tm中查找TMTrace.log日志,可以看到是T_TM_PLANEINVOICE中FENDORSEMENT字段超长,如下图发票签字字段超长
![downloadfile2.webp](/download/0100c3c90fdbb923483b9d42b1b1585f5563.webp)
**解决方案:**
更新税务全票池补丁
85(PT170171 2023-02-24)
86(PT169989 2023-02-16)
临时变通:sql语句更新字段长度
IF EXISTS(SELECT 1 FROM Ksql_usercolumns where ksql_col_tabname = 'T_TM_PLANEINVOICE' and ksql_col_name = 'FENDORSEMENT')
alter table T_TM_PLANEINVOICE alter column FENDORSEMENT NVARCHAR(50);
报销单上传飞机票提交报错
**问题描述:**报销单上传飞机票提交报错,如下:错误信息:nullCaused exception message is: Transaction[XID:020021008B62819865617...
点击下载文档
本文2024-09-22 18:47:28发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-103043.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章