Latest Contributions by jaykapalczynski

This is what is created via the script until the error (See attachment)...It creates the FC and Attachment table.  The FC Table has all the records (I remove all but one), while the attachment table has nothing but the fields.  NO data was written to the Attachment table. There is NO 'rowid' field...nothing looks out of the ordinary....very confused here....still getting the error in my previous post. Any help would be greatly appreciated... ... View more

Does this error point to line 556? ugggg Creating Feature Classes & Tables -Created BR_Boat_Ramp_Inspection_2 -Creating Relationships -Adding records -Finding Attachments -Boat_Ramp_Inspection_2 > BR_Boat_Ramp_Inspection_2 -Field Map -Boat_Ramp_Inspection_2 -Adding attachments ====================== FAIL: Updating Tables exception: A column was specified that does not exist. ['A column was specified that does not exist.'] <type 'exceptions.RuntimeError'> 556 ---------------------- arcpy messages: ====================== Failed script SyncData... ... View more

Only differences I can see.  No rowID in the Feature Class SDE FC                                   AGO OBJECTID                              objectid SYS_TRANSFER_DATE ... View more

In the attachment table I have this ATTACHMENTID, REL_GLOBALID, CONTENT_TYPE, ATT_NAME, DATA_SIZE, DATA, GLOBALID ... View more

I dont see a rowid anywhere ... View more

It appears the attachment table is fine...there are no _1 field names. The Feature Class on the other hand has 3 fields that have a _1 after them and this is not in the FC in ArcGIS online Region_1, County_1 and Ramp_1... ... View more

SQL Server 2012 R2....I am at a loss here....what do I have to modify? ... View more

Update: I figured out that I had the featureService parameter wrong.  I had to REMOVE the 0 index value at the end of the below string as the script puts it there. featureService - http://services2.arcgis.com/qsZIVOgnyrsajEtb/arcgis/rest/services/service_mbb5bb/FeatureServer/0 featureService - http://services2.arcgis.com/qsZIVOgnyrsajEtb/arcgis/rest/services/service_mbb5bb/FeatureServer/   But now I have another error....The script runs for some time and actually creates the Feature Class, Relationship Class, and Attachment Table in my EGDB.  BUT it appears to blow when it tries to sync the Attachments...The Records are created in the Feature Class but no images came across   ANY IDEAS???? ERROR: FAIL: Updating Tables exception: A column was specified that does not exist. ['A column was specified that does not exist.'] <type 'exceptions.RuntimeError'> 556 NameError: global name 'fc' is not defined Executing: SyncData C:\Users\adminjk\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\DGIF_TEST@Rack30_Admin.sde BR https://services2.arcgis.com/qsZIVOgnyrsajEtb/arcgis/rest/services/service_vvvb5bb/FeatureServer/ US/Eastern https://www.arcgis.com  xxxx  xxxx Start Time: Tue Nov 08 16:04:57 2016 Running script SyncData... -Getting Replica {"replicaName":"","replicaID":"","submissionTime":1478639100707,"lastUpdatedTime":1478639101433,"status":"ExportingData","resultUrl":""} -Check 1: ExportingData {"replicaName":"","replicaID":"","submissionTime":1478639100707,"lastUpdatedTime":1478639109607,"status":"ExportAttachments","resultUrl":""} -Check 2: ExportAttachments {"replicaName":"","replicaID":"","submissionTime":1478639100707,"lastUpdatedTime":1478639119697,"status":"Completed","resultUrl":"https://services2.arcgis.com/qsZIVOgnyrsajEtb/ArcGIS/rest/services/service_bcea0ae7dbd646a9b9e7cec73eabb5bb/FeatureServer/replicafiles/aa1df64045374ea6ae82044cbdf01d08.geodatabase"} -Check 3: Completed -Filtering records to new set -CreationDate > date '2016-11-08 21:04:58' featureclass -Adding Syncronization Time -Creating Tables -Creating Domains - -Creating Feature Classes & Tables -Created BR_Boat_Ramp_Inspection_2 -Creating Relationships -Adding records -Finding Attachments -Boat_Ramp_Inspection_2 > BR_Boat_Ramp_Inspection_2 -Field Map -Boat_Ramp_Inspection_2 -Adding attachments ====================== FAIL: Updating Tables exception: A column was specified that does not exist. ['A column was specified that does not exist.'] <type 'exceptions.RuntimeError'> 556 ---------------------- arcpy messages: ====================== Failed script SyncData... Traceback (most recent call last): File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 588, in <module> main() File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 582, in main process(sde_conn, prefix, featureService, timezone, portal, username, password) File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 563, in process cleanup(cleanupOperations, sdeConnection, prefix, now) File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 477, in cleanup arcpy.Delete_management(fc) NameError: global name 'fc' is not defined Failed to execute (SyncData). Failed at Tue Nov 08 16:07:00 2016 (Elapsed Time: 2 minutes 2 seconds) ... View more

