Latest Contributions by Kathleen_Crombez

No. I was not able to get this resolved. The primary key is a unique integer. It is also an identity field in SQL if that makes any difference. ... View more

I know this is an older post, but we just ran into a similar issue where we could not get the services to start and they would be stuck in a "stopping" status. Most of the articles I read all point to low memory or network changes being the cause of this. In our scenario we think it was related to new anti-virus software that was recently installed on the servers. While researching this I ran across this article about excluding ArcGIS Enterprise directories from the virus scans. FAQ: Which ArcGIS Enterprise directories should be excluded for security or antivirus software?  Different antivirus and security software on the market and in computing environments sometimes detect ArcGIS Enterprise directories or components as a threat to the systems and networks with which they interact. When detected, the software may attempt to fix the ArcGIS Enterprise threat as it would any other, resulting in a partial or total loss of functionality for ArcGIS Enterprise. To ensure the best functionality of ArcGIS Enterprise with the environment security, the following directories can be marked as excluded. Portal for ArcGIS <installation drive>:\arcgisportal <installation drive>:\Program Files\ArcGIS\Portal ArcGIS Server <installation drive>:\arcgisserver <installation drive>:\Program Files\ArcGIS\Server <installation drive>:\Python27 ArcGIS Data Store <installation drive>:\arcgisdatastore <installation drive>:\Program Files\ArcGIS\Datastore This solution seems to have worked for us. Hopefully this will help someone else in the future because we battled with this for over a month before we figured it out. ... View more

Andres, The links you provided are very helpful. I really need to read the whole Versioning for Dummies series. Generally we use 3 tier versioning with a QC version below default that all our other versions are built from. But the Parcel Fabric only allows for 2 tier versioning. (all versions off of default) My nightly script reconciles and posts all grandchildren to their parent (QC), then QC to default. Then it runs a second time, in the same order. (Not the reverse order like you suggested.) It seems this method should still get all edits pushed up and down. (we only have a few versions off of QC) Strangely, since some of our editors have been on vacation the last week, it has suddenly pushed all the edits to the base table and the adds and deletes tables are empty. So maybe our method is not 100% because it seems like it took a few days for all the edits to get moved over to the base. Thank you again for all your help! Kathleen ... View more

When a feature class has an established relationship class with a stand alone table, the editor must have the same edit permissions on the table as they do the feature class or they will not be able to edit the layer. Based on this reason alone, tables should be allowed to be placed in a feature dataset so they will have the same edit permissions as the feature classes that they participate in the relationship class with. ... View more

Thank you. Please keep us informed on your findings. ... View more

I disagree. The response from mabeykoon is completely relevant. It has been determined that editing (or even opening) a 10.3 mosaic with 10.5 desktop modifies the data storage in a way that is not backwards compatible. Mahinda is saying that this new keyword RASTERBLOB can be modified to BINARY (or BLOB) allowing the mosaic to once again be backwards compatible. If this is true... (which i have not tested because we have already updated all our desktops to 10.5.1), then this should be considered the solution to being able to open the 10.5 mosaics in an older version of desktop. I somehow missed this documentation when we ran into this issue. And I wish I would have had a chance to test it before we upgraded our desktops. But I believe this information would be extremely useful for others running into the same issue as the original post. ... View more

My apologies. The "..." was written so I did not have to post a 500 line post because every multipolygon that did not have and area of zero had hundreds of XY vertices. I was just short handing the response. Sorry. I should have made that clear in my post. also note that out data is in State Plane US Feet. ... View more

Just to be clear, I am not looking for a solution to the getArea() function. I decided to use SHAPE@AREA to get the area and test if it is zero. but I do not understand why there are these different geometry types within a single feature class. The original layer in SDE only contains <geoprocessing describe geometry object objects> but after running the union against the rebuild layers I end up with a combination of "geoprocessing describe geometry object objects" and "arcpy.arcobjects.mixins._passthrough objects" what are these arcpy.arcobjects.mixins._passthrough objects? ... View more

Not really sure what this is providing me. It looks like a single point tuple. It is close to the first point in the multipolygon, but not exactly. Here are the first two records when I use "Shape" These are the same two records as the ones shown in the post above. (1057423.7430463613, 1223122.6208914442) (1004102.0138055336, 1210731.6523156033) ... View more

with arcpy.da.SearchCursor(t, ["SHAPE@","SHAPE@WKT"]) as cursor:       for row in cursor:             print row[0], row[1] where the area is zero the SHAPE@WKT is None (however they look like slivers when I view them in ArcMap) otherwise my print statement looks something like this... <geoprocessing describe geometry object object at 0x02B31820> MULTIPOLYGON (((1057644.6332177445 1225359.5342195705, .... , 1055905.6406327449 1225768.6685719043))) <arcpy.arcobjects.mixins._passthrough object at 0x02B31810> MULTIPOLYGON (((1005439.4298855774 1219931.8436314017, ... , 1005750.351835914 1217696.1525647417))) NOTE: the ... in the examples above elimates numerous XY coordinates. All polygons are legitimate multipolygons with a minimum of 4 vertices. ... View more

Rebecca, We do have topology on the original layers in SDE. these areas are not being identified in the topology errors. we do have Boundary Must Be Covered By the line work layer. we also have Must Not Overlap and Must Not have Gaps. however, this is not what I meant by marking it as an exception. I meant that I was using a conditional statement (if row[0].getArea() == 0.0) to provide a different error message to prompt the person running the script to check a different location to find these sliver errors where the polygons do not match the line work because they cannot be copied to the final fallout location. But that conditional statement was throwing an error on the arcpy.arcobjects.mixins._passthrough objects. Thanks anyways. ... View more