SAP Knowledge Base Article - Public

3619090 - Error when submitting a New Hire / Rehire: "java.lang.IllegalStateException: org.hibernate.exception.SQLGrammarException: could not execute query" - Employee Central

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

  1. Add New Hire or Rehire employee either via Add New Employee, Rehire Inactive Employee or Drafts in Manage Pending Hires;
  2. Fill in all required fields;
  3. Hir final submit;
  4. 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

Product

SAP SuccessFactors Employee Central all versions