HTTP 500 or Odata API response issue for ERP to Employee Central Confirmation

[Former Member]

Hi All,

Our ERP to Employee Central Confirmation was working however we keep getting the below error at intervals.

HTTP/1.1 500 Internal Server Error Set-Cookie: JSESSIONID=E819D571E09B8FF9C38C42C06E5D78B7F33A1C7EC4FBBC0A3532E322A3014CA1; Path=/cxf; Secure; HttpOnly Set-Cookie: JTENANTSESSIONID_b47ae854d=KNxiO2YQBq%2BAMuK0HYtthKrxuVKWicDu5LEBpuD4ALs%3D; Domain=.hana.ondemand.com; Path=/; Secure; HttpOnly Content-Type: text/xml;charset=UTF-8 Content-Length: 538 Date: Mon, 26 Feb 2018 18:20:03 GMT X-Cnection: close Server: SAP Set-Cookie: BIGipServere0680iflmapavahcie.factoryus1.customdomain=!aanOaeqxUggLYOdciSbt/Chwrr7WVMPmjelvxP69JYaKrjXLgR283VKkr8uokVKn2p5e1xhxBxSYdg==; path=/; httponly; secure Strict-Transport-Security: max-age=31536000; includeSubDomains; preload <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header></soap:Header><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>An internal error occurred. For error details check MPL ID AFqUT9K546L_N3fXNEllIDiQ0QPD in message monitoring or use the URL https://<REMOVED HOST PORT>/itspaces/shell/monitoring/MessageDetails/%7B%22messageGuid%22%3A%22AFqUT9K546L_N3fXNEllIDiQ0QPD%22%7D to directly access the error information.</faultstring></soap:Fault></soap:Body></soap:Envelope>

On opening the error directly in the Web UI we get the below error.

Message Strip Error

Message processing failed. Error Details javax.script.ScriptException: java.lang.Exception: java.lang.Exception: OData Upsert failed. View the attached upsert response or take a look at the upsert response in the OData API Audit Log in Employee Central for more details.@ line 10 in FailedUpsertException.gsh, cause: java.lang.Exception: OData Upsert failed. View the attached upsert response or take a look at the upsert response in the OData API Audit Log in Employee Central for more details.As mentioned in the Audit log we checked the OData API Response and the response is copied in the test.txt file. test.txtWhat is the actual root cause of this issue and what should be the resolution?Thanks,Shaibayan

[former_member110033]

Hello,

Facing the same below error in the same iFlow and no MPL attachment generated in CPI message, so unable to find root cause of error. Please let us know how and where (Tcode and table) to check in EC and ERP systems? as unable to find it in EC.

Error- javax.script.ScriptException: java.lang.Exception: java.lang.Exception: OData Upsert failed. View the attached upsert response or take a look at the upsert response in the OData API Audit Log in Employee Central for more details.@ line 10 in FailedUpsertException.gsh, cause: java.lang.Exception: OData Upsert failed. View the attached upsert response or take a look at the upsert response in the OData API Audit Log in Employee Central for more details.

iFlow name- Send Confirmations from SAP ERP or SAP S4HANA to SAP SuccessFactors Employee Central

Regards

[Eleodora]

Same issue here