Solution : https://service.sap.com/sap/support/notes/145647 (SAP Service marketplace login required)
Summary :
SAP Note addresses performance degradation and deadlocks in payment program F110 due to various update processes in REGUV table and suboptimal COMMIT strategy. Enhancements include modifying the COMMIT threshold in T042C to manage update frequency and reduce database locking, thereby preventing deadlocks. The solution, effective from Release 4.6C, requires setting the COMMIT control parameter, which aggregates documents thus minimizing COMMIT calls and optimizing transaction processing. Implementing these changes involves adjusting entries in SM31 for T042C, considering database-specific adjustments for effective transaction management.
Key words :
'synchronous database updates' field, business partners selected, sap standard system, pays ten invoices, procedure - transaction sm31 -, parallel processing due, process treasury loans, larger rollback segments, database system settings, special lock techniques
Related Notes :
| 1323336 | Payment medium creation using PMW takes too long |
| 362631 | Pymnt progrm and pymnt medium printout tkes too lng |
| 178487 | High increase of table BSIS, RFBLG |
| 124094 | Payment run: Deadlock on DPAYG dur.parallelization |
| 110511 | Deadlocks on FI-SL summary table |
| 95200 | Cash managmt and forecast: deadlock on FDSB or FDSR |
| 86578 | Guidelines for F110 Payment Program (W/Check mgmt) |
| 84348 | Oracle deadlocks, ORA-00060 |
| 12663 | Deadlock on table RFBLG during the payment run |