HANA Geodatabase - Create Database User Error: Wrong column type (-114)

354
1
Jump to solution
01-24-2024 02:02 PM
AnthonyRyanEQL
Occasional Contributor III

Hi all,

I'm using ArcGIS Pro 3.2.1 with Advanced licensing, ArcGIS Enterprise 11.1 with Advanced licensing and  HANA 2 SP07 database.

Our dba setup the 'sde' user with the permissions as defined in Privileges for geodatabases in SAP HANA—ArcGIS Pro | Documentation and I was able to enable the geodatabase successfully using the Enable Enterprise Geodatabase gp tool in Pro.

To create the database user, I'm using the 'Create Database User' gp tool in Pro. The database connection for the tool is a sde file configured to connect as sde. I have successfully used this gp tool in ArcGIS Pro 3.1.3 to create db user in HANA before but this time I'm getting the following error from the go tool's messages 'Wrong column type [Success] ERROR: Failed to create HANA user UNOWNER (-114).
Error: Wrong column type (-114)'

Has anybody come across this error before? Thanks

 

AnthonyRyanEQL_0-1706133915307.png

 

I uninstalled ArcGIS Pro 3.2.1 and installed ArcGIS Pro 3.1.3 and repeated the above and was successful in creating the database user. I used this user to create a feature class & data and all worked as expected.

0 Kudos
1 Solution

Accepted Solutions
AnthonyRyanEQL
Occasional Contributor III

This functionality for HANA has been removed in ArcGIS Pro 3.2

View solution in original post

0 Kudos
1 Reply
AnthonyRyanEQL
Occasional Contributor III

This functionality for HANA has been removed in ArcGIS Pro 3.2

0 Kudos