2803339 - ODATA API: Unable to DELETE EmployeeTime

This document has been created to address issue when attempting to delete EmpoloyeeTime data via OData API .

When the delete operation is performed, either directly via a REST Client or via an Intgertaion Interface,

You observe the one of the below errors:

1. [COE0018]com.successfactors.sca.ServiceApplicationException: Failed to execute and process SQL query
   
   
2. [COE0018]Time type Long term sickness is not assigned for User1234567 on 01/01/2019

• SuccessFactors 
• OData API

A DELETE operation similar to the below, is performed either directly via a REST Client or via an Intgertaion Interface:

DELETE https://apiX.successfactors.com/odata/v2/EmployeeTime(externalCode='a1b2c3def98999df17a54e581ced779512')

You receive one or both of the error messages which are outlined within the symptom section above.

The above outlined error messages are a result of one or both of the following:

• No job_information is maintained for the employee time
  
  
• The time profile does not contain the time type of the employee time

(i.e. trying to delete something which doesn't exist in the period)

To resolve the above error messages

• The affected employee's job information must be correctly maintained for the relevant period(s)
  
  
• The affected employee's time type must be correctly maintained within the time profile, for the relevant period(s)

If you believe that (in terms of above points) the data is correctly maintained, please proceed with the following actions:

1. Please create a support ticket with LOD-SF-INT-ODATA
   
   
2. Provide the request which is encountering issues - [e.g. DELETE https://apiX.successfactors.com/odata/v2/EmployeeTime(externalCode='a1b2c3def98999df17a54e581ced779512')]
   
   
3. Provide the response which was received from the performed request [e.g. [COE0018]com.successfactors.sca.ServiceApplicationException: Failed to execute and process SQL query]
   
   
4. Provide the API log data (from OData API Audit Logs) for thew performed request, as shown below:

6701000 (Log ID)
ODataAPIuser (Login ID)
ABCD8D5EC0EB6A04B021A9XX7F******.vsaXXXXXX (Jsession ID)
456000 (Req ID)
Failed (Status)
Delete (Call)
EmployeeTime (Object)
2019-01-01 00:00:00.000 Z (Timestamp)
4321 (Response ms)

Please be advised that this sample log data generated from internal test system

ODATA, API, DELETE, EmployeeTime, Job Information, [COE0018], Failed to execute and process SQL query , KBA , LOD-SF-INT-ODATA , OData API Framework , Problem