E1: BSSV Multiple JDE/BSSV Sessions Are Causing Row Locks On The Database (DB lock) or Connection Timeout
(Doc ID 1536985.1)
Last updated on AUGUST 17, 2020
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
You have custom integrations using BSSV solutions. Both Provider and Consumer. Provider does some table I/O against F0006 by calling a custom BSFN. When Oracle FMW calls the BSSV, it generates 6 sessions and F0006 gets locked.
Because of that, any of the E1 users who use applications or UBE's that access the F0006, get an error.
You have a dedicated logic server for the BSSV integrations. You would like to know why the BSSV requests are causing the table lock.
In order to fix the issue, you have to kill the kernels and db sessions to stop the lock.
You might see this issue using the JAVA Interop Solution.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document