ERROR

"Insufficient privilege" after importing a shapefile from SAP HANA Studio

Last Published: April 25, 2020

Error Message

SAP HANA Studio allows shapefiles to be imported into a SAP HANA database. After importing a shapefile, the spatial table may throw an "Insufficient privilege" error when drawing the shapefile in ArcGIS or viewing the properties of the feature class.

Image of the Insufficient Privilege error in ArcGIS Pro.

Cause

The SAP HANA Studio Import tool surrounds lowercase or sentence case names with double quotes (ex: “railways”). Because ArcGIS accesses names in uppercase without quotes, this causes a Table not found/No permission error. This error can be fixed by renaming the columns and table names to all uppercase letters. Geoprocessing tools (such as Feature Class To Feature Class) convert the fields to uppercase automatically.
 

Solution or Workaround

Before selecting a shapefile to import, ensure the name of the tables and columns are in capital letters in the geoprocessing tool.
Note:
This was tested and confirmed with SAP HANA version 1.00.122.04.1478575636.

Article ID:000015843

Software:
  • ArcMap
  • ArcGIS Pro 1 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic