Sparx Systems Forum
Enterprise Architect => Bugs and Issues => Topic started by: damo1978 on July 03, 2015, 05:54:58 pm
-
Below has been sent to support. Has anyone else experienced this issue that can help?
====
We are trialling the Sparx cloud services so that we can eventually rollout a shared repository function via it. We are aiming very soon to have a MS SQL-served repository, but whilst we’re waiting for that to be provisioned, we are using a Firebird DB on a VDI drive, and accessing this with our client EA application via the Sparx cloud service.
The errors can be said to be intermittent, but generally the occur on the client EA app when adding things in the repository. They particular occur when moving elements under other elements, say an Activity into an Activity on a diagram, which results in the expected move of the Activity element in the repository moving subordinate to the parent Activity element. But, the errors also occur when adding new elements directory to the repository.
This occurs on any shared repository that is set up.
We have only a small number of users with access, up to 2 or 3. This occurs even when there is only one user accessing the repository.
We have currently not added any 3rd party version control to any of the tested repositories. We are planning to do this with SVN, but until we have bottomed out this issue we don’t want to add further diagnostic challenges.
Even though these errors occur, it does seem to affect the overall function of the shared repository, i.e. the changes are reflected by to the repo, and each other user can see those changes.
The configuration details below show that we’re on an early version of 12, but a recent version of the cloud service. It has taken us quite a while to get v12 through our packaging process. So if there recommendations to upgrade before continuing with diagnostics, please bear this in mind that this may be a challenge. We may be able to have single users upgrade to test this, but we will need dispensation from our package deployment team. Please also note, these errors occurred even with the earlier versions of the cloud service.
Configuration
EA version: 12.0.1209
Sparx Cloud version: 1.0.10.1 (the installation binary is stamped @ 29.04.2015 @ 05:24)
Database: FDB
Server/VDI: 8GB / 4 cores
Client Console - System Output
@07:19
Cloud Services: Query in batch execute failed with message: FAIL: Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
[ODBC Firebird Driver][Firebird]deadlock
update conflicts with concurrent update
concurrent transaction number is 44865
Cloud Services: Query in batch execute failed with message: FAIL: Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
[ODBC Firebird Driver][Firebird]deadlock
update conflicts with concurrent update
concurrent transaction number is 44869
Server Logs
2015-07-03 07:18:21 [WARNING]: Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
2015-07-03 07:18:21 [WARNING]: [ODBC Firebird Driver][Firebird]deadlock
update conflicts with concurrent update
concurrent transaction number is 44865
2015-07-03 07:18:21 [WARNING]: Microsoft OLE DB Provider for ODBC Drivers [-2147467259]
2015-07-03 07:18:21 [WARNING]: [ODBC Firebird Driver][Firebird]deadlock
update conflicts with concurrent update
concurrent transaction number is 44869
-
I have the same problem. Did you get an answer from the support?
-
I've seen at least one report of something similar, but never reproduced it.
The point that jumps out to me is that you have a firebird model "on a VDI drive". Are you talking about the cloud service running on a VirtualBox (where vdi is the file extension for the disk image) or Microsoft Virtual Desktop Infrastructure (shortened to VDI)?