Latest Contributions by ApurvDanke

‎11-26-2024

Hello, We have upgraded a geodatabase from 10.6.1 to 10.8.1 using an SQL Server backup file extracted from production environment. This is also an ArcFM enabled database including Fiber Manager, where ArcFM has been upgraded from 10.6.1 to 10.8.1c. Broadly we followed these steps. Restore the database from backup file in a new instance of SQL Server. Upgrade ESRI geodatabase from 10.6.1 to 10.8.1 using upgrade geodatabase geoprocessing tool. Upgrade ArcFM and Fiber Manager from 10.6.1 to 10.8.1c. Applied all necessary privileges and permissions to data creators such as Electric, Water, Fiber users (schema owners) in SQL server. Provided all the permissions to SDE user in SQL server. We're observing few things. After logging in with Electric user (schema owner for Electric data) we can see Electric datasets, Electric relationships but we can also see relationships from other data creators such as Water, Fiber etc. As per our client, this should not happen. Only Electric data and Electric relationships should be visible. If we connect to geodatabase using Electric user, we can view the properties of Electric relationships correctly, but if we check properties of Water or Fiber relationships we get an error - ApurvDanke_0-1732622060971.png 3. We see all the objects in geodatabase whether it is feature dataset, feature class, table or relationship - all of them are named as [DatabaseName].[DataCreatorUser].[ObjectName]. For example a feature class for Fuse is named as ABC.Electric.Fuse. Where ABC is our database name. This is unusual. Usually the format should be Electric.Fuse. Same is observed for other objects like feature dataset, table or relationship. Following permissions have been provided to Electric user in SQL Server (15.x). Database Level Permissions - Connect, Create Procedure, Create Table User Memberships - None Permissions given on SDE schema - Execute, Select Permissions given on Electric schema - Electric user is owner of this schema Database Role Membership - Public We tried giving database role membership "db_datareader" and it fixes the issue for relationship error for other data creator owned relationships such as Water (#2 above in observations), but it introduces another issue which is that all the other datasets belonging to other data creators are also visible to Electric user. Any reason why we're observing the points 1-3 above? Any solution or workaround for the same? Regards, Apurv

‎03-30-2022

Hello, I have access to an Enterprise Portal 10.9.1, where I have created an EB application and am working on it to add more data and functionality. Further down the line, we would be getting a new environment where a separate instance of ArcGIS Enterprise 10.9.1 will be setup. I want to be able to download the application which I'm working on the current Enterprise Portal 10.9.1 and import it in the new Enterprise Portal 10.9.1 once it is ready, so that future development can happen in the new environment. I have not seen any download option or import option yet for EB within Enterprise Portal 10.9.1. Is this possible to do? I do not want to be in a situation when suddenly I realize that I need to develop the application from scratch again in the new Enterprise Portal 10.9.1. Regards, Apurv

‎05-21-2020

Hello, We're planning to change RAM on our servers which are virtual machines. We have four types of changes planned. 1. Increase RAM on Server 1. This server has ArcGIS Desktop installed and is authorized using single-use license. Also, Portal for ArcGIS is installed on this server. 2. Increase RAM on Server 2. This server has ArcGIS Server installed and authorized. 3. Server 3 - Same as point 1 above but here RAM will be decreased. 4. Server 4 - Same as point 2 above but here RAM will be decreased. My question is will increasing or decreasing RAM on these servers have any impact on functioning of ArcGIS Desktop, Portal and Server and also their respective licenses? Is there any need to de-authorize the licenses or even uninstall the products before changing RAM size? The version is 10.7.1 on Windows 2016. Regards, Apurv

‎03-27-2020

Hello All, Has anyone ever configured Collector app on an IOS emulator on a Windows 7 or 10 machine? Which IOS emulators can be used on Windows to configure Collector app? Regards, Apurv

‎12-27-2019

