Latest Contributions by ChristianWells

Hi Eric, the important part of this error is the "Error parsing SQL statement". With that in mind: 1. Does this versioned feature class have issues drawing? 2. Does it only occur when you apply the select clause (i.e. WHERE (FILENUMBER = 'N2015F0001' and  CLIENTNAME = 'Peter's Expediting Ltd.'))? Do other selections work? 3. Can you apply the bind variables from SQL Server and run the query via SSMS? 4. It seems to be pointing out 2092 as a bad state_id value, can you run the diagnose version metadata and diagnose version tables tools to see if any errors are found? 5. Is this unique to this version of the data? Or do all versions fail on the same query? ... View more

Thanks, Ahmed. Unfortunately, your options for workarounds are limited to:  1. Insert 1 record in the table 2. Manually update entity via ArcCatalog and register 3. Create all feature classes from Arcpy, not SQL ... View more

Hi Scott, this should be relatively easy using arcpy.da.SearchCursor and csv.writer. If you create the cursor to search the rows, you can simply append them to a CSV. The nice thing about this is that you can open a writer object for CSV then iterate over the rows of the SDE table to read the row. SearchCursor—Data Access module | ArcGIS for Desktop  13.1. csv — CSV File Reading and Writing — Python 2.7.13 documentation  ... View more

Hi Tobias, that checkbox in the GDB properties simply comes down to a Boolean operator in the sde.server_config table. Although, someone may not have been connected as SDE during that time, unchecking that box/changing the record in the table does not disconnect any existing connections, only disallows new connections.  With that in mind, the only things that could trigger this is:  1. Someone with permissions to the server_config table modified it via SQL 2. Someone as SDE unchecked the box earlier in the day 3. A process or task called the AcceptConnections command: AcceptConnections—ArcPy Functions | ArcGIS for Desktop  One way you could hunt this issue down is to have your DBA look in the v$sql table in Oracle for an UPDATE command issued to the sde.server_config table. This table should give you the time, user, application and node that issued the command.  ... View more

If the table is blank in ArcCatalog, I would check for field name issues. Often times a space or special character can cause this issue.  Field Name Rules: FAQ: What characters should not be used in ArcGIS for field names and table names?  ... View more

Jerry, I believed this in answered in your other post: https://community.esri.com/thread/186625-when-is-arcgis-going-to-stop-supporting-ms-sql-server-2008r2  10.3.1 is the last release where it is supported. At 10.4, we no longer support this version of SQL Server ... View more

Starting at ArcGIS 10.4, we no longer certify SQL Server 2008 or 2008 R2 for use. Microsoft SQL Server database requirements for ArcGIS 10.4.x—System Requirements | ArcGIS for Desktop  ... View more

Great to hear, Damon! ... View more

Hi Jose,  NIM096849 isn't implemented in the software, it's just a request to include in a future release. If you contact support, we can add you to the enhancement, which adds more weight behind adding the functionality.  If you want to query the process_information table, you can follow my steps here. This table is owned by the GDB administrative user, so you may need fully qualify the table name. Keep in mind, I am showing Oracle for this one, but it will appear slightly different for SQL Server or PostgreSQL.  Description of the process_information table columns are here: System tables of a geodatabase stored in Oracle—Help | ArcGIS for Desktop  SDEMON: SQL: ... View more