SAP Knowledge Base Article - Preview

2770250 - Create ES_ADMIN user fails on error Primary key for table 'ISYSUSER' is not unique - SAP Dynamic Tiering

Symptom

  • Upgrade from  DT 1 to  DT 2
  • As part of the DT upgrade you need to run sp_iqrebuildindex on DT using the ES_ADMIN user.

And you need to create that user with the command:
ALTER EXTENDED STORAGE CREATE ADMIN USER ES_ADMIN PASSWORD pwd FORCE PASSWORD CHANGE OFF

  • You could hit this error:

ALTER EXTENDED STORAGE CREATE ADMIN USER ES_ADMIN PASSWORD pwd FORCE PASSWORD CHANGE OFF
SAP DBTech JDBC: [403]: internal error: Failed to alter extended storage create admin user:
[SAP][ODBC Driver]Primary key for table 'ISYSUSER' is not unique: Primary key value ('103')


Read more...

Environment

SAP Dynamic Tiering 2

Product

SAP HANA dynamic tiering 2.0

Keywords

KBA , HAN-DYT , SAP HANA Dynamic Tiering , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.