|
POST
|
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
12-13-2016
08:34 AM
|
0
|
1
|
843
|
|
POST
|
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
12-07-2016
09:26 AM
|
0
|
0
|
1639
|
|
POST
|
Currently this functionality does not exist within arcpy, however, one workaround is to insert 1 record of the spatial type you want. From here, register the table where arcpy will discover the geometry type. Once this is complete you can delete the data from the table.
... View more
12-07-2016
08:24 AM
|
1
|
3
|
1639
|
|
POST
|
Here is a sample of what I was talking about above. Let me know if you have any questions on this. import arcpy, csv
#SDE Feature Class
fc = r"Database Connections\sdefile.sde\SDE.us_cities"
#Open CSV file
csvfile = open(r'c:\tmp\us_cities.csv', 'wb')
#Create CSV Writer
csvwriter = csv.writer(csvfile)
#Write header to CSV file
csvwriter.writerow(['FID', 'CITY_FIPS', 'CITY_NAME', 'STATE_NAME'])
#Loop through SDE FC and collect specific fields
for row in arcpy.da.SearchCursor(fc, ['OID@', 'CITY_FIPS', 'CITY_NAME', 'STATE_NAME']):
#Write rows to CSV based on SearchCursor results
csvwriter.writerow([row[0], row[1], row[2], row[3]])
... View more
12-05-2016
03:37 PM
|
2
|
0
|
1686
|
|
POST
|
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
12-05-2016
01:57 PM
|
1
|
1
|
1686
|
|
POST
|
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
12-02-2016
08:13 AM
|
3
|
1
|
881
|
|
POST
|
When ArcGIS scans a spatial view for Geometry type it looks at the record in the first row. If the type cannot be found because its null or missing the geometry, no Geometry type is chosen. If you know what Geometry type it should be, then you can set it for you session by opening the properties and selecting the type under the General tab. However, this will only last for the session.
... View more
12-01-2016
03:27 PM
|
1
|
0
|
1567
|
|
POST
|
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
11-30-2016
10:09 AM
|
1
|
1
|
900
|
|
POST
|
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
11-29-2016
02:02 PM
|
0
|
0
|
438
|
|
POST
|
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
11-29-2016
01:35 PM
|
1
|
0
|
548
|
|
POST
|
Hi Jordan, If you are using Chrome 54 it may be related to the following notice: Announcement: Errors Encountered in ArcGIS for Server and Portal for ArcGIS Web Apps after Certain Browser Updates | Sup… We are working on addressing patches for this issue and the above blog will be updated as they are released. Here is a link to the 10.4.1 patch for Server: Esri Support 10.4 (10.4.1)
... View more
11-23-2016
12:59 PM
|
1
|
2
|
1396
|
|
POST
|
Have you also tried the 10.5 Portal Prerelease patch? Portal for ArcGIS 10.5 Prerelease Create Portal Patch This sounds very similar to the issues encountered by the defect described in the patch.
... View more
11-22-2016
12:36 PM
|
1
|
4
|
1792
|
|
POST
|
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
10-28-2016
09:14 AM
|
0
|
0
|
1508
|
|
POST
|
It is possible to store both spatial and non-spatial data together. To insert empty geometries, just double-click the empty row at the bottom of the attribute table, which is supported in ArcMap and ArcGIS Pro. Please keep in mind, however, that personal geodatabases are not supported in ArcGIS Pro. Although, its possible to store both together, there are some issues that you may experience, such as errors in analysis stating the operation was performed on an empty geometry or in Python, the null geometry will be returned as a Nonetype. Simply put, all a non-spatial record represents to the geodatabase is a NULL record (except for in SDE). As long as you are aware that those records are there and the potential issues or errors you may encounter, it should not damage the geodatabase on the existence of null geometry records alone.
... View more
10-27-2016
02:27 PM
|
1
|
1
|
1174
|
| Title | Kudos | Posted |
|---|---|---|
| 3 | 10-09-2025 08:31 AM | |
| 12 | 09-27-2022 06:23 AM | |
| 3 | 03-28-2024 05:12 AM | |
| 3 | 12-20-2023 06:42 AM | |
| 6 | 08-31-2023 05:42 PM |
| Online Status |
Offline
|
| Date Last Visited |
Thursday
|