Latest Contributions by VinceAngelo

Cross-posted to GIS StackExchange ... View more

If your server environment does not have ArcGIS Desktop, you cannot create a valid file to import.  Not true:  You can use the Python within ArcGIS Server to create connection files, via arcpy.CreateDatabaseConnection_management() The lack of a trusted bridge, however, should prevent any access, so this is really a non sequitur.  The publishing process uses the hostname and connection properties from the local machine's connection to the server to identify the registered connection on the server.  No identical registered connection, no service. Therefore, you need a mechanism to publish from a trusted host (via RDP or SSH, or possibly both) - V ... View more

Even when I had the ability, I did not use sdetable to create views -- I used SQL scripts in the database exclusively. Where necessary, I would sdelayer -o register layers, but with Query Layers, I find it's not necessary. - V ... View more

A spatial view is a database object. It is not registered with the geodatabase in any way. Therefore, when you access it via a Query Layer, ArcGIS needs to ask  for the rowid column and geometry type (this lack of meta-information is the defining characteristic of a Query Layer). The ability to register views to a geodatabase was added at ArcGIS 10.5, so if you're running 10.4.1 or lower, Query Layers is your only mechanism to access views. - V ... View more

Note that this is a cross-post of three additional questions on GIS StackExchange, all of which were closed for lack of code. The best way to get help with code is to provide code. - V ... View more

Actually, I never install application software on C: -- Only Microsoft apps are allowed on my C: drive, which I limit to 100-200Gb.  My Esri installs are always in a D:\Esri folder (directories with spaces in them make me break out in hives).  That said, I only install application software and data on internal disks. External disks are for archiving and transfer, not for GIS data or software. ... View more

If you're just starting with Python, there's really no reason to use anything but the correct indentation scheme -- 4 spaces. Making your code legible is just as important as including the complete error messages, or adding diagnostic arcpy.AddMessage() lines just inside each for loop to trace execution flow. - V ... View more

Not only does it need to be the correct ArcGIS release, but it also needs to be for the correct operating system AND PostgreSQL release, AND in the correct location (which varies by build source) so make sure it's the right file in the right place. For good or for bad, the database is always right when it comes to library compatibility (the Direct Connect client just asks the PG instance if the library is present) - V ... View more

Did you upgrade the Image Server license? Are there any messages in the logs? - V ... View more

Is there a reason you linked to the documentation of a retired release of ArcGIS?  Current documentation also references arcpy.ArcSDESQLExecute, which remains the only within-ArcPy method to execute ad-hoc SQL. Note that this function could be used to corrupt geodatabase metadata (with an injudicious DROP TABLE, for example), so extreme care should be used.  That said, I just executed a cascade of 1200+ SQL statements against a PostgreSQL database (thanks to Python dictionaries, string substitution, and nested looping), so the only reason to fall back to ODBC is if your return results are not supported by the API (the most dangerous being long (64-bit) integers and geometry columns). - V ... View more

No, there is no way I can help you. Providing one function call is of little use, since it's unlikely the problem is with that one call -- it's just where some other error can manifest itself. You really ought to assemble a full code sample which reproduces the issue (StackExchange calls it an MCVE), and turn that over to Tech Support, along with complete details about the configuration of the VM and non-VM hosts. You can post the MCVE here, but given the reproducibility issues, there may be challenges ahead. - V ... View more

We'll need more information than a link to archaic documentation.  Of critical interest: The RDBMS and version of the source database The RDBMS and version of the target database The geodatabase version of the target database There are no tools to use pure Python to populate SDEBINARY geometry without ArcPy. Attempting to do so will cost far more than a seat of Desktop (and if the database is already SDEBINARY, then the software already exists). - V ... View more

Shapefile is an awful format for database-to-database conversion. Recommend file geodatabase instead, since FGDB won't lose date resolution, numeric nulls, wide tables, UTF-16 strings, wide strings, legible field names,.... ... View more