REQ_SCALEUP_PREREQ - hdbsql -U SYSTEM is giving error

[pr_srinivas]

Backup Ground :

SAPSID "SOR"  running on LINUX, on the same host it's ORADB-SID "SLE" of ERP EHP6 is running with SP9

We are upgrading to EHP7 & migrating this DB to HANA [102.02 ]from oracle using SUM-1.0-SP16-PL6 using DMO

The upgrade+Migrate using DMO came to phase :

MAIN_SHDIMP/SUBMOD_MIG_UPTIME_RUN/REQ_SCALEUP_PREREQ

######

SAPCONSOLE SHOWS AS BELOW -START

######

MAIN_SHDIMP/SUBMOD_MIG_UPTIME_RUN/REQ_SCALEUP_PREREQ

===========

Perform Scale Up (Single Node) Prerequisite on SAP HANA if necessary

===========

*Action Required (if condition is met):*

*You decided to NOT run the SAP HANA Landscape Reorganization.

However, if you run an SAP HANA Single-Node system with scale-up, you must

manually import a file with specific SQL-information to enable the optimal

table partition.

Carry out the following procedure:*

1. Download the appropriate file that is in the attachment of the following

SAP Notes:

  * For SAP Business Warehouse on SAP HANA, see SAP Note 1908075. From the

    attachment TABLE_PLACEMENT_BW.zip, select the suitable SQL-file.

  * For SAP Business Suite on SAP HANA or SAP S/4HANA, see SAP Note 1899817.

    Choose the attachment: TABLE_PLACEMENT_ERP_* or TABLE_PLACEMENT_S4H_*

    according to the version and SP level of the target system.

2. Edit the downloaded file by replacing all occurrences of $$PLACEHOLDER with

your SAP<sid>.

3. Import the edited files to SAP HANA using one of the following commands on

OS level of the managed system:

  * */usr/sap/SOR/hdbclient/hdbsql -U SYSTEM -I <filename> -E 1*

  * */usr/sap/SOR/hdbclient/hdbsql -U SUPER -I <filename> -E 1*

4. After the import, continue with the migration procedure.

######

SAPCONSOLE SHOWS AS BELOW -END

######

I have downloaded the script named - TABLE_PLACEMENT_ERP_SP10.TXT and changed placeholder with SID"SOR" i.e SAPSOR and executing the command from Application server - i am getting below error .

The console is asking to run 2 commands

one with - SYSTEM user

one with - SUPER user

when i ran it as below

Command with SUPER - returned to command prompt

---------------

semqcs2s:soradm 105> hdbsql -U SUPER -I 20160406_01A_TABLE_PLACEMENT_ERP_SP10.TXT -E 1

semqcs2s:soradm 106>

Command with SYSTEM- returning the error

---------------

semqcs2s:soradm 106> hdbsql -U SYSTEM -I 20160406_01A_TABLE_PLACEMENT_ERP_SP10.TXT -E 1

* -10104: Invalid value for KEY (SYSTEM)

semqcs2s:soradm 107>

semqcs2s:soradm 107>

ERROR : * -10104: Invalid value for KEY (SYSTEM)

semqcs2s:soradm 107>

How to get this fixed ?

Please help

Please suggest

Rgds

Srinivas

[Former Member]

Hello,

I'm facing the same error. Did you solved the problem?

Best regards

Bastian