|
楼主 |
发表于 2016-1-7 10:57:28
|
显示全部楼层
后台报错3
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO Bb_Crm_DayWorkPlan2Summary (Bb_Crm_DayWorkPlan2Summary.fID, Bb_Crm_DayWorkPlan2Summary.VERSION, Bb_Crm_DayWorkPlan2Summary.FYEAR, Bb_Crm_DayWorkPlan2Summary.FPERIOD, Bb_Crm_DayWorkPlan2Summary.FDATE, Bb_Crm_DayWorkPlan2Summary.FBILLNO, Bb_Crm_DayWorkPlan2Summary.FNOTE, Bb_Crm_DayWorkPlan2Summary.FREMARK, Bb_Crm_DayWorkPlan2Summary.FQTY, Bb_Crm_DayWorkPlan2Summary.FAMOUNT, Bb_Crm_DayWorkPlan2Summary.FAMOUNTDX, Bb_Crm_DayWorkPlan2Summary.FSTATUS, Bb_Crm_DayWorkPlan2Summary.FDELETE, Bb_Crm_DayWorkPlan2Summary.FCANCELLATION, Bb_Crm_DayWorkPlan2Summary.FPOS, Bb_Crm_DayWorkPlan2Summary.FCREATEDATE, Bb_Crm_DayWorkPlan2Summary.FCREATEUSERID, Bb_Crm_DayWorkPlan2Summary.FCREATEUSERNAME, Bb_Crm_DayWorkPlan2Summary.FCHECKDATE, Bb_Crm_DayWorkPlan2Summary.FCHECKUSERID, Bb_Crm_DayWorkPlan2Summary.FCHECKUSERNAME, Bb_Crm_DayWorkPlan2Summary.FPOSDATE, Bb_Crm_DayWorkPlan2Summary.FPOSUSERID, Bb_Crm_DayWorkPlan2Summary.FPOSUSERNAME, Bb_Crm_DayWorkPlan2Summary.FCUSTUUID, Bb_Crm_DayWorkPlan2Summary.FCUSTNAME, Bb_Crm_DayWorkPlan2Summary.FDEPTUUID, Bb_Crm_DayWorkPlan2Summary.FDEPTNAME, Bb_Crm_DayWorkPlan2Summary.FEMPUUID, Bb_Crm_DayWorkPlan2Summary.FEMPNAME, Bb_Crm_DayWorkPlan2Summary.FBILLTYPE, Bb_Crm_DayWorkPlan2Summary.FTODAYSUM, Bb_Crm_DayWorkPlan2Summary.FNEXTDAYPLAN, Bb_Crm_DayWorkPlan2Summary.FCHECKVIEWS, Bb_Crm_DayWorkPlan2Summary.FPOSVIEWS, Bb_Crm_DayWorkPlan2Summary.FTODAYSUMTEXT, Bb_Crm_DayWorkPlan2Summary.FNEXTDAYPLANTEXT, Bb_Crm_DayWorkPlan2Summary.FCHECKVIEWSTEXT, Bb_Crm_DayWorkPlan2Summary.FPOSVIEWSTEXT, Bb_Crm_DayWorkPlan2Summary.FCHECKSCORE, Bb_Crm_DayWorkPlan2Summary.FCHECKACCURACY, Bb_Crm_DayWorkPlan2Summary.FPOSSCORE, Bb_Crm_DayWorkPlan2Summary.FPOSACCURACY, Bb_Crm_DayWorkPlan2Summary.FSCORE, Bb_Crm_DayWorkPlan2Summary.FACCURACY) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [307D29FE25F34CF7B14A97EAC334B3F0, 0, 2016, 1, 2016-01-07, DPS20160107-0063, , , 0.0, 0.0, , 0, 0, 0, 0, 2016-01-07 10:43:02.046, PSN28, 曹飞, null, , , null, , , , , , , PSN28, 曹飞, 0, test, test, , , null, null, null, null, 0, -1, 0, -1, 0, -1]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 34 more
Caused by: java.sql.SQLException: 违反了 PRIMARY KEY 约束 'PK_Bb_Crm_DayWorkPlan2Summary'。不能在对象 'dbo.Bb_Crm_DayWorkPlan2Summary' 中插入重复键。
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)
... 35 more
url:/UI/system/service/common/bizAction.j
param:{"process":"/BlueBerry_System/CRM/process/Bb_Crm_DayWorkPlan2Summary/bb_Crm_DayWorkPlan2SummaryProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"PSN28","executeContext":"","action":"saveBb_Crm_DayWorkPlan2SummaryAction","parameters":{"table":{"@type":"table","userdata":{"relationAlias":"version,FYear,FPeriod,FDate,FBillNo,FNote,FRemark,FQty,FAmount,FAmountDx,FStatus,FDelete,FCancellation,FPos,FCreateDate,FCreateUserID,FCreateUserName,FCheckDate,FCheckUserID,FCheckUserName,FPosDate,FPosUserID,FPosUserName,FCustUUID,FCustName,FDeptUUID,FDeptName,FEmpUUID,FEmpName,FBillType,FToDaySum,FNextDayPlan,FCheckViews,FPosViews,FToDaySumText,FNextDayPlanText,FCheckViewsText,FPosViewsText,FCheckScore,FCheckAccuracy,FPosScore,FPosAccuracy,FScore,FAccuracy","relationTypes":"Integer,Integer,Integer,Date,String,String,String,Decimal,Decimal,String,Integer,Integer,Integer,Integer,DateTime,String,String,DateTime,String,String,DateTime,String,String,String,String,String,String,String,String,Integer,String,String,String,String,Text,Text,Text,Text,Integer,Integer,Integer,Integer,Integer,Integer","idColumnType":"String","sys.rowid":"Bb_Crm_DayWorkPlan2Summary","idColumnDefine":"Bb_Crm_DayWorkPlan2Summary","idColumnName":"Bb_Crm_DayWorkPlan2Summary","relations":"Bb_Crm_DayWorkPlan2Summary.version,Bb_Crm_DayWorkPlan2Summary.FYear,Bb_Crm_DayWorkPlan2Summary.FPeriod,Bb_Crm_DayWorkPlan2Summary.FDate,Bb_Crm_DayWorkPlan2Summary.FBillNo,Bb_Crm_DayWorkPlan2Summary.FNote,Bb_Crm_DayWorkPlan2Summary.FRemark,Bb_Crm_DayWorkPlan2Summary.FQty,Bb_Crm_DayWorkPlan2Summary.FAmount,Bb_Crm_DayWorkPlan2Summary.FAmountDx,Bb_Crm_DayWorkPlan2Summary.FStatus,Bb_Crm_DayWorkPlan2Summary.FDelete,Bb_Crm_DayWorkPlan2Summary.FCancellation,Bb_Crm_DayWorkPlan2Summary.FPos,Bb_Crm_DayWorkPlan2Summary.FCreateDate,Bb_Crm_DayWorkPlan2Summary.FCreateUserID,Bb_Crm_DayWorkPlan2Summary.FCreateUserName,Bb_Crm_DayWorkPlan2Summary.FCheckDate,Bb_Crm_DayWorkPlan2Summary.FCheckUserID,Bb_Crm_DayWorkPlan2Summary.FCheckUserName,Bb_Crm_DayWorkPlan2Summary.FPosDate,Bb_Crm_DayWorkPlan2Summary.FPosUserID,Bb_Crm_DayWorkPlan2Summary.FPosUserName,Bb_Crm_DayWorkPlan2Summary.FCustUUID,Bb_Crm_DayWorkPlan2Summary.FCustName,Bb_Crm_DayWorkPlan2Summary.FDeptUUID,Bb_Crm_DayWorkPlan2Summary.FDeptName,Bb_Crm_DayWorkPlan2Summary.FEmpUUID,Bb_Crm_DayWorkPlan2Summary.FEmpName,Bb_Crm_DayWorkPlan2Summary.FBillType,Bb_Crm_DayWorkPlan2Summary.FToDaySum,Bb_Crm_DayWorkPlan2Summary.FNextDayPlan,Bb_Crm_DayWorkPlan2Summary.FCheckViews,Bb_Crm_DayWorkPlan2Summary.FPosViews,Bb_Crm_DayWorkPlan2Summary.FToDaySumText,Bb_Crm_DayWorkPlan2Summary.FNextDayPlanText,Bb_Crm_DayWorkPlan2Summary.FCheckViewsText,Bb_Crm_DayWorkPlan2Summary.FPosViewsText,Bb_Crm_DayWorkPlan2Summary.FCheckScore,Bb_Crm_DayWorkPlan2Summary.FCheckAccuracy,Bb_Crm_DayWorkPlan2Summary.FPosScore,Bb_Crm_DayWorkPlan2Summary.FPosAccuracy,Bb_Crm_DayWorkPlan2Summary.FScore,Bb_Crm_DayWorkPlan2Summary.FAccuracy","model":"/BlueBerry_System/CRM/data","updateMode":"whereVersion","concept":"Bb_Crm_DayWorkPlan2Summary","conceptAlias":"Bb_Crm_DayWorkPlan2Summary"},"rows":[{"userdata":{"id":{"value":"307D29FE25F34CF7B14A97EAC334B3F0","originalValue":"307D29FE25F34CF7B14A97EAC334B3F0","changed":"0"},"recordState":"new"},"version":{"value":0,"originalValue":0,"changed":"0"},"FYear":{"value":2016,"originalValue":2016,"changed":"1"},"FPeriod":{"value":1,"originalValue":1,"changed":"1"},"FDate":{"value":"2016-01-07","originalValue":"2016-01-07","changed":"1"},"FBillNo":{"value":"DPS20160107-0063","originalValue":"DPS20160107-0063","changed":"1"},"FNote":{"value":"","originalValue":"","changed":"1"},"FRemark":{"value":"","originalValue":"","changed":"1"},"FQty":{"value":"0.0","originalValue":"0.0","changed":"1"},"FAmount":{"value":"0.0","originalValue":"0.0","changed":"1"},"FAmountDx":{"value":"","originalValue":"","changed":"1"},"FStatus":{"value":0,"originalValue":0,"changed":"1"},"FDelete":{"value":0,"originalValue":0,"changed":"1"},"FCancellation":{"value":0,"originalValue":0,"changed":"1"},"FPos":{"value":0,"originalValue":0,"changed":"1"},"FCreateDate":{"value":"2016-01-07T10:43:02.046Z","originalValue":"2016-01-07T10:43:02.046Z","changed":"1"},"FCreateUserID":{"value":"PSN28","originalValue":"PSN28","changed":"1"},"FCreateUserName":{"value":"曹飞","originalValue":"曹飞","changed":"1"},"FCheckDate":{"value":"","originalValue":"","changed":"1"},"FCheckUserID":{"value":"","originalValue":"","changed":"1"},"FCheckUserName":{"value":"","originalValue":"","changed":"1"},"FPosDate":{"value":"","originalValue":"","changed":"1"},"FPosUserID":{"value":"","originalValue":"","changed":"1"},"FPosUserName":{"value":"","originalValue":"","changed":"1"},"FCustUUID":{"value":"","originalValue":"","changed":"1"},"FCustName":{"value":"","originalValue":"","changed":"1"},"FDeptUUID":{"value":"","originalValue":"","changed":"1"},"FDeptName":{"value":"","originalValue":"","changed":"1"},"FEmpUUID":{"value":"PSN28","originalValue":"PSN28","changed":"1"},"FEmpName":{"value":"曹飞","originalValue":"曹飞","changed":"1"},"FBillType":{"value":0,"originalValue":0,"changed":"1"},"FToDaySum":{"value":"test","originalValue":"","changed":"1"},"FNextDayPlan":{"value":"test","originalValue":"","changed":"1"},"FCheckViews":{"value":"","originalValue":"","changed":"1"},"FPosViews":{"value":"","originalValue":"","changed":"1"},"FToDaySumText":{"value":"","originalValue":"","changed":"1"},"FNextDayPlanText":{"value":"","originalValue":"","changed":"1"},"FCheckViewsText":{"value":"","originalValue":"","changed":"1"},"FPosViewsText":{"value":"","originalValue":"","changed":"1"},"FCheckScore":{"value":0,"originalValue":0,"changed":"1"},"FCheckAccuracy":{"value":-1,"originalValue":-1,"changed":"1"},"FPosScore":{"value":0,"originalValue":0,"changed":"1"},"FPosAccuracy":{"value":-1,"originalValue":-1,"changed":"1"},"FScore":{"value":0,"originalValue":0,"changed":"1"},"FAccuracy":{"value":-1,"originalValue":-1,"changed":"1"}} |
|