Latest Contributions by CallumSmith

‎08-09-2016

In the end I couldn't get to the bottom of my issue so I had to uninstall and reinstall/configure the datastoret

‎07-21-2016

I have just come across this issue as well. Collector with Portal and ArcGIS Server 10.3.1. My schema is (all GlobalIDs/Guids) MudPits(fc) 1:M CleaningEvents(table) 1:M Attachments(table) Works fine in desktop but not in collector. Has anyone figured out a solution for this??

‎07-20-2016

The problem still persists in 10.4.1 but Fredric's workaround above works for me! Cheers

‎07-13-2016

Thanks Bruce yes I have opened a call and are working through it with ESRI. I do have a workaround in place like you suggest which dumps the attachments to the file system, processes them and then reattaches them. Works fine. Hopefully ESRI will identify the issue with the updateCursor which I think is a bug? Will post any updates on this issue I get from ESRI here.

‎07-07-2016

Hi Dianna I have tried both the 32 and 64 bit versions and they both give the same error. cheers Callum

‎07-07-2016

Hi We have the ArcGIS datastore 10.3.1 installed in our Portal/Server stack and it has been up and running without issue for the past 8 months. The datastore is installed on the same machine as ArcGIS for Server. Portal is installed on a different server However yesterday the service stopped and we cant get it to start again? If I look in the logs there isn’t much except “Failed to stop CouchDB. com.esri.arcgis.datastore.common.DataStoreException: Configuration store is not configured correctly, or a bad configuration is being used.. Could not find file nulletc\arcgis-data-store-config.json.” In the event viewer there is: The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: pg_ctl: could not send reload signal (PID: 4704): No such process Any Ideas anyone..??

‎07-06-2016

Yes it is a geodatabase feature class with attachments enabled. Basically I have a test script which cursors over the features in the feature class and then for each feature cursors over the related attachment records. Pretty standard stuff. It always crashes after 3-4 records. It is important to note that it only crashes when the feature class is registered as versioned and the images in the attachment table are large. I have also had a colleague of mine replicate the issue in a completely separate environment. We are using desktop 10.4.1 and ArcGIS for Server 10.3.1 Test Script: # Script to hightlioght insertCursor Issue on attachment table that is versioned in sde # # Callum Smith # 30/6/2016 import arcpy import os # Change dataPath to the location of the data ##dataPath = r'D:\CBS\cursorIssue\geodatabase.gdb' dataPath = r'D:\CBS\cursorIssue\DOWNERGIS@Dev@GISADMIN.sde' # Run for either Large Images or SmallImages fcName = 'FC_LargeImages' #fcName = 'FC_SmallImages' fc = os.path.join(dataPath, fcName) attachTable = os.path.join(dataPath, fcName + '__ATTACH') try: # Insert Cursor print 'Running the Cursor on the Featurclass...' fields = ['GLOBALID'] with arcpy.da.SearchCursor(fc, fields) as searchCursor: for row in searchCursor: globalID = row[fields.index('GLOBALID')] print 'Processing Feature: ' + str(globalID) edit = arcpy.da.Editor(dataPath) edit.startEditing(False, True) edit.startOperation() # Insert Cursor on attach Table. count = 1 whereClause = '"REL_GLOBALID" = ' + "'" + str(globalID) + "'" attachCusorFields = ['CONTENT_TYPE', 'DATA_SIZE', 'DATA', 'ATT_NAME'] with arcpy.da.UpdateCursor(attachTable, attachCusorFields, whereClause) as attachCursor: for attachRow in attachCursor: attName = attachRow[attachCusorFields.index('ATT_NAME')] print ' Attachment: {0} ---> {1}'.format(count, attName) attachCursor.updateRow(attachRow) count += 1 # Stop Editing. edit.stopOperation() edit.stopEditing(True) print 'Process Complete.' except Exception, err: print err This is the error I get. cheers Callum

‎07-05-2016

Hi Joshua, DBMS: SQL Server 2012 Yes only about 3 or 4 records process before it crashes. Even if I don't process the blob at all (i.e change nothing in the record) and perform the update it crashes? cheers Callum

‎07-04-2016

Hi has anybody had a issue when processing a updateCursor over a versioned table that contains a blob field? If the table is not versioned the cursor completes ok but if it is versioned python totally crashes after processing a few records. I have also tested the size of the blob and it seems the if the size is smaller (~<500kb) the cursor completes without issue (versioned or unversioned). I am writing a script to reduce the size of images in a attachment table as it causes issues with collector taking them offline and have come across this issue. I have a work around but was just wondering if anyone else has come across this issue with the (da) updateCursor?

‎03-23-2016

It is because the service used in the webmap is not secured so users can hit it anonymously. A good way to test this is if you can hit the rest end point of the service without providing any credentials it is available anonymously. If a service is secured then users will have to provide credentials to access it and therefore the version will be created with the users credentials.

‎11-26-2015

Thanks It worked for me as well!

‎10-14-2015

Thanks Dan Yes I do have an edit session open as the featureclass participates in a geometric network and is also versioned. Not sure why it is failing as the error message is not very helpful!! cheers Callum

‎10-14-2015

Yes I have tried running the script from a tool within arcmap and it still gives me the same issue. cheers Callum

‎10-14-2015

Thanks Neil I do have an edit session open as the featureclass is also in a versioned enterprise geodatabase. In my testing I have copied the data to a file gdb and it still does not work. If I remove the geometric network the it does work??? cheers Callum

‎10-13-2015

Hi I am got an issue where I am trying to insert features into a feature class that participates in a geometric network. Firstly I guess the question is "Is this even possible?" When I try to insert a record into the featureclass I am getting this error: SystemError('error return without exception set',) If I remove the geometric network or use the code on another feature class that does not participate in a geometric network it works fine. I cannot however remove the geometric network from the production database. If anybody has any ideas on this issue that would be appreciated. cheers Callum

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

My Ideas

Latest Contributions by CallumSmith

Re: ArcGIS DataStore 10.3.1 Service wont start

Re: Foreign key in related table not automatically populating in Collector (?)

Re: Problems with GLOBALIDs, GUIDs, and the Create Relationship Class GP Tool

Re: Issue with da updateCursor on a versioned table with blob field.

Re: Issue with da updateCursor on a versioned table with blob field.

ArcGIS DataStore 10.3.1 Service wont start

Re: Issue with da updateCursor on a versioned table with blob field.

Re: Issue with da updateCursor on a versioned table with blob field.

Issue with da updateCursor on a versioned table with blob field.

Re: Esri_Anonymous offline collector maps

Re: Password Change & Reset Password in 10.3.1- Not Working

Re: Error using insert cursor (da) with featureclass in a geometric network

Re: Error using insert cursor (da) with featureclass in a geometric network

Re: Error using insert cursor (da) with featureclass in a geometric network

Error using insert cursor (da) with featureclass in a geometric network

Re: Issue with da updateCursor on a versioned tabl...

Re: Esri_Anonymous offline collector maps

Re: Problems with GLOBALIDs, GUIDs, and the Create...