Latest Contributions by MarcoBoeringa

What version of ArcGIS / ArcSDE are you using? Support for SQL is a new thing in 10 and extended in 10.1. It may be that the stored procedure you are trying to use does not exist in your geodatabase until a future upgrade to 10.1. Please note that an upgrade of an existing geodatabase is a separate operation from upgrading your client PC's ArcGIS for Desktop application. You may be running ArcGIS 10.1 locally, but still be connecting to a 10.0 or 9.3.1 geodatabase not having this stored procedure. By the way, I would like to strongly discourage you to tamper with any of the stored procedures or geodatabase system tables using SQL. Unless you are a true expert geodatabase administrator, there is a high chance of wrecking your geodatabase. ... View more

"Hung" - not released even though no longer in use - licenses are an old problem with concurrent licenses and the license manager in ArcGIS, especially on 8.x and 9.x. You should be able to find information on this topic using the search functions. I guess the mystery switch to ArcView might have to do with that license being the only one available left with the others checked out / in use. See these links: http://forums.arcgis.com/threads/3974-Remove-hung-licenses-using-lmutil-lmremove-changed Using the options file http://help.arcgis.com/en/arcgisdesktop/10.0/install_guides/License_Manager_Guide/index.html#/Using_the_Options_File/00790000000z000000/ TIMEOUT and TIMEOUTALL http://help.arcgis.com/en/arcgisdesktop/10.0/install_guides/License_Manager_Guide/index.html#/TIMEOUT_and_TIMEOUTALL/00790000002w000000/ HowTo:  Release a hung license from a 9.x License Manager server http://support.esri.com/es/knowledgebase/techarticles/detail/26584 HowTo:  Automatically release a hung license http://support.esri.com/es/knowledgebase/techarticles/detail/29828 ... View more

One basic thing to remember is that a geodatabase resides in an RDBMS. It means any valid RDBMS security policies also holds for your geodatabase. That said, there are other tips and things documented in ESRI papers. Some links: Authentication in ArcGIS http://video.arcgis.com/watch/2197/authentication-in-arcgis Building an Enterprise GIS �?? Best Practices, Design Strategies and Performance Benchmarks http://blogs.esri.com/esri/arcgis/2011/08/26/building-an-enterprise-gis-best-practices-design-strategies-and-performance-benchmarks/ Designing an Enterprise GIS Security Strategy http://downloads2.esri.com/resources/enterprisegis/feduc2011security.pdf Enterprise GIS Security http://resources.arcgis.com/en/communities/enterprise-gis/01n200000004000000.htm ArcGIS 10.1 Enterprise Deployment http://support.esri.com/en/knowledgebase/whitepapers/view/productid/66/metaid/1896 http://downloads.esri.com/support/whitepapers/other_/1896J9736_ArcGIS_Enterprise_Deployment.pdf Marco ... View more

I was hoping that I would be able to prepare a mxd document in ArcMap and publish that as a ArcGIS mapservice. Using the ArcGIS Spatial Data Server will not allow that as it streams the data to the client which is then responsible for the drawing. Actually, if your only goal is a read-only map service, than theoretically, ArcGIS for Server should be able to do this. The process would require adding Query Layers to ArcMap (as you seem to have successfully done reading your first post in this thread), and than use this Map Document as the source for publishing to ArcGIS for Server as a Map Service. This should work for any database on your local LAN, and in this way uses the direct SQL access properties of ArcMap and ArcGIS for Server. However, reading your error / remark in the first post: When I then try to register the data source (Azure SQL) I get the message: '...The connection property set was missing a required property or the property value was unregnized... Could not open a connection to SQL Server...' I am starting to think there may be an undocumented limitation that this specific option of direct SQL access / Query Layer does not work for a Cloud based database like Azure in ArcGIS for Server. Maybe not an entire surprise, but not documented if so. ... View more

Ok, you might have convinced me.  I will look at reinstalling tomorrow. Forkandwait, although Vince's recommendation of reinstalling ArcGIS for Desktop entirely makes sense if you have been uncareful or highly confused while doing all this, I think you don't necessarily need to re-install if instead you have been careful in tracking and documenting which files you copied to ArcGIS's Bin folder. In that last case, simply removing any files you added to the Bin, and copying the right 32 bit files as a replacement, should solve the issues without a complete re-install. In essence, the files you need to remove and replace by their 32 bit counterparts, are the five files I referenced before, based on ESRI's Help documentation: libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll So ... where do I find the files I need again?  In the postgres installation, copy to bin64?  Or the .exe mentioned a couple of threads back? If there is a link to the download on the customer care site that would be great... NO, you SHOULDN'T be copying anything to a bin64 folder. What you need to do is to get the 32 bit versions of the five above mentioned files from the ESRI Customer Care portal (in the "pg_client_windows86" client library download as documented on this Help page), and copy these as a replacement in the ArcGIS for Desktop "Bin" folder, as described here. Also make sure to follow all other possibly necessary steps described there! The Customer Care portal is here: https://customers.esri.com If you are logged in (If not: login!), you should have access to downloads. You can find the necessary files under - "Software Downloads" - "DMBS Support Files" - Scroll down until you see "PostgreSQL Client Libraries (Windows)", should be 2.21 MB big file download, so small. - Click "Download" In the downloaded file should be the "pg_client_windows86" client set of libraries containing the necessary 32 bit version of the above mentioned five files. Copy these to the ArcGIS for Desktop "Bin" folder. Good luck! ... View more

