Events and Notification framework table EOEN_CONFIG Lock issue
Hi All,
We are facing an issue events frame work table lock(EOEN_CONFIG) when multiple transactions related to job data is happening. for ex: When users running job mass update programs / running HRCMP015 / doing Job data online transactions we could see spinning issue on the Job data page. when we query back end we could able to see that there is a table lock on record EOEN_CONFIG . Peoplecode function GetNextNumberWithGapsCommit() is trying to get EOEN_LAST_ID + 1 but as there were many transaction happening on job data going on (Mass update/CMP015) it is holding up that record. We also set the DBFlagvalue to 8 in App and process scheduler configuration files to establish secondary connection as