Thoughts on this error? THIS IS CHECKED in ArcGIS Online (the feature class created by Survey123) Sync X  Enable Sync (disconnected editing with synchronization). Do I have to add my server as a trusted server in ArcGIS Online? I am blowing up right here but dont know why.  Are there settings on my server that I need to set for Sync Capabilities?  Or is this error coming from a setting in AGO? if serviceInfo["syncCapabilities"]["supportsAttachmentsSyncDirection"] == True: replicaParameters["attachmentsSyncDirection"] = "bidirectional" Start Time: Tue Nov 08 13:31:56 2016 Running script SyncData... -Getting Replica ====================== FAIL: Downloading Survey exception: 'syncCapabilities' ['syncCapabilities'] <type 'exceptions.KeyError'> 540 ---------------------- arcpy messages: ====================== Failed script SyncData... Traceback (most recent call last): File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 578, in <module> main() File "C:\Users\adminjk\Desktop\PythonSync\SyncBoatRamps.py", line 573, in main arcpy.SetParameterAsText(7, sde_conn) File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\__init__.py", line 670, in SetParameterAsText return gp.setParameterAsText(index, text) File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\geoprocessing\_base.py", line 231, in setParameterAsText self._gp.SetParameterAsText(*gp_fixargs(args, True))) RuntimeError: Object: Error in setting parameter as text Failed to execute (SyncData). Failed at Tue Nov 08 13:31:58 2016 (Elapsed Time: 2.34 seconds) ... View more

Tweaking some parameters and getting this error.... EDIT....changed the SDE_Conn to full path and it got further through he script but getting another error....seems to be with the Sync.  I have the Feature Class in AGO set for sync....dont know where else I might have to set this. ... View more

I created a toolbox and added the script to a new Toolbox tool.   In that new tool I then defined the 7 parameters at the end of the python script (seen below) I am not sure what syntax the user needs to put in for the first 5....Can you please help with a couple examples. sde_conn = arcpy.GetParameterAsText(0) prefix = arcpy.GetParameterAsText(1) featureService = arcpy.GetParameterAsText(2) timezone = arcpy.GetParameterAsText(3) portal = arcpy.GetParameterAsText(4) username = arcpy.GetParameterAsText(5) password = arcpy.GetParameterAsText(6) process(sde_conn, prefix, featureService, timezone, portal, username, password) arcpy.SetParameterAsText(7, sde_conn) ... View more

OK that makes sense now...I will try and setup as a GP Tool for now and see if I can get it to work...thanks for your patience. ... View more

Hey James thanks....I think this is where I am getting confused...All I have it the downloaded python script.  I am confused where to set the input parameters etc.  Do I need to run this from a specific location/on a specific server? The only thing I modified at this point was the TOKEN info in the script def getToken(vxxxx, password='Dxxxxxx1n', portal_URL = 'https://www.arcgis.com'): '''Gets a token from ArcGIS Online/Portal with the given username/password''' arcpy.AddMessage('\t-Getting Token') if password == None: password = getpass.getpass() ... View more

I upgraded to 10.4. Getting this error... What are the key areas of the Python Script that I have to modify...still confused on that... >>> ================================ RESTART ================================ >>> Traceback (most recent call last): File "C:\Users\tjv36463\Desktop\PythonSync\SyncBoatRamps.py", line 578, in <module> main() File "C:\Users\tjv36463\Desktop\PythonSync\SyncBoatRamps.py", line 572, in main process(sde_conn, prefix, featureService, timezone, portal, username, password) File "C:\Users\tjv36463\Desktop\PythonSync\SyncBoatRamps.py", line 514, in process now = getUTCTimestamp(timezone) File "C:\Users\tjv36463\Desktop\PythonSync\SyncBoatRamps.py", line 47, in getUTCTimestamp timeZone = pytz.timezone(timezone) File "C:\Python27\ArcGISx6410.4\lib\site-packages\pytz\__init__.py", line 180, in timezone raise UnknownTimeZoneError(zone) UnknownTimeZoneError: '' ... View more

10.3...I guess I could upgrade  EDIT:  I will upgrade and try again ... View more