Latest Contributions by RandyKreuziger

‎09-15-2014

We have a SQL / SDE 10.1 database containing about 200 feature classes. The metadata for most of these is still in the FGDC format but there are maybe 20 to 30 with metadata upgraded to the ArcGIS internal format and updated with new information. ArcCatalog detects when a feature class's metadata needs upgrading, but is there a way to do this in arcpy?

‎09-08-2014

Turns out this is a known bug, NIM-090100, however it was submitted 18 months ago and still no fix Bug Number NIM090100 Submitted Mar 26, 2013 2:45 PM Severity Medium Applies To ArcGIS Version Found 10.1 SP1 Prog Language N/A Server Platform All Windows Client Platform Windows Database SQL Server Locale N/A Status Open: Assigned Version Fixed N/A SP Fixed N/A

‎09-05-2014

No it's not versioned. I just saw the Truncate Tool under Data Management Tools | Tables but it's not under Features so I missed it. (But I am disappointed I have to modify all my scripts and models after ESRI changed the behavior of a tool.) Thank you.

‎09-05-2014

DeleteFeatures no longer deletes all records at one time which it's supose to do when the input is a feature class or table! We upgraded from ArcGIS 10.0 / SQL 2008 to ArcGIS 10.1 / SQL 2012 so I don't know which caused the change. In 10.0 this was carried out all at once in like a truncate on the database side, but after upgrading it's taking forever now. Through SQL Profiler I can see that the records are being deleted in batches of about 150 records at a time, so what use to take about 2 to 3 seconds now takes over 30 minutes for a feature class containing a 1,000,000 records. Is there any fix for this? BTW, this is similar to a bug introduced back in 9.3.1 https://community.esri.com/message/16613?sr=search&searchId=27c4082a-5048-443b-ab3e-d38219e3b633&searchIndex=4#16613 -- sample from SQL profiler -- declare @p1 int set @p1=8003 exec sp_prepexec @p1 output,NULL,N'DELETE FROM GEOLIB_STAGE.DBO.TRANS WHERE OBJECTID IN (8678,149031,781870,529051,850941,146097,548880,540263,435454,354365,529268,582084,247165,795180,559851,414179,446673,660244,490564,517760,142856,241123,695475,471813,307298,412080,719441,332785,592142,194167,188071,810130,824122,400725,570745,21179,375132,466956,743512,188859,661765,372015,794739,91259,138852,136984,883971,444122,485764,713000,134614,347483,503788,44012,840195,132928,875866,156734,523141,402599,752233,603552,330094,513428,53304,131004,803002,129594,498844,667558,90466,357945,633048,672060,479776,608211,820966,126915,265315,440638,677618,464150,236562,34384,749617,733983,658454,506931,764976,301637,532466,872429,19165,7489,252175,120581,409177,543996,163044,438198,534060,262530,872814,185194,325948,81350,576719,110589,181631,55689,398198,13743,348374,705618,417351,115767,853417,30666,733162,858712,256363,177822,683846,622061,827987,854389,200153,859952,871,296910,516844,385774,118935,665057,36949,631680,118086,428021,716597,783347,813725,878892,436661,336825,755693,225822,339504,355226,784398,584838)' select @p1

‎09-05-2014

In Python I'd like to redirect the location ArcGIS looks for SDE connection files when "Database Connections" is used. Is that possible? "Database Connections\\GeoStore.sde"

‎09-04-2014

The 10.1 upgrade process changes the default geometry type from SDEBinary to SQL Geometry. Since SDEBinary is going away the sooner we migrate away from SDEBinary the better I thought but that hasn't been the case. We have multiple workflows that are now broken. New fields are added to the output feature class when doing both an ArcMap Export and using the Feature Class to Feature Class tool. If the fc is a polygon, the area and length fields get duplicated with the addition of Shape_STArea__ and Shape_STLength__ in the output feature class. This happens both when going to a file geodatabase and an SDE geodatabase. This doesn't occurer when the the source feature class is SDEBinary. After contacting ESRI support I found out that this is expected behavior and not considered a bug. So, now I have to figure out programmatic work arounds and change interactive workflows. Is there a way to determine the storage type of an SDE feature class in python? If I know the storage type is Geometry I can add a delete fields line to my programs. We are running ArcSDE 10.1 with SQL Server 2012.

‎09-03-2014

I'm running into the same problem when going appending from Oracle to SQL Geometry. This is killing me! At 10.1 a bug deleting with spatial views and the SDEBinary storage type in SQL Server was introducted. The workaround to that bug is to convert the storage type of the base feature classes from SDEBinary to Geometry. OK spatial view issue fixed, except that results in the discovery of another bug dealing with the APPEND. Now that the storage type has been converted to SQL Geometry the Append no longer works when going from Oracle GDB to SQL Server GDB. A error is reported that the Schemas differ. I can turn off the Schema Type test which works but I shouldn't have to do that because I do want to be alerted if there are legitimate schema changes like missing fields. When I posted back in June I only knew that the problem occurs going between SDEBinary to Geometry within SQL Server. (With every release of the ESRI software comes news bugs. I've spent 3 weeks implementing workarounds to the scripts and workflows that were broken with the 10.1 upgrade since upgrading. And I'm not even finished. I wish I had stayed at 10.0 ArcSDE! rant over)

