SAP Knowledge Base Article - Preview

2772567 - Compensation - Error when applying eligibility rules (Invalid DATE, TIME OR TIMESTAMP value)

Symptom

When applying eligibility rules, the attempt fails. Downloading the jobResponse.txt file or viewing the job through Provisioning shows the following error messages:

SQLException: [303]: invalid DATE, TIME or TIMESTAMP value: search table error:  [6931] attribute value is not a date or wrong syntax;attribute value is not a date or wrong syntax

Downloading and re-uploading the User Directory File (UDF) via Employee Data Import with zero changes will clear up the issue. However, after an update (such as a user update via ODATA API), the problem returns.

**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**


Read more...

Environment

  • SAP SuccessFactors Compensation
  • SAP SuccessFactors HXM Suite

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Suite all versions

Keywords

KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.