Latest Contributions by srinivasreddy

How to query delta (Addition) table for particular version data in SQL developer. I have find SDE_STATE_ID column is only the column related to that, but still i could not able to do it. Thanks & regards V.Srinivasa Reddy ... View more

Hi, I Have Oracle 11g and ArcSDE 10.1. I have a production version where all the softwares (ArcSDE, Oracle) installed properly. and same kind of set up we made for test environment also. Here the problem is, we are regularly creating the oracle backup files (Which contains lot of ArcSDE spatial table and multiple versions) using oracle export utility tool and it is creating a .dmp file. When we are importing it in oracle test environment with oracle import utility, all the users, schema and their roles are importing with out any error.But when we connect to the SDE through catalog all the Feature datasets and Feature Classes are available with out data. i.e, only schema is available. Do i need to do any other operations for this spatial data while exporting or importing? Any suggestions would help to solve my problem. Thanks & regards srinivas ... View more

I have a SDE user (parent), and two more users (ex: user1,user2) in my oracle database with required SDE permissions. In my SDE db, i have a polygon FeatureClass (Ex: world) with a field called region (attribute values are North and South) and it is registered as versioned under sde.default. And now i would like create, two child versions for sde.default (Ex: version1,version2) for user1 and user2 respectively and i would like to allow user1(version1) to view/edit the data related to a particular region(Ex:North), similarly for the user2(version2) to view/edit data related to the region south. Is it possible to apply the above filter while creating versions in ArcSDE database? Thanks & Regards Srinivas ... View more

I have a requirement to provide option to the user to clip all the locations which are falling in a particular polygon boundary. Here actually, the point locations are at server side and polygon is his local featureclas/featurelayer in ArcMap. And the clip process should done by a GP Service. So here i need to have an option to input the user featurelayer in GP service tool and run the process. (But i don't want to use featureset for selection). Is this possible? ... View more

I need help in developing a python tool. I have few queries in FeatureSet datatype. 1) When i am using featureset in 10.2, it is giving options to draw on the map or to select some features from featureclass and it is the second parameter of the tool. My first parameter is a dropdownlist with options a) Select b) Create So, here is it possible to enable only draw option disable select from feature layer when user selects create and only select option when user selects select option.(Based on the first parameter) 2) When i disabled the Featureset parameter in tool validator class, Only dropdown is getting disabled but still draw option is enabled for featureset. Is it possible to completely disable featureset as well as draw option of the featureset. 3) Is it possible to arrange multiple checkboxes horizontally in a tool. i need help on this. Thanks & Regards V Srinivas ... View more

When i am installing ArcSDE 10.1 with oracle 11g R2 64 bit i am getting the following error.    "The ArcSDE(esri_sde)" service on local computer is started and then stopped" . I tried to resolve this issues from all the possible internet resources. But i could not resolve the issue. Here i am using the following softwares 1) Oracle DB- 11g R2 X 64 bit 2) Oracle Client- 11g R2 X 32 bit 3) ArcSDE 10.1 And i have set the port number and other details in the services.sde file and same copied in services file(Windows dir). I have set SDEHOME and ORACLEHOME also. I have attached log file also. Please provide solution to this. Srinivas ... View more

I am getting the following error when starting esri_sde service on local machine. And my system configuration are... 1) Windows Server R2 X 32-bit 2) ArcSDE 10 3) Oracle 11g 32-bit and Client also same. Initially it was working fine, but suddenly i don't know what happened to the esri_sde service it is not starting with OS. So when i tried to start manually first time i have received  "1053: The service did not respond to the start or control request in a timely fashion". so i just re-install oracle client. Then it starts showing the following error. "The ArcSDE service (ESRI_SDE) service on local computer started and then stopped. Some Services stop automateically if they are not in use by other services or programs" Some help is needed Thanks Srinivas ... View more

I am querying 100 SdeFeatureclasses Inside a for loop using a Polygon using following code. //This List of SDE.FeatureClases.. List<string> FeatureClassList=GetFeatureClasses(); Ex: for(int i=0;i<FeatureClassList.Count;i++) {     ISpatialFilter pspQuery=new SpatialFilterClass();     pspQuery.Geometry=myGeom;     pspQuery.spatialRel=esriSpatialRelEnum.SpatilRelIntersects;        PFeatureClass=PworkSpacefactory.OpenFeatureClass(FeatureClassList)         int Count=PFeatureClass.FeatureCount(pspQuery);   } When Query Reaches to 25th FeatureClass it, is showing E_RPC_SERVERFAULT Exception...... Do i have to Change any configuration settings in sde connection files. Here i am using PropertySetCLass Only..... ThankS SRI ... View more

As of now, if we want to query ArcSDE Geodatabase which stored in Oracle, We have the following ways 1) Query using ArcObjects classes 2) Query the GeoDataService if we have ArcGIS Server. 3) Query using REST or SOAP API s (If our data is published using ArcGIS Server) By all the above methods we cann't Query Oracle tables directly. and these are little bit time consuming if geoemtry is complecated. Instead of with these methods if there is a direct way to query Geodatabse(In oracle or SQL Server) tables using st_geometry functions it will be fast. Actually this method is possible using Oracle.DataAccess.Client library. But we have to implement a CustomMapping class to work with st_geoemtry. If it is possible please implement an custom interface to work with SDE directly with out using any ArcObject classes or an SDEDataAccess dll like oracle dataaccess dll. Thanks and Regards V.Srinivasa Reddy ... View more

I have ArcSDE 10 and Oracle 11g installed on my Windows server 2003. And i am trying to query tables having st_geoemtry columns.and i have got the results when i am querying from SQL Developer, and queries are working fine. But when i am trying to access and filling into DataSet in c# using ADO.NET it is throwing exception like "Un supported data format" for st_geometry column. and i want to write a webservice which having the capability to query ArcSDE (Oracle) by sql statements contains st_geometry operations. Actually my main objective is querying oracle (ArcSDE) using asmx webservice(c#). If any body have any idea over this please share with me or at least some suggestions. Thanks and Regards SRI ... View more

I have return a small dll on ArcGIS 10 and visula studio 2010 when i was registering on other machines it is working fine. But when i wrote the same code in Visual studio 2008 and running on 9.3.1 it is working on my system perfectly. But when i try to register this dll on other systems using esriRegSvr it is showing "Unable to locate exported function dllregisterserver." even this same error is occurring on my system when i use   esriRegSvr. Please somebody help me thank you..... Srinivas ... View more

I am trying to add layers dynamically to the map component by using the following code with a button click..... for(var i:int=0;i<4;i++) { ArcGISDynamicserviceLayer dyn=new ArcGISDynamicLayer(//URL); dyn.VisibleLayers=//Some visible Layers array collection.... myMap.addLayer(dyn,i); } When i am adding first time it is adding successfully.... But when i remove all the layers i have added and i tried add another set of layers like this with another button click the new set of layers are not visible on the map..... When i am checking the number of layers on map it showing the count and all urls also....What is the reason for this..... Thanks & Regards Srinivas.............. ... View more