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

AnthonyRyanEQL — Thu, 25 Jan 2024 01:22:37 GMT

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

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.

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

AnthonyRyanEQL — Thu, 25 Jan 2024 01:22:06 GMT

This functionality for HANA has been removed in ArcGIS Pro 3.2

topic Re: HANA Geodatabase - Create Database User Error: Wrong column type (-114) in Geodatabase Questions

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

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