Dump on HR_EVENT_UPDATE - DBSQL Duplicate key

[om24]

Hi experts,

I am trying to update/insert time record in the database TEVEN  to populate in PA61, through function modules BAPI_CC1_UPLOAD_TIMEEVENT, HR_CC1_TIMEEVENT_POST, but  I am getting the ERROR : DBSQL_DUPLICATE_KEY_ERROR in the HR_EVENT_UPDATE  which is inside of HR_CC1_TIMEEVENT_POST, which is preventing time records to be saved.   

I kindly ask you to give insights on how to resolve this .

Thank you in advance

[om24 · Accepted solution]

Hi @raymind_giuseppi, 

I found the problem. When I first run the program, the server crushed. And somehow the data was being treated as not processed. Thus, prompting the duplicated key error while processing new data.

Thank you!

[RaymondGiuseppi]

Could you post your code in characters (menu ... then </>)

How do you currently handle duplicates

• Duplicate records received (for example, when an employee swipes his badge twice in less than 1 min, do you check on the badge application or before calling the BAPI)
• Received record is alreay in infotype 2011 / TEVEN

[om24]

Hi @raymind_giuseppi,