I recently ran into an issue with ALBPM 5.7 MP2 when it was deployed on Weblogic 9.2. The Engine would look like it started properly, but automatic activities within a process would not be executed. Upon closer review of the Engine Log, this error was seen:

An exception occurred while executing a transaction. Details: An error occurred while accesing the database. Technical detail: SQL statement: ' SELECT DUETIME, ID, PROCESSID, INSTID, THREADID, TSTAMP, TYPE, ACTIVITYNAME, ORIGINPROCESSDN, REALTHREADID, NETYPE, PRIORITY, LATER, DATA FROM PTODOITEMS WITH (ROWLOCK , UPDLOCK) WHERE...