BUG-000085841 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000085841
Submitted	March 4, 2015
Last Modified	March 21, 2024
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.2.2
Operating System	Windows OS
Operating System Version	10.0 64 Bit
Status	Will Not Be Addressed

Additional Information

ArcGIS Desktop (including ArcGIS Engine and ArcObjects) is in mature support and will be retired March 1, 2026. Mature support means the end of functionality-based patches and hotfixes; therefore, this issue will not be addressed. There are no plans for future releases of ArcGIS Desktop, and it is recommended to migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro for more information. https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate

Workaround

- Create the view from the relational database management system (RDBMS) side. - Right-click the database connection in ArcCatalog > New > View. - Create the view using ArcSDESQLExecute. For example: import arcpy egdb = r"C:\Users\your-username\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\theconnection.sde" egdb_conn = arcpy.ArcSDESQLExecute(egdb) sql = ''' CREATE VIEW viewtest AS SELECT OBJECTID, 100/10 AS Price from DATAOWNER.TESTTABLE ''' egdb_return = egdb_conn.execute(sql) ArcSDESQLExecute: http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-classes/arcsdesqlexecute.htm

Steps to Reproduce

Bug ID: BUG-000085841

Software:

ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

The Create Database View tool does not accept the divide operator '/' in the view definition input field.

Additional Information

Workaround

Steps to Reproduce

Discover more on this topic