Latest Contributions by MikeChancey

‎01-17-2018

Excellent! This looks like what I need to get started.

‎01-16-2018

I am wondering if this is a valid work flow at all. What I am really looking for is an If Then functionality, if there are rows to process then process them. If not stop. Am I simply trying to use the wrong tools to do that?

‎01-16-2018

I am running Desktop 10.2.2. I have been using model builder for years, creating models and exporting them to Python to automate tasks. Recently, after a number of process failures due to broken connections, I have been trying to upgrade them to validate connections and results before continuing to the next steps. What I wanted to do was simply check that a feature class was not empty before attempting to process it. For test purposes I made a very simple model to check the row count on a polygon feature class and if it were greater than 0 copy it to a new feature class. If the count was 0 it should stop. Really simple. As a model it worked perfectly, so I exported it to Python. That produced this: # -*- coding: utf-8 -*- # --------------------------------------------------------------------------- # TestModel.py # Created on: 2018-01-16 11:41:45.00000 # (generated by ArcGIS/ModelBuilder) # Description: # --------------------------------------------------------------------------- # Import arcpy module import arcpy # Load required toolboxes arcpy.ImportToolbox("Model Functions") # Local variables: TestData = "C:\\Testing\\TestGeodatabase.gdb\\TestData" TestPolys = "C:\\Testing\\TestGeodatabase.gdb\\TestData\\TestPolys" # Process: Get Count arcpy.GetCount_management(TestPolys) # Process: Calculate Value arcpy.CalculateValue_management("%Row Count% > 0", "", "Boolean") # Process: Stop arcpy.Stop_mb("true", "FALSE") # Process: Feature Class to Feature Class arcpy.FeatureClassToFeatureClass_conversion(TestPolys, TestData, "TestPolys2", "", "SHAPE_Length \"SHAPE_Length\" false true true 8 Double 0 0 ,First,#,C:\\Testing\\TestGeodatabase.gdb\\TestData\\TestPolys,SHAPE_Length,-1,-1;SHAPE_Area \"SHAPE_Area\" false true true 8 Double 0 0 ,First,#,C:\\Testing\\TestGeodatabase.gdb\\TestData\\TestPolys,SHAPE_Area,-1,-1", "") Of course, that failed due to the IOError "The toolbox file Model Functions was not found", so I deleted the portion # Load required toolboxes arcpy.ImportToolbox("Model Functions") Now it generates this error: Traceback (most recent call last): File "C:\GeoProcessing\SWProcessingPythonSQL2\Scripts\TestModel.py", line 20, in <module> arcpy.CalculateValue_management("%Row Count% > 0", "", "Boolean") File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\management.py", line 3808, in CalculateValue raise e ExecuteError: ERROR 000539: SyntaxError: invalid syntax (<expression>, line 1) Failed to execute (CalculateValue). Why, why, why can't Model Builder export Python code that actually works? What is the point of a WYSIWYG GUI that doesn't produce functional code? So, something is wrong with the expression. What exactly would that be since it works in Model Builder? This should be easy. All I want to do is validate that there is data to process before processing it.

‎09-20-2017

Just and added note. I did notice the error message was now quite the same in the original 10.2.2 message. That said: Synchronize Replica Failed Table not registered [wsdpub.DBO.GDB_TEMP_USER_IDS] Table attachments not supported in this release of the Geodatabase. No update session in progress. On both the 10.2.2 and the 10.3.1 machines I did check the ReplicaLog.data files. When using the XML view they are empty, no errors, no warnings, and nothing under Operation Name, Time Completed, or Operation Info.

‎09-20-2017

