[mapguide-users] New UpdateFeatures problem

[Klaus Lehtonen]

zspitzer wrote:
> 
> Can you do a clean start of mapguide which isn't being used by other
> users and then
> run your code to reproduce the problem and then post the Mapguide
> Server Access.log entries?
> 
> That will show the series of API calls being made.
> 

I did that by trying to add 20 features and  here is the result:

<2008-05-20T09:34:31> 			Anonymous
SelectFeatures.1.0.0:3(Session:2145c204-0000-1000-8000-0050563d1e2e_en_7F0000010AF20AF10AF0//Add
layer.FeatureSource,Feature,MgFeatureQueryOptions) Success
<2008-05-20T09:34:31> 			Anonymous	CloseFeatureReader.1.0.0:1(473296232)
Success
<2008-05-20T09:34:31> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:32> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:32> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:32> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:33> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:33> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:34> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:34> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:34> 			Anonymous
GetResourceData.1.0.0:3(Session:2145c204-0000-1000-8000-0050563d1e2e_en_7F0000010AF20AF10AF0//joensuu4edit48326e4b22554.Map,RuntimeData,)
Success
<2008-05-20T09:34:34> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:34> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Failure
<2008-05-20T09:34:36> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Failure
<2008-05-20T09:34:38> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Failure
<2008-05-20T09:34:40> 			Anonymous
QueryFeatures.1.0.0:7(Session:2145c204-0000-1000-8000-0050563d1e2e_en_7F0000010AF20AF10AF0//joensuu4edit48326e4b22554.Map,MgStringCollection,MgGeometry,4,,1,3)
Success
<2008-05-20T09:34:41> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:41> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:42> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:42> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:42> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:43> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:43> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:44> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:44> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success
<2008-05-20T09:34:44> 			Anonymous
UpdateFeatures.1.0.0:3(Library://Joensuu/Editor/Data/ora_iris.FeatureSource,MgFeatureCommandCollection,false,)
Success

This starts with selecting features from a session layer and then the
feature reader is closed. After that there was 9 features added without
problems. Starting from <2008-05-20T09:34:34> there was three failures to
add one feature. I added a two second wait before retry and the code tries
to add three times before giving up. However the next 10 features are added
without any problems.

I managed to solve this by not using UpdateFeatures and adding features with
ExecuteSqlNonQuery. I tried similar test many times and it seems to always
work. The logs also showed that using ExecuteSqlNonQuery was two times
faster than UpdateFeatures.
-- 
View this message in context: http://www.nabble.com/New-UpdateFeatures-problem-tp17248351p17334658.html
Sent from the MapGuide Users mailing list archive at Nabble.com.