Hello, We have an application which is built using Web App Builder and it uses the ESRI resource proxy (.Net latest version 1.1.2) to access ArcGIS Online and other URL's accessible on internet. The proxy application has been setup in IIS with anonymous authentication. Pinged the proxy and it worked fine. https://[server]/[proxyname]/proxy.ashx?ping Initially, I tried accessing ArcGIS Online URL via the proxy without making any changes in proxy config or application: https://[server]/[proxyname]/proxy.ashx?https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json Got the following error. {"error": {"code": 403,"message":"Proxy has not been set up for this URL. Make sure there is a serverUrl in the configuration file that matches: https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json"}} This means that the error message was coming from proxy application only as it mentioned “serverUrl” parameter. Now by default the following rule is already present in the default version of proxy.config <serverUrl url="http://services.arcgisonline.com" matchAll="true"/> Still the above error message for “ServerUrl” came. So I added another “ServerUrl” as given below. <serverUrl url="https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json" matchAll="true"/> I didn’t mention any user or password or domain. Now I got the following error while trying to access AGOL URL via proxy. {"error": {"code": 500,"message":"Unable to connect to the remote server https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json"}} This suggests that proxy application is unable to access internet. So now I changed the following line in proxy.ashx to use our organization proxy. private static System.Net.IWebProxy SYSTEM_PROXY = new WebProxy("[Our organization proxy PAC file]",true); //System.Net.HttpWebRequest.DefaultWebProxy; // Use the default system proxy After I did this change the AGOL URL was accessible via proxy. However after some time when I tried to access same URL: https://[server]/[proxyname]/proxy.ashx?https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json Getting this error (In Chrome) This site can’t be reached The webpage at https://[server]/[proxyname]/proxy.ashx?https://services.arcgisonline.com/ArcGIS/rest/services/World_Topo_Map/MapServer?f=json might be temporarily down or it may have moved permanently to a new web address. ERR_UNEXPECTED_PROXY_AUTH Error in IE You must be authenticated by a proxy before the Web server can process your request. Why is this happening? Operating System is Windows Server 2016. IIS version is 10. ArcGIS Server, Portal for ArcGIS version is 10.7.1. Regards, Apurv

‎11-25-2019

Hello, We have been extracting reports from ArcGIS Monitor on a daily basis, monitoring ArcGIS Server and Portal for ArcGIS. Since last few days there is no data in the report. All reports are the same, and few tabs in the report excel sheet are missing. If I try to see graphs on the ArcGIS Monitor dashboard, I see a message "No data available". Interestingly this is happening only for one of the collectors, the other collector is getting data correctly. Any suggestions on what could be the reason the collection is failing for one of the collectors? Versions as given below. ArcGIS Monitor 10.6.1 ArcGIS Server 10.4.1 Portal for ArcGIS 10.4.1 Regards, Apurv

‎07-16-2019

Hello John, As per the link given below, it mentions choosing the Request Type(under HTTP) as ArcGIS Token. Then put the URL you want to monitor in the "Url" box and enter the Token URL for ArcGIS Server as well as adding the ArcGIS Server admin credentials in the "Add Credentials". Add HTTP In order to monitor ArcGIS Online services, what would be the token URL format and what credentials should be added here? Especially for the services which are accessible within the organization? Thank you for your assistance. Regards, Apurv

‎07-15-2019

Hello, Is it possible to monitor services hosted in ArcGIS Online using AGS Monitor 10.6.1? Such as feature services in AGOL? Is it possible using the Add HTTP option? Regards, Apurv

‎12-15-2018