I have run into an issue with synchronization from a parent to child (one way) replica failing. We use a production SQL server with multiple databases for editors, then replicate to a separate publication SQL server with a single database for end users. Now for some reason the edits from one production database will not replicate to the publication database. The production database was setup in 10.3.1. The publication database was setup in 10.2.2. The error message is: Synchronize Replica failed Table not registered [wsdpub.DBO.GDB_TEMP_USER_IDS] No update session in progress. For test purposes I backed up the publication (child) database, then restored it on a test server and ran it again. The error was the same. I thought this might be related to NIM094669 so I then upgraded the ArcMap install from 10.2.2 to 10.3.1 and ran it again. No change. I then upgraded the child database to 10.3.1 and ran it again. Still no change. I had this same problem several months ago, but at that time resolved it by building a completely new publication server install and re-replicating everything. A drastic solution, but there were other outstanding issues and it resolved everything. Now the replication problem is back. Last time both the water and wastewater replicas were affected, so far this time only the wastewater set is having an issue, but if it follows the same pattern as last time the water replica will start failing in a day or two. Oddly enough, the stormwater replica was never affected. Both the water and wastewater datasets contain networks, the stormwater set only has topology rules. I am not sure if this has anything to do with this issue. Has anyone seen anything like this? If so, did you find a resolution?

‎05-01-2017

I am trying to setup a "highly available" ArcGIS database in Microsoft SQL. I created an 10.3.1 enterprise database on the principal server, populated it with data, and then followed the standard SQL procedures to setup the mirror and witness copies on two other servers. MSSQL is reporting everything working correctly. I then setup this connection in ArcCatalog: For testing purposes, w63-hydra-m is my principal server and w63-hydra is the mirror server. The mirrored database is DevTest. With this connection as long as the principal server is up, everything works perfectly. If the SQL service on principal server is stopped, the connection fails. If the SQL service on the principal is then restarted, the connect still doesn't work. The only method I have found to get the connection working again is to stop and restart the service on the mirror so the orignal server is again shown as the principal, then close and reopen ArcCatalog. This is not exactly a highly available connection. Obviously I must have done something wrong here. So what is it?

‎03-14-2017

Sometimes it is the simplest things. Proxy settings! All I had to do was login as the Windows user account ArcServer was using, open Internet Explorer, go to internet options, connections, and update the LAN settings to match our network. Boom, everything worked.

‎03-02-2017

I am running a internal intranet only single machine install of ArcGIS Server 10.3.1. I have both a production install and a separate development install on another virtual machine. Recently we switched the access control from IP filters in IIS to Windows Authentication. I have a geoprocessing service Export Map Task to allow end users to create PDF maps from the web applications running in Flex. I followed the instructions at Printing maps that contain secured services—Documentation (10.3 and 10.3.1) | ArcGIS for Server to setup a secure connection to allow access to the web services. On the development system everything works correctly. On the production system the Export Map Task fails with the message "esriJobFailed". The server log shows: "Error executing tool. Export Web Map Job ID: j409e1f0490c94335b4c9d07bc645595a : Layer "Customer Service": Unable to connect to map server at http://<server name>/ArcGIS/rest/services/CustSvsDynBase/MapServer. Layer "Overlay": Unable to connect to map server at http://<server name>/ArcGIS/rest/services/CustSvsOverlay/MapServer. Failed to execute (ExportWebMap). Failed to execute (Export Web Map)." When I turn off all the map layers hosted on the production machine and only turn on layers coming from an open image server, the geoprocess works perfectly. What is truly bizarre is if I host the geoprocessing service on the development machine and point it to the services on the production machine it works perfectly. Both systems are using the same user accounts and passwords, and every setting anyone can think of is set identically. The only difference I know of is the two virtual machines are hosted on different host machines. I have been wrestling with this for about two weeks now and simply cannot find a resolution. I realize the Flex application is no longer supported, but this is actually not an issue with Flex, it is with the geoprocessing service. Does anyone have any suggestions?

‎12-13-2014

Has anyone resolved this? I created models to sync a number of replicas. I then exported them to Python and added them to a scheduled task run daily. They worked for a few days, then stopped. Now all I get is the 000655 error in the models. This workflow is basically essential, how do I get it to work?

