Oracle DB Table Resource Adapter Deadlock Issue
Howdy folks,
This morning I configured a resource adapter against a table in an Oracle db. IDM made the adapter and I attempted to load accounts from the resource. However, I mapped my accountId against a field that was too short (ids less then 4 characters long). So I went to edit the resource adapter and change the key to a different field. Unfortunately, it decided to throw a Deadlock error.
"==> java.io.IOException: ORA-00060: deadlock detected while waiting for resource"
The same thing happens when I try to edit or create a new resource. Looking at the logs/errors from the Oracle db side, it really looks like IDM is locking a table, then locking the same table again. Thus creating a deadlock state for Oracle. Right now I can no longer create or modify any oracle table resource adapters. Has anyone had this happen before? Does anyone know why this might be happening?
Does anyone have any advice for debugging it? Right now I'm thinking that I'll try to increase IDM's trace level or debug level or what not...
