Server raised fault: 'Database concurrency condition detected'

Friday, May 16, 2014 2:58:10 PM

I am using the Web service to trying to update the TestSet, When I call TestSet_Update(testset), I got the error  "suds.WebFault: Server raised fault: 'Database concurrency condition detected' .  Any idea?

all I did is:

Call set=TestSet_RetrieveById(10), to get the RemoteTestSet record. And then I change the set.TestSetStatusName="Completed",  After updating the value, I call client.service.TestSet_Update(set). I got the error message.

4 Replies
Friday, May 16, 2014 3:55:50 PM
Avatar
re: ygan on Friday, May 16, 2014 2:58:10 PM
That means that the ConcurrencyDate you are passing back does not match the one you received (or your SOAP library is changing its timezone).
Friday, May 16, 2014 8:05:08 PM
Avatar
re: inflectra.adam on Friday, May 16, 2014
Thank for your answer. But Could you give me more clues? What I can do to solve this issue?
Thursday, June 26, 2014 2:34:49 PM
Avatar
re: ygan on Friday, May 16, 2014

Hi

Most likely the issue is either the timezone or rounding issues on the milliseconds, is there a way to set the timezone on the Python date object?

Here's some pointers - http://reverb.findawayworld.com/development/easy-python-soap-with-suds-with-a-few-datetime-gotchas/

Try force-setting it to UTC?

Regards

Adam

Wednesday, July 9, 2014 7:35:43 AM
Avatar
re: inflectra.adam on Thursday, June 26, 2014
Hi,

we struggled with this suds issue for months. There is a bug in suds that cannot handle the milliseconds correctly. You cannot predict what value will be returned, even if the timestamp was only stored in a variable and later on read out.

our solution is https://pypi.python.org/pypi/suds-jurko. There the issue is solved.

this is what we used as installation for it (we are linux users):

perform:

wget http://bitbucket.org/jurko/suds/downloads/suds-jurko-0.6.tar.bz2

tar -xvf suds-jurko-0.6.tar.bz2

cd /usr/local/lib/python2.7/suds-jurko-0.6

python2.7 setup.py install


hope that helps :-)
Filip
Statistics
  • Started: Friday, May 16, 2014 2:58:10 PM
  • Last Reply: Wednesday, July 9, 2014 7:35:43 AM
  • Replies: 4
  • Views: 976