Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Process Manager (Stardust) » ConcurrencyException on AuditTrailPartitionBean with Tomcat 6 and MSSQL
ConcurrencyException on AuditTrailPartitionBean with Tomcat 6 and MSSQL [message #1008530] Tue, 12 February 2013 16:25 Go to next message
Jan Hendrik Scheufen is currently offline Jan Hendrik Scheufen
Messages: 61
Registered: October 2011
Member

I deployed a Stardust 0.7 release on Tomcat 6 with MSSQL 8 as AuditTrail. The DB schema as created using the "sysconsole ddl" command and then deployed via MSSQL management tools.

The application starts up normally, but when I try to deploy a process model I get the following error in the log:
02/12 14:06:28.614 INFO - [http-8080-3    ] Session                             - BPMRT03601 - Concurrent attempt to lock object of type class org.eclipse.stardust.engine.core.runtime.beans.AuditTrailPartitionBean with OID 1, row not selected.
02/12 14:06:28.615 WARN - [http-8080-3    ] LogUtils                            - BPMRT03601 - Concurrent attempt to lock object of type class org.eclipse.stardust.engine.core.runtime.beans.AuditTrailPartitionBean with OID 1, row not selected.
02/12 14:06:28.626 ERROR- [http-8080-3    ] ExceptionHandler                    - org.eclipse.stardust.common.error.ConcurrencyException: BPMRT03601 - Concurrent attempt to lock object of type class org.eclipse.stardust.engine.core.runtime.beans.AuditTrailPartitionBean with OID 1, row not selected.
02/12 14:06:28.752 ERROR- [http-8080-3    ] MessageDialog                       - org.eclipse.stardust.common.error.ConcurrencyException: BPMRT03601 - Concurrent attempt to lock object of type class org.eclipse.stardust.engine.core.runtime.beans.AuditTrailPartitionBean with OID 1, row not selected.

Re: ConcurrencyException on AuditTrailPartitionBean with Tomcat 6 and MSSQL [message #1008536 is a reply to message #1008530] Tue, 12 February 2013 16:57 Go to previous messageGo to next message
Jan Hendrik Scheufen is currently offline Jan Hendrik Scheufen
Messages: 61
Registered: October 2011
Member

The property AuditTrail.UseLockTables = true was set when generating the DDL, so there are extra _lck tables, but the PARTITION_LCK table was empty which caused the problem. The environment uses only the 'default' partition wich can be found in the PARTITION table with OID=1, so executing the following statement fixed the problem:
INSERT INTO partition_lck (oid) VALUES (1);
Re: ConcurrencyException on AuditTrailPartitionBean with Tomcat 6 and MSSQL [message #1008537 is a reply to message #1008536] Tue, 12 February 2013 16:59 Go to previous message
Jan Hendrik Scheufen is currently offline Jan Hendrik Scheufen
Messages: 61
Registered: October 2011
Member

It's possible that this is a bug! The entry in the PARTITION_LCK table should have been set by Stardust automatically. Will need to investigate ...
Previous Topic:Starting and reactivating multiple process instances
Next Topic:Accessing Stardust dynamic web services on Weblogic 10.3 results in 401 Unauthorized response
Goto Forum:
  


Current Time: Wed Jul 23 02:01:00 EDT 2014

Powered by FUDForum. Page generated in 0.01613 seconds