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

1. Go to user
2. Action -> Terminate
3. Fill in required fields
4. Click Save
5. Error: java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: HibernateException thrown could not prepare statement

SAP Internal log:

• DAOException caught: SQLException : Failed in "USERS_SYS_JOBCODE" column with the value 'xxxxx.....'

Hris synced value exceeds the max length of target field USERS_SYS_JOBCODE (Max. 128) while the calculated string is 140.

1. Go to Manage data
2. Select job code or job clarification
3. Select code:

See example

Job Code Field has more than 128 bytes View: Job Information (hris-element-id: jobInfo)

• The job code name considers both the title and code into the byte count. The text will need to be reduced to 128 bytes or less before any changes can be saved.
• NOTE: Some languages have double byte characters e.g., Traditional Chinese, Simplified Chinese, Japanese, Korean.

Step 1:  Export all user impacted by wrong job code

You must  run a report and filter all user with impact job code :2317955 - Correct or Remove Job Information record via Import in Full Purge mode

1. Go to Analytic then Adhoc Report
2. Create new Report
3. Select sub-domain: Person and Employment Export
4. In Column, Select only column Employee Job Infos
5. Filter Test user
6. Save
7. Back up your report into Your Desktop (will be used as a Backup)

Step 2: Correct label Maximum length: Max. Length: 128

1. Go to Manage data
2. Select job code or job clarification
3. Select code:

Or 

1. Correct Via Import and Export Data 

View: 2277155 - MDF - How to Export Data for MDF Objects?

Step 3: Insert new record or Update Job Information

• 2080801 - How to update Foundation Objects, and the respective Employee Data - Employee Central
• 2551350 - How to Update Generic Objects and the Respective Employee Data - Employee Central

For Hris sync JOB

• 2964383 - MDF Field label name Change Doesn't Sync to Employee Profile Header after HRIS Sync (real time or Incremental Sync job)

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

A) Guide: For any EC Standard field creation please refer to Guide: 

• Guide: Data Model Field Information for Employee Central
• For : Job Classification - job-code Max. Length: 128
• Field: employee-class  - Max. Length= 258
• Field: Department - division - Max Length = 128

• 3594029 - Daily or Full HRIS Sync job failure caused by Foundation Object ( FOO) Field Maximum Length 
• 2277155 - MDF - How to Export Data for MDF Objects?
• 2277994 - How to Import Data for MDF Objects/MDF picklists in SuccessFactors?
• 2236017 - Mass Deletion of MDF Data via Import
• 2317955 - Correct or Remove Job Information record via Import in Full Purge mode
• 2080801 - How to update Foundation Objects, and the respective Employee Data - Employee Central
• 2551350 - How to Update Generic Objects and the Respective Employee Data - Employee Central
• 2964383 - MDF Field label name Change Doesn't Sync to Employee Profile Header after HRIS Sync (real time or Incremental Sync job)
• 2740031 - Label remains with old value on Employee Export after being changed on Manage Data.- 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