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

QQ登录

只需一步,快速开始

查看: 2339|回复: 2

[处理中] 关于OA源代码程序错误问题

[复制链接]

131

主题

382

帖子

585

积分

高级会员

Rank: 4

积分
585
QQ
发表于 2013-11-12 11:09:11 | 显示全部楼层 |阅读模式
会议室管理里面点会议纪要,新建一条会议纪要并保存,列表中出现一条未发布的信息记录。如下图:
123.jpg
然后点右上角的发布,出现勾选发布范围,点去确定后出现如下错误:
124.jpg
控制台错误显示如下:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: insert into OA_KM_Knowledge k(k,k.version,k.fTitle,k.fKeyword,k.fDocNumber,k.fWriter,k.fFolderID,k.fFolderName,k.fFolderFullID,k.fFolderFullName,k.fRightsText,k.fIsNeedApprove,k.fImportant,k.fImportantName,k.fContentType,k.fContentTypeName,k.fTemplateID,k.fTemplateName,k.fLinkURL,k.fContent,k.fContentURL,k.fIsTop,k.fCreateOgnID,k.fCreateOgnName,k.fCreateDeptID,k.fCreateDeptName,k.fCreatePsnID,k.fCreatePsnName,k.fCreatePsnFID,k.fCreatePsnFName,k.fCreateTime,k.fReleaseOgnID,k.fReleaseOgnName,k.fReleaseDeptID,k.fReleaseDeptName,k.fReleasePsnID,k.fReleasePsnName,k.fReleasePsnFID,k.fReleasePsnFName,k.fReleaseTime,k.fReleaseStatus,k.fReleaseStatusName,k.fIsDisplayOnPortal,k.fIsInheritRights,k.fOtherFolders,k.fDocument,k.fAttachment,k.fBizID,k.fBizType,k.fBizTypeName)values('068B456E77E54E038FAABCA638580076',0,'讨论部门月工作计划',' ',' ','ceshi','doc','文件中心','public/doc','知识中心/文件中心','','','','','uploaddoc','上传文档','','','','','','','ORG01','集团总公司','ORG01','集团总公司','26D850F8BCB14B15915E938689A4186E','ceshi','/ORG01.ogn/26D850F8BCB14B15915E938689A4186E@ORG01.psm','/集团总公司/ceshi',:currentDate,'ORG01','集团总公司','ORG01','null','26D850F8BCB14B15915E938689A4186E','ceshi','/ORG01.ogn/26D850F8BCB14B15915E938689A4186E@ORG01.psm','/集团总公司/ceshi',:currentDate,'1','已发布','','','','[{"docID":"C5EB2EBC4E3000018488A55018401E82","docName":"123.jpg","size":22632,"fileID":"175-root","docPath":"/root/a7519eac-6749-4e27-b94d-06085ff7a4cc/7ba5ffc6-2626-469f-8016-8ca0fb0aa0ee/d440c01c-57b4-4ff2-8e20-9463c6cf20e5/e92635f3-a52c-43f2-84e4-27bcffc5e322","time":"2013-11-12T10:57:35.416Z"}]','','21D3D48735B541FE992AC757FA554C6D','doc','文件中心'); 可能的原因: 无
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at KMKnowledge.createNewKnowledge(KMKnowledge.java:463)
at KMKnowledge.publishKnowledgeInterface(KMKnowledge.java:289)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO OA_KM_Knowledge (OA_KM_Knowledge.fID, OA_KM_Knowledge.VERSION, OA_KM_Knowledge.FTITLE, OA_KM_Knowledge.FKEYWORD, OA_KM_Knowledge.FDOCNUMBER, OA_KM_Knowledge.FWRITER, OA_KM_Knowledge.FFOLDERID, OA_KM_Knowledge.FFOLDERNAME, OA_KM_Knowledge.FFOLDERFULLID, OA_KM_Knowledge.FFOLDERFULLNAME, OA_KM_Knowledge.FRIGHTSTEXT, OA_KM_Knowledge.FISNEEDAPPROVE, OA_KM_Knowledge.FIMPORTANT, OA_KM_Knowledge.FIMPORTANTNAME, OA_KM_Knowledge.FCONTENTTYPE, OA_KM_Knowledge.FCONTENTTYPENAME, OA_KM_Knowledge.FTEMPLATEID, OA_KM_Knowledge.FTEMPLATENAME, OA_KM_Knowledge.FLINKURL, OA_KM_Knowledge.FCONTENT, OA_KM_Knowledge.FCONTENTURL, OA_KM_Knowledge.FISTOP, OA_KM_Knowledge.FCREATEOGNID, OA_KM_Knowledge.FCREATEOGNNAME, OA_KM_Knowledge.FCREATEDEPTID, OA_KM_Knowledge.FCREATEDEPTNAME, OA_KM_Knowledge.FCREATEPSNID, OA_KM_Knowledge.FCREATEPSNNAME, OA_KM_Knowledge.FCREATEPSNFID, OA_KM_Knowledge.FCREATEPSNFNAME, OA_KM_Knowledge.FCREATETIME, OA_KM_Knowledge.FRELEASEOGNID, OA_KM_Knowledge.FRELEASEOGNNAME, OA_KM_Knowledge.FRELEASEDEPTID, OA_KM_Knowledge.FRELEASEDEPTNAME, OA_KM_Knowledge.FRELEASEPSNID, OA_KM_Knowledge.FRELEASEPSNNAME, OA_KM_Knowledge.FRELEASEPSNFID, OA_KM_Knowledge.FRELEASEPSNFNAME, OA_KM_Knowledge.FRELEASETIME, OA_KM_Knowledge.FRELEASESTATUS, OA_KM_Knowledge.FRELEASESTATUSNAME, OA_KM_Knowledge.FISDISPLAYONPORTAL, OA_KM_Knowledge.FISINHERITRIGHTS, OA_KM_Knowledge.FOTHERFOLDERS, OA_KM_Knowledge.FDOCUMENT, OA_KM_Knowledge.FATTACHMENT, OA_KM_Knowledge.FBIZID, OA_KM_Knowledge.FBIZTYPE, OA_KM_Knowledge.FBIZTYPENAME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,  ? , ?, ?, ?, ?, ?, ?, ?, ?,  ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), binds: [068B456E77E54E038FAABCA638580076, 0, 讨论部门月工作计划,  ,  , ceshi, doc, 文件中心, public/doc, 知识中心/文件中心, , , , , uploaddoc, 上传文档, , , , , , , ORG01, 集团总公司, ORG01, 集团总公司, 26D850F8BCB14B15915E938689A4186E, ceshi, [url=]/ORG01.ogn/26D850F8BCB14B15915E938689A4186E@ORG01.psm[/url], /集团总公司/ceshi, 2013-11-12 11:08:32.342, ORG01, 集团总公司, ORG01, null, 26D850F8BCB14B15915E938689A4186E, ceshi, [url=]/ORG01.ogn/26D850F8BCB14B15915E938689A4186E@ORG01.psm[/url], /集团总公司/ceshi, 2013-11-12 11:08:32.342, 1, 已发布, , , , [{"docID":"C5EB2EBC4E3000018488A55018401E82","docName":"123.jpg","size":22632,"fileID":"175-root","docPath":"/root/a7519eac-6749-4e27-b94d-06085ff7a4cc/7ba5ffc6-2626-469f-8016-8ca0fb0aa0ee/d440c01c-57b4-4ff2-8e20-9463c6cf20e5/e92635f3-a52c-43f2-84e4-27bcffc5e322","time":"2013-11-12T10:57:35.416Z"}], , 21D3D48735B541FE992AC757FA554C6D, doc, 文件中心]出错; 可能的原因: 无
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 33 more
Caused by: java.sql.SQLException: 从数据类型 nvarchar 转换为 numeric 时出错。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 34 more

39

主题

1379

帖子

2464

积分

金牌会员

Rank: 6Rank: 6

积分
2464
发表于 2013-11-13 10:49:13 | 显示全部楼层
已经测试,oracle数据库正常,sqlserver数据库报错,调整后会更新资源

39

主题

1379

帖子

2464

积分

金牌会员

Rank: 6Rank: 6

积分
2464
发表于 2013-11-13 14:12:41 | 显示全部楼层
lixin_justep 发表于 2013-11-13 10:49
已经测试,oracle数据库正常,sqlserver数据库报错,调整后会更新资源

会议纪要发布报错,经测试,oracle数据库正常,sqlserver报错,是因为在sqlserver数据库中,数据类型为integer的时候,不能保存字符数据
高级模式
B Color Image Link Quote Code Smilies |上传

本版积分规则

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

GMT+8, 2024-11-25 00:36 , Processed in 0.074163 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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