3698387 - PDC error "java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: thrown could not prepare statement" - SAP SuccessFactors Onboarding

• The onboardee encounters the error "java.lang.IllegalStateException: java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: thrown could not prepare statement" when attempting to submit the Personal Data Collection (PDC) step during onboarding.
• The error is seen if field in the Localized Biographical Information section is populated with data

SAP SuccessFactors Onboarding

1. Log in as candidate
2. Open Personal Data Collection step
3. Populate fields under Localized Biographical Information section
4. Attempt to submit the PDC step
5. Observe the error "java.lang.IllegalStateException: java.lang.IllegalStateException: com.successfactors.db.dao.DAOException: thrown could not prepare statement".

• The error is caused by an invalid sequence in the database: "BIOGRAPHICAL_INFO_LOC_ID_SEQ".
• Backend logs indicate the sequence is not properly exposed to external users, resulting in the error during processing.

1. Open a support ticket with support with affected company id, timestamp error presented and candidate user id so logs can be checked to ensure error is the same.
2. A script is required to update the sequence in the system to resolve the error.
3. Support see internal memo

personal data collection, onboarding error, java.lang.IllegalStateException, DAOException, IllegalStateException, BIOGRAPHICAL_INFO_LOC_ID_SEQ,, invalid sequence, PDC step error, Localized Biographical Information, PDC , KBA , LOD-SF-OBX-PDC , Personal Data Collection , Problem