组织机构中添加人员出现下面的错误

xjtfq · 发表于 2018-5-15 16:54:21

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_OPPerson (SA_OPPerson.sID, SA_OPPerson.VERSION, SA_OPPerson.SNAME, SA_OPPerson.SCODE, SA_OPPerson.SIDCARD, SA_OPPerson.SNUMB, SA_OPPerson.SLOGINNAME, SA_OPPerson.SPASSWORD, SA_OPPerson.SPASSWORDTIMELIMIT, SA_OPPerson.SPASSWORDMODIFYTIME, SA_OPPerson.SMAINORGID, SA_OPPerson.SSAFELEVELID, SA_OPPerson.SSEQUENCE, SA_OPPerson.SVALIDSTATE, SA_OPPerson.SDESCRIPTION, SA_OPPerson.SPHOTO, SA_OPPerson.SPHOTOLASTMODIFIED, SA_OPPerson.SSEX, SA_OPPerson.SBIRTHDAY, SA_OPPerson.SJOINDATE, SA_OPPerson.SHOMEPLACE, SA_OPPerson.SCOUNTRY, SA_OPPerson.SPROVINCE, SA_OPPerson.SCITY, SA_OPPerson.SDEGREE, SA_OPPerson.SGRADUATESCHOOL, SA_OPPerson.SSPECIALITY, SA_OPPerson.SSCHOOLLENGTH, SA_OPPerson.STITLE, SA_OPPerson.SMARRIAGE, SA_OPPerson.SCARDNO, SA_OPPerson.SCARDKIND, SA_OPPerson.SFAMILYADDRESS, SA_OPPerson.SZIP, SA_OPPerson.SIPADDRESS, SA_OPPerson.SQQ, SA_OPPerson.SMAIL, SA_OPPerson.SMOBILEPHONE, SA_OPPerson.SFAMILYPHONE, SA_OPPerson.SOFFICEPHONE, SA_OPPerson.SENGLISHNAME) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [v9Oa45eTdBdDhbqPZi5, 0, 储运设备, cysb, null, 30, null, F3D3A7EF80A1E7BDA2511A3A0B7E6CF8, null, 2018-05-15 16:49:31.497, X4fFkgVrNA9oAElistM, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 工区, null, null, null, null, null]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 40 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'sPasswordModifyTime' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)