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 ONE Support launchpad (Login required).

Search for additional results

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