3710325 - Error: “intermittently error "504 Gateway Time-out"

The recruitment system intermittently fails to load job requisition approvals and offer approvals, returning a 504 Gateway Time-out.  

The issue can be reproduced by the following conditions and actions: 

1. Description fields in SuccessFactors (such as job requisition descriptions) are designed to store textual information only. 

2. Oversized image or binary data is stored within these LOB/text description columns, contrary to their intended usage. 

3. A fuzzy search index is enabled on these description fields. 

4. As image and binary content is added, the fuzzy search index grows excessively in size. 

5. During system operations that require full table loading into memory (such as approval processing or system maintenance activities), SAP HANA loads the table together with the associated fuzzy search index. 

6. Due to the oversized fuzzy search index created on non-textual content, data loading and index creation times become slow and intermittent. 

7. These delays lead to timeouts at the application layer, resulting in intermittent 504 Gateway Time-out errors across multiple approval flows in SuccessFactors.