‎08-02-2011

I have been exporting models to Python and then triggering them in simple batchfiles for quite some time. The only model I have exported to Python that had this issue was this one with replication. None of the others created # Set the necessary product code import arceditor I got mine working by remarking out the import arceditor line. Something has to be wrong in the export to Python portion of model builder for it to create this bogus line.

‎04-07-2011

I am trying to create a batch file to update a local file geodatabase one-way replica from an SDE server. I created a very simple model to uncompress the file geodatabase and then sychronize changes from the SDE database to the file geodatabase. The model seemed to run fine. I then exported the model to python, and added it to the batch file. When I attempt to run it, it errors out and logs the following: _____________________________________________________ Traceback (most recent call last): File "C:\GeoProcessing\UpdateArcReaderData\Scripts\Step04UpdateswBillingReplica.py", line 9, in <module> import arceditor File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arceditor.py", line 18, in <module> gp.setProduct("ArcEditor") RuntimeError: ERROR 999999: Error executing function. _____________________________________________________ The Python script generated by the model builder export looks like this: # --------------------------------------------------------------------------- # Step04UpdateswBillingReplica.py # Created on: 2011-04-07 10:57:06.00000 # (generated by ArcGIS/ModelBuilder) # Description: # --------------------------------------------------------------------------- # Set the necessary product code import arceditor # Import arcpy module import arcpy # Local variables: swRegStorm_as_MChancey___sdeprod1_sde = "Database Connections\\swRegStorm as MChancey @ sdeprod1.sde" KCMO_swBilling_gdb = "C:\\ArcReaderData\\KCMO_SDE\\KCMO_swBilling.gdb" Uncompressed_data = "C:\\ArcReaderData\\KCMO_SDE\\KCMO_swBilling.gdb" # Process: Uncompress File Geodatabase Data arcpy.UncompressFileGeodatabaseData_management(KCMO_swBilling_gdb, "") # Process: Synchronize Changes arcpy.SynchronizeChanges_management(swRegStorm_as_MChancey___sdeprod1_sde, "MCHANCEY.ToAR_swBilling", Uncompressed_data, "FROM_GEODATABASE1_TO_2", "IN_FAVOR_OF_GDB1", "BY_OBJECT", "DO_NOT_RECONCILE") ______________________________________________________________ Can anyone tell me why this isn't working? I haven't modified the Python code at all, it is just as created by ArcGIS. This is running on a PC with Windows 7 as the OS and with ArcGIS 10 with the current service pack.

‎06-23-2010

Found my own answer on this one, read the system requirements first. I had inadvertantly selected a PC that did not meet the minimums. The specs require a dual core or better, mine was just a regular P4. I uninstalled and moved it to an actual dual core unit and the large intersect worked quickly with no issues.

‎06-21-2010

