Latest Contributions by ChristianWells

‎06-23-2016

It sounds like you would have had them registered at 10.0 using either the sdelayer -o register or sdetable -o create view. Does that sound familiar? If so, that might explain the performance hit you are seeing at 10.3.1 with views after recreating them. To address the performance you may want to consider using the SDE 10.2.2 command line tools to register your views at 10.3.1.

‎06-22-2016

Hi Andrew, What version did you upgrade from? Were your spatial views previously registered with the geodatabase or is this a stand-alone instance? Spatial views (Query Layers) do have additional overhead when compared to feature classes or tables.

‎06-16-2016

Edited

‎06-16-2016

Hi Martin, I'm looking into the SQL ST functions for curved data. In the immediate, can you use the JSON via the da.SearchCursor? for row in arcpy.da.SearchCursor("SDE.ST_LINES", ["SHAPE@"]): print row[0].JSON Output: {"curvePaths":[[[-43050711.692462206,8862199.7932373881],[6561666.6665721536,39487124.706322819],{"c":[[99048939.903926104,89099503.065357178],[43156100.269598193,82281334.322446659]]}]],"spatialReference":{"wkid":102645,"latestWkid":2229}}

‎06-15-2016

Diego, I think the simplest workflow would be to restrict access to the server where the license manager resides. Perhaps this is what you are looking for: Restrict Server Access to Members of a Group Only

‎06-14-2016

To Tanu's point, having a support case for this is extremely helpful. Please DM me if you have any issues creating a ticket.

‎06-14-2016

Hi Hani, Do you have any unique indexes specified on your feature class for columns other than OBJECTID? The reason that multiversion tables cannot support unique indexes is because the delta tables that get created in this operation will support multiple rows for a single OBJECTID. Therefore, a unique index cannot be used as the values in the column will most likely repeat. For example in table 'Streets' with columns OBJECTID, NAME, LENGTH, SHAPE the following row exists: 1, Main St, 1.234, Shape If editor 'A' modifies the length field the delta tables will have a new entry: 1, Main St, 2.567, Shape If editor 'B' modifies it after editor 'A' but changes the length, the new delta table will look like this: 1, Main St, 2.567, Shape 1, Main St, 2.789, Shape This shows that if a unique index was built on the NAME column, the delta tables would error out frequently with every insert or update.

‎06-10-2016

Hi Thomas, You are correct the issue does still occur at 10.4.1. These publishing issues are being considered for a future patch in addition to future releases.

‎06-10-2016

Instead of starting a new thread, I would recommend contacting Esri Support so we can identify if this is a new defect or an existing one.

‎06-10-2016

Hi Mark, There are some defects regarding publishing in 10.4 that we have identified for some layer types. Are you able to open a Esri Support case so we can attach you to the defects as appropriate? BUG-000096292: When the database view is joined to a definition que.. Thanks, Christian

‎06-09-2016

The forward slash represents a path separator. There are many ways to write these paths including raw strings: r'path\folder', double-backslashes: 'path\\folder', or forward slashes 'path/folder' This is because a single backward slash can be interpreted as an escape character. Below is a helpful blog in understanding this Python issue. Gotcha — backslashes in Windows filenames | Python Conquers The Universe

‎06-09-2016

I haven't tested publishing to 10.3.1 Server, but I will look to test there.

‎06-09-2016

Looks like I missed a paren, it should be updated now.

‎06-09-2016

Does looping through the connection list work? workspaces = ["dbconn1.sde", "dbconn2.sde"] for sde in workspaces: arcpy.env.workspace = sde userList = arcpy.ListUsers(sde) for user in userList: print("Username: {0}, Connected at: {1}".format(user.Name, user.ConnectionTime))

‎06-07-2016

Hi Sonia, I can see this behavior in 10.3.1 as well, however, it looks like the behavior is fixed in 10.4. There are a lot of fixes made at this release (10.4) for querying the available objects and general performance. Are you able to test or work with 10.4?

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by ChristianWells

Re: Has anybody had latency issues with Spatial Views in Server?

Re: Has anybody had latency issues with Spatial Views in Server?

Re: Get the "real" geometry with ST_ASTEXT?

Re: Get the "real" geometry with ST_ASTEXT?

Re: Floating Licenses managed by Active Directory?

Re: Unable to publish map service with data in enterprise database using Server 10.4

Re: Unique indexes cannot be specified for multiversion tables

Re: Unable to publish map service with data in enterprise database using Server 10.4

Re: Unable to publish map service with data in enterprise database using Server 10.4

Re: Unable to publish map service with data in enterprise database using Server 10.4

Re: Using the ListUser function, cannot loop through Two or more Server Geodatabases

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

Re: Using the ListUser function, cannot loop through Two or more Server Geodatabases

Re: Using the ListUser function, cannot loop through Two or more Server Geodatabases

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

Re: Is it better to use Pandas/SQLAlchemy or Arcpy...

Receive ArcGIS patch notifications in the Esri Sup...

Re: Future Proofing Your GIS Career

Re: Looking for Guidance: Masters in GIS

The Art of Resumes: Apply These Best Practices

GIS Leadership User Group