Tag Info

New answers tagged

0

geoAlchemy is supposed to do the job using GeometryColumns. However, I was not able to make it work on Windows/Python 2.7/sqlalchemy 0.9.6 due to AttributeError: type object 'ColumnProperty' has no attribute 'ColumnComparator'


0

We ended up having our dba go in and delete these orphaned locks from the table_locks table through the SQL backend. No further issues so far.


1

The issue 'QODBC3: Unable to connect' may be due to the configuration on the SQL server. Have your IT Admin 'enable' the Protocols TCP/IP and NamedPipe services for the database instance you are trying to connect to. This is performed in the SQL Server Configuration manager > Network Configuration . Also ensure the IP addresses have TCP Port = 1433 and the ...


0

I'll start by saying this issue is a great candidate for a support call if that's available to you. However, you can get a better idea of what's happening on your own with the following: Orphaned locks can be caused by application crashes or critical errors during some geodatabase operations. There is also an ArcGIS server bug in 10.1 when applying ...


0

After some back and forth with FME and becoming more familiar with it’s Workbench I have come up with the following solution. I solved this problem by using only the inline query and the Batch Deploy… located under the File menu; running the Batch Deploy initializes a wizard where it runs the query(s) and writers to completion on each input DB one at ...


1

This seems to have been a issue with SQL Server for some time now. Not sure why they don't allow it. If you change your update statement to something like this, it should work. UPDATE [dbo].[MyFeatureClass_evw] SET [dbo].[MyFeatureClass_evw].[Status] = ( SELECT A.[Status_2] FROM [dbo].[MySDEDataTable] AS A WHERE ...


0

I have used the PostGIS code with success from Bryan Mcbride's Github Page. It also contains a MySQL version of the code and can also be used for other geometries like polygon and line.



Top 50 recent answers are included