3545732 - [Known Error] PFS Internal Error with BPE Document generation error - Onboarding

See error in PFS account > Maintain Form Templates page:

• Internal error occurred. Please try again later.

See Document generation error in Business Process tile:

• HCP Error Message: Http Status Code 500 
• Operation /odata/DataSchema (for FormId OOOXXX Locale en_GB) returned status code 500
• HCP Response Content: {"error":{"code":null,"message":"Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLException: Borrow prepareStatement from pool failed\nError Code: 0\nCall: SELECT pk_id AS a1, template_creation_date AS a2, template_desc AS a3, template_id AS a4, template_name AS a5, template_locale AS a6, template_status AS a7, tenant_id AS a8, template_version AS a9, template_xml_content AS a10, template_zip_flag AS a11 FROM PFS_Template WHERE (((((template_id = ?) AND (template_locale = ?)) AND (template_zip_flag IS NULL)) AND (tenant_id = ?)) AND ((((? = 1) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 0)))) ORDER BY template_version DESC LIMIT ? OFFSET ?\n\tbind => [OOOXXX, en_GB, 335c3552-c2d4-4135-bcd2-5b362ece804f, 0, SAP_PROVIDER_TENANT, 335c3552-c2d4-4135-bcd2-5b362ece804f, 335c3552-c2d4-4135-bcd2-5b362ece804f, 1, 0]\nQuery: ReadAllQuery(referenceClass=Template sql=\"SELECT pk_id AS a1, template_creation_date AS a2, template_desc AS a3, template_id AS a4, template_name AS a5, template_locale AS a6, template_status AS a7, tenant_id AS a8, template_version AS a9, template_xml_content AS a10, template_zip_flag AS a11 FROM PFS_Template WHERE (((((template_id = ?) AND (template_locale = ?)) AND (template_zip_flag IS NULL)) AND (tenant_id = ?)) AND ((((? = 1) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 0)))) ORDER BY template_version DESC LIMIT ? OFFSET ?\"); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception: java.sql.SQLException: Borrow prepareStatement from pool failed\nError Code: 0\nCall: SELECT pk_id AS a1, template_creation_date AS a2, template_desc AS a3, template_id AS a4, template_name AS a5, template_locale AS a6, template_status AS a7, tenant_id AS a8, template_version AS a9, template_xml_content AS a10, template_zip_flag AS a11 FROM PFS_Template WHERE (((((template_id = ?) AND (template_locale = ?)) AND (template_zip_flag IS NULL)) AND (tenant_id = ?)) AND ((((? = 1) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 0)))) ORDER BY template_version DESC LIMIT ? OFFSET ?\n\tbind => [OOOXXX, en_GB, 335c3552-c2d4-4135-bcd2-5b362ece804f, 0, SAP_PROVIDER_TENANT, 335c3552-c2d4-4135-bcd2-5b362ece804f, 335c3552-c2d4-4135-bcd2-5b362ece804f, 1, 0]\nQuery: ReadAllQuery(referenceClass=Template sql=\"SELECT pk_id AS a1, template_creation_date AS a2, template_desc AS a3, template_id AS a4, template_name AS a5, template_locale AS a6, template_status AS a7, tenant_id AS a8, template_version AS a9, template_xml_content AS a10, template_zip_flag AS a11 FROM PFS_Template WHERE (((((template_id = ?) AND (template_locale = ?)) AND (template_zip_flag IS NULL)) AND (tenant_id = ?)) AND ((((? = 1) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 1))) OR ((tenant_id = ?) AND (template_status = 0)))) ORDER BY template_version DESC LIMIT ? OFFSET ?\")"}}

SAP SuccessFactors Onboarding

1. Go to To-do bar > see Business Process error
2. Log into PFS account > Maintain Form Templates > see Internal error pop-up

The issue has been resolved by engineering team. Follow below steps to resolve the error:

1. Go to To-do bar > Business Process tile
2. Restart the Document creation error
3. After restarting, the E-signature step should be triggered now

SAP, SuccessFactors, Onboarding, Print Form Services, PFS, internal error, Business Process, Exception [EclipseLink-4002], Status Code 500 , KBA , LOD-SF-OBX-DOC , Generation of Documents using PFS , Bug Filed