Hi to all,
We are using html,
jsp,xml,
servlets and beans in our application and DB2 as backend.
The issue is in Leave application(maintains Leaves of Employees) which is the part of HRMS.
We are facing below error at production level. Once we clean the browser history and delete cache then its working working fine. Can any body tell some permanent solution.
Status of objects submitted.. Error encountered while trying to execute the query INSERT INTO LAT_ATT(EMPID,ATTDATE,ATTTYPE,ATTMARKEDBY)VALUES(‘15895’,’04-03-2013’,’PR’,’15895’). Actual error message is One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DB2INS1. LAT_ATT " from having duplicate rows for those columns. Error encountered while trying to execute the query INSERT INTO LAT_ATT(EMPID,ATTDATE,ATTTYPE,ATTMARKEDBY)VALUES(‘15895’,’04-03-2013’,’PR’,’15895’) Actual error message is One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1 " constrains table "DB2INS1. LAT_ATT " from having duplicate rows for those columns. For error during submission for any objects check error log for details of errors.