Latest Contributions by KevinMorris

I have been experiencing subtle problems with Form Control items not scaling properly to allow the ability to select an feature in ArcMap and ArcGIS for Flex. The issue for ArcMap appears to be localized to my workstation, but the issue in ArcGIS for flex is observed on both of my external servers for which my co-workers have no problem. I feel that these issues may in fact be separate, but have not ruled out the possibility that a roaming profile may be introducing the behavior. The issues with ArcMap occur for everyone that uses (logs) into my computer. This would appear to be a driver issue so the drivers were updated for the video card and monitors (dual monitor setup). No luck. To check and see if the problem is in my roaming profile I logged into two separate servers and ran ArcMap and created an legend and checked the properties and no problems were observed. My thoughts. Its a local problem. To make sure the ArcMap template was not responsible, I deleted the NORMAL template. No success.   Issue 2? In remote logins to both of my servers from serveral different workstations, I get a truncated "view" of the controls in the ArcGIS viewer for FLex where the delete function is not accessable. My coworkers do not have this problem. While I understand ArcGIS for Flex is being deprecated, we still have a number of maps that we publish and still like the ease of using this direct and easy tool.   SETUP: Dell PRECISION T7500, 24Gig ram, Intel Xenon CPU X5550, 64X Win 7 Enterprise, video Quadro FX 580, Monitors(2) DELL 2009W on DVI. DRIVERS: NVIDIA 341.05,DELL 2009W video driver (stock driver also didn't work)   If anyone has some tips for me I'd be happy to hear from you. ... View more

In weed management and other management operations, technicians will often define weed polygons using a central point with radius or walk a linear transect and define the polygon as a buffer of the line segment. Having this ability to apply these functions directly in Collector as an ad-hoc method to create polygon features will simplify back-end processing, remove the need to multiple feature-classes and provide a smoother workflow in operations. ... View more

I've recently implemented a revised geodatabase in Native SQL Server that is drawn upon in ArcGIS through a Server Query Layer. It works well for showing near real time satellite data locations for individuals in the field, however, when I wanted to convert points feature to a line, the tool in ArcGIS failed.   Upon analysis, the problem was the name for the SHAPE field. In the SQL tables and Query Layer the Geometry field was called GeoPOINT and it needed to be called SHAPE. This seems obvious now, but when some tools work and some don't we don't always suspect the most likely candidate.   Solution: The easy solution was to rename GeoPOINT to SHAPE in the query layer as modifying the schema in SQL server is more difficult.   Other Interesting Facts Uncovered: (1) Exporting the data from the query layer to a shape field removes the time field from a date/time field. (2) Exporting the data from the query layer to a file geodatabase kept the GeoPOINT column  as the default SHAPE and still could not be used for the points-to-line tool.   Tool Development Tips: (when coding in python) (1) known-check for column name of the identification field (FID, OID, OBJECTID) for feature classes (2) new-check for the column name for the SHAPE. It may not be SHAPE! for feature classes ... View more

Setup Prior to Update: Windows Server 2008 R2. ArcServer 10.1 SP1. Active Domain Roles / Users. MSIexec (Windows Installer) V 5.0.7601.17514 Trying to update ArcGIS for Server 10.2 over ArcGIS for Server 10.1 SP1 failed with the error message 1315. A network error occurred. We can repair 10.1 but the services are corrupt and immediately show "Status: Stopping..." when viewed in ArcGIS Server Manager. When we try to uninstall ArcGIS for Server 10.1 SP1 using Add Remove Programs or the setup.exe command it proceeds but hangs with the error message and rolls back without uninstalling. We are currently looking into repairing the registry and potentially manually removing the software. We have not used the ArcGIS uninstaller as we are concerned that I will affect SDE that also resides on the same server under SQL Server 2008. Has anyone observed this behavior and does anyone have any suggestion? Fortunately, this upgrade was done on our test server so the issue is limited, but we are concerned about bricking our production server during the upgrade. Update 1 (11/27/2013 0950): Following up on Error 1316. We ran the Microsoft Tool - FixIT        http://support.microsoft.com/mats/Program_Install_and_Uninstall which is the successor tool to Windows Installer CleanUp Utility. Selecting ArcGIS for Server SP1 for uninstall in the tool proceeded smoothly and indicated a number of registry issues. Allowing the tool to continue removed ArcGIS for Server SP1 from the system leaving the configuration folders untouched. At this point we wished to return to our ArcGIS 10.1 SP1 configuration on our server, so we reinstalled ArcServer 10.1 SP1. Installation proceeded smoothly, but upon review of the services in ArcGIS Server Manager, the services were still not properly starting and showed the ominous "Status - Stopping" message. Attempting to restart Publishing Tools gave the following message "service failed to startSystem.PublishingTools.GPServer: INPSEKIGISTEST Service startup timeout." Given that the installation may need a reboot, the server was rebooted and the services again failed to start with identical behavior. When a user service is stopped and restarted a message indicating another administrative function is ongoing and the service cannot be started or the timeout message is shown. "" Cheers Kevin ... View more

ArcGIS 10.1 SP1. ArcSDE 10.1, SQL Server 2008 R2 I have been trying to use the Make Query Layer Tool to create a table view from SDE tables (_VM) in SQL Server 2008 R2 and save the table by a number of export methods with limited success. I have been unsuccessful in saving the information through either the tools, modelbuilder, python window or arcpy (external python). Only manual export is working. The tool "make query layer" ran from within ArcMap will create the proper table from the SDE/SQL Server 2008R2 query and tables, however, it is not possible to export this Table_View layer using export Table to Table  or CopyRows or Table to Geodatabase as shown in the help literature. The ONLY method to export the information has been in the Table of Contents (TOC), through export from the table. Delving a little deeper I tried to get a little infomration on this object and it appears to contain part of the SQL/SDE connection string as part of it's object as several tools have indicated a .name of "SEKI_HazardTrees.DBO.%HazTree" when the original given name is HazTree only (SEKI_HazardTrees is the name of the SQL/SDE database). I also receive this name when I run arcpy.describe on the object and return a path of the sde connection string. desc.name = SEKI_HazardTrees.DBO.%HazTree desc.dataType = TableView desc.nameString = HazTree desc.path = Z:\Projects\HazardTrees\inpsekigistest_HazardTrees.sde ( the path of the SQL database) The error received is very general and similar between failing tools:   Failed to convert SEKI_HazardTrees.DBO.%HazTree. ERROR 999999: Error executing function.   Failed to execute (CopyRows).       or   Cannot open HazTree (the Table View - in arcpy) I have tried to override the tool from including the SEKI_HazardTrees to it's name by setting up the scratch and normal workspaces to no avail. IF you have a working python .py example of this (not from the ESRI site that does not work) please post. I have tried all the versions posted by ESRI. Thanks Kevin I'm including my code here for what its worth, but since the stand-alone tools couldn't work I wouldn't expect the arcpy gp tools to work any better (although sometimes they do). python code #Import system modules import arcpy arcpy.env.overwriteOutput = True # Set data path also tried removing the r and change / to // workspace = r"Z:/Projects/HazardTrees/Results.gdb" intable = r"Z:/Projects/HazardTrees/Results.gdb/Veg_HazardTreeSurvey_tbl" inpsekigistest_HazardTrees_sde = r"Z:/Projects/HazardTrees/inpsekigistest_HazardTrees.sde" arcpy.env.workspace = workspace arcpy.env.scratch = workspace # Create the Query Layer and return the Table-View name for verification test = arcpy.MakeQueryLayer_management(inpsekigistest_HazardTrees_sde, "HazTree", "SELECT * from SEKI_HazardTrees.dbo.Veg_HazardTreeSurvey_tbl_VW", "OBJECTID", "", "", "").getOutput(0) # Get the properties of the Query Layer if possible objMQ = arcpy.Describe(test) print objMQ.name print objMQ.dataType print objMQ.nameString print objMQ.path print test # Get column count - note that if the MakequeryLayer function fails, then an empty table with only the schema will be produced. # However, we have tested this and copied the SQL query and parameters from ArcMap tools for which we were successful generating the Table View so this should be ok #print int(arcpy.GetCount_management(test).getOutput(0))   # doesn't work #print int(arcpy.GetCount_management("HazTree").getOutput(0)) # doesn't work #arcpy.CopyRows_management(test, r"Z:/Projects/HazardTrees/hz002.dbf")  # doesn't work Error 99999 #arcpy.CopyRows_management(test, "Z://Projects//HazardTrees//hz002.dbf")  # doesn't work Error 99999 ... View more

Hello GIS and GPS techies, I am involved with getting ArcGIS for Mobile working with our Enterprise SDE/ArcServer Services through our intranet (not public facing unless through VPN). I have been successful testing the arcmobile project in windows and copying it to a Juno Device where I performed several feature creation/edits. However, when I want to update changes to the server, the synchronize function (on the Juno) fails to connect to the Server. This appears to be a matter of permissions and I was hoping that someone out there has come across how to resolve this issue. My original assumption, was that if the Juno was connected to an NPS computer, the Active Directory user/password would be used. If this is not the case do I have to create a VPN on the JUNO? During the creation of the .amp project in Mobile Project Center I have tried both entering a user/password for ArcServer and use the option to use Windows Authentication. The demo service permissions were converted to public in ArcServer to see if this would "open" up the service to all permissions and viewers. NOTE: The local version of the project (.amp) does synchronize to the server when running on my workstation (Windows version of ArcGIS for Mobile). Workstation: Windows 7/ArcGIS for Mobile 10.1.1 Server: Windows Server 2008, SQL Server 2008 R2, SDE 10.1 (w/ 10.0 database), ArcServer 10.1 using the Web Adaptor and Windows Authentication for Role Policies.  Mobile applications running on Mobile Services. Handheld: Juno, ArcGIS for Mobile 10.1.1 ... View more

The box to "Show MapTips using the display expression" is greyed out for my query layer.  I would like to get it to work. The ArcGIS 10.1 query layer is pulling point geometries from SQL Server Express 2012. A spatial index is created on the SQL server side and ArcGIS appears to have created it's own spatial index. This was confirmed and even updated ('Update Extent') from the layer properties -> source tab. The ESRI resource page indicates that as long as a spatial index (ArcGIS side) is available it should work. Here are the best articles on the subject I could find: http://resources.arcgis.com/en/help/main/10.1/index.html#//00s50000000r000000 http://resources.arcgis.com/en/help/main/10.1/index.html#//003n0000001r000000 Thanks Kevin ... View more