Hello Everyone,
We are facing a strange problem after we upgraded to 10.2.2. We use the SOAP API to query map service and it was working fine until 10.2 and once we upgraded to 10.2.2 we started to get General Geodatabase error and Error processing server request. The code we use is below:
QueryFilter queryFilter = new QueryFilter();
queryFilter.WhereClause = "ID NOT NULL";
queryFilter.PostfixClause = " ORDER BY ID DESC";
queryFilter.SubFields = "ID";
recordSet = soapMap.QueryFeatureData(mapName, LayerId, queryFilter);
This code works fine on a map service published on 10.2 and if the same map document is published on 10.2.2 then we get general geodatabase error. The error is thrown when QueryFeatureData is called. Here are the map service logs:
<Msg time='2014-05-09T04:57:38,306' type='FINE' code='100001' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' >String request received. Request size is 589 characters.</Msg>
<Msg time='2014-05-09T04:57:38,306' type='FINE' code='10022' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' >QueryFeatureData has started.</Msg>
<Msg time='2014-05-09T04:57:38,307' type='SEVERE' code='10837' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' >General GeoDatabase Error.</Msg>
<Msg time='2014-05-09T04:57:38,307' type='FINE' code='10023' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' elapsed='0.00081'>QueryFeatureData has completed.</Msg>
<Msg time='2014-05-09T04:57:38,307' type='SEVERE' code='100005' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' elapsed='0.00178'>Method failed.HRESULT = 0x80004005 : Unspecified error
.</Msg>
<Msg time='2014-05-09T04:57:38,307' type='DEBUG' code='100000' target='RTAENOC.MapServer' methodName='MapServer.QueryFeatureData' machine='VMAGS102.RMEDUBAI.COM' process='3508' thread='1996' user='anonymous' > ERROR INFO = Error processing server request</Msg>
We even tried upgrading geodatabase to 10.2 and still the same issue. We tried even other postfix clauses like ORDER BY ID ASC or just ORDER BY ID and still the same error.
Any ideas why we are getting this error?
The geodatabase is in Oracle 11.
Thanks
Bala
