2098724 - Error "SAP DBTech JDBC: [257] (at ...): sql syntax error: line 1 col ... (at pos ...)" when creating user in SAP HANA repository

Symptom

• You use SAP Provisioning Framework(version 1 or 2) to create user in HANA repository, but get error:
  
  SAP DBTech JDBC: [257] (at ...): sql syntax error: line 1 col ... (at pos ...)
  
  Exception from Add operation:com.sap.idm.ic.ToPassException: Could not create user in HANA
   
• The dse log of connector job "Create SAP HANA user" shows below similar call stack for the error exception(see KBA 2038329 about how to generate higher level job dse log):
  
  Error code 257 SQL state:HY000(!)
  java.lang.Throwable: SAP DBTech JDBC: [257] (at ...): sql syntax error: line 1 col ... (at pos ...)
        at com.sap.idm.ic.Logger.logIt
        at com.sap.idm.ic.ToPass.logIt
        at com.sap.idm.ic.ToHANA.addEntryCustom
  ...
  Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [257] (at ...): sql syntax error: line 1 col ... (at pos ...)
        at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException
        at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException
        at com.sap.db.jdbc.packet.ReplyPacket.createException
        at com.sap.db.jdbc.ConnectionSapDB.throwSQLError
        at com.sap.db.jdbc.ConnectionSapDB.execute
  ...

Environment

SAP Netweaver Identity Management 7.2

Reproducing the Issue

Assign HANA repository account privilege to one user, so that to create it in the HANA repository.

Cause

The authentication mechanism of the user was not specified properly(missing) when creating the user in HANA. HANA requires that at least one authentication mechanism has to be specified to allow the user to connect and work with the database instance. Please refer to section Additional Prerequisites for SAP HANA Connector of SAP Provisioning Framework configuration guide, which provides links to HANA documentations.

Resolution

• Specify authentication mechanism for the user properly according to HANA requirements. For example, password.
• If you want to set password as authentication mechanism for the user, please also refer to this Wiki about password provisioning.

Keywords

HANA Database, ToHANA, plugin, hook task 1.