3585819 - Job Information or termination Update failure caused by USERS_SYS_JOBCODE Maximum Length

An application error appears when trying to approve an update for a users job information record or when terminating a user.

The application error id would be accompanied by the error: DAOException caught: SQLException for column: Failed in "USERS_SYS_JOBCODE"  

Error: java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: HibernateException thrown could not prepare statement

• Caused by: java.sql.SQLException:  Transaction cannot proceed: STATUS_MARKED_ROLLBACK
• Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
• Caused by: com.successfactors.db.dao.DAOException: HibernateException thrown could not prepare statement

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

• SAP SuccessFactors HXM Suite
• SAP SuccessFactors Employee Central

Incident, INC11881333, Caused by: com.successfactors.db.dao.DAOException: HibernateException thrown could not prepare statement, Caused by:Transaction cannot proceed: STATUS_MARKED_ROLLBACK, USERS_SYS_JOBCODE, 128 character , manage data, Job Classification  , Job Code, terminate, max length , exerntalCode , Max. Length , Max Length , department , cost center , division  , KBA , LOD-SF-EC-EMP , Employment Information (Employment Details) , LOD-SF-EC-TER , Termination Details , LOD-SF-EC-HRS , HRIS Sync , Problem