SAP Knowledge Base Article - Preview

2720663 - Alter on multistore table in HANA Dynamic Tiering returns distributed metadata error

Symptom

Alter on multistore tables in HANA Dynamic Tiering results in the following error
ALTER TABLE "owner"."OPT_object" ALTER PARTITION (DATUM) USING default STORAGE ( '19000101' <= VALUES < '20160101');

Could not execute 'ALTER TABLE "owner"."OPT_object" ALTER PARTITION (DATUM) USING EXTENDED STORAGE ( ...'
SAP DBTech JDBC: [2561]: distributed metadata error: Failed to get table location during table lock, TRANSACTION_ID=16 , UPDATE_TRANSACTION_ID=0 , Database name= , Schema name=owner , Table name=OPT_object , error=part of split table does not exist;owner:OPT_object


Read more...

Environment

SAP HANA Dynamic Tiering 2.0 Revision 003.00

Product

SAP HANA dynamic tiering 2.0

Keywords

DYT , DT , multi store , extended storage , archive , 195522 , 203021 , 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.