1959122 - HANA: import failed with error "invalid column name: PARTNO"

Symptom

You're performing an import migration into HANA and you face the following issue:

(DB) INFO: 

DbSl Trace:   prepare() of C_0001, rc=1, rcSQL=260 (invalid column name: PARTNO)
DbSl Trace: SQL PREPARE on connection 0, rc=260 (invalid column name: PARTNO)
(IMP) ERROR: DbSlPrepare/BegModify failed
  rc = 99, table "/BIC/BXXXXXXXXXX"
  (SQL error 260)
  error message returned by DbSl:
invalid column name: PARTNO

Environment

HANA database 1.0 all releases

Cause

There's a problem with PSA tables containing PARTNO in their hash partition key.

Resolution

Implement the following SAP Note:
SAP Note 1908854 - RSHDB: Hash partition keys of PSA tables without PARTNO
After that, please execute program SMIGR_CREATE_DDL with option "SAP HANA Database" and re-import using the new created DODS.SQL file.

See Also

SAP Note 1921023 - SMIGR_CREATE_DDL: Corrections and enhancements for SAP HANA

Keywords

BW on HANA, system copy, HANA migration, import, invalid column name, PARTNO, rc=260, SMIGR_CREATE_DDL, PARTITION_SPEC

Header Data

Released On	30.01.2014 00:17:49
Release Status	Released to Customer
Component	HAN-LM-INS SAP HANA Installation
Other Components	HAN-DB SAP HANA Database
Priority	Normal
Category	How To