Hello, I am getting a similar error message in the Search method while doing spatial query in ArcObjects (C#). The code is given below. public IFeatureCursor GetOSMMGeometry(IFeature pFeederFeature, IFeatureClass pOsmmFC, string osmm_FeatCodeList) { ISpatialFilter pSpatialFilter = null; IFeatureCursor pOsmmCursor; try { pSpatialFilter = new SpatialFilterClass(); pSpatialFilter.Geometry = pFeederFeature.ShapeCopy; pSpatialFilter.GeometryField = pOsmmFC.ShapeFieldName; pSpatialFilter.SpatialRel = esriSpatialRelEnum.esriSpatialRelIntersects; pSpatialFilter.WhereClause = "FEATCODE IN (" + osmm_FeatCodeList + ")"; pSpatialFilter.SubFields = "*"; pOsmmCursor = pOsmmFC.Search(pSpatialFilter, false); return pOsmmCursor; } catch(Exception ex) { } } Exception details given below. System.Runtime.InteropServices.COMException was caught HelpLink=esri_csGeoDatabase.hlp HResult=-2147216072 Message=Underlying DBMS error [ORA-29902: error in executing ODCIIndexStart() routine ORA-13200: internal error [ODCIIndexStart] in spatial indexing. ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 543::SELECT TOID, VERSION, VERDATE, FEATCODE, THEME, CALCAREA, CHANGE, DESCGROUP, DESCTERM, MAKE, PHYSLEVEL, PHYSPRES, BROKEN, LOADDATE, OBJECTID, SHAPE, SE_ANNO_CAD_DATA, 0, 0 FROM OSMM.OSMMAREA WHERE mdsys.sdo_filter(OSMM.OSMMAREA.SHAPE, MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1), 'querytype=window') = 'TRUE' AND (FEATCODE IN (10089,10167,10172,10183))] [OSMM.OSMMArea] Source=esriDataSourcesGDB.SdeWorkspace.1 ErrorCode=-2147216072 StackTrace: at ESRI.ArcGIS.Geodatabase.IFeatureClass.Search(IQueryFilter filter, Boolean Recycling) at CrossingsUpdate.PipeCrossingPoint.GetOSMMGeometry(IFeature pFeederFeature, IFeatureClass pOsmmFC, String osmm_FeatCodeList) The Feature Class I am trying to do a spatial query on is "pOsmmFC" which is a polygon type, while the query geometry is from another Feature Class which is a Polyline type. The "pOsmmFC" contains around 8 million features, but I am only interested in 4 feature codes, which are applied in the where clause of the spatial filter. I also tried Select By Location in ArcMap using the same two feature classes and selected the same polyline feature on the map, and tried do perform spatial query on the OSMM polygon feature class using only the selected feature, and it gave the output showing 257 intersecting features. Why isn't the same working in ArcObjects? The ArcGIS version is 10.4.1 on Oracle database 12c. We are using SDO Geometry as the geometry type for geodatabase. Regards, Apurv

‎11-21-2018

Hello Kevin, These suggestions have worked for us and we no longer need to disable versioning, archiving and editor tracking for most of the data model changes. However one question I still have is that if any fields get added or modified in a feature class, which participates in a replica, then does the replica need to be dropped and recreated? Presently whenever we need to create a new featureclass, and it should be part of replica, we need to drop and recreate the replica. Similarly do field addition/modification/removal or even subtype/domain changes in a featureclass affects the replica? Regards, Apurv

‎10-10-2018

Thanks George. I ran the SQL logging in as SDE user and this is the result in our staging database. Looks like all are valid. However, now we have a strange observation. Now when we do a reconcile/post to SDE.DEFAULT the error is not coming. But when we run "Synchronize Changes" python script to replicate the data updates from our staging database to consumption database, we are getting the error as given below. Synchronisation Started at Time 2018-10-08 10:50:58.501000 Source SDE = [Our staging database SDE connection] Replication ID = [Our replica name] Target SDE = [Our consumption database SDE connection] Exception caught at :2018-10-08 10:51:14.283000 Code = 1 (FAILURE), Underlying DBMS error [ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE] Error on Line 86 Replica Synchronisation Failed for Site Area Code = Underlying DBMS error [ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE] Now I ran the same SQL query in our consumption database, and I see there is an index which is in FAILED state. How to drop and rebuild this index? Also our staging database is versioned, while consumption is non-versioned. Thanks for your help. Regards, Apurv

‎10-05-2018

Hi, We recently migrated our Oracle geodatabase from AIX to Oracle Linux platform. The geodatabase version is 10.4.1. We're using SDO_Geometry as our spatial type. While doing our database checks, we encountered an error while doing a reconcile/post. As per our versioning framework, we have SDE.Default as the top version in hierarchy. Below that, we have 3 user schema versions - Schema1.ADMIN, Schema2.Admin, Schema3.Admin , all of them are children of SDE.Default. Now under each schema admin version we have further children which are the user versions. So for example, we have a version Schema1.User1 which is child of Schema1.ADMIN, which in turn is child of SDE.Default. Now in the migrated database, we did some edits in Schema1.User1 version, which were successfully reconciled and posted to Schema1.ADMIN. The error has come when we do reconcile and post from Schema1.ADMIN to SDE.Default. Here reconcile still works, it is in the post that we get this error. The ESRI article in the link given below is applicable for ArcSDE 9.2-9.3.1 and for ST_Geometry. In our case we do not have ArcSDE, we have ESRI Geodatabase 10.4.1 and enabled SDO_Geometry. Error: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE What could be the cause of this? Is it related to tablespace or something else? Regards, Apurv

‎08-31-2018

Hi Uday, Before querying the versioned view in my stored procedure I wrote the following statement. sde.version_util.set_current_version(Version_Name); After that I wrote the query to retrieve the data from this version. Lastly you need to set the current version back to SDE.DEFAULT, so you must call the function again after getting the data. For some reason which I cannot recall , I had to do this particular thing in a separate stored procedure which has just one line which is to set the current version. So I made 2 SP calls - first one containing setting the query version, and executing the query to get the data. 2nd one simply to set the current version back to SDE.DEFAULT. This approach worked for me. I am not sure if you can write the last statement to set back to SDE.DEFAULT in the same stored procedure, but you can try. Hope this input helps. Regards, Apurv

‎08-06-2018

Hi Jonathan, In my case I need to migrate the ArcGIS Server 10.4.1 to a new server with different hostname and IP address. I would need to uninstall ArcGIS Server on the old server and freshly install ArcGIS Server on the new server. I am using a lot of map services and some feature services. Also I have Oracle geodatabase connections, and folders having data registered with ArcGIS Server. There are no users or roles except for the site administrator. Also, 1 site has 1 GIS server machine only. Also web adaptor has been configured with IIS, so I'm planning to install ArcGIS Server and configure Web Adaptor on the new server. However, Before uninstalling ArcGIS Server from old server, what steps need to be taken. After installing ArcGIS Server and configuring web adaptor in new server, what steps need to be taken. I want to minimize the work as much as possible. I don't want to publish each and every service again, or register all the data sources again. Thanks for your help. Regards, Apurv

‎06-01-2018

As discussed in earlier posts in this thread, you cannot instantiate ArcObjects classes within a .Net Web service as there are limitations. Hence go for ArcGIS Server REST API "addFeatures" or "ApplyEdits" or create geoprocessing services of your own and call either of them in your web service. For one of our requirements we used "addFeatures" method from REST API in a web service to create point and polygon features in non-versioned feature classes. You can also try Oracle Spatial functions or methods in case your geodatabase is based on Oracle; though I'm not very sure how it could be done. Hope that helps. Regards, Apurv

Online Status	Offline
Date Last Visited	‎11-26-2024 07:49 AM

My Ideas

Latest Contributions by ApurvDanke

Seeing relationships from other data creator in a particular data creator SDE connection

Export and Import an Application from EB

Impact on ArcGIS License Due to RAM Increase/Decrease

IOS Emulator for Collector on Windows

Authentication error with .Net resource proxy

ArcGIS Monitor Does not show any data

Re: Discover ArcGIS Monitor 10.6.1

Re: Discover ArcGIS Monitor 10.6.1

Re: intersecting a geometry with a feature class error in SHAPELIB

Re: Approach for Data Model Changes

Re: ORA-29861:domain index is marked LOADING/FAILED/UNUSABLE

ORA-29861:domain index is marked LOADING/FAILED/UNUSABLE

Re: Using sde.version_util.set_current_version in Oracle stored procedure

Re: The best practice to transfer the ArcGIS Server data from one machine to another,

Re: WADL/WSDL using .Net web service using ArcObjects SDK

Re: Unable to Delete Versions

Unable to Delete Versions

Re: Using sde.version_util.set_current_version in ...

Re: Export Statistics Failed in ArcGIS Server Mana...

Re: Error 001359: Failed to connect to the server