Thanks for your help, Vince.  Replies below. Umm, I installed PG with 64 bit, which is specifiied as OK here: http://resources.arcgis.com/en/help/...00000075000000 What? If the install is from PG 64 bit, then why would I need to run the file command, etc? I don't really want to reinstall (yuck!)  I am going to find out our customer number and download the file you speak of.  Is it a self-installer (from the "exe")?  It should just clobber the old files, right? Forkandwait, I don't think you need to re-install yet, nor re-do your 64bit PostgreSQL, as you correctly remark a 64 bit PostgreSQL install is listed as "supported"... If I understand Vince well, he is actually trying to say to you that the thing you CAN'T do is, is to copy the 64 bit DLL's from your essentially 64 bit PostgreSQL install, to the ArcGIS for Desktop Bin folder. You need to copy 32 bit DLLs there, either from a 32 bit PostgreSQL install, or by downloading them from the ESRI Customer Care portal. I guess downloading them from the ESRI site, and replacing all the files you put in your ArcGIS Bin, is the easiest and safest thing. If it than still fails, maybe more drastic measures are in order... ... View more

I'm having trouble loading a somewhat large (700 MB uncompressed, 540 MB zipped) shapefile to AGOL. I'm working with an Organizational account, and am loading using the Add Item button under My Content. I understand this is the most reliable way to load large datasets. The shapefile has a lot of features, 231,698 polygons. I've tried twice to load it, and get this message: Unable to load http://usgs.maps.arcgis.com/sharing/content/users/ahrea/968e162241994b2ab8d3110aa3defc37/addItem status: 0 Any ideas?  Thanks much. I have never used ArcGIS Online, but this really sounds like something to take up directly with ESRI customer support, not on a users forum. You may well be hitting some limitation to your account. Lastly, it probably is recommendable to run "Check Geometry" before trying to upload anything that large online. You don't want to sit back and wait 4 hours for something to upload, only to discover it failed because of bad geometries. ... View more

I placed the following in both my blahblah/desktop10.1/bin64 and my stuff/bin directory, copying from my recent 9.1 Postgres installation: libeay32.dll  libintl-8.dll  libpq.dll  ssleay32.dll Still running the same Postgres installation as described from the version queries above. Don't know if this is the issue, but this Help page: Setting up a connection to PostgreSQL states you actually need 5 files for a 32-bit client like ArcGIS for Desktop. You seem to be missing the underlined file: "pg_client_windows86: Includes the client files required to make a connection from a 32-bit client on a Windows operating system to a PostgreSQL database. Files are libeay32.dll, libiconv-2.dll, libintl-8.dll, libpq.dll, and ssleay32.dll" The four file client setup is for 64-bit clients, I guess the Help means ArcGIS for Server / ArcSDE. By the way, it is slightly confusing on this Help page, but if I understand it well. the pg_client_windows86 does NOT refer to the Windows itself being 32- or 64-bit, but to the specific software you are running being either 32-bit (like ArcGIS for Desktop), or 64-bit (like ArcGIS for Server / ArcSDE). As the Help page also states: "Be sure to download the correct libraries for your ArcGIS client. For ArcGIS for Desktop and ArcGIS Engine, you need the 32-bit libraries. For ArcGIS for Server, you need the 64-bit client libraries." You probably already read this one, but this Help page may be of use to others too, as it lists some of the prerequisites for setting up Query Layers: Preparing to use query layers ... View more

This page of Refractions Research lists PostGIS 1.5.1: http://postgis.refractions.net/download/windows/pg84/ And this page PostGreSQL 9.0.5: http://www.postgresql.org/ftp/source/v9.0.5/ These pages you probably already know may be of use: PostgreSQL database requirements for ArcGIS 10.1 http://resources.arcgis.com/en/help/system-requirements/10.1/index.html#//015100000075000000 Which versions of PostgreSQL and spatial types are supported with ArcGIS 10.1 and ArcGIS 10.1 SP1? http://support.esri.com/en/knowledgebase/techarticles/detail/40553 ... View more

Dear Users, I'm suffering an annoying problem: I'm working with ArcGIS 10.1 and I'm connected to an SDE 10.1. When I try to copy a certain Feature Class to a local file GDB ESRI tells me, that it can't copy because there are shape integrity erros. I'm sure it is because of invalid geometries. Now the question is how to find out which Features exactly cause the Problem. I don't know how to get this Information. Maybe you have an idea... Thank you in advance Run the Check Geometry and Repair Geometry tools in ArcToolbox to find out... ... View more

Jamal, Is your F: drive a removable disk? Sometimes these things only work for fixed internal disks. And sometimes you aren't allowed to put a file in root either... I have seen many of these similar issues with multiple different programs. E.g. I recently discovered I wasn't able to use an external disk attached to a front USB port of my desktop as the backup drive for a Windows 7 system backup. When I attached it to a back USB port (directly connected to the mainboard), it worked like a charm... ... View more

I can't say if there are any "benefits" in terms of performance or so (but most likely minor, SDEBINARY was and is efficient too), but from a functionality point of view, ESRI always strived with ArcSDE and ArcGIS to make the user experience uniform and GIS functions almost completely independent of underlying database storage format and storage options. This means you should be able to do, from a functionality point of view, exactly the same things (e.g. create topologies) whatever database storage options you choose. There just seems to be a minor caveat to this when choosing OGCWKB as the geometry storage format, as this Help page states it only supports 2D geometries, which would definitely impact the user experience at some point, but this is a real exception: "Note that the OGC well-known binary representation supports only simple 2D geometries." ... View more

Alternatively, if you are using ArcGIS 10.1 and have a 10.1 geodatabase, you might consider querying the Versioned Views that form part of the geodatabase. It will allow you to see the edit state of a specific version you specify in SQL. ... View more