I have been testing 10 pre-release with some of our standard processes. The only issue I have encountered has been with the interesect tool. I am trying to intersect two polygon features, one representing parcels (193,569 records) and one representing impervious surfaces, (681,255 records). This is a process that has run successfully in previous versions of ArcGIS. I have tried using input files stored in file geodatabases, shapefiles, and even coverages. I have run repair geometry on the input features. No matter what I try the query errors out. Reading Features... Processing Tiles... ERROR 999999: Error executing function. Invalid Topology [Topoengine error.] Failed to execute (Intersect). Failed at Mon Jun 21 10:25:46 2010 (Elapsed Time: 14 minutes 55 seconds) From another run the error log shows: - <ResultViews> - <ResultView Tool="Intersect"> <CommandLine>Intersect_analysis 'C:\GeoProcessing\SWProcessing\SWGISData.gdb\swBilling\swImperviousSurfaces #;C:\GeoProcessing\SWProcessing\SWProcessFile.gdb\KCMO\swParcels_Process #' C:\GeoProcessing\SWProcessing\SWProcessFile.gdb\KCMO\swImperviousSurfaces_Split1 ALL # INPUT</CommandLine> <ToolSource>C:\Program Files\ArcGIS\Desktop10.0\ArcToolbox\Toolboxes\Analysis Tools.tbx\Overlay\Intersect</ToolSource> <StartTime>06/21/10 11:10:14 AM</StartTime> - <Parameters> - <Inputs> <Parameter Label="Input Features" Type="Dataset">C:\GeoProcessing\SWProcessing\SWGISData.gdb\swBilling\swImperviousSurfaces #;C:\GeoProcessing\SWProcessing\SWProcessFile.gdb\KCMO\swParcels_Process #</Parameter> <Parameter Label="JoinAttributes" Type="Scalar">ALL</Parameter> <Parameter Label="Output Type" Type="Scalar">INPUT</Parameter> </Inputs> - <Outputs> <Parameter Label="Output Feature Class" Type="Dataset">C:\GeoProcessing\SWProcessing\SWProcessFile.gdb\KCMO\swImperviousSurfaces_Split1</Parameter> </Outputs> </Parameters> - <Environments> <Environment Label="Precision For New Coverages">SINGLE</Environment> <Environment Label="Auto Commit">1000</Environment> <Environment Label="Minimize memory use during analysis on terrains">false</Environment> <Environment Label="Compression">LZ77</Environment> <Environment Label="Coincident Points">MEAN</Environment> <Environment Label="Random number generator">0 ACM599</Environment> <Environment Label="Raster Statistics">STATISTICS 1 1</Environment> <Environment Label="Level Of Comparison Between Projection Files">NONE</Environment> <Environment Label="Output has Z Values">Same As Input</Environment> <Environment Label="Maintain fully qualified field names">true</Environment> <Environment Label="Tile Size">128 128</Environment> <Environment Label="Pyramid">PYRAMIDS -1 NEAREST DEFAULT 75</Environment> <Environment Label="Default TIN storage version">CURRENT</Environment> <Environment Label="Output Spatial Grid 1">0</Environment> <Environment Label="Cell Size">MAXOF</Environment> <Environment Label="Output has M Values">Same As Input</Environment> <Environment Label="Output Spatial Grid 2">0</Environment> <Environment Label="Output Spatial Grid 3">0</Environment> <Environment Label="Maintain Spatial Index">false</Environment> <Environment Label="Precision For Derived Coverages">HIGHEST</Environment> </Environments> - <Errors> <Error>ERROR 999999: Error executing function.</Error> <Error>Failed to execute (Intersect).</Error> </Errors> <EndTime>26 minutes 41 seconds)</EndTime> </ResultView> </ResultViews> This process is mission essential, and has to work as a Python script. So far I can't get it to work in the model builder window or even just straight from the toobox. The error log mentions Output has Z Values and Output has M Values. I am fairly sure neither input feature as either Z or M. FWIW, the PC I am testing on sucessfully ran this process in 9.1, 9.2, 9.3, and 9.31. We did do a fully reformat before installing 10 so there are no leftover bits of previous versions of ArcGIS. Any ideas?

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

My Ideas

Latest Contributions by MikeChancey

Re: ERROR 000539: SyntaxError: invalid syntax

Re: ERROR 000539: SyntaxError: invalid syntax

ERROR 000539: SyntaxError: invalid syntax

Re: Synchronize Replica failed, table not registered.

Synchronize Replica failed, table not registered.

How Do I Use SQL Mirroring in ArcGIS?

Re: Geoprocess Unable To Connect To Service Running on Same Machine?

Geoprocess Unable To Connect To Service Running on Same Machine?

Re: error 000655 when using Python for replica synchronization

Re: Python Error import arceditor

Python Error import arceditor

Re: ArcGIS 10 Pre-release Intersect Failure on Large Dataset

ArcGIS 10 Pre-release Intersect Failure on Large Dataset

Python Error import arceditor

How Do I Use SQL Mirroring in ArcGIS?