‎09-02-2014

ESRI is moving away from the SDE command line to create views to the new "Create New View" functionality in ArcGIS Desktop, but don't consider it a bug when the replacement function loses functionality? Not uncommon for ESRI since they did that when going from ArcInfo Workstation to ArcGIS Desktop taking around 10 years to regain automated map production. Losing the ability to attache metadata to database views is a serious loss. There is no way for the user to know what the base feature is or what definition queries are placed on the data. Layer files are pointers to data (and symbolozation) but once you've added the layer to your MXD metadata in the .lyr.xml file is no longer associated with the MXD entry!

‎09-02-2014

It could be a database permissions issue. Maybe the user has access to the feature class but not the table.

‎08-29-2014

Justin, Have you reported that as a bug? I'm running ArcGIS 10.1, SP1 and just ran into this problem when doing an export. These two extra fields that are created cause problems further down in our work flow! Shape_STArea__ Shape_STLength__ Shape_Length Shape_Area

‎08-29-2014

The technical article link is broken for me but I know what you're referring to. However, does the memory issue only apply to 3 tier connections only or does it include direct connects?

‎08-08-2014

Adam, Thanks, that worked.

‎08-07-2014

I called with one into ESRi after a coupe hours of stripping down the author's MXD until it just had one layer in it and a joined table all in ArcSDE. It turns out there is a known bug that was introduced in SP1 for 10.1 that broke labeling but inconsistantly. The fix is either to upgrade to 10.2 where it's fixed or uninstall SP1 on the desktop and since I couldn't upgrade I did the uninstall. Here's a link to the bug NIM087311 - Map labels do not work in a map service if the fea.. Bug NIM-087311 Nimbus ID NIM087311 Submitted Dec 12, 2012 10:27 AM Severity Critical Applies To ArcGIS Version Found 10.1 SP1 Prog Language N/A Server Platform All Windows Client Platform Windows Database All Locale N/A Status Resolved Version Fixed 10.2 SP Fixed Synopsis Map labels do not work in a map service if the feature class resides in an ArcSDE database and is joined to a table. Additional Status Information N/A Alternate Solution Publish a map service using ArcMap 10.1 with no service pack to ArcGIS Server 10.1 SP1.

‎08-06-2014

We have an MXD with several layers all of which display labels at one scale or another. It's been publishing to ArcGIS Server just fine but the user noticed that the wrong attribute was being labels. The user modified the MXD and asked me to publish it. I went through the same process that I've been doing for the past several months but today the labels aren't showing. I've verified that the labels display properly in the preview when creating the SD file but once published they don't show. I've also bypassed the service definition file process and published directly to the server but that didn't help. Any ideas? One of the layers should be displaying labels at all scale so that's not the issue. Myself and others have zoomed in and the labels never come on. The data is stored in MS SQL 2012 / ArcSDE 10.1 SP1. The labels are coming from an attribute in a joined table if that makes any difference.

Re: Named Users? · ‎08-05-2014

These are extra named users in addition to the named users that you get with the ArcGIS for Desktop entitlement (e.g., you get a named user for every license of ArcGIS for Desktop). Derek, It was said again and again at the UC but it isn't exactly true. If your organization has an ELA you get zero Name Users for your Desktop licenses. Zero. You only get the number of Named Users you negotiate for in the ELA which you also pay for in the ELA. Between concurrent licenses and standalones my agency has around 100 desktop licenses but we could only afford 50 named users in the ELA.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by RandyKreuziger

Finding FGDC metadata that needs to be upgraded to ArcGIS format

Re: Export Data Creating Extra Fields When SQL Geometry Storage Type Used

Re: DeleteFeatures Behavior Changed in ArcSDE 10.1 / SQL Server 2012

DeleteFeatures Behavior Changed in ArcSDE 10.1 / SQL Server 2012

Can the "Database Connections" default location be redirected to a network drive?

Export Data Creating Extra Fields When SQL Geometry Storage Type Used

Re: Appends When Geometry Storage Type Differs?

Re: Database Views and Metadata

Re: ArcGIS Online with SDE Views

Re: SHAPE.STArea()field in SQL 2008

Re: Database connections exceeded or unable to connect

Re: Labels not showing up in published map service

Re: Labels not showing up in published map service

Labels not showing up in published map service

Re: Named Users?

Copy_management brings along Relationship Classes ...

Re: Publish raster dataset as image service with a...

Data Deduplication on the File System

Labels not showing up in published map service

Re: Connecting to OneDrive in ArcGIS Pro