Symptom
Error when submitting a new hire or rehire: "java.lang.IllegalStateException: org.hibernate.exception.SQLGrammarException: could not execute query."
Environment
SAP SuccessFactors Employee Central
Reproducing the Issue
- Add New Hire or Rehire employee either via Add New Employee, Rehire Inactive Employee or Drafts in Manage Pending Hires;
- Fill in all required fields;
- Hir final submit;
- Error message is displayed: "java.lang.IllegalStateException: org.hibernate.exception.SQLGrammarException: could not execute query".
Cause
End Date 12/31/9999 was defined for a Pay Component, which is the default End Date for all Pay Components.
Resolution
- Remove the End Date 12/31/9999 from Pay Component;
- Ensure that no End Date is set when it should be equal to the default value (12/31/9999).
Keywords
SAP DBTECH JDBC: DATE/TIME VALUE OUT OF RANGE: 10000-01-01 00:00:00.000000000 UTC AD (VALUE MUST BE BETWEEN 0001-01-01 00:00:00.000000000 UTC AD AND 9999-12-31 23:59:59.999999900 UTC AD INCLUSIVE), error, new hire, sap successfactors, employee central, java.lang.IllegalStateException, org.hibernate.exception.SQLGrammarException, SAP DBTECH JDBC, DATE/TIME VALUE OUT OF RANGE, SQL Error: -11419, SQLState: 07006, Pay Component, End Date, successfactors, employee central , KBA , LOD-SF-EC-HIR-NEW , Add New Employee Wizard , How To
SAP Knowledge